|
Problem IC81567
|
Status: Geschlossen |
AUTOMATIC STATISTICS COLLECTION MIGHT NOT OCCUR FOR A RANGE PARTITIONED TABLE AFTER LOAD. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
After the LOAD utility has been run on a range partitioned
table, you might observe that automatic statistics collection
does not process the table. This can occur for tables with
indexes. As the table is further used, for example in SQL
queries, it should return to a state in which automatic
statistics will process the table. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 LUW Version 9.7 Fix Pack 6. *
**************************************************************** |
| Local-Fix: |
After the LOAD completes, compile an SQL statement that
references the table. The SQL statement should not be one that
is already in the package cache. |
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Lösung |
Problem was first fixed in DB2 LUW Version 9.7 Fix Pack 6. |
| Workaround |
See Local Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 22.02.2012
04.07.2012
04.07.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP6
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.6
|
 |
