|
Problem IC76609
|
Status: Closed |
RUNSTATS MAY FAIL WITH -901 ERROR DURING SANITY CHECK. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
RUNSTATS failed with -901 during sanity check.
In db2diag.log you may see the following log:
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 Summary: |
****************************************************************
* 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.7 FP5 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
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 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
With this fix, the -901 error will never occur while runstats
on a huge volument of XML data. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC77145 IC77377
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.05.2011
07.12.2011
07.12.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
