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

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 is sysrouted FROM one or more of the following:

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

Fix information

Applicable component levels