Disable data capture - connect_cdc_sqdata - Latest

Connect CDC (SQData) Change Data Capture

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Change Data Capture
Copyright
2024
First publish date
2000
ft:lastEdition
2024-09-05
ft:lastPublication
2024-09-05T15:00:09.754973

There are multiple methods for permanently or temporarily disabling data capture. Selecting which method to use depends on the reason it is necessary to do so:

  1. Application of captured changes by downstream Engine has been or must be interrupted for a short time due to system outage, communication failure, Engine failure, need for Engine script modification, etc.

    Solution: Temporarily stop or pause the Log Reader Capture Agent.

  2. Data Capture no longer required for specific Source Data segment.

    Solution: The solution depends, in part, how capture was specified in the DBD. If the Exit parameter is specified at the segment level then the DBD should be updated to remove that Exit specification. If capture was specified with the Exit parameter at the DBD level, either the DBD can be revised to segment level specification or the EXIT keyword and NOLOG parameter can be added at the segment Level.

  3. Data Capture no longer required for any of the Segments in a DBD.

    Note: This stops changes from being written to the LogStream meaning those changes cannot be captured.

    Solution: Remove the EXIT keyword(s) from the DBD keeps IMS from writing the 99 records read by the IMS Log Reader Data Capture Agent for the database/segment(s) in which the EXIT keyword was previously specified. If other data capture exits are defined for a particular IMS database/segment and still required then removing only the ",LOG" parameter will eliminate the 99 records read by the Log Reader Capture.