What is the format of column STORE_CLOCK in the CA Datacom Change Data Capture (CDC) feature and where is it derived from?
Article ID: 45005
Updated On:
Products
Datacom
DATACOM - AD
CIS
COMMON SERVICES FOR Z/OS
90S SERVICES
DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
COMMON PRODUCT SERVICES COMPONENT
Common Services
CA ECOMETER SERVER COMPONENT FOC
Easytrieve Report Generator for Common Services
INFOCAI MAINTENANCE
IPC
UNICENTER JCLCHECK COMMON COMPONENT
Mainframe VM Product Manager
CHORUS SOFTWARE MANAGER
CA ON DEMAND PORTAL
CA Service Desk Manager - Unified Self Service
PAM CLIENT FOR LINUX ON MAINFRAME
MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME
GRAPHICAL MANAGEMENT INTERFACE
WEB ADMINISTRATOR FOR TOP SECRET
Xpertware
Issue/Introduction
Question:
What is the format of column STORE_CLOCK in the CA Datacom Change Data Capture (CDC) feature and where is it derived from?
Answer:
The STORE_CLOCK value in the CDC tables is the time the log record was written to the source MUF's LXX log file.
This value is a hardware IBM TOD (time of day) clock stamp. This is the clock the LXX depends on.
The TOD timestamp is an 8 byte field but this STORE_CLOCK field is 10 bytes with a zero at both ends of the TOD timestamp. Bytes 1 and bytes 10 are zeros bytes 2 thru 9 are the TOD timestamp.
The TIME_STAMP field is a 26 byte.
The TIME_STAMP value in the CDC tables is an externalized clock that honors the timezone set by the system.
This timestamp is the same value you will see in the Read Rxx report columns DATE and TIME.
This would be the same externalized clock found in an SQL date/time format.
So TIME_STAMP is stored in SQL date/time format. It is not easily read in raw form.
Additional Information:
Refer the CA Datacom® Core - 15.0 quide for information on Change Data Capture (CDC) feature
Sample CDC programs can be found here under Sample Programs, CA Datacom/DB
There is also COBOL READRXX with sample COBOL program, JCL, and sample report.
Environment
Release:
Component: DB
Component: DB
Feedback
Yes
No
Powered by
