PK63838: POSSIBLE ALAA0440E OR ALAA0447E WHILE USING MISCELLANEOUS FILTERS AND TABLES WITH DCC TURNED LOG FORWARD MODE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• If miscellaneous filters are used without object filters and
  there is a mixture of objects using Data Capture Changes and
  objects not using Data Capture Changes, an error condition can
  occur that results in ALAA0440E or ALAA0447E while in Log
  Forward mode. This occurs if the DBID, PSID combination of the
  table with DCC on is less than the DBID, PSID combination of the
  table with out DCC on - and when all the activity for the
  non-DCC object occurs before the activity for the DCC object for
  the reporting timeframe.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Log Analysis Tool.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: If miscellaneous filters are used       *
  *                      without object filters and there is a   *
  *                      mixture of objects using Data Capture   *
  *                      Changes and objects not using Data      *
  *                      Capture Changes, an error condition     *
  *                      can occur that results in ALAA0440E or  *
  *                      ALAA0447E while in Log Forward mode.    *
  *                      This occurs if the DBID, PSID           *
  *                      combination of the table with DCC on    *
  *                      is less than the DBID, PSID             *
  *                      combination of the table with out DCC   *
  *                      on - and when all the activity for the  *
  *                      non-DCC object occurs before the        *
  *                      activity for the DCC object for the     *
  *                      reporting timeframe.                    *
  ****************************************************************
  * 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:

Modules/Macros

•    ALAGLOAD
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R220 PSY UK35507

     UP08/04/23 P F804

• R230 PSY UK35508

     UP08/04/23 P F804

• R310 PSY UK35509

     UP08/04/23 P F804

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.