Replication between databases with compatible code pages

If your replication configuration requires SQL statements and data to go between systems with differing code pages, the underlying DB2® protocols such as DRDA® handle code page conversion. Also, if data is passed between DB2 and non-DB2 relational databases, DB2 replication relies on the underlying database products to handle any necessary code page conversion.

If you plan to replicate between databases with differing code pages, check the IBM® Information Management Software for z/OS® Solutions Information Center or DB2 Information Center to determine if the code pages you have are compatible. For example, if you are using DB2 for Linux, UNIX, and Windows, see the section on the conversion of character data.

Once you have verified that your databases have compatible code pages, determine if the databases use code pages differently. For example, assume that one database product allows a different code page for each column in a table while another database product requires the code page to be specified only at the database level. A table with multiple code pages in the first product cannot be replicated to a single database in the second product. Therefore, how the databases handle code pages affects how you must set up replication to ensure that data is successfully replicated between the various databases in your environment.