The LTM for MVS Date_in_char configuration parameter controls whether the Replication Agent sends values in IBM DB2 Universal Database DATE columns as default CHAR(10) character strings, or converts them to the Sybase datetime format.
In general, if the value of the Date_in_char parameter is set to N, all of the corresponding datatypes in replication definitions for DATE columns must specify the Sybase datetime datatype.
See the Replication Agent for DB2 UDB User’s and Troubleshooting Guide for a complete description of the Date_in_char parameter. See the Replication Server Administration Guide for a complete description of UDDs and their use.
If you use any date- or time-related UDDs in a replication
definition, Sybase recommends that you configure the Replication
Agent to send data to the Replication Server in the format that
is native to the primary database. Sybase prefers to not have
the Replication Agent perform any datatype translations.
In general, the Replication Agent for DB2 UDB should not perform datatype translations. However, when all of the replicate data servers require the same translation, to save processing time, it is probably better to perform the translation once at the Replication Agent, rather than at each replicate database DSI.
