PI69692: Message CHC0112E is issued if a target table has an expression based index.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A CHC0112E error occurs during administration for indexes with
  expression-based ordering.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Any users of InfoSphere CDC for z/OS who     *
  *                 require administration for indexes with      *
  *                 expression-based ordering.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: The ORDERING field for indexes with     *
  *                      expression-based ordering in            *
  *                      SYSIBM.SYSKEYS is blank, which is not   *
  *                      handled by CDC for z/OS. During         *
  *                      administration for indexes of this      *
  *                      type, CHC0112E error will occur.        *
  ****************************************************************
  * RECOMMENDATION: APPLY CORRECTIVE SERVICE                     *
  ****************************************************************
  An expression-based index on a table will cause message CHC0112E
  to be produced when the table is being administered.
  

Problem conclusion

• Additional logic to handle a blank ORDERING field in the DB2
  SYSIBM.SYSKEYS Catalog table is added to fix this issue.
  

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:

  UI42946

Modules/Macros

•    CHCDTCFR CHCPAACM CHCTDTGP CHCTMDDL
  

Fix information

• Fixed component name

  INFO SRVR CDC Z

• Fixed component ID

  5655U7600

Applicable component levels

• RA21 PSY UI42946

     UP16/12/09 P F612

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.