DB2 for z/OS Primary Datatype Translation

The Replication Agent for DB2 UDB for z/OS Date_in_char, Time_in_char, and Timestamp_in_char configuration parameters control whether the Replication Agent sends values in character strings, or converts them to the Sybase datetime format.

See the Replication Agent for DB2 UDB Users and Troubleshooting Guide for a complete description of these parameters.

Note: If you use any date- or time-related user-defined datatypes (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 recommends 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.

IBM DB2 UDB represents midnight as 24.00. This format may not be compatible with other data servers. To change the value from 24.00 to 00.00, you can modify the datatype definition to automatically change the value.

IBM DB2 UDB allows year values that may be incompatible with other data servers. If the replicate data server does not allow years as early as the IBM DB2 UDB does, set the LTMCFG parameter, Minimum_year, so that the DB2 UDB Replication Agent modifies any year earlier than the Minimum_year parameter to the Date_conv_default parameter.