IBM Support

IC89863: DB2CKBKP REPORTS MISLEADING ERROR "NO PAGE HEADER: POSSIBLE LOB.ERROR - TABLESPACE PAGE SIZE INCONSISTENT FOR TABLESPACE ID <#>"

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • A 'db2ckbkp -a <DB2_backup_image>' reports misleading error on
    possible LOB page.
    
    The report of db2ckbkp will look like following:
    
            No page header: Possible LOB.
            No page header: Possible LOB.
            No page header: Possible LOB.ERROR - Tablespace page
    size inconsistent for tablespace ID 2.
    
            No page header: Possible LOB.
            No page header: Possible LOB.
    
    The error does not belong to the LOB page it is reported next
    to. It belongs to the next page being checked by db2ckbkp.
    
    Some caution needs to be taken with the db2ckbkp report. The
    utility does not know about the type of a page it is going to
    check (in contrast to the db2dart utility).
    Hence the utility tries to determine if a page is a LOB page,
    DMS page, INDEX page or any other type.
    
    As LOB pages can look like anything you can ignore the error.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 9.7 Fix Pack 9                        *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 version 9.7 Fix Pack 9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC89863

  • 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

    2013-01-26

  • Closed date

    2013-12-23

  • Last modified date

    2013-12-23

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

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

    IC91793 IC93786 IC95430

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 #: IC89863

Modified date: 23 December 2013