DB2 - Problembeschreibung
Problem IC89219 | Status: Geschlossen |
ASYNCHRONOUS RUNSTATS REQUESTS MIGHT BE LOST IN DPF ENVIRONMENTS FOR TABLES THAT DO NOT RESIDE ON THE CATALOG DATABASE PARTITION | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
When the real time statistics (RTS) feature is enabled for a database, db2agent EDUs compiling SQL statements can synchronously collect statistics and make asynchronous runstats requests to be satisfied by the background RTS daemon. The asynchronous requests might be lost in DPF environments for tables that do not reside on the catalog database partition. Whether the problem will occur is not deterministic. If the problem occurs, until statistics are refreshed by a subsequent synchronous or asynchronous collection, the query optimizer will have less accurate statistics when making access plan decisions. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * DPF * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fix Pack 8. * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows | |
Lösung | |
This problem is first fixed in DB2 Version 9.7 Fix Pack 8. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC91299 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 19.12.2012 01.04.2013 01.04.2013 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP8 | |
Problem behoben lt. FixList in der Version | |
9.7.0.8 |