Data type restrictions in Db2 Warehouse

Replication of spatial data types is not supported, and some data types can be replicated only under certain circumstances.

LONG VARCHAR and LONG VARGRAPHIC

If you add LONG VARCHAR columns to a table after you create a replication set and the table previously had no LONG columns, you must use the ALTER TABLE statement to enable DATA CAPTURE CHANGES INCLUDE LONGVAR COLUMNS for the new LONG VARCHAR or LONG VARGRAPHIC columns.

User-defined data types

You can replicate user-defined distinct data types, but not user-defined structured and reference data types. User-defined distinct data types (distinct data types in Db2 Warehouse) are converted to the base data type before they are replicated.

Encrypt scalar function

To replicate data that uses the encrypt scalar function, the data type must be VARCHAR FOR BIT DATA at the source. This data replicates successfully as long as the source and target use the same code page and the decrypt functions are available. Replication of columns with encrypted data should only be used with servers that support the DECRYPT_BIN or DECRYPT_CHAR function.