The Replication Agent allows you to control how it sends the IBM DB2 Universal Database DATE, TIME, and TIMESTAMP column values to the Replication Server. There are two options:
Send the value as a character string (the default)
Send the value as a Sybase datetime value
The value of the Replication Agent pdb_convert_datetime configuration parameter determines how the Replication Agent handles temporal datatypes.
If you set the pdb_convert_datetime parameter to true, all corresponding datatypes in a replication definition for DATE, TIME, and TIMESTAMP columns are converted to the Sybase datetime datatype.
If you set the pdb_convert_datetime parameter to false, the datatype in a replication definition for a DATE, TIME, or TIMESTAMP column must be either:
A Replication Server user-defined datatype (UDD), or
A character datatype.
The character (char or varchar) datatype specified in a replication definition for for a DATE, TIME, or TIMESTAMP column must have sufficient length to accommodate the column’s default display length.
See the Replication Agent Administration Guide for more information about the pdb_convert_datetime parameter and a complete list of datatype mapping for the IBM DB2 Universal Database datatypes. For a complete list of the IBM DB2 Universal Database datatype mapping, see the Replication Agent Primary Database Guide.
