JR63074: COLUMN SIZE TRUNCATED ON CDC KAFKA TARGET

APAR status

• Closed as program error.

Error description

• When replicating data to CDC Kafka target, the Kafka topic
  fields are created based on the source column names. A
  source column name longer than 30 characters is truncated
  at 30 characters in the Kafka Topic.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue may affect you if you are using IDR 11.4.0.3-5572 *
  * or earlier for Kafka.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Column names longer than 30 characters on the source were    *
  * truncated to 30 characters in the Kafka topic.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR 11.4.0.3-5576 or newer for Kafka.             *
  * Add a new system parameter,                                  *
  * "global_column_name_length_limit_chars", and set the value   *
  * to the longest column name length. The maximum length is     *
  * 255. The default value is 30. Then create a subscription as  *
  * usual.                                                       *
  * If you have existing subscriptions that require longer       *
  * column names, recreate the subscriptions (using Generate     *
  * CHCCLP script,                                               *
  * https://www.ibm.com/support/knowledgecenter/SSTRGZ_11.4.0/co *
  * m.ibm.cdcdoc.mcadminguide.doc/tasks/generatingachcclpscriptf *
  * rommc.html).                                                 *
  *                                                              *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.3-5576 or newer for Kafka, then setting
  the system parameter and recreating the subscriptions 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

  IDR KAFKA

• Fixed component ID

  5725E30KA

Applicable component levels