PH48330: INCORRECT SQLOUT GENERATION FOR TEMPORAL TABLES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When there are update with generated always columns defined as
  ROW BEGIN, ROW END or AS TRANSACTION START ID, the product does
  not generate these values in update statement. This APAR fixes
  this situation.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Log Analysis Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: When there are update with generated    *
  *                      always columns defined as ROW BEGIN,    *
  *                      ROW END or AS TRANSACTION START ID,     *
  *                      the product does not generate these     *
  *                      values in update statement. This APAR   *
  *                      fixes this situation.                   *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Incorrect SQLOUT generation for temporal tables
  

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:

  UI81808

Modules/Macros

• ALAFRMTR ALASQL1  ALASQL2  ALASQL3
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R350 PSY UI81808

     UP22/08/06 P F208

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.