What is the format of column STORE_CLOCK in the CA Datacom Change Data Capture (CDC) feature and where is it derived from?
search cancel

What is the format of column STORE_CLOCK in the CA Datacom Change Data Capture (CDC) feature and where is it derived from?

book

Article ID: 45005

calendar_today

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