PI24892: SQL CORRECTION IN TCZ MEMBER ALALT1

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Optional TCz job ALALT1 has an error in the SQL UPDATE statement
  labeled #5. This statement is used to update the LAT_LRSN column
  when using the packed format.  The line 'SUBSTR(LAT_LRSN,7,12)'
  read 'SUBSTR(LAT_LRSN,7,6)'.  The current UPDATE statement
  returns a -433 SQLCODE is executed.
  

Local fix

• Manually change 'SUBSTR(LAT_LRSN,7,12)'
              to: 'SUBSTR(LAT_LRSN,7,6)'
  before executing the UPDATE statement.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Log Analysis.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Optional TCz job ALALT1 has an error in *
  *                      the SQL UPDATE statement labeled #5.    *
  *                      This statement is used to update the    *
  *                      LAT_LRSN column when using the packed   *
  *                      format.  The line                       *
  *                      'SUBSTR(LAT_LRSN,7,12)' read            *
  *                      'SUBSTR(LAT_LRSN,7,6)'.  The            *
  *                      current UPDATE statement returns        *
  *                      a -433 SQLCODE is executed.             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

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:

  UI22444

Modules/Macros

•    ALALT1
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R340 PSY UI22444

     UP14/10/31 P F410

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.