IBM Support

IC81927: BACKUP OF SMS TABLESPACE CAN FAIL TO DETECT INVALID PAGE HEADERS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Backup of SMS tablespace can fail to detect invalid page headers
    
    db2ckbkp with the -a option will detect the corruption in the
    backup image, and report errors similar to this one
    
    ==================
    BUFFER 1
    ==================
    BufAddr  PoolID Token Type     Offset   FileSize ObjectSize
    OrigSize Object Name
    -------- ------ ----- ---- ---------- ---------- ----------
    ---------- -----------
    <snip>
    00048400:     3    19    0          0          1       4096
    0 "Tablespace: 3, Table: SQL00019"
    00049600:     3    19    1          0          3      12288
    0 "Tablespace: 3, Table: SQL00019"
    ERROR - Tablespace page size inconsistent for tablespace ID 3.
    ERROR:  Corrupted BPS page header at position 0x800000001828
    
    ERROR:  VerifyBufferObject - read in object type 1 at location
    17098752
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 6                        *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 9.7 Fix Pack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC81927

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

  • Closed date

    2012-06-06

  • Last modified date

    2012-06-06

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

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

    IC84538

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC81927

Modified date: 06 June 2012