Datatypes for IBM DB2 UDB Replication

Learn about the datatypes supported and unsupported for replicating into and out of IBM DB2 UDB.

Replicating Datatypes into IBM DB2 UDB

These Sybase datatypes are supported or unsupported by ECDA 15.0.1 for replicating into IBM DB2 UDB.

These IBM DB2 UDB datatypes are supported or unsupported by ECDA 15.0.1 for replicating into IBM DB2 UDB.

ECDA Supported and Unsupported IBM DB2 UDB Datatypes
Datatypes	Supported	Unsupported
IBM DB2 UDB	`bigint`	`blob`
	`graphic`	`clob`
	`vargraphic`	`dbclob`
	`decfloat` (for replication only, not gateway)	`long varchar`
	`smallint`	`long vargraphic`
	`float`	`ROWID`
	`integer`	`long varchar for bit data`
	`decimal`	`xml`
	`real`	UDDs
	`double`
	`time`
	`timestamp`
	`date`
	`char`
	`varchar`
	`char for bit data`
	`varchar for bit data`

Note: The decfloat datatype is supported only in a replication environment (not for gateway or any other ECDA use).

These IBM DB2 UDB datatypes are supported or unsupported by Replication Agent for replicating out of IBM DB2 UDB.

Replication Agent does not support these features of IBM DB2 UDB 9.5 or 9.7:

Replication of XML datatype

Note: Since Replication Agent does not support replicating XML, restrictions have been imposed on marking a table containing XML columns. Replication Agent generates an error message each time an attempt is made to mark a table with XML columns. To replicate all but the XML columns of a table, use the force option when marking the table for replication.
When replicating DECFLOAT columns from UDB to other databases that do not support DECFLOAT or an equivalent datatype, DECFLOAT is mapped to FLOAT, which may cause a loss of precision.
Replication Agent does not support replication of DECFLOAT special values such as positive and negative INFINITY, NAN, and SNAN. Replication Agent replicates these values to NULL if the column is nullable, or 0.0 if the column is not nullable.