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

RUNSTATS MAY FAIL WITH -901 ERROR DURING SANITY CHECK.

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
RUNSTATS failed with -901 during sanity check. 
 
As db2diag.log reported: 
 
2011-05-21-12.17.53.761431+480 I663167A1558       LEVEL: Severe 
PID     : 2863358              TID  : 16964       PROC : db2sysc 
1 
INSTANCE: db2inst1             NODE : 001         DB   : SAMPLE 
APPHDL  : 0-617                APPID: *N0.db2inst1.110521033033 
AUTHID  : db2inst1 
EDUID   : 16964                EDUNAME: db2agntp (SAMPLE) 1 
FUNCTION: DB2 UDB, XML Node Manager, XmlrnStatsCheckSanity, 
probe:1149 
DATA #1 : String, 17 bytes 
Count > Max Count 
DATA #2 : unsigned integer, 8 bytes 
10432209 
DATA #3 : unsigned integer, 8 bytes 
10432211 
DATA #4 : unsigned integer, 4 bytes 
0 
CALLSTCK: 
  [0] 0x090000000995BA10 pdLog + 0xEC 
  [1] 0x09000000082E1A6C checkSanity__14XmlrnStatsPathFUl + 
0x15C 
  [2] 0x09000000082E15F4 checkSanity__10XmlrnStatsFi + 0x38C 
  [3] 0x090000000831F1AC 
checkSanity__14XmlrnStatsInfoFi@AF249_106 + 0x4C 
  [4] 0x09000000082E121C checkSanity__14XmlrnStatsInfoFi + 0x2C 
  [5] 0x09000000082DF2AC 
XmlrnStatsCheckSanity__FP13SQLO_MEM_POOLP8sqlrg_pdi + 0x11C 
  [6] 0x09000000082D9740 
@88@sqlr_finalize_pd__FP8sqlrr_cbP11sqlrrstringT2P10SQLD_TSTATPP 
10SQLD_ISTATPP8sqlrg_pdPiiP14sqlrg_nodecardPUcUlUiT11_T8T11_P16 
+ 0x5A4 
  [7] 0x090000000673781C 
sqlr_update_catalogs__FP8sqlrr_cbP11sqlrrstringT2P10SQLD_TSTATiP 
P10SQLD_ISTATPiPP8sqlrg_pdP5sqlcaT5P14sqlrg_nodecardUsUiUlPPc 
+ 0x180 
  [8] 0x090000000779B714 
sqlrLocalRunstats__FP8sqlrr_cbP11sqlrrstringN22UcUsT6PP8sqlrg_pd 
iN39P16sqlrl_stats_colsPPsUiPPUsT15_dT15_T6PP20sqlr_runstats_re 
+ 0x1218 
  [9] 0x09000000080E80AC 
sqlrkstc__FP8sqlrr_cbP16sqlkdRqstRplyFmtiP15SQLR_RPCMESSAGE + 
0xB60 
 
