Record Modification Time (&TIMSTAMP)
The date and time of when the update or refresh was made on the source.
In environments that support microsecond precision, the date and time format of this journal
control field is YYYY-MM-DD-HH:MM:SS.UUUUUU. Otherwise, CDC Replication limits the precision to
milliseconds, and sets the microsecond component to zeroes or does not include it at all.
- Data Type
- Timestamp
- Restrictions and limitations:
- Depending on the replication engine that you install, journal
control fields may or may not be supported when mirroring or refreshing data. Unsupported journal
control fields contain default values that vary between the replication engines.
- CDC Replication Engine for Db2® for i—When mirroring data, this journal control field contains the date and time when you write the data to the source table. When refreshing data, this journal control field contains the current date and time.
- CDC Replication Engine for Db2 Database—When mirroring data, this journal control field contains the date and time when you write the data to the source table. When refreshing data, this journal control field contains the date and time of when CDC Replication refreshed the first row.
- CDC Replication Engine for Db2 for z/OS®—When mirroring data, this journal control field contains the date and time when you write the data to the source table. When refreshing data, this journal control field contains the date and time when the SQL FETCH was issued. Note that the time value format (local or UTC) is determined by the REPLTIMESTAMP configuration parameter.
- CDC Replication Engine for Oracle XStream—The value for this journal control field is obtained from Oracle XStream DefaultLCR.getSourceTime().