IBM Support

IT20963: An online backup may trigger auto prune to delete the first log required by the oldest backup image that needs retaining.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • An online backup may trigger auto prune to delete the first log
    required
    by the oldest backup image that needs retaining.
    
    In case where the customer sets auto_del_rec_obj on and
    configures num_db_backups and rec_his_retentn, when
    backup-initiated atuo-prune starts to run, if the number of
    backups reaches num_db_backups and the oldest backup that needs
    retaining is an online backup but not rec_his_retentn (in our
    repro, we set it to 2) days old yet, auto-prune will mistakenly
    delete the first log required by this oldest online backup if
    that first log is over rec_his_retentn days old.
    
    The following is the repro:
    
    auto_del_rec_obj ON
    num_db_backups   2
    rec_his_retentn  3
    
    
    In the history file,
    
    Before back-initiated auto prune starts, we have the following:
    
    log file 1
    
    backup 1
    
    log file 2 (over 3 days old and is the first log required by
    backup 2)
    
    log file 3
    
    backup 2   (less than 3 days old and is online backup and the
    first required log file is log file 2)
    
    backup 3
    
    
    
    After the auto prune, we will end up with the following, that
    is, we mistakenly delete the log file required by backup 2.
    
    log file 3
    
    backup 2   (less than 3 days old and is online backup and the
    first required log file is log file 2)
    
    backup 3
    

Local fix

  • Can look to reduce REC_HIS_RETENTN.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 10.5 Fix Pack 9 or higher                     *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 10.5 Fix Pack 9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT20963

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-06-09

  • Closed date

    2017-09-29

  • Last modified date

    2017-09-29

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

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

    IT21048

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA50 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.5","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 January 2022