PK86760: A MASS DELETE COULD BE REPORTED FOR TABLES WITH DCC ON UNDER CERTAIN CIRCUMSTANCES BY DB2 LOG ANALYSIS TOOL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• For tables utilizing Data Capture Changes (DCC),
  DB2 reports each row that was deleted during a mass delete.
  DB2 Log Analysis Tool (LAT) only reports the delete records in
  this case not the Mass Delete.
  
  If the URID is split across logs or another delete log record on
  a reported table is mixed within the log records, it is possible
  that LAT will report the deletes and a Mass Delete.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Log Analysis Tool.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: For tables utilizing Data Capture       *
  *                      Changes (DCC), DB2 reports each row     *
  *                      that was deleted during a mass delete.  *
  *                      DB2 Log Analysis Tool (LAT) only        *
  *                      reports the delete records in this      *
  *                      case not the Mass Delete. If the URID   *
  *                      is split across logs or another delete  *
  *                      log record on a reported table is mixed *
  *                      within the log records, it is possible  *
  *                      that LAT will report the deletes and a  *
  *                      Mass Delete.                            *
  ****************************************************************
  * 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:

  UK47295 UK47296

Modules/Macros

•    ALA@FSP  ALA@MNT  ALAALA   ALABSQL  ALAGEN1
  ALAGFLT  ALAGLOAD ALALLB   ALASTOR
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R230 PSY UK47295

     UP09/06/12 P F906

• R310 PSY UK47296

     UP09/06/12 P F906

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.