IBM Support

IC82362: BAD PAGE HEADER DETECTED DURING ONLINE EXTENT MOVE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • If a transaction that includes a rollback of a create table
    statement is applied during recovery (crash recovery,
    rollforward recovery following a restore, or on a HADR standby
    database), the following error may be encountered during online
    extent movement.   The error is only detected by online extent
    movement, and only if the database has not been restarted since
    recovery completed.
    
    2012-03-20-07.45.45.854843+060 I147568A3884       LEVEL: Severe
    PID     : 21364924             TID  : 43915       PROC : db2sysc
    0
    INSTANCE: db2inst1            NODE : 000         DB   : SAMPLE
    APPHDL  : 0-10697              APPID: *LOCAL.DB2.120320064128
    AUTHID  : db2inst1
    EDUID   : 43915                EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, buffer pool services, sqlb_verify_page,
    probe:14
    MESSAGE : ZRC=0x87020036=-2029912010=SQLB_BADHDR "Bad Page
    Header"
              DIA8547C An error occurred in a database page header.
    DATA #1 : String, 64 bytes
    Error encountered trying to read a page - information follows :
    DATA #2 : String, 23 bytes
    Page verification error
    DATA #3 : Page ID, PD_TYPE_SQLB_PAGE_ID, 4 bytes
    7169488
    DATA #4 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 88 bytes
        Obj: {pool:62;obj:10557;type:64} Parent={62;10557}
      lifeLSN:       0000000000000000
      tid:           0 0  0
    <...>
    
    CALLSTCK:
      [0] 0x090000001451E1AC pdLog + 0xD4
      [1] 0x09000000111BF828
    sqlbLogReadAttemptFailure__FUiP16SQLB_OBJECT_DESCT1P9SQLB_PAGEib
    UlT1PcP12SQLB_GLOBALS + 0x194
      [2] 0x09000000111C0244
    sqlbLogReadAttemptFailure__FUiP16SQLB_OBJECT_DESCT1P9SQLB_PAGEib
    UlT1PcP12SQLB_GLOBALS@glue4F2 + 0x9C
      [3] 0x0900000010070B98
    sqlb_verify_page__FP9SQLB_PAGEP16SQLB_OBJECT_DESCUiT3P12SQLB_GLO
    BALSPUl + 0x10C
      [4] 0x090000001446204C sqlbReadPage + 0x19C
      [5] 0x090000001445C838 sqlbGetPageFromDisk__FP11SQLB_FIX_CBi +
    0x678
      [6] 0x090000001445BF88 sqlbfix__FP11SQLB_FIX_CB + 0xB40
      [7] 0x090000000F8F6194
    sqlbScanAllEMPsForObject__FUiP16SQLB_OBJECT_DESCP11SQLB_FIX_CBPl
    P12SQLB_POOL_CBP12SQLB_GLOBALS + 0x4A8
      [8] 0x090000000F8F5508
    sqlbFindEMPMappingMovedExtent__FUiP11SQLB_FIX_CBUsT3UcPUiPUlPlPU
    cP12SQLB_GLOBALS + 0x1250
      [9] 0x090000000FA8DE90
    sqlbMoveHighestExtent__FUilP12SQLB_POOL_CBT1P9sqeBsuEdu + 0x1414
    

Local fix

  • Restart the database before beginning an online extent move
    following a recovery event.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version V9.7 FP6                              *
    ****************************************************************
    

Problem conclusion

  • First fixed in version 9.7 Fix Pack 6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC82362

  • 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

    2012-03-29

  • Closed date

    2012-06-05

  • Last modified date

    2012-06-05

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

  • 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 #: IC82362

Modified date: 05 June 2012