IBM Support

IT22352: DB2 : IF ANY COMMAND WITH RECLAIM EXTENTS OPTION IS RUN ON AN MDC TABLE DURING A BACKUP, A ROLLFORWARD ON IT COULD FAIL

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

  • - When one or more commands like "TRUCATE TABLE with REUSE
    STORAGE option" or "AUTO or MANUAL REORG TABLE with RECLAIM
    EXTENTS option" i.e. commands which perform a "reclaim extents"
    operation are executed on an MDC table while an online backup is
    in progress,
    DB2 frees those extents for the table, but the operation is not
    logged correctly.
    The backup completes successfully.
    
    - Restore of this backup is also successful.
    
    - When the Rollforward is executed, DB2 tries to replay a
    "create new block" operation in logs for the table in question
    and fails with following error as these extents are no more
    available, they were already freed .
    
    db2diag.log will have LEVEL: Error message:
    
    FUNCTION: DB2 UDB, buffer pool services, sqlbExtendObject,
    probe:650
    MESSAGE : ZRC=0x8402001A=-2080243686=SQLB_EMP_MAP_INFO_END "EMP
    MAP INFO END"
    
    The fix will ensure that the "reclaim extent" operations run
    during backup are logged correctly so replay during rollforward
    will not fail.
    

Local fix

  • As a workaround, please avoid running the following when there
    is an online backup in progress:
    
    1) TRUCATE TABLE with the REUSE STORAGE option on an MDC table
    2) REORG TABLE with the RECLAIM EXTENTS option (AUTO or MANUAL)
    on an MDC table
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * MDC TABLEs                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Please, see Error Description and install the fix.           *
    ****************************************************************
    

Problem conclusion

  • Please, see Error Description and install the fix.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT22352

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-09-11

  • Closed date

    2018-07-16

  • Last modified date

    2018-07-16

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

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

    IT22385 IT22386

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

[{"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":"10.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 July 2018