IBM Support

IC79627: DB2DART & INSPECT NEED TO REMOVE THE CHECK DMS HEADER FREE SPACE OFFSET

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • db2dart & INSPECT report a false message about DMS Header free
    space offset, this is normal to have this, and the REDIST should
    already be fixed to cope with this condition.  the check should
    be remove from both db2dart & INSPECT commands.
    
    db2dart:
    
             Traversing extent map for object type: 0
          Extent Map traversal complete.
       Table inspection start: DB2INST1.SAMPLE
    
          Data inspection phase start. Data obj: 17183  In pool: 8
          Error: DMS Header free space offset 0x2BC points inside
    the slot directory space 0x2D4.
          Error: in page 4212, pool page 12100596, of Object 17183,
    in tablespace 8.
          Error: Page data will be dumped to report.
    
            000       *0030 3FD0 0000 1074 0500 0002 0000 0008*
    *.0.....t........*
            010       *00B8 A3F4 431F 0000 0000 0000 0000 0E2F*
    *....C...........*
            020       *0000 0238 AF16 F5E0 1E08 0204 0000 0000*
    *...8............*
            030       *                                         **
            030  000  *016A 0012 0012 0000 0046 02BB 0000 0C20*
    *.j.......F......*
            040  010  *84C7 0000 3F8E 3F66 3F38 3F10 3EE2 3EBA*
    *.......f.8......*
            050  020  *3E8C 3E64 3E36 3E0E 3DE0 3DB8 3D8A 3D62*
    *...d.6.........b*
    
    INSPECT:
    
    Action: CHECK DATABASE
    Result file name: SAMPLE.dat
    
            Database phase start.
            Tablespace phase start. Tablespace ID: 8
            Table phase start (ID Signed: 17183, Unsigned: 17183;
    Tablespace ID: 8) :
            Data phase start. Object: 17183  Tablespace: 8
            Error: In page 4212, physical page 4212 of object 17183
    in tablespace 8, pagesize 16384.
            Error: Hexadecimal dump of page contents.
    0000  *00303FD0 00001074 05000002 00000008* *.0.....t........*
    0010  *00001074 431F0000 00000000 0000DF0F* *...tC...........*
    0020  *00000238 AF16F5E0 1E080204 00000000* *...8............*
    0030  *016A0012 00120000 004602BB 00000C20* *.j.......F......*
    ...
            Error: Found error type (invalid free block pointer
    field value 0x2BC in the data header points inside the slot
    directory space 0x2D4).
          Data phase end.
        Table phase end.
      Tablespace phase end.
    Database phase end.
    
    You could also see the following from db2dart :
    
             Index inspection phase start. Index obj: 17183  In
    pool: 8
              Scanning pages for unique index itoken(0) root
    page:1p.
              Scanning pages for index itoken(1) root page:2p.
              Error: Number of data rows 99913 does not match number
    of index entries 100000.
              Total key errors found: 1.
             Index inspection phase end.
    

Local fix

  • Run Classic REORG:
     db2 "REORG TABLE DB2INST1.SAMPLE"
    or
     db2 "REORG TABLE DB2INST1.SAMPLE USE <tablespace>"
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Platforms                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to v9.7 Fixpack 6 or Higher                          *
    ****************************************************************
    

Problem conclusion

  • Fixed in v9.7 Fixpack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC79627

  • 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

    2011-11-04

  • Closed date

    2012-07-17

  • Last modified date

    2012-07-17

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

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

    IC79630

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

Modified date: 17 July 2012