IBM Support

IT39314: DOC DEFECT: UTF8 REPLICATION FAILING (ISAM -202) OR TRUNCATING DATA IF SMALLER SOURCE SCHEMA ENDING UP BEING MASTER SCHEMA

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as documentation error.

Error description

  • When migrating data from non-UTF to UTF through ER UTF8
    replication, even providing up to 4 times the space in target
    schema for e.g. CHAR fields, you can incurr data truncation with
    data growing through byte expansion, or replication might fail
    with ISAM error -202 ('illegal character').
    
    This happens with master replicates and with the (smaller)
    source schema ending up being the master schema.
    Note that
     - replicates by default are master replicates now
     - the first participant incurred in 'cdr define replicate'
        command, by default, is chosen as master node
    

Local fix

  • Make sure one of these is true at replicate definition:
     - explicitly specify (UTF) target node as master node, using -M
    <target_server>
     - put target participant first in replicate definition
     - force classic (non-master) replicate using --classic option
       (not recommended)
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of Informix Server documentation prior to 14.10.xC7.   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • The documentation has been corrected.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT39314

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    E10

  • Status

    CLOSED DOC

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-12-06

  • Closed date

    2022-04-07

  • Last modified date

    2022-04-07

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

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

Fix information

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10"}]

Document Information

Modified date:
07 April 2022