IBM Support

IC67554: DB2 CRASH WHEN CTRL+C IS PRESSED DURING MDC REFRESHING, WHEN NOT LOGGED INITIALLY IS ACTIVATED

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DB2 might crash when interrupt is received during MDC
    refreshing, when NOT LOGGED INITIALLY is activated.
    One of the symptom is showing the following stack in db2diag.log
    (or in trap file)
    2010-03-24-13.46.03.808277-240 I2069921E1331       LEVEL: Error
    PID     : 20752                TID  : 198499625312 PROC :
    db2sysc 5
    INSTANCE: nypxt400             NODE : 005          DB   : C1RISK
    APPHDL  : 1-37312              APPID:
    10.163.26.167.16280.10032417454
    AUTHID  : CPGDBPRD
    EDUID   : 267757               EDUNAME: db2agnta (C1RISK) 5
    FUNCTION: DB2 UDB, sqldb, sqldb_purgeAllRolloutCBsFromTENTRY,
    probe:548
    MESSAGE : Rollout CB list is not empty at tx boundary!
    DATA #1 : Pointer, 8 bytes
    0x0000002df3433080
    CALLSTCK:
      [0] 0x0000002A966E4509 pdLog + 0xD7
      [1] 0x0000002A97113363
    _Z34sqldb_purgeAllRolloutCBsFromTENTRYP8sqeAgent + 0x16F
      [2] 0x0000002A96AD7FAB
    _Z17sqlpEndUowRuntimeP8sqeAgentP9SQLP_DBCB + 0x7E7
      [3] 0x0000002A96AD3A22
    /ms/dist/ibmdb2/PROJ/ds/9.5.4.10/.exec/x86_64.linux.2.6.glibc.2.
    3/lib64/libdb2e.so.1
    + 0x1351A22
      [4] 0x0000002A96AD202F
    _Z8sqlpxrbkP8sqeAgentP15SQLXA_CALL_INFOPiP9SQLP_GXIDPP11sqlo_xla
    tch
    + 0x497
      [5] 0x0000002A96B3F6CC
    _Z12sqlrrbck_dpsP8sqlrr_cbiiiP15SQLXA_CALL_INFOP9SQLP_GXID +
    0x106
      [6] 0x0000002A97F35F13 _Z17sqlrr_tran_routerP8sqlrr_cb + 0x85F
      [7] 0x0000002A97F20F5C
    _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0xB42
      [8] 0x0000002A971B51D1 _Z20sqleSubRequestRouterP8sqeAgentPjS1_
    + 0xA83
      [9] 0x0000002A971B4147 _Z21sqleProcessSubRequestP8sqeAgent +
    0x5F
    
    The problem is that sqldRolloutBlocksOfCell passes the master
    TCB to sqldb_allocateAndLinkRolloutCB, which then uses it to
    check if Not Logged Initially is activated for the table.
    However the TCB_D_NOLOG is not stored in the master TCB, only in
    the TCB for the partitions.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * DB2 might crash when interrupt is received during MDC        *
    *                                                              *
    * refreshing, when NOT LOGGED INITIALLY is activated.          *
    *                                                              *
    * One of the symptom is showing the following stack in         *
    * db2diag.log                                                  *
    * (or in trap file)                                            *
    *                                                              *
    * 2010-03-24-13.46.03.808277-240 I2069921E1331      LEVEL:     *
    * Error                                                        *
    * PID    : 20752                TID  : 198499625312 PROC :     *
    *                                                              *
    * db2sysc 5                                                    *
    *                                                              *
    * INSTANCE: nypxt400            NODE : 005          DB  :      *
    * C1RISK                                                       *
    * APPHDL  : 1-37312              APPID:                        *
    *                                                              *
    * 10.163.26.167.16280.10032417454                              *
    *                                                              *
    * AUTHID  : CPGDBPRD                                           *
    *                                                              *
    * EDUID  : 267757              EDUNAME: db2agnta (C1RISK) 5    *
    * FUNCTION: DB2 UDB, sqldb,                                    *
    * sqldb_purgeAllRolloutCBsFromTENTRY,                          *
    * probe:548                                                    *
    *                                                              *
    * MESSAGE : Rollout CB list is not empty at tx boundary!       *
    *                                                              *
    * DATA #1 : Pointer, 8 bytes                                   *
    *                                                              *
    * 0x0000002df3433080                                           *
    *                                                              *
    * CALLSTCK:                                                    *
    *                                                              *
    *   [0] 0x0000002A966E4509 pdLog + 0xD7                        *
    *                                                              *
    *   [1] 0x0000002A97113363                                     *
    *                                                              *
    * _Z34sqldb_purgeAllRolloutCBsFromTENTRYP8sqeAgent + 0x16F     *
    *                                                              *
    *   [2] 0x0000002A96AD7FAB                                     *
    *                                                              *
    * _Z17sqlpEndUowRuntimeP8sqeAgentP9SQLP_DBCB + 0x7E7           *
    *                                                              *
    *   [3] 0x0000002A96AD3A22                                     *
    *                                                              *
    * /ms/dist/ibmdb2/PROJ/ds/9.5.4.10/.exec/x86_64.linux.2.6.glibc.
    * 3/lib64/libdb2e.so.1                                         *
    *                                                              *
    * + 0x1351A22                                                  *
    *                                                              *
    *   [4] 0x0000002A96AD202F                                     *
    *                                                              *
    * _Z8sqlpxrbkP8sqeAgentP15SQLXA_CALL_INFOPiP9SQLP_GXIDPP11sqlo_x
    * tch                                                          *
    *                                                              *
    * + 0x497                                                      *
    *                                                              *
    *   [5] 0x0000002A96B3F6CC                                     *
    *                                                              *
    * _Z12sqlrrbck_dpsP8sqlrr_cbiiiP15SQLXA_CALL_INFOP9SQLP_GXID + *
    *                                                              *
    * 0x106                                                        *
    *                                                              *
    *   [6] 0x0000002A97F35F13 _Z17sqlrr_tran_routerP8sqlrr_cb +   *
    * 0x85F                                                        *
    *   [7] 0x0000002A97F20F5C                                     *
    *                                                              *
    * _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0xB42   *
    *                                                              *
    *   [8] 0x0000002A971B51D1                                     *
    * _Z20sqleSubRequestRouterP8sqeAgentPjS1_                      *
    * + 0xA83                                                      *
    *                                                              *
    *   [9] 0x0000002A971B4147 _Z21sqleProcessSubRequestP8sqeAgent *
    * +                                                            *
    * 0x5F                                                         *
    *                                                              *
    *                                                              *
    *                                                              *
    * The problem is that sqldRolloutBlocksOfCell passes the       *
    * master                                                       *
    * TCB to sqldb_allocateAndLinkRolloutCB, which then uses it to *
    *                                                              *
    * check if Not Logged Initially is activated for the table.    *
    *                                                              *
    * However the TCB_D_NOLOG is not stored in the master TCB,     *
    * only in                                                      *
    * the TCB for the partitions.                                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * n/a                                                          *
    ****************************************************************
    

Problem conclusion

  • Problem is first fixed in Version 9.7 Fix Pack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC67554

  • 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

    2010-03-30

  • Closed date

    2010-09-23

  • Last modified date

    2010-09-23

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

    IC67553

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC67554

Modified date: 23 September 2010