IC67296: ROLLFORWARD FAILS WITH MESSAGE: SQL1042C AN UNEXPECTED SYSTEM ERROR OCCURRED. SQLSTATE=58004

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • This problem happens when trying to rollforward a database that
    contains a table with XML column(s).
    If the table is unavailable for any reason, rollforward will
    fail when trying to reorg that table.
    
    
    In the db2diag.log, the following records were recorded:
    
    2010-02-04-15.40.26.912561-300 I131497E3139        LEVEL: Severe
    PID     : 25566                TID  : 47401540774208PROC :
    db2sysc
    INSTANCE: simap                NODE : 000          DB   : SPDB
    APPHDL  : 0-52                 APPID: *LOCAL.simap.100204204023
    AUTHID  : SIMAP
    EDUID   : 266                  EDUNAME: db2redom (SPDB)
    FUNCTION: DB2 UDB, buffer pool services, sqlbDMScheckObjAlloc,
    probe:790
    MESSAGE : ZRC=0x8402001A=-2080243686=SQLB_EMP_MAP_INFO_END "EMP
    MAP INFO END"
    DATA #1 : signed integer, 4 bytes
    2
    DATA #2 : signed integer, 4 bytes
    1
    DATA #3 : signed integer, 8 bytes
    0
    DATA #4 : unsigned integer, 4 bytes
    1
    DATA #5 : unsigned integer, 4 bytes
    0
    DATA #6 : unsigned integer, 4 bytes
    2
    DATA #7 : Fix control block, PD_TYPE_SQLB_FIX_CB, 168 bytes
      accessMethod:  SQLB_POOL_RELATIVE
      fixMode:                        2   SQLBOLD/SQLBOLDS
      buffptr:       0x00002b1cd5a73000
      bpdPtr:        0x00002b1cd2e04280
      dmDebugHdl:                     1
      objectPageNum:                  0
      empDiskPageNum:                768
      unfixFlags:                     0
      dirtyState:    SQLBCLEAN
      fixInfoFlags:  SQLB_PI_READ_FROM_DISK
      regEDUid:      0
      Pagekey: {pool:2;obj:4;type:70} PPNum:0
          Obj: {pool:2;obj:4;type:70} Parent={2;4}
      lifeLSN:       000000000251AE4B
      tid:           0 0  0
      extentAnchor:                 768
      initEmpPages:                   0
      poolPage0:                      0
      poolflags:                   3122
      objectState:                  827
      lastSMP:                        0
      pageSize:                    4096
      extentSize:                    32
      bufferPoolID:                   1
      partialHash:           1174667266
      bufferPool:    0x00002b1cd2bba5a0
      pdef:          0x00002b1cd2dcf280
      glob:          0x00002b1ca20ba7e0
    DATA #8 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
    pageHead: {tbspSeed:2;obj:4;type:70} PPNum:0 OPNum:0
      begoff:                      48
      datlen:                    4048
      pagebinx:                  1490
      revnum:                    1280
      pagelsn:     000000000251B7CB  flag:                         a
      future32:                    0
      cbits1to31:                   0
      cbits32to63:                  0
    DATA #9 : Dumped object of size 4096 bytes at offset 0, 57 bytes
    /home/hotel50/simap/sqllib/db2dump/25566.266.000.dump.bin
    CALLSTCK:
      [0] 0x00002B1C6F6D9404 pdLog + 0x18C
      [1] 0x00002B1C6FB77969
    _Z20sqlbDMScheckObjAllocP16SQLB_OBJECT_DESCmiiPPjP12SQLB_GLOBALS
    + 0xF7D
      [2] 0x00002B1C6F9E0420 _Z17sqlbGetDiskPageIDP11SQLB_FIX_CBPj +
    0x2C0
      [3] 0x00002B1C6FAD8DAE _Z19sqlbGetPageFromDiskP11SQLB_FIX_CBi
    + 0x34A
      [4] 0x00002B1C6F9DC08C _Z7sqlbfixP11SQLB_FIX_CB + 0x25C8
      [5] 0x00002B1C6F3FA707 _Z11sqlbFixPageP11SQLB_FIX_CBiji +
    0x277
      [6] 0x00002B1C6F42D9AB
    _Z15sqldcsl_fixPageP8sqeAgentP8SQLD_TCBP12SQLD_TCB_CSLP14SQLDCSL
    _FIX_CB
    + 0x207
      [7] 0x00002B1C6F42C5DB
    _Z18sqldcsl_fetchFirstP8sqeAgentP8SQLD_TCBP12SQLD_TCB_CSLP16SQLD
    CSL_FETCH_CB
    + 0x17F
      [8] 0x00002B1C6F42CEBC
    _Z16sqldcsl_fetchRowP8sqeAgentP8SQLD_TCBP12SQLD_TCB_CSLP16SQLDCS
    L_FETCH_CB
    + 0x16E
      [9] 0x00002B1C6F432028
    _Z33sqldcsl_reorgNonEmptyPageAndSlotsP16SQLD_REORGCSL_CB + 0x51C
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * see APAR information                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Customers must upgrade to V97 fixpack 3                      *
    ****************************************************************
    

Problem conclusion

  • This problem is fixed in V97 fixpack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC67296

  • 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-17

  • Closed date

    2010-05-13

  • Last modified date

    2010-05-13

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

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

    IC67471

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.7

Reference #:

IC67296

Modified date:

2010-05-13

Translate my page

Machine Translation

Content navigation