IBM Support

IT03543: DB2 INSPECT INCORRECTLY REPORTS EMP PAGE ERRORS FOR LARGE LOB TABLES

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When there is a large amount of LOB data in a table so that
    level 2 EMP pages are required then the INSPECT command can
    incorrectly calculate the next EMP page resulting in the errors
    similar to the following:
    
    DATABASE: SAMPLE
    VERSION : SQL09076
    
    2014-05-15-09.06.15.460665
    
    Action: CHECK TABLE
    Schema name: DB2INST1
    Table name: TABLELOB
    Tablespace ID: 11  Object ID: 1037
    Result file name: tb_inspect_trc.txt
    
        Table phase start (ID Signed: 1037, Unsigned: 1037;
    Tablespace ID: 11) : DB2INST1.TABLELOB
    
          Data phase start. Object: 1037  Tablespace: 11
          The index type is 2 for this table.
           Traversing DAT extent map, anchor 626164.
           Extent map traversal complete.
           DAT Object Summary: Total Pages 1369 - Used Pages 1369 -
    Free Space 7 %
          Data phase end.
    
          Index phase start. Object: 524  Tablespace: 15
           Traversing INX extent map, anchor 460.
           Extent map traversal complete.
           INX Object Summary: Total Pages 437 - Used Pages 437
          Index phase end.
    
          LOB phase start. Object: 6  Tablespace: 6
           Traversing LOB extent map, anchor 44.
          Error: In page 19944, physical page 19944 of object 6 in
    tablespace 6, pagesize 4096.
          Error: Hexadecimal dump of page contents.
    0000  *3FD848E9 3DD7CB35 4760D8EB B879CD10*
    *..H....5G....y..*
    ...
    0FF0  *D1EFD352 8B3E89D6 02CDA36A F314F127*
    *...R.......j....*
          Error: Page header invalid revnum value 0.
          Error: Page header invalid field begoff value 55359,
    expected value 48.
          Error: Page header invalid field datlen value 59720,
    expected value 4048.
          Error: Page header LSN (x06DAAD703BA52B81) is greater than
    database current LSN (x0000014556D31436).
          Error: Page header invalid field poolPageNumber value
    902551357, expected value 19944.
          Error: Page header invalid field objectID value 30687,
    expected value 6.
          Error: Page header invalid field objectType value 216,
    expected value 67.
          Error: Page header invalid field objectPageNumber value
    902551357, expected value 19944.
          Error: Page header invalid field tablespaceSeed value
    281901496, expected value 6.
          Error: Found error type  (scan relative page 143740000 EMP
    16952012 with entries 1011440027 > max 1000) drtbps.C
    dartNextEMPExtent 1983 .
          Error: In page 19945, physical page 19945 of object 6 in
    tablespace 6, pagesize 4096.
          Error: Hexadecimal dump of page contents.
    0000  *1D93B0F6 1B36ADB3 BB5C268B E06C32A7*
    *.....6.......l2.*
    
    The Pages reported to be having the problem will not be
    consistent and may change on each run of the INSPECT command.
    

Local fix

Problem summary

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

Problem conclusion

  • First fixed in DB2 LUW 9.7 Fix Pack 10
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT03543

  • 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

    2014-08-01

  • Closed date

    2014-11-10

  • Last modified date

    2014-11-10

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

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

    IT03657 IT03662

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

Modified date: 10 November 2014