Database Ingestion and Replication

Back Next

Db2 for LUW Source and Amazon Redshift Target

The following table identifies the recommended data-type mappings for

configurations with a Db2 for Linux, UNIX, and Windows (LUW) source and an Amazon Redshift target:

Db2 for LUW Source Data Type	Amazon Redshift Target Data Type
bigint	bigint
binary(`size`), 1 <= size <= 255	binary varying(`size`), 1 <= size <= 255
boolean	boolean
char for bit data	binary varying(1)
char(`size`) for bit data, 2 <= size <= 255	binary varying(`size`), 2 <= size <= 255
character(`size`), 1 <= s <= 255	character(`size`), 4 <= size <= 1020
date	date
decfloat(`precision`), 16 <= p <= 34	character varying(255)
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31	numeric(p,s), 1 <= p <= 31, 0 <= s <= 31
double	double precision
integer	integer
long varchar	character varying(65535)
long varchar for bit data	binary varying(32700)
real	real
smallint	smallint
time	time without time zone
timestamp(`precision`), 0 <= p <= 6	timestamp without time zone
timestamp(`precision`), 7 <= p <= 12	character varying(`size`), 27 <= size <= 32
varbinary(`size`), 1 <= size <= 32672	binary varying(`size`), 1 <= size <= 32672
varchar(`size`) for bit data, 1 <= size <= 32672	binary varying(`size`), 1 <= size <= 32672
varchar(`size`), 1 <= size <= 32672	character varying(`size`), 4 <= size <= 65535