PK84571: ALAA440E WHEN USING ONLY MISC FILTERS ON NON DCC TABLES WHEN IN LOG FORWARD MODE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If only using Misc Filters on tables that do not have data
  capture change on, the log records are going to have be
  processed again for all the tables that have activity to report.
  In the case where there is one and only one piece of activity to
  report and it has the full row image in the log, while in log
  forward processing mode the logs were not processed correctly
  the second time.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Log Analysis Tool.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: If only using Misc Filters on tables    *
  *                      that do not have data capture change    *
  *                      on, the log records are going to have   *
  *                      be processed again for all the tables   *
  *                      that have activity to report. In the    *
  *                      case where there is one and only one    *
  *                      piece of activity to report and it has  *
  *                      the full row image in the log, while    *
  *                      in log forward processing mode the      *
  *                      logs were not processed correctly the   *
  *                      second time.                            *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

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:

  UK46452 UK46453

Modules/Macros

•    ALAALA   ALABSQL  ALAETV   ALALF1   ALAMLOB
  ALASBDB  ALASBDF  ALASLX   ALASUBG  ALAUNRE
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R230 PSY UK46452

     UP09/05/15 P F905

• R310 PSY UK46453

     UP09/05/15 P F905

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.