|
Problem IC81567
|
Status: Closed |
AUTOMATIC STATISTICS COLLECTION MIGHT NOT OCCUR FOR A RANGE PARTITIONED TABLE AFTER LOAD. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
Problem was first fixed in DB2 LUW Version 9.7 Fix Pack 6. |
| Workaround |
See Local Fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.02.2012
04.07.2012
04.07.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
