Discussion:
Is it possible to replicate among different local database environment?
(too old to reply)
n***@naver.com
2007-08-20 08:26:52 UTC
Permalink
I have a customer who uses two DB2 UDB and he want to replicate each engines.
But each databases language codeset are different. One is 970 and the other is UTF8.

I wonder in this case , it is possible to replicate among different local database environment.

Thanks in advance.
Knut Stolze
2007-08-20 13:06:20 UTC
Permalink
Post by n***@naver.com
I have a customer who uses two DB2 UDB and he want to replicate each
engines. But each databases language codeset are different. One is 970 and
the other is UTF8.
I wonder in this case , it is possible to replicate among different local
database environment.
As long as it's possible to map all characters between the code pages, you
won't have a problem. If there are code points in the character sets that
cannot be mapped, then the default behavior of DB2 applies (the Apply-part
of Replication is basically just like any other DB2 application). I'm not
sure what the default is. It may be to use surrogate characters or return
warnings/errors. If you just replicate from whatever to UTF-8 (and not the
other way), I wouldn't expect much problems.
--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Loading...