|
Problem IC91299
|
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 / A10 - 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 Version10.1 Fix Pack 3. *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Lösung |
This problem is first fixed in DB2 Version 10.1 Fix Pack 3. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 03.04.2013
17.10.2013
17.10.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
