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 IC64367 Status: Geschlossen

RUNSTAT ON XML DATA MAY REPORT WARNING IN
FUNCTIONXMLRNSTATS::SUMMARIZEBCATCHALLPV()

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
While running runstats on xml tables we may receive following in 
db2diag.log file. 
 
================================ 
2009-09-03-10.55.31.720092+120 I2037449E857        LEVEL: 
Warning 
PID     : 1379                 TID  : 46920529602880PROC : 
db2sysc 0 
INSTANCE: inst1              NODE : 000          DB   : SAMPLE 
APPHDL  : 0-321                APPID: *LOCAL.abcd.090903085300 
AUTHID  : Admin 
EDUID   : 114                  EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, XML Node Manager, 
XmlrnStatsSummarizeBCatchAllPV, 
probe:1976 
DATA #1 : String, 16 bytes 
Sample Node Card 
DATA #2 : unsigned integer, 8 bytes 
0 
DATA #3 : String, 15 bytes 
Sample Doc Card 
DATA #4 : unsigned integer, 8 bytes 
0 
DATA #5 : String, 14 bytes 
Sum Node Count 
DATA #6 : unsigned integer, 4 bytes 
1206532352 
DATA #7 : String, 13 bytes 
Sum Doc Count 
DATA #8 : unsigned integer, 4 bytes 
1185276928 
DATA #9 : String, 20 bytes 
Distinct Value Count 
DATA #10: unsigned integer, 8 bytes 
632 
 
 
This messages are not harmful for the system,these will be 
reported as a info message as a fix of this APAR in future 
releses.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* RUNSTAT ON XML DATA MAY REPORT WARNING                       * 
* INFUNCTIONXMLRNSTATS::SUMMARIZEBCATCHALLPV()                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW Version 9.7 Fix Pack  2                   * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Problem was first fixed in Version 9.7 Fix Pack 2
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
09.11.2009
31.05.2010
31.05.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.,
9.7.FP2
Problem behoben lt. FixList in der Version
9.7.0.2 FixList