home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC75415 Status: Geschlossen

RUNSTATS via USE PROFILE collects inaccurate statistics after REDISTRIBUTE

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* 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.
verfügbare FixPacks:
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

Lösung
First fixed in DB2 Version 9.5 Fix Pack 8.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC75416 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
30.03.2011
01.07.2011
01.07.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP8
Problem behoben lt. FixList in der Version
9.5.0.8 FixList