|
Problem IC95375
|
Status: Geschlossen |
REDISTRIBUTE UPDATES TABLE PACKED DESCRIPTOR AND OVERWRITES UPDATES OF RUNSTATS |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 UDB Version 10.5 Fix Pack 3. *
**************************************************************** |
| Local-Fix: |
Gather new statistics after REDISTIRBUTE finished. |
| verfügbare FixPacks: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Lösung |
Problem was first fixed in DB2 UDB Version 10.5 Fix Pack 3. |
| Workaround |
Gather new statistics after REDISTIRBUTE finished. |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 27.08.2013
27.02.2014
27.02.2014 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