2011-05-21-12.17.53.766880+480 I664726A586        LEVEL: Severe 
PID     : 2863358              TID  : 16964       PROC : db2sysc 
1 
INSTANCE: db2inst1             NODE : 001         DB   : SAMPLE 
APPHDL  : 0-617                APPID: *N0.db2inst1.110521033033 
AUTHID  : db2inst1 
EDUID   : 16964                EDUNAME: db2agntp (SAMPLE) 1 
FUNCTION: DB2 UDB, XML Node Manager, XmlrnStatsCheckSanity, 
probe:50 
RETCODE : ZRC=0xFFFFFC7B=-901 
DATA #1 : String, 14 bytes 
Sum Node count 
DATA #2 : unsigned integer, 8 bytes 
10432209 
DATA #3 : String, 32 bytes 
topNodePathid checkSanity failed
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* RUNSTATS failed with -901 during sanity check.               * 
*                                                              * 
*                                                              * 
*                                                              * 
* As db2diag.log reported:                                     * 
*                                                              * 
*                                                              * 
*                                                              * 
* 2011-05-21-12.17.53.761431+480 I663167A1558      LEVEL:      * 
* Severe                                                       * 
* PID    : 2863358              TID  : 16964      PROC :       * 
* db2sysc                                                      * 
* 1                                                            * 
*                                                              * 
* INSTANCE: db2inst1            NODE : 001        DB  : SAMPLE * 
* APPHDL  : 0-617                APPID:                        * 
* *N0.db2inst1.110521033033                                    * 
* AUTHID  : db2inst1                                           * 
*                                                              * 
* EDUID  : 16964                EDUNAME: db2agntp (SAMPLE) 1   * 
*                                                              * 
* FUNCTION: DB2 UDB, XML Node Manager, XmlrnStatsCheckSanity,  * 
*                                                              * 
* probe:1149                                                   * 
*                                                              * 
* DATA #1 : String, 17 bytes                                   * 
*                                                              * 
* Count > Max Count                                            * 
*                                                              * 
* DATA #2 : unsigned integer, 8 bytes                          * 
*                                                              * 
* 10432209                                                     * 
*                                                              * 
* DATA #3 : unsigned integer, 8 bytes                          * 
*                                                              * 
* 10432211                                                     * 
*                                                              * 
* DATA #4 : unsigned integer, 4 bytes                          * 
*                                                              * 
* 0                                                            * 
*                                                              * 
* CALLSTCK:                                                    * 
*                                                              * 
* [0] 0x090000000995BA10 pdLog + 0xEC                          * 
*                                                              * 
* [1] 0x09000000082E1A6C checkSanity__14XmlrnStatsPathFUl +    * 
*                                                              * 
* 0x15C                                                        * 
*                                                              * 
* [2] 0x09000000082E15F4 checkSanity__10XmlrnStatsFi + 0x38C   * 
*                                                              * 
* [3] 0x090000000831F1AC                                       * 
*                                                              * 
* checkSanity__14XmlrnStatsInfoFi@AF249_106 + 0x4C             * 
*                                                              * 
* [4] 0x09000000082E121C checkSanity__14XmlrnStatsInfoFi +     * 
* 0x2C                                                         * 
* [5] 0x09000000082DF2AC                                       * 
*                                                              * 
* XmlrnStatsCheckSanity__FP13SQLO_MEM_POOLP8sqlrg_pdi + 0x11C  * 
*                                                              * 
* [6] 0x09000000082D9740                                       * 
*                                                              * 
* @88@sqlr_finalize_pd__FP8sqlrr_cbP11sqlrrstringT2P10SQLD_TST * 
* AT                                                           * 
* 10SQLD_ISTATPP8sqlrg_pdPiiP14sqlrg_nodecardPUcUlUiT11_T8T11_ * 
* P1                                                           * 
* + 0x5A4                                                      * 
*                                                              * 
* [7] 0x090000000673781C                                       * 
*                                                              * 
* sqlr_update_catalogs__FP8sqlrr_cbP11sqlrrstringT2P10SQLD_TST * 
* AT                                                           * 
* P10SQLD_ISTATPiPP8sqlrg_pdP5sqlcaT5P14sqlrg_nodecardUsUiUlPP * 
* c                                                            * 
*                                                              * 
* + 0x180                                                      * 
*                                                              * 
* [8] 0x090000000779B714                                       * 
*                                                              * 
* sqlrLocalRunstats__FP8sqlrr_cbP11sqlrrstringN22UcUsT6PP8sqlr * 
* g_                                                           * 
* iN39P16sqlrl_stats_colsPPsUiPPUsT15_dT15_T6PP20sqlr_runstats * 
* _r                                                           * 
* + 0x1218                                                     * 
*                                                              * 
* [9] 0x09000000080E80AC                                       * 
*                                                              * 
* sqlrkstc__FP8sqlrr_cbP16sqlkdRqstRplyFmtiP15SQLR_RPCMESSAGE  * 
* +                                                            * 
* 0xB60                                                        * 
*                                                              * 
*                                                              * 
*                                                              * 
* 2011-05-21-12.17.53.766880+480 I664726A586        LEVEL:     * 
* Severe                                                       * 
* PID    : 2863358              TID  : 16964      PROC :       * 
* db2sysc                                                      * 
* 1                                                            * 
*                                                              * 
* INSTANCE: db2inst1            NODE : 001        DB  : SAMPLE * 
* APPHDL  : 0-617                APPID:                        * 
* *N0.db2inst1.110521033033                                    * 
* AUTHID  : db2inst1                                           * 
*                                                              * 
* EDUID  : 16964                EDUNAME: db2agntp (SAMPLE) 1   * 
*                                                              * 
* FUNCTION: DB2 UDB, XML Node Manager, XmlrnStatsCheckSanity,  * 
*                                                              * 
* probe:50                                                     * 
*                                                              * 
* RETCODE : ZRC=0xFFFFFC7B=-901                                * 
*                                                              * 
* DATA #1 : String, 14 bytes                                   * 
*                                                              * 
* Sum Node count                                               * 
*                                                              * 
* DATA #2 : unsigned integer, 8 bytes                          * 
*                                                              * 
* 10432209                                                     * 
*                                                              * 
* DATA #3 : String, 32 bytes                                   * 
*                                                              * 
* topNodePathid checkSanity failed                             * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v9.5 FP9                                          * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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
With this fix, the -901 error will never occur while runstats 
on a huge volument of XML data.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
23.06.2011
12.02.2012
01.03.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP9
Problem behoben lt. FixList in der Version
9.5.0.9 FixList