Code page requirements
Before you begin mapping tables, review the default code page values for VSAM Remote Source and update them if required.
- DBCSCODEPAGE
-
- Use: Identifies the encoding of GRAPHIC data in the VSAM data sets. Only required when the ZOSCODEPAGE parameter specifies a mixed-mode code page and your relational tables contain GRAPHIC or VARGRAPHIC columns.
- Default: 0
- Configuration parameter details: DBCSCODEPAGE
- Common code page converters: See Table 3.
- ZOSCODEPAGE
-
- Use: Identifies the encoding of the VSAM data sets.
- Default: 37
- Configuration parameter details: ZOSCODEPAGE
- Common code page converters: See Table 1.
- HOSTCODEPAGE
-
- Use: Identifies the code page of the Linux® container and is the converter for the data that is sent or received between the ClassicCDCVSAM container and Management Console and CHCCLP.
- Default: 1252
- Configuration parameter details: HOSTCODEPAGE
- Common code page converters: See Table 2.
Updating the code page values
- Attach to the container:
docker attach ClassicCDCVSAM - Set the required
values;
SET,CONFIG,SERVICE=CAPTURE,ZOSCODEPAGE=value SET,CONFIG,SERVICE=CNTL,HOSTCODEPAGE=value - Confirm the value that you set by displaying the
configuration:
DISPLAY,CONFIG,ALL
Updating code page values for already-mapped and replicated data
- Make changes as described in Updating the code page values.
- Mark the subscription for refresh by using Management Console or the MTO command SET,REPL.
- If you use MTO commands, manually activate the describe process for the replication with the START,REPL command and DESCRIBE parameter, which validates metadata at the source server and transfers metadata about active subscriptions and replication mappings to the target server.
- To process the refresh for the subscription, start replication using Management Console or START,REPL.
Code page converters
Use the tables below to identify the appropriate code page converters for your single byte-locale. You can then specify the converters for the z/OS® remote log reader, Linux container, and the UNIX and Linux CLI client interface in the UNIX and Linux cac.ini configuration file.
SBCS locales
Table 1 and Table 2 identify the available code page converters for single-byte character sets.
| Converter name (UNIX and Linux) | Code page | ODBC name (Windows) | Character set |
|---|---|---|---|
| ibm-37 | 37 | ibm-37_P100-1995,swaplfnl | CECP (Country Extended Code Page), USA, Canada (ESA*), Netherlands, Portugal, Brazil, Australia, New Zealand |
| ibm-273 | 273 | ibm-273_P100-1995 | CECP, Austria, Germany |
| ibm-277 | 277 | ibm-277_P100-1995 | CECP, Denmark, Norway |
| ibm-278 | 278 | ibm-278_P100-1995 | CECP, Finland, Sweden |
| ibm-280 | 280 | ibm-280_P100-1995 | CECP, Finland, Sweden |
| ibm-284 | 284 | ibm-284_P100-1995 | CECP, Spain, Latin America, Spanish |
| ibm-285 | 285 | ibm-285_P100-1995 | CECP, United Kingdom |
| ibm-290 | 290 | ibm-290_P100-1995 | Japanese Katakana host extended SBCS |
| ibm-297 | 297 | ibm-297_P100-1995 | CECP, France |
| ibm-420 | 420 | ibm-420_X120-1999 | Arabic, all presentation shapes string type 4 |
| ibm-424 | 424 | ibm-424_P100-1995 | Hebrew|, legacy IDs: CS 941/2, CP 424/2, string type 4 |
| ibm-500 | 500 | ibm-500_P100-1995 | CECP, Belgium, Canada (AS/400*), Switzerland, International Latin-1 |
| ibm-803 | 803 | ibm-803_P100-1999 | Hebrew Set A, legacy code, string type 4 |
| ibm-838 | 838 | ibm-838_P100-1995 | Thai host extended SBCS |
| ibm-870 | 870 | ibm-870_P100-1995 | Latin-2 - EBCDIC multilingual |
| ibm-871 | 871 | ibm-871_P100-1995 | CECP, Iceland |
| ibm-875 | 875 | ibm-875_P100-1995 | Greek |
| ibm-1025 | 1025 | ibm-1025_P100-1995 | Cyrillic, Multilingual |
| ibm-1026 | 1026 | ibm-1026_P100-1995 | Turkey Latin-5 |
| ibm-1047 | 1047 | ibm-1047_P100-1995,swaplfnl | Latin-1 and Open Systems |
| ibm-1097 | 1097 | ibm-1097_P100-1995 | Farsi |
| ibm-1112 | 1112 | ibm-1112_P100-1995 | Baltic, multilingual |
| ibm-1122 | 1122 | ibm-1122_P100-1999 | Estonia |
| ibm-1123 | 1123 | ibm-1123_P100–1995 | Cyrillic Ukraine |
| ibm-1130 | 1130 | ibm-1130_P100-1997 | Vietnamese |
| ibm-1132 | 1132 | ibm-1132_P100-1998 | Lao |
| ibm-1137 | 1137 | ibm-1137_P100-1999 | Devanagari EBCDIC, based on Unicode character set |
| ibm-1140 | 1140 | ibm-1140_P100-1997,swaplfnl | ECECP, USA, Canada, Netherlands, Portugal, Brazil, Australia, New Zealand |
| ibm-1141 | 1141 | ibm-1141_P100-1997 | ECECP, Austria, Germany |
| ibm-1142 | 1142 | ibm-1142_P100-1997,swaplfnl | ECECP, Denmark, Norway |
| ibm-1143 | 1143 | ibm-1143_P100-1997,swaplfnl | ECECP, Finland, Sweden |
| ibm-1144 | 1144 | ibm-1144_P100-1997,swaplfnl | ECECP, Italy |
| ibm-1145 | 1145 | ibm-1145_P100-1997,swaplfnl | ECECP, Spain, Latin America, Spanish |
| ibm-1146 | 1146 | ibm-1146_P100-1997,swaplfnl | ECECP, United Kingdom |
| ibm-1147 | 1147 | ibm-1147_P100-1997,swaplfnl | ECECP, France |
| ibm-1148 | 1148 | ibm-1148_P100-1997,swaplfnl | ECECP, International 1 |
| ibm-1149 | 1149 | ibm-1149_P100-1997,swaplfnl | ECECP, Iceland |
| ibm-1153 | 1153 | ibm-1153_P100-1999,swaplfnl | Latin-2 - EBCDIC, multilingual with euro |
| ibm-1154 | 1154 | ibm-1154_P100-1999 | Cyrillic Multilingual with euro |
| ibm-1155 | 1155 | ibm-1155_P100-1999 | Turkey, Latin-5 with euro |
| ibm-1156 | 1156 | ibm-1156_P100-1999 | Baltic, multilingual with euro |
| ibm-1157 | 1157 | ibm-1157_P100-1999 | Estonia, EBCDIC with euro |
| ibm-1158 | 1158 | ibm-1158_P100-1999 | Cyrillic Ukraine, EBCDIC with euro |
| ibm-1160 | 1160 | ibm-1160_P100-1999 | Thai host with euro |
| ibm-1164 | 1164 | ibm-1164_P100-1999 | Vietnamese with euro |
| ibm-4899 | 4899 | ibm-4899_P100-1998 | Hebrew Set A, legacy code, maximal set with euro and new sheqel, string type 4 |
| ibm-4971 | 4971 | ibm-4971_P100-1999 | Greek, with euro |
| ibm-5123 | 5123 | ibm-5123_P100-1999 | Japanese Latin host extended SBCS, with euro |
| ibm-8482 | 8482 | ibm-8482_P100-1999 | Japanese Katakana, with euro, growing CS |
| ibm-12712 | 12712 | ibm-12712_P100-1998,swaplfnl | Hebrew, max set with euro and new sheqel, string type 10 |
| ibm-16804 | 16804 | ibm-16804_X110-1999,swaplfnl | Arabic, all presentation shapes, string type 4, with euro |
| Converter name | Code page | ODBC name | Description |
|---|---|---|---|
| ibm-367 | 367 | ibm-367_P100-1995 | ANSI X3.4 ASCII standard; USA |
| ibm-437 | 437 | ibm-437_P100-1995 | USA, many other countries and regions, PC base PC data |
| ibm-737 | 737 | ibm-737_P100-1997 | MS-DOS Greek, PC data |
| ibm-775 | 775 | ibm-775_P100-1996 | MS-DOS Baltic, PC data |
| ibm-813 | 813 | ibm-813_P100-1995 | ISO 8859-7, Greek and Latin |
| ISO-8559–1 | 819 | ISO-8859-1 | ISO 8859-1, Latin-1 countries and regions |
| ibm-850 | 850 | ibm-850_P100-1995 | LP 222, Latin-1 countries and regions, PC data |
| ibm-851 | 851 | ibm-851_P100-1995 | Greek, PC data |
| ibm-852 | 852 | ibm-852_P100-1995 | Latin-2 multilingual, PC data |
| ibm-855 | 855 | ibm-855_P100-1995 | Cyrillic, PC data |
| ibm-856 | 856 | ibm-856_P100-1995 | Hebrew, string type 5, PC data |
| ibm-857 | 857 | ibm-857_P100-1995 | Turkey Latin-5, PC data |
| ibm-858 | 858 | ibm-858_P100-1997 | MLP 222, Latin-1 with euro, Latin-1 countries and regions, PC data |
| ibm-860 | 860 | ibm-860_P100-1995 | Portugal, PC data |
| ibm-861 | 861 | ibm-861_P100-1995 | Iceland, PC data |
| ibm-862 | 862 | ibm-862_P100-1995 | Hebrew, migration, string type 4, PC data |
| ibm-863 | 863 | ibm-863_P100-1995 | Canada, PC data |
| ibm-864 | 864 | ibm-864_X110-1999 | Arabic, string type 5, PC data |
| ibm-865 | 865 | ibm-865_P100-1995 | Denmark, Norway, PC data |
| ibm-866 | 866 | ibm-866_P100-1995 | Cyrillic, Russian, PC data |
| ibm-867 | 867 | ibm-867_P100-1998 | Hebrew, a modification of code page 862, string type 4, PC data |
| ibm-869 | 869 | ibm-869_P100-1995 | Greek, PC data |
| ibm-874 | 874 | ibm-874_P100-1995 | Thai PC data extended SBCS |
| ibm-878 | 878 | ibm-878_P100-1996 | Russian Internet koi8-r |
| ibm-897 | 897 | ibm-897_P100-1995 | Japanese PC data single byte. |
| ibm-901 | 901 | ibm-901_P100-1999 | Baltic, 8-bit with euro |
| ibm-902 | 902 | ibm-902_P100-1999 | Estonia, 8-bit with euro |
| ibm-912 | 912 | ibm-912_P100-1995 | Latin-2 - ISO 8859-2 |
| ibm-913 | 913 | ibm-913_P100-2000 | ISO Latin-3 - 8859-3 |
| ibm-914 | 914 | ibm-914_P100-1995 | Latin-4 - ISO 8859-4 |
| ibm-915 | 915 | ibm-915_P100-1995 | Cyrillic, 8-bit, ISO 8859-5 |
| ibm-916 | 916 | ibm-916_P100-1995 | ISO 8859-8, Hebrew, string type 5 |
| ibm-920 | 920 | ibm-920_P100-1995 | ISO 8859-9 Latin-5, ECMA-128, Turkey TS-5881 |
| ibm-921 | 921 | ibm-921_P100-1995 | Baltic, 8-bit, ISO 8859-13 |
| ibm-922 | 922 | ibm-922_P100-1999 | Estonia, 8-bit |
| ibm-923 | 923 | ibm-923_P100-1998 | ISO 8859-15, Latin-9 with euro, total of 8 characters replaced from 819 |
| ibm-1051 | 1051 | ibm-1051_P100-1995 | HP emulation, for use with Latin-1. GCGID SF150000 is mapped to a control X'7F' |
| ibm-1089 | 1089 | ibm-1089_P100-1995 | ISO 8859-6, Arabic, string type 5 |
| ibm-1098 | 1098 | ibm-1098_P100-1995 | Farsi, personal computer |
| ibm-1124 | 1124 | ibm-1124_P100-1996 | Cyrillic Ukraine, 8-Bit |
| ibm-1125 | 1125 | ibm-1125_P100-1997 | Cyrillic Ukraine, PC data Windows, Cyrillic |
| ibm-1129 | 1129 | ibm-1129_P100-1997 | ISO-8 Vietnamese |
| ibm-1131 | 1131 | ibm-1131_P100-1997 | Cyrillic Belarus, PC data |
| ibm-1133 | 1133 | ibm-1133_P100-1997 | ISO-8 Lao |
| ibm-1162 | 1162 | ibm-1162_P100-1999 | Thai Windows, with euro |
| ibm-1168 | 1168 | ibm-1168_P100-2002 | Ukrainian KOI8-U |
| ibm-1250 | 1250 | ibm-1250_P100-1995 | Windows Latin-2 |
| ibm-1251 | 1251 | ibm-1251_P100-1995 | Windows, Cyrillic |
| ibm-1252 | 1252 | ibm-1252_P100-2000 | Windows, Latin-1 |
| ibm-1253 | 1253 | ibm-1253_P100-1995 | Windows, Greek |
| ibm-1254 | 1254 | ibm-1254_P100-1995 | Windows, Turkey |
| ibm-1255 | 1255 | ibm-1255_P100-1995 | Windows, Hebrew, string type 5 |
| ibm-1256 | 1256 | ibm-1256_P110-1997 | Windows, Arabic, string type 5 |
| ibm-1257 | 1257 | ibm-1257_P100-1995 | Windows, Baltic Rim |
| ibm-1258 | 1258 | ibm-1258_P100-1997 | Windows, Vietnamese |
| ibm-1276 | 1276 | ibm-1276_P100-1995 | Adobe PostScript standard encoding |
| ibm-4909 | 4909 | ibm-4909_P100-1999 | ISO-8, Greek and Latin with euro |
| ibm-5346 | 5346 | ibm-5346_P100-1998 | Windows Latin-2, version 2 with euro |
| ibm-5347 | 5347 | ibm-5347_P100-1998 | Windows, Cyrillic version 2 with euro |
| ibm-5348 | 5348 | ibm-5348_P100-1997 | Windows, Latin-1, Version 2 with euro) |
| ibm-5349 | 5349 | ibm-5349_P100-1998 | Windows, Greek version 2 with euro |
| ibm-5350 | 5350 | ibm-5350_P100-1998 | Windows, Turkey version 2 with euro |
| ibm-5351 | 5351 | ibm-5351_P100-1998 | Windows, Hebrew version 2 with euro, string type 5 |
| ibm-5352 | 5352 | ibm-5352_P100-1998 | Windows, Arabic version 2 with euro, string type 5 |
| ibm-5353 | 5353 | ibm-5353_P100-1998 | Windows, Baltic Rim version 2 with euro |
| ibm-5354 | 5354 | ibm-5354_P100-1998 | Windows, Vietnamese version 2 with euro |
| ibm-9005 | 9005 | ibm-9005_X100-2005 | Greek ISO 8859-7,2003 |
| ibm-9447 | 9447 | ibm-9447_P100-2002 | Windows, Hebrew, Windows 1255-12/2001, string type 5 |
| ibm-9449 | 9449 | ibm-9449_P100-2002 | Windows, Baltic Rim with euro and 7 additional characters |
Table 3 shows the DBCSCODEPAGE values for z/OS EBCDIC DBCS code pages.
| Converter name | Code page | ODBC name | Description |
|---|---|---|---|
| ibm-930 | 930 | ibm-930_P120-1999 | Japanese Katakana-Kanji host mixed including 4370 UDC (User Defined Character), extended SBCS |
| ibm-933 | 933 | ibm-933_P110-1995 | Korean host mixed including 1880 UDC, Extended SBCS |
| ibm-935 | 935 | ibm-935_P110-1999 | Simplified Chinese host mixed including 1880 UDC, extended SBCS |
| ibm-937 | 937 | ibm-937_P110-1999 | Traditional Chinese host mixed including 6204 UDC, extended SBCS |
| ibm-939 | 939 | ibm-939_P120-1999 | Japanese Latin-Kanji host mixed including 4370 UDC, extended SBCS |
| ibm-1364 | 1364 | ibm-1364_P110-1997 | Korean host mixed extended including 11,172 full Hangul |
| ibm-1371 | 1371 | ibm-1371_P100-1999 | Traditional Chinese host mixed including: 6204 UDC, Extended SBCS including SBCS and DBCS euro |
| ibm-1388 | 1388 | ibm-1388_P103-2001 | Simplified Chinese DBCS- GB 18030 host with UDCs and Uygur extension. |
| ibm-1390 | 1390 | ibm-1390 | Extended Japanese Katakana-Kanji host mixed for JIS X0213 (Japanese Industrial
Standards), including: 6205 UDC, extended SBCS, includes SBCS & DBCS euro |
| ibm-1399 | 1399 | ibm-1399 | Extended Japanese Latin-Kanji host mixed for JIS X0213 including: 6205 UDC, extended SBCS, includes SBCS & DBCS euro |