PI98498: DEFINING A DERIVED COLUMN THAT REFERENCES THE SOURCE TABLE, LEADS TO CHC1232E POORLY FORMATTED INPUT ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When the instance of IIDR CDC for z/OS is configured with the
  default DB2 configuration setting TABLEPATHLEVEL=2, attempting
  to define a source-side derived column refrencing a table using
  a two level table path will fail with the error message,
  CHC1232E Poorly formatted input was received for request 2013,
  Based-On identifier count
  

Local fix

• Change the DB2 setting TABLEPATHLEVEL to three, and include the
  database, owner and table name when referencing the table in
  the derived column
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of InfoSphere Change Data Capture for  *
  *                 z/OS  who use derived column expressions.    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When the instance of CDC for z/OS       *
  *                      is configured with the default Db2      *
  *                      configuration setting TABLEPATHLEVEL=2, *
  *                      attempting to define a source-side      *
  *                      derived column that references a table  *
  *                      by using a two-level table path will    *
  *                      fail with the error message, CHC1232E.  *
  *                      Poorly formatted input was received     *
  *                      for request 2013, Based-On identifier   *
  *                      count.                                  *
  ****************************************************************
  * RECOMMENDATION: APPLY CORRECTIVE SERVICE                     *
  ****************************************************************
  The processing of the derived column expression only handled
  the legacy three-level path case. It wasn't updated to cover
  the two-level paths when that support was introduced. A case
  should be added for TABLEPATHLEVEL=2 where referencing table
  uses a two level table path.
  

Problem conclusion

• The derived expression code was updated to correct 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:

  UI56240

Modules/Macros

•    CHCPAASC
  

Fix information

• Fixed component name

  INFO SRVR CDC Z

• Fixed component ID

  5655U7600

Applicable component levels

• RA21 PSY UI56240

     UP18/06/14 P F806

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.