PH69380: A CHAR in a field of derived column is incorrectly failing UTF-8 validation.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When a %BEFORE expression referencing a VARCHAR column is
  selected for one of the source columns, the internal UTF-8
  validation may, in rare cases, incorrectly flag a character as
  invalid. This results in message CHC0974E, followed by CHC0321W,
  and causes replication to stop.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IIDR CDC for DB2 for z/OS who are   *
  *                 using source column expressions for          *
  *                 character data.                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a %BEFORE expression is used for   *
  *                      data in a tablespace with CCSID UNICODE *
  *                      the UTF-8 validation of the data is     *
  *                      improperly flagging a CHAR field as     *
  *                      invalid. CHC0974E and CHC0321W messages *
  *                      are seen and the subscription is        *
  *                      terminated.                             *
  ****************************************************************
  UTF-8 validation for a CHAR field fails while processing column
  expression for a data in a tablespace with CCSID UNICODE.
  

Problem conclusion

• The UTF-8 validation logic has been updated to correctly
  handle variable length CHAR fields.
  

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:

  UO06992

Modules/Macros

• CHCMBARA CHCMBCHS CHCMBCHT CHCMBDAN CHCMBDES CHCMBDEU CHCMBELL
  CHCMBENG CHCMBENP CHCMBENU CHCMBESP CHCMBFIN CHCMBFRA CHCMBFRB
  CHCMBFRC CHCMBFRS CHCMBHEB CHCMBISL CHCMBITA CHCMBITS CHCMBJPN
  CHCMBKOR CHCMBNLB CHCMBNLD CHCMBNOR CHCMBPTB CHCMBPTG CHCMBRMS
  CHCMBRUS CHCMBSVE CHCMBTHA CHCMBTRK CHCPALPF CHCPALRP CHCSDTUT
  

Fix information

• Fixed component name

  INFO SRVR CDC Z

• Fixed component ID

  5655U7600

Applicable component levels

• RA21 PSY UO06992

     UP26/03/12 P F603

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.