PK06129: S0C4 IN ALADTL1 PROCESSING CATALOG TABLE SYSINDEXES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Possible S0c4 in ALADTL1 processing catalog table SYSINDEXES if
  rows of that table are still in DB2 V6 (or earlier) format, but
  current DB2 version is V7 (or higher). Row data might contain
  shorter format of V6 causing S0c4. Other DB2 catalog tables may
  suffer similar problems.
  
  OTHER KEYWORDS AND ADDITIONAL SYMPTOMS
  S0C4 ABEND0C4
  USE OF MISCELLANEOUS FILTERS CAN CAUSE ERROR MESSAGE ALAA447E
  

Local fix

• If the customer wants to get by this, they could set 'Include
  Catalog Tables=N' and retry. Or they could try just excluding
  SYSINDEXES, though DB2 could obviously behave this way for any
  catalog table and it could occur again for another catalog
  table.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Log Analysis Tool.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Possible S0c4 in ALADTL1 processing     *
  *                      catalog table SYSINDEXES if rows of     *
  *                      that table are still in DB2 V6          *
  *                      (or earlier) format, but current DB2    *
  *                      version is V7 (or higher). Row data     *
  *                      might contain shorter format of V6      *
  *                      causing S0c4. Other DB2 catalog tables  *
  *                      may suffer similar problems.            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  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:

Modules/Macros

•    ALABHDR  ALADSNM  ALAFR1   ALAGEN1  ALAGFLT
  ALAGFL2  ALAINTF  ALALF1   ALALF1A  ALALF3   ALAQT    ALAQTL
  ALAQTP   ALAREC   ALAREC3  ALASBDB  ALASBDF  ALASLX   ALASUBG
  

Fix information

• Fixed component name

  DB2 LOG ANALYSI

• Fixed component ID

  5655E6601

Applicable component levels

• R210 PSY UK04875

     UP05/07/06 P F507

• R220 PSY UK04876

     UP05/07/06 P F507

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.