IBM Support

PI82406: REPLICATION FAILS FOR CHAR FOR BIT DATA COLUMN CREATED IN UNICODE TABLE SPACE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When replicating a CHAR FOR BIT DATA column to the target CHAR
    FOR BIT DATA column that is created in Unicode table space,
    CHC0322W will be issued to indicate that this is an invalid
    data type conversion and the replication will fail
    

Local fix

  • NA
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of InfoSphere Data Replication Change  *
    *                 Data Capture for z/OS                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: When CDC for z/OS attempts to replicate *
    *                      a CHAR FOR BIT DATA column to a target  *
    *                      CHAR FOR BIT DATA column that was       *
    *                      created in a Unicode table space,       *
    *                      replication fails and message CHC0322W  *
    *                      is incorrectly issued to indicate that  *
    *                      an invalid data type conversion         *
    *                      occurred.                               *
    ****************************************************************
    * RECOMMENDATION: APPLY CORRECTIVE SERVICE                     *
    ****************************************************************
    When you map to a target CHAR FOR BIT DATA column that was
    created in a Unicode table space, the CCSID for this column is
    set incorrectly in the CDC for z/OS metadata.
    

Problem conclusion

  • The code that sets the CCSID in the metadata was updated to
    correct this issue.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI82406

  • Reported component name

    INFO SRVR CDC Z

  • Reported component ID

    5655U7600

  • Reported release

    A21

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-06-01

  • Closed date

    2017-06-07

  • Last modified date

    2017-07-05

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UI47836

Modules/Macros

  •    CHCDB2DL
    

Fix information

  • Fixed component name

    INFO SRVR CDC Z

  • Fixed component ID

    5655U7600

Applicable component levels

  • RA21 PSY UI47836

       UP17/06/21 P F706

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTVMA","label":"InfoSphere Data Replication for DB2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
05 July 2017