Setting encoding schemes

To specify the proper encoding scheme for tables, modify the SQL that is used to generate the tables.

It is recommended that you stop the Capture and Apply programs before you change the encoding scheme of existing tables.
Note: The Db2® for z/OS V8 SQL Reference contains more information about CCSID.
To set encoding schemes:
  1. Create new source and target tables with the proper encoding scheme.
    It is recommended that afterwards that you initialize Capture with a cold start and restart the Apply program.
  2. If you have already created your source and target tables, change the encoding schemes of the existing target and source tables.
    Existing tables must have the same encoding scheme within a table space
    1. Use the Reorg Tablespace utility to unload the existing table space.
    2. Drop the existing table space.
    3. Re-create the table space specifying the new encoding scheme.
    4. Use the Load utility to load the old data into the new table space.
      See the Db2 for z/OS V8 Utility Guide and Reference for more information on the Load and Reorg utilities.
  3. Use the Replication Center to create new control tables with the proper encoding scheme.
  4. Use the Reorg and Load utilities to modify the encoding scheme for existing control tables and CD tables.
  5. When you create new replication sources or subscription sets by using the ASNCLP or Replication Center, specify the proper encoding scheme.