|
Problem IC84464
|
Status: Geschlossen |
RUNSTATS DOES NOT COLLECT XML STATISTICS WHEN STATS_HEAP_SZ IS NOT BIG ENOUGH |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
When stats_heap_sz is not big enough, even though it is set to
be automatic, RUNSTATS will not collect XML statistics. No
error will be reported to the user. However, the db2cat output
for the table will not show a part of XML statistics.
If db2 trace is turned on, users can see an entry like the
following in the flw file:
| XmlrnStatsProcessPathValueInstance entry
| | XmlrnStatsAddInstanceToReservoir entry
| | XmlrnStatsAddInstanceToReservoir exit
| | XmlrnStatsBloomFilterCheckZValue entry
| | XmlrnStatsBloomFilterCheckZValue exit
| | XmlrnStatsAddInstanceToReservoir entry
| | XmlrnStatsAddInstanceToReservoir exit
| | XmlrnStatsAddPVInstanceToCatchAllPVBucket entry
| | | XmlrnStatsPVBktFindBucket entry
| | | XmlrnStatsPVBktFindBucket exit [rc = 1] <<<
| | XmlrnStatsAddPVInstanceToCatchAllPVBucket exit
| XmlrnStatsProcessPathValueInstance exit |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Users who collect statistics against tables with XML *
* column(s). *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Please upgrade to V10.1 FixPack 1 or later. *
**************************************************************** |
| Local-Fix: |
Increase the value of stats_heap_sz and run db2cat to make sure
XML statistics are collected. |
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Lösung |
This problem was first fixed in DB2 V10.1 FixPack 1. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 14.06.2012
05.11.2012
05.11.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
