PowerExchange for CDC and Mainframe
- PowerExchange for CDC and Mainframe 10.5.1
- All Products
Data Source Type
| Time Stamp Type
|
---|---|
Adabas
| The HDDATE time stamp from the PLOG block header, which indicates when the block was written.
In Adabas environments with a low level of update activity, the same time stamp might be reported for multiple updates that occurred at different times.
|
Datacom table-based CDC
| The Coordinated Universal Time (UTC) time or local time when the change record was written to the Datacom LXX log. The LOCAL_TIME parameter in the ECCR configuration member, ECCRDCMP, controls whether the UTC or local time is used.
|
Db2 for i (i5/OS)
| An i5/OS journal time stamp that reflects when the change was recorded in the journal.
|
Db2 for
z/OS
| The time at which the DB2 ECCR captured the change data record. Each record in a UOW has a different time stamp. Usually, this time stamp is a UTC value that reflects the time zone of the DB2 for z/OS system.
|
IDMS
| The time at which the change data record was written to the IDMS log file. This time stamp is equivalent to the storeclock (STCK) time stamp. It does not reflect the local time zone.
|
IMS log-based CDC
| The time at which the change was recorded in the IMS logs.
|
IMS synchronous CDC
| The time at which the change occurred.
|
Batch VSAM and CICS/VSAM
| The time at which the change record was captured. Each record in a UOW has a different time stamp. Usually, this time stamp is a UTC value.
|
Data Source Type
| Time Stamp Type
|
---|---|
Db2 on Linux, UNIX, or Windows
| The time stamp of the transaction commit. This time stamp is an ascending virtual time stamp (VTS) of the Db2 system, which usually corresponds to the UTC value.
|
Microsoft SQL Server
| The time at which the change was written to the distribution database.
|
MySQL
| The time stamp of the change event that MySQL recorded in the binary log.
|
PowerExchange Express CDC for Oracle
| The time stamp type is controlled by the TIME_STAMP_MODE parameter setting in the OPTIONS statement of the Express CDC configuration file.
|
PostgreSQL
| The time of the transaction commit.
|