Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC77377 Status: Closed

RUNSTATS MAY FAIL WITH -901 ERROR DURING SANITY CHECK.

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
RUNSTATS failed with -901 during sanity check. 
 
The message in  db2diag.log might look something like: 
 
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 * 
* ATPP                                                         * 
* 10SQLD_ISTATPP8sqlrg_pdPiiP14sqlrg_nodecardPUcUlUiT11_T8T11_ * 
* P16                                                          * 
* + 0x5A4                                                      * 
*                                                              * 
*   [7] 0x090000000673781C                                     * 
*                                                              * 
* sqlr_update_catalogs__FP8sqlrr_cbP11sqlrrstringT2P10SQLD_TST * 
* ATiP                                                         * 
* P10SQLD_ISTATPiPP8sqlrg_pdP5sqlcaT5P14sqlrg_nodecardUsUiUlPP * 
* c                                                            * 
* + 0x180                                                      * 
*                                                              * 
*   [8] 0x090000000779B714                                     * 
*                                                              * 
* sqlrLocalRunstats__FP8sqlrr_cbP11sqlrrstringN22UcUsT6PP8sqlr * 
* g_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                             * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v9.1 FP11                                         * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Solution
This APAR will be fixed in v9.1 FP11
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
06.07.2011
07.12.2011
07.12.2011
Problem solved at the following versions (IBM BugInfos)
9.1.FP11
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.11 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.