Keyed file compare capture runtime report - connect_cdc_sqdata - Latest

The Connect CDC (SQData) Keyed File Data Capture Agent runtime report provides information regarding the collection of changed data.

SQDC000I *******************************************************
SQDC021I sqddfcdc Version 4.00.30
SQDC022I Build-id f2c4068afb04bdf31c565c94bad9c8806b4ab4e7
SQDC000I *******************************************************
SQDC000I
SQD0000I 2018-01-15 10:36:55
Old data store..........................: 'SQDATA.Keyed File.FILEA.BAC'
Number of records read................: 12365480
New data store..........................: 'SQDATA.Keyed File.FILEA'
Number of records read................: 12433121
Output data store.......................: SQDATA.Keyed FileCDC.LOG1
Number of records written.............: 142617
 Number of deletes...................: 8523
 Number of inserts...................: 59118
 Number of updates...................: 74976
SQD0041E (10) Processing completed with return code 0

This particular run shows that the following processing has taken place.

• The name of the older file is DFH320.PREV.FILEX - The total number of records in this dataset is 12,365,480.
• The name of the newer file is DFH320.CICS.FILEX - The total number of records in this dataset is 12,433,121.
• The compare of the two (2) files yielded the following delta changes:
  • The number of records that existed in the older file, but were deleted in the newer file was 8,523.
  • The number of records that did not exist in the older file, but were inserted into the newer file was 59,118.
  • The number of records that changed from the older file to the newer file was 74,976.

• The total number of changed records written to the output CDC datastore was 142,617.