PI41594: VARIOUS ISSUES AFTER MIGRATING TO DB2 11 CM INCLUDING SQLCODE -302 AND ALAA628E MESSAGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Log Analysis Tool was not resetting a new function mode flag
  that was set while running in a previous version of DB2 that was
  NFM.  With the flag still being set after migrating to DB2 11
  CM, various issues can be encountered.  The issues that may
  occur include SQLCODE -302 or an ALAA628E error message.
  

Local fix

• Rebuild the MODEFILE by stepping through the ISPF panels.  The
  existing MODEFILE can also be manually edited, but this should
  only be done under the supervision of Log Analysis support.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of ALA                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: VARIOUS ISSUES AFTER MIGRATING TO       *
  *                      DB2 11 CM INCLUDING SQLCODE             *
  *                      -302 AND ALAA628E MESSAGE               *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  VARIOUS ISSUES AFTER MIGRATING TO
  

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:

  UI30291 UI30292

Modules/Macros

•    ALAGEN1  ALAMDTL
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R340 PSY UI30291

     UP15/08/25 P F508

• R350 PSY UI30292

     UP15/08/25 P F508

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.