Data type considerations
When you replicate or publish certain data types, such as LONG VARCHAR or LOB data types, you should be aware of certain conditions and restrictions.
- General data restrictions for Q Replication and Event Publishing
Some data types are not supported in Q Replication and Event Publishing and some data types can be used only under certain circumstances. - Considerations for large object (LOB) data types for Q Replication and Event Publishing
Replication handles binary large object (BLOB), character large object (CLOB), and double-byte character large object (DBCLOB) data types differently depending on the setting of the Q Capture lob_send_option parameter and the size of the LOB data. - Considerations for replicating the XML data type
DB2® Version 9.1 and later supports native storage of XML documents. You can replicate or publish the XML documents. - Replication between XML and LOB columns
Q Replication supports mappings between XML and large object (LOB) columns, with restrictions in some cases. - Replication of new DB2 Version 9.7 data types (Linux, UNIX, Windows)
Q Replication supports new data types that were introduced with DB2 for Linux, UNIX, and Windows Version 9.7 to make it easier to migrate applications to DB2. - Replication of tables with identity columns
Q Replication allows identity columns in both source and target tables, but because of DB2 restrictions you might need to take extra steps if your source table has columns that are defined with the AS IDENTITY GENERATED ALWAYS clause.