IBM Support

IC90866: WHEN USING DB2ADUTL DELETE OLDER THAN S00000XX.LOG COMMAND THE LOG INCLUDING S00000XX.LOG WOULD BE REMOVED.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Using the db2adutl tool to delete the logs older than the
    specified log, deletes the logs including the specified log as
    well.
    
    Specified log should be excluded from the deletion list.
    
    Here is an example:
    -----------------------
    $ db2adutl query db test
    Query for database TEST
    
    Retrieving FULL DATABASE BACKUP information.
      No FULL DATABASE BACKUP images found for TEST
    <>
    Retrieving LOAD COPY information.
      No LOAD COPY images found for TEST
    
    Retrieving LOG ARCHIVE information.
       Log file: S0000000.LOG, Chain Num: 0, Log stream: 0, Taken
    at: 2013-12-03-17.20.29
       Log file: S0000001.LOG, Chain Num: 0, Log stream: 0, Taken
    at: 2013-12-03-17.20.30
       Log file: S0000002.LOG, Chain Num: 0, Log stream: 0, Taken
    at: 2013-12-03-17.20.30
    $ db2adutl delete logs older than S0000002.LOG without prompting
    
    Query for database TEST
    Retrieving LOG ARCHIVE information.
       Log file: S0000000.LOG, Chain Num: 0, Log stream: 0, Taken
    at: 2013-12-03-17.20.29
       Log file: S0000001.LOG, Chain Num: 0, Log stream: 0, Taken
    at: 2013-12-03-17.20.30
       Log file: S0000002.LOG, Chain Num: 0, Log stream: 0, Taken
    at: 2013-12-03-17.20.30  <-- This log should not be included as
    we only want logs older than S0000002.LOG
    $ db2adutl query db test
    
    Query for database TEST
    Retrieving FULL DATABASE BACKUP information.
      No FULL DATABASE BACKUP images found for TEST
    
    Retrieving LOG ARCHIVE information.
    +++++++++++++++++++++++++++++++++
    
    Log file S0000002.LOG got deleted which should not be deleted.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users using TSM for log archiving.                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 9 or Later.              *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 9.7 Fix Pack 9.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC90866

  • 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

    2013-03-14

  • Closed date

    2013-12-06

  • Last modified date

    2013-12-06

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

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

    IC98168 IC98173

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

Modified date: 06 December 2013