How To Convert Self-created Characters To UTF8 While Migrating DB2/AS400 To Oracle Using GoldenGate, the DB2/AS400 has CCSID 37,937,28709,65535 for its table columns. (Doc ID 2831229.1)

Last updated on APRIL 17, 2023

Applies to:

Goal

We are having a project to migrate data from DB2/AS400 to Oracle using Oracle GoldenGate.
The DB2/AS400 has CCSID 37,937,28709,65535 for its table columns.
There may be double-byte Chinese characters storing in single byte columns.
Further more, customer may create some Chinese characters which not exists in the standard CCSID character set by using the reserved area.
When migrating data from the DB2/AS400 to oracle, we must convert all characters to Oracle's AL32UTF8.
It seems GoldenGate cannot convert some Chinese characters correctly, especially the self-created Chinese characters.

I think GoldenGate should have many in-built encoding mappings that help to convert characters from each CCSID to UTF8.
Where are the encoding mappings?
Can we edit the encoding mappings so that we can add the self-created character mapping?

 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.