IBM Support

IC76609: RUNSTATS MAY FAIL WITH -901 ERROR DURING SANITY CHECK.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error 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
    

Local fix

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                                          *
    ****************************************************************
    

Problem conclusion

  • With this fix, the -901 error will never occur while runstats
    on a huge volument of XML data.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC76609

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-05-25

  • Closed date

    2011-12-07

  • Last modified date

    2011-12-07

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC77145 IC77377

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R910 PSN

       UP

  • R950 PSN

       UP

  • R970 PSN

       UP

  • R980 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC76609

Modified date: 07 December 2011