Last updated: Feb 25, 2025
When you use IBM Db2 on Cloud as a source connection, you can replicate only some data types.
When you use the Db2 on Cloud connection with the Copy goal, Data Replication will attempt to create or replicate to a column in the target database with a similar column name and compatible data type. If the data type of the
target column is not compatible, it will convert the target data type to a string-based data type (for example, varchar).
The following table shows the Db2 on Cloud data types that you can replicate. If a source table contains a column with an unsupported data type, the table is not replicated to the target database.
| Data Type | Supported |
|---|---|
| SMALLINT | ✓ |
| [INTEGER \ INT] | ✓ |
| BIGINT | ✓ |
| [DECIMAL \ DEC \ NUMERIC \ NUM] (precision-integer, scale-integer) | ✓ |
| FLOAT(integer) | ✓ |
| REAL | ✓ |
| DOUBLE | ✓ |
| DOUBLE PRECISION | ✓ |
| FLOAT | ✓ |
| DECFLOAT(precision-integer) | ✓ |
| [CHARACTER \ CHAR] (integer [OCTETS \ CODEUNITS32]) | ✓ |
| [CLOB \ CHARACTER LARGE OBJECT \ CHAR LARGE OBJECT] (integer [K \ M \ G] [OCTETS \ CODEUNITS32]) | |
| VARCHAR(size) | ✓ |
| LONG VARCHAR | |
| GRAPHIC(integer [CODEUNITS16 \ CODEUNITS32]) | ✓ |
| VARGRAPHIC(integer [CODEUNITS16 \ CODEUNITS32]) | ✓ |
| DBCLOB(integer [K \ M \ G] [CODEUNITS16 \ CODEUNITS32]) | |
| [NATIONAL CHARACTER \ NATIONAL CHAR \ NCHAR] (integer) | ✓ |
| [NATIONAL CHARACTER LARGE OBJECT \ NCHAR LARGE OBJECT \ NCLOB] (integer [K \ M \ G]) | |
| BINARY(integer) | ✓ |
| [VARBINARY \ BINARY VARYING] (integer) | ✓ |
| [BLOB \ BINARY LARGE OBJECT] (integer [K \ M \ G]) | |
| DATE | ✓ |
| TIME | ✓ |
| TIMESTAMP(integer) or TIMESTAMP | ✓ |
| XML | |
| BOOLEAN | ✓ |
Parent topic: Replicating Db2 on Cloud data