IBM Support

IC80774: USING DB2ADUTL "QUERY LOGS BETWEEN" AND THE ".LOG" EXTENSION ON THE LOG FILE NAME RETURNS AN INCORRECT LOG LIST

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • This problem was introduced in v9.7 FP5.
    
    Using db2adutl in version 9.7 FP5 with "query logs between" and
    specifying the .LOG extension does not works anymore and
    incorrect query results are being returned. This can lead to
    incorrect files being deleted.
    
    
    Consider the following content in the query result:
    
    $ db2adutl query logs  db sample
    
    Query for database SAMPLE
    
    Retrieving LOG ARCHIVE information.
    
       Log file: S0137876.LOG, Chain Num: 4, DB Partition Number: 0,
    Taken    at: 2011-01-26-09.54.51
       Log file: S0137877.LOG, Chain Num: 4, DB Partition Number: 0,
    Taken    at: 2011-02-02-14.28.46
    ----------------------------------------------------------------
    --------------------------------------------------
    
    
    In the following command using the "BETWEEN" syntax, the two log
    numbers passed in parameter do not exist (note that they start
    with S1 and S2 respectively instead of S0 as above):
    
    $ db2adutl query logs between S1137876.LOG and S2137878.LOG db
    sample
    
    Query for database SAMPLE
    
    Retrieving LOG ARCHIVE information.
    
       Log file: S0137876.LOG, Chain Num: 4, DB Partition Number: 0,
    Taken      at: 2011-01-26-09.54.51
       Log file: S0137877.LOG, Chain Num: 4, DB Partition Number: 0,
    Taken      at: 2011-02-02-14.28.46
    ----------------------------------------------------------------
    ----------------------------------------------------
    
    You can see that with the above "BETWEEN" syntax, all log
    entries are returned instead of returning no entries as it
    should.
    
    
    Another type of wrong results is showing an empty list returned
    instead of the expected list of logs shown above in the first
    query when using different parameters for the "BETWEEN" syntax:
    
    $ db2adutl query logs between S0137876.LOG and S0137878.LOG db
    sample
    
    Query for database SAMPLE
    
      Retrieving LOG ARCHIVE information.
    
      No LOG ARCHIVE images found for SAMPLE
    

Local fix

  • Do not specify the ".LOG" extension at the end of the log file
    name in the db2adutl query as follows:
    
    $ db2adutl query logs between  S0137876 and S0137878 db sample
    
      Query for database SAMPLE
    
      Retrieving LOG ARCHIVE information.
    
       Log file: S0137876.LOG, Chain Num: 1, DB Partition Number: 0,
    Taken   at: 2011-01-26-09.54.51
       Log file: S0137877.LOG, Chain Num: 1, DB Partition Number: 0,
    Taken   at: 2011-02-02-14.28.46
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * all                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Same as Apar description                                     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to V9.7 FP6 or use the given Local Fix.              *
    ****************************************************************
    

Problem conclusion

  • First fixed in V9.7 FP6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC80774

  • 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

    2012-01-11

  • Closed date

    2012-06-05

  • Last modified date

    2012-06-05

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

  • 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

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC80774

Modified date: 05 June 2012