IBM Support

IT21048: AN ONLINE BACKUP MAY DELETE ARCHIVED LOG FILES THAT ARE REQUIREDBY THE OLDEST REQUIRED BACKUP IMAGE.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • An online backup may delete archived log files that are required
    by the oldest required backup image.
    
    If your database has the following:
    	db2 update db cfg using NUM_DB_BACKUPS <Value>
    	db2 update db cfg using REC_HIS_RETENTN <Value>
    	db2 update db cfg using AUTO_DEL_REC_OBJ ON
    
    Then an online backup initiates auto-prune when the following
    conditions are met:
    	- If the number of backups reaches the NUM_DB_BACKUPS value.
    	- If the oldest online backup which needs retaining has not
    reached REC_HIS_RETENTN.
    	- If the Transaction log file required by this backup is over
    REC_HIS_RETENTN, auto-prune will mistakenly delete it.
    
    eg.
    	db2 update db cfg using NUM_DB_BACKUPS 2
    	db2 update db cfg using REC_HIS_RETENTN 2
    	db2 update db cfg using AUTO_DEL_REC_OBJ ON
    
    When backup-initiated auto-prune happened, it was
    20170606021400. At this point of time, the following is the
    oldest backup that needs retaining. It was an online backup and
    not 2 days old yet.
    
    Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log
    Backup ID
    -- --- ------------------ ---- --- ------------ ------------
    --------------
      B  D  20170606021354001   N    D  S0000025.LOG S0000025.LOG
    ----------------------------------------------------------------
    ------------
      Contains 5 tablespace(s):
    
    00001 SYSCATSPACE
    00002 USERSPACE1
    00003 IBMDB2SAMPLEREL
    00004 IBMDB2SAMPLEXML
    00005 SYSTOOLSPACE
    ----------------------------------------------------------------
    ------------
        Comment: DB2 BACKUP SAMPLE ONLINE
    Start Time: 20170606021354
       End Time: 20170606021356
         Status: A
    ----------------------------------------------------------------
    ------------
      EID: 47 Location: /backups
    
    The first log required by this oldest online backup that needs
    retaining is S0000025.LOG and it is over 2 days old.
    
    Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log
    Backup ID
    -- --- ------------------ ---- --- ------------ ------------
    --------------
      X  D  20170604021347      1    D S0000025.LOG C0000000
    ----------------------------------------------------------------
    ------------
    
    ----------------------------------------------------------------
    ------------
        Comment:
    Start Time: 20170604021347
       End Time: 20170606021357
         Status: A
    ----------------------------------------------------------------
    ------------
      EID: 44 Location:
    /logs/db2inst1/SAMPLE/NODE0000/LOGSTREAM0000/C0000000/S0000025.L
    OG
    
    As a result, auto-prune mistakenly deleted S0000025.LOG.
    

Local fix

  • Can look to increase NUM_DB_BACKUPS and/or REC_HIS_RETENTN.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Platforms                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 LUW v11.1 Mod 3 Fixpack 3                     *
    ****************************************************************
    

Problem conclusion

  • First Fixed in Db2 LUW v11.1 Mod 3 Fixpack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT21048

  • 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

    2017-06-15

  • Closed date

    2018-03-16

  • Last modified date

    2018-03-16

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

    IT20963

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"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:
16 March 2018