JR56823: UPDATE TABLE DEFINITION WILL FAIL ON A SYSTEM WITH CCSID 5035 IF A TABLE MAPPING ENCODING HAS BEEN EXPLICITLY SET

APAR status

• Closed as program error.

Error description

• Update table definition will corrupt the metadata on a system
  with CCSID 5035 and fail with an MC error: RA MSG 2033 SQL
  Error: 0335 "An error has occurred while updating the access
  parameters" if a table mapping encoding has been explicitly set.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue may affect you if you use IDR/CDC for DB2 i       *
  * 11.3.3 Interim Fix 8 or lower.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * UPDATE TABLE DEFINITION WILL FAIL ON A SYSTEM WITH CCSID     *
  * 5035 IF A TABLE MAPPING ENCODING HAS BEEN EXPLICITLY SET     *
  *                                                              *
  * Details:                                                     *
  *                                                              *
  * Update table definition will corrupt the metadata on a       *
  * system with CCSID 5035 and fail with an MC error: RA MSG     *
  * 2033 SQL                                                     *
  * Error: 0335 "An error has occurred while updating the access *
  * parameters" if a table mapping encoding has been explicitly  *
  * set.                                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR/CDC for DB2 i 11.3.3.3 Interim Fix 11 or newer
  resolves the 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:

Fix information

• Fixed component name

  IS CDC DB2 ISER

• Fixed component ID

  5725E30DI

Applicable component levels