PQ73402: INCORRECT OUTPUT IN GENERATED UNDO/REDO SQL DURING DETAIL REPORTRUN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Incorrect output in generated redo/undo SQL during Detail report
  run. Incorrect output can be caused by longer table name SQL
  followed by shorter table name SQL statements, and incorrect
  handling of embedded quotes in long varchar type columns.
  This APAR allows undo/redo SQL to be generated correctly.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of IBM DB2 Log Analysis.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: Incorrect output in generated redo/undo *
  *                      SQL during Detail report run. Incorrect *
  *                      output can be caused by longer table    *
  *                      name SQL followed by shorter table name *
  *                      SQL statements, and incorrect handling  *
  *                      of embedded quotes in long varchar type *
  *                      columns. This APAR allows undo/redo SQL *
  *                      to be generated correctly.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Code changes have been made to address this issue.
  

Problem conclusion

• Apply 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:

  UQ76424

Modules/Macros

•    ALABSQL
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R120 PSY UQ76424

     UP03/05/01 P F304

• R130 PSY UQ76425

     UP03/05/15 P F305

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.