PK46129: MESSAGE ALAA358E MAY INCORRECTLY BE RETURNED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In cases where table versioning was performed (e.g., ALTER
  TABLE... ALTER COLUMN... SET DATA TYPE ...), message ALAA358E
  may be incorrectly returned.
  
  * If all log activity processed by DB2 Log Analysis Tool is:
    - past the point of a REORG on the affected tablespace, and
    - that REORG was taken AFTER such column alteration took
      place,
    then the message should not appear.
  
  * If any log activity occurred prior to that REORG,
    then the message is correct and this APAR will have no affect.
  
  NOTE: Only affects DB2 Log Analysis Tool v2.1 and v2.2.
        DB2 Log Analysis Tool v2.3 functions correctly.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Log Analysis Tool.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: In cases where table versioning was     *
  *                      performed (e.g., ALTER TABLE...         *
  *                      ALTER COLUMN... SET DATA TYPE ...),     *
  *                      message ALAA358E may be incorrectly     *
  *                      returned.                               *
  *                      * If all log activity processed by DB2  *
  *                      Log Analysis Tool is:                   *
  *                        - past the point of a REORG on the    *
  *                       affected tablespace, and               *
  *                        - that REORG was taken AFTER such     *
  *                       column alteration took place,          *
  *                       then the message should not appear.    *
  *                      * If any log activity occurred prior    *
  *                      to that REORG, then the message is      *
  *                      correct and this APAR will have no      *
  *                      affect.                                 *
  *                      NOTE: Only affects DB2 Log Analysis     *
  *                            Tool v2.1 and v2.2. DB2 Log       *
  *                            Analysis Tool v2.3 functions      *
  *                            correctly.                        *
  ****************************************************************
  * 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:

  UK26328 UK26329

Modules/Macros

•    ALASQL
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R210 PSY UK26328

     UP07/06/27 P F706

• R220 PSY UK26329

     UP07/06/27 P F706

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.