PQ99459: MSG ALAA0411E DETECTED DURING LOG-BACKWARD PROCESSING OF DETAIL REPORT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Msg ALAA0411E is reported during log-backward processing of
  detail report when DATA CAPTURE CHANGES (DCC) are on for the
  affected table. This should not occur because DCC forces DB2 to
  log each individual DELETE. The 'Mass Delete' type log record is
  also written by DB2 in this scenario, and that causes the error
  message to be written. The 'Mass Delete' log record should be
  ignored during detail report program logic in this specific
  scenario.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Log Analysis Tool.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Msg ALAA0411E is reported during        *
  *                      log-backward processing of detail       *
  *                      report when DATA CAPTURE CHANGES (DCC)  *
  *                      are on for the affected table. This     *
  *                      should not occur because DCC forces DB2 *
  *                      to log each individual DELETE. The      *
  *                      'Mass Delete' type log record is        *
  *                      also written by DB2 in this scenario,   *
  *                      and that causes the error message to    *
  *                      be written. The 'Mass Delete' log       *
  *                      record should be ignored during detail  *
  *                      report program logic in this specific   *
  *                      scenario.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  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:

  PQ99485

Modules/Macros

•    ALAA41
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R210 PSY UK00205

     UP05/02/14 P F502

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.