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

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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

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