Replication between XML and LOB columns

Q Replication supports mappings between XML and large object (LOB) columns, with restrictions in some cases.

No restrictions

The following mapping is supported without restriction:

• BLOB to XML

Supported with restrictions

The following mappings are supported, but no automatic load (type I) is allowed because moving data from XML to BLOB or CLOB columns is not supported by the DB2® LOAD or IMPORT utilities that are used in automatic loads:

• XML to BLOB
• XML to CLOB

You can use automatic loads with CLOB to XML, but if you specify the EXPORT and LOAD utilities the source and target databases must be in the same code page:

• CLOB to XML

Attention: If you are replicating CLOB to XML, data loss can occur if both of the following conditions are true:

• The source database uses a non-UTF-8 code page, and the target database uses code page 1208 (codeset UTF-8).
• The Q subscription specifies an automatic load that uses the EXPORT and IMPORT utilities.

In this situation, you must use the LOAD from CURSOR utility for the Q subscription.

Not supported

The following mappings are not supported:

• XML to DBCLOB
• DBCLOB to XML