|
Problem IC75413
|
Status: Closed |
REDISTRIBUTE UPDATES TABLE PACKED DESCRIPTOR AND OVERWRITES UPDATES OF RUNSTATS |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
On the statistics collection during REDISTRIBUTE, after RUNSTATS
updates the catalogs with
a) external catalog statistics and
b) a table packed descriptor (PD) with statistics,
REDISTRIBUTE modifies the table packed descriptor to change the
partition map.
This subsequent update wipes out the changes to the PD that
RUNSTATS did, resulting in incorrect internal packed descriptor
statistics.
Although the external SYSCAT.TABLES cardinality statistics will
be correct, the incorrect internal packed descriptor will affect
the query compiler estimates. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* see ERROR DESCRIPTION *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.5 Fix Pack 8. *
**************************************************************** |
| Local Fix: |
Gather new statistics after REDISTIRBUTE finished. |
| available fix packs: |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 Version 9.5 Fix Pack 8. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC75414
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 30.03.2011
01.07.2011
01.07.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.5.FP8
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.5.0.8
|
 |
