|
Problem IC75415
|
Status: Closed |
RUNSTATS via USE PROFILE collects inaccurate statistics after REDISTRIBUTE |
| product: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problem description: |
You may notice that table cardinality is calculated wrong when
using statistics profile on a table after adding database
partition(s) and performing a redistribute.
The statistics collection (RUNSTATS) during REDISTRIBUTE does
not update the user statistics profile's number of nodes. On
the subsequent RUNSTATS USE PROFILE, DB2 looks at the user
statistics profile number of nodes as indication of how many
nodes the table is on. This causes incorrect external catalog
statistics.
In contrast the internal table packed descriptor cardinality
value is correct.
Hence this issue affects tools like REORGCHK, which is using the
external statistics stored in the catalog tables.
This issue does not affect the query compiler which relies on
statistics stored in the internal packed descriptor of the
table. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* see ERROR DESCRIPTION *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 9.5 Fix Pack 8. *
**************************************************************** |
| Local Fix: |
Running an RUNSTATS 'update profile' or setting a new statistics
profile after the REDISTRIBUTE helps to correct the number of
nodes in the profile and get the correct table cardinality. |
| 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: IC75416
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
|
 |
