PM30742: LOG ANALYSIS TOOL MAY NOT REPORT ON CERTAIN OBJECTS AFTER THE DB2 LOG RBA HAS BEEN RESET

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Log Analysis Tool uses the table create RBA as stored in
  SYSTABLES field RBA1 in non-data sharing regions to determine if
  the current object in the DB2 catalog is valid for the object
  found in the DB2 log. If the create RBA is greater than the RBA
  of the activity in the log, then Log Analysis Tool reports the
  object as *UNKNOWN because it may or may not be the same object
  as in the catalog. Once the DB2 log RBA aproaches the maximum
  value and is reset - it becomes possible for the object create
  RBA is to be a greater value than the activity RBA. This APAR
  will now change the product to use the object create timestamp
  for the non datasharing region and compare to the LRSN of the
  activity.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Log Analysis Tool.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Log Analysis Tool uses the table        *
  *                      create RBA as stored in SYSTABLES       *
  *                      field RBA1 in non-data sharing regions  *
  *                      to determine if the current object in   *
  *                      the DB2 catalog is valid for the object *
  *                      found in the DB2 log. If the create RBA *
  *                      is greater than the RBA of the activity *
  *                      in the log, then Log Analysis Tool      *
  *                      reports the object as *UNKNOWN because  *
  *                      it may or may not be the same object as *
  *                      in the catalog. Once the DB2 log RBA    *
  *                      aproaches the maximum value and is      *
  *                      reset - it becomes possible for the     *
  *                      object create RBA is to be a greater    *
  *                      value than the activity RBA. This APAR  *
  *                      will now change the product to use      *
  *                      the object create timestamp for the     *
  *                      non datasharing region and compare to   *
  *                      the LRSN of the activity.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Apply the PTF.
  

Temporary fix

Comments

APAR Information

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

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

  UK65190 UK65191

Modules/Macros

•    ALABSDS  ALACDF1  ALAGEN1  ALALF1A  ALAPGR
  ALAREC   ALASQL0  ALASQL7  ALASQL8  ALASQL8C ALASQL9  ALASQL9C
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R310 PSY UK65190

     UP11/03/02 P F103

• R320 PSY UK65191

     UP11/03/02 P F103

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.