IBM Support

IT29127: DB2DART DETECTS ERRORS AFTER UPGRADING TO V11.1FP4

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • If tablespaces  were created prior to V10  after upgrading  to
    V11.1 Fixpack 4 db2dart may  detect following type Errors
    
             Error: Unable to determine pool relative page number
    for obj rel page 15871 (Obj ID:260, Pool ID:0) due to rc
    0x84020019
             Error: Unable to read pool page 0, object page 15871,
    from pool 0, due to rc 0x84020019
             Error: parent pool 0, object ID 260, object type Data.
             Error: extent map anchor page of object is 128272.
             Error: Unable to determine pool relative page number
    for obj rel page 12873 (Obj ID:260, Pool ID:0) due to rc
    0x84020019
             Error: Unable to read pool page 0, object page 12873,
    from pool 0, due to rc 0x84020019
             Error: parent pool 0, object ID 260, object type Data.
             Error: extent map anchor page of object is 128272.
             Error: Overflow record (Object Page: 111, Slot: 8) is
    pointing to  deleted row (Object Page: 582, Slot: 4)
             Error: in page 111, pool page 137207, of Object 260, in
    tablespace 0.
             Error: Page data will be dumped to report.
    
    db2dart in v11.1m4fp4 is now able to detect an orphan pointer or
    overflow record. However it causes a such false positive error
    against those tablespaces created prior to v10.
    

Local fix

  • Run reorg table command to remove pointer records.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1.4.5 or later                             *
    ****************************************************************
    

Problem conclusion

  • Upgrade to Db2 11.1.4.5 or later
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT29127

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-05-14

  • Closed date

    2019-10-31

  • Last modified date

    2019-10-31

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

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

    IT30810

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
31 October 2019