Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging and Reporting
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  15. Appendix B: PowerExchange Glossary

Time Stamps That Are Reported in the DTL__CAPXTIMESTAMP Field by Data Source

Time Stamps That Are Reported in the DTL__CAPXTIMESTAMP Field by Data Source

The time stamp that PowerExchange reports in the generated DTL__CAPXTIMESTAMP field in change records depends on the data source type and on certain parameter settings.
For PowerExchange data sources on z/OS, the TIMESTAMP parameter in the UOWC CAPI_CONNECTION controls the type of time stamp that PowerExchange reports in the DTL__CAPXTIMESTAMP field. If you set the TIMESTAMP parameter to COMMIT, PowerExchange reports the time stamp of the transaction commit on the source for all changes in the transaction. If you use the default parameter value of LOG, PowerExchange retrieves the time stamp from the source database logs. In this case, the time stamp type depends on the source type.
The following table describes the time stamps that PowerExchange reports when you use the default value of LOG for the TIMESTAMP parameter:
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.
For other data sources that do not use the UOWC CAPI_CONNECTION statement, PowerExchange determines the appropriate time stamp to report in the DTL__CAPXTIMESTAMP field. For PowerExchange Express CDC for Oracle sources, the TIME_STAMP_MODE parameter in the OPTIONS statement of the Express CDC configuration file controls the time stamp type.
The following table describes the time stamp types that PowerExchange reports for these data sources:
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.
  • If you use the default value of LOGTIME, PowerExchange reports the time stamp of the change on source database, as recorded in the redo logs. This time stamp reflects the local time zone.
  • If you specify COMMITTIME, PowerExchange reports the time stamp of the transaction commit on the source database.
  • If you specify BEGINTIME, PowerExchange reports the time stamp of the begin UOW log record.
PostgreSQL
The time of the transaction commit.

0 COMMENTS

We’d like to hear from you!