PK57139: ABENDS0C4 RSN11 OCCURRED AT X'1338' IN DGOYCNDX (EYECATCHER 2006.268 V210) DUE TO IGNORED SQLCODE +100 IN DGOYCNDX.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DGOYCNDX does a SELECT FROM SYSKEYS for the INDEX
  object SCHUECO.I2BHATKO and gets an SQLCODE=100 (No data).
  A later reference to the catalog field SYSCOLUMNS.FLDPROC
  results in this S0C4, because no storage for the table row
  SYSCOLUMNS was getmained after SQLCODE=100.
  DGOYCNDX must be changed to handle the SQLCODE +100
  Additional keywords:
  SQLCODE100
  

Local fix

• A possible circumvention could be to run RUNSTATS to create
  data in table SYSKEYS for the INDEX object
  SCHUECO.I2BHATKO (in this case).
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 - Explain                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: DGOYCNDX does a SELECT FROM SYSKEYS for *
  *                      an INDEX object and gets a SQLCODE=100  *
  *                      (No data). A later reference to the     *
  *                      catalog field SYSCOLUMNS.FLDPROC        *
  *                      results in S0C4, because no storage for *
  *                      the table row SYSCOLUMNS was getmained  *
  *                      after SQLCODE=100.                      *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  DGOYCNDX does a SELECT FROM SYSKEYS for an INDEX object and gets
  a SQLCODE=100 (No data). A later reference to the catalog field
  SYSCOLUMNS.FLDPROC results in S0C4, because no storage for the
  table row SYSCOLUMNS was getmained after SQLCODE=100.
  
  PROBLEM CONCLUSION:
  Code corrected.
  
  KEYWORDS: EXPLAIN S0C4 DGOYCNDX SQLCODE100
  

Problem conclusion

• Code corrected.
  
  KEYWORDS: EXPLAIN S0C4 DGOYCNDX SQLCODE100
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  PK56508

• APAR is sysrouted TO one or more of the following:

  UK32028 UK32029

Modules/Macros

• DGO@CNDX DGO@MAIN DGOYCNDX DGOYMAIN
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R310 PSY UK32028

     UP07/12/08 P F712

• R410 PSY UK32029

     UP07/12/08 P F712

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.