Data Replication
- Data Replication 9.7.0
- All Products
DB2 Source Datatype | DB2 Target Datatype | Comments |
---|---|---|
BIGINT | BIGINT | - |
BLOB( n ) | BLOB( n ) | Data Replication does not extract LOB data from compressed rows. Use the global.lob_truncation_size runtime parameter to set the maximum size of a source LOB value that the Applier and InitialSync can replicate to the target. Maximum supported size for change data capture is 50 MB. |
CHAR FOR BIT DATA( n ) | CHAR FOR BIT DATA( n ) | - |
CHARACTER( n ) | CHARACTER( n ) | - |
CHARACTER FOR BIT DATA( n ) | CHARACTER FOR BIT DATA( n ) | - |
CLOB( n ) | CLOB( n ) | Data Replication does not extract LOB data from compressed rows. Use the global.lob_truncation_size runtime parameter to set the maximum size of a source LOB value that the Applier and InitialSync can replicate to the target. Maximum supported size for change data capture is 50 MB. |
DATE | DATE | - |
DBCLOB( n ) | DBCLOB( n' )
| Data Replication does not extract LOB data from compressed rows. Use the global.lob_truncation_size runtime parameter to set the maximum size of a source LOB value that the Applier and InitialSync can replicate to the target. Maximum supported size for change data capture is 50 MB. |
DECFLOAT |
| - |
DECIMAL( p ,s ) |
| - |
DOUBLE | DOUBLE | - |
FLOAT( p ) | FLOAT( p ) | - |
GRAPHIC( n ) | GRAPHIC( n' )
| - |
INTEGER | INTEGER | - |
LONG VARCHAR | LONG VARCHAR | Data Replication does not extract LONG VARCHAR data from compressed rows. |
LONG VARCHAR FOR BIT DATA | LONG VARCHAR FOR BIT DATA | Data Replication does not extract LONG VARCHAR data from compressed rows. |
LONG VARGRAPHIC | LONG VARGRAPHIC | Data Replication does not extract LONG VARGRAPHIC data from compressed rows. |
REAL | REAL | - |
SMALLINT | SMALLINT | - |
TIME | TIME | - |
TIMESTAMP | TIMESTAMP | The Extractor truncates the fractional seconds part of source TIMESTAMP values to nine digits (nanoseconds). |
VARCHAR( n ) | VARCHAR( n ) | - |
VARCHAR FOR BIT DATA( n ) | VARCHAR FOR BIT DATA( n ) | - |
VARGRAPHIC( n ) | VARGRAPHIC( n' )
| - |