Modify IMS DBD's for 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
Last updated
2024-11-25
Published on
2024-11-25T15:05:48.570404

The Log Reader Capture Agent reads type "99" records written to the IMS Log. The EXIT Keyword with the * parameter must be specified on either the SEGM or DBD keywords in the IMS Database Descriptor along with the LOG Parameter.

While IBM's IMS documentation is the definitive resource for specific DBDGEN options, the following summarizes the parameters related to the two Connect CDC SQData IMS Data Capture agents.

Syntax
EXIT=(<exit_name> | *, LOG | NOLOG, KEY, DATA, PATH | NOPATH,(CASCADE,KEY,DATA,PATH|NOPATH))
Keyword and Parameter Descriptions
Keyword Description
<exit_name> | * required Identifies either a specific program "exit_name" or when * is used as a placeholder, that No Exit program is used. Only the TM EXIT Capture utilizes an Exit therefore an * must be specified for the IMS Log Reader Capture agent.
LOG | NOLOG required

Specifies if IMS Data Capture type 99 records are written to the IMS log. Defaults to LOG when * is specified for <exit_name> parameter. You can specify NOLOG on individual SEGM statements, if these segments do not contain data that is to be captured. Note, both a program "Exit" and Log records can be generated to support multiple concurrent capture methods. LOG is required for the Log Reader Capture.

KEY | NOKEY optional

Specifies if the concatenated key is passed along with the changed data. Default is KEY.

DATA | NODATA optional Specifies if the changed data is included in the IMS CDC Log records. Default is DATA.
PATH | NOPATH optional Specifies if PATH data is to be included in the IMS CDC Log records. Default is NOPATH.
CASCADE | NOCASCADE optional Specifies if child segments are captured resulting from a cascade delete to a parent segment. Default is CASCADE.
Changed IMS data can either be captured at the database level or the segment level, depending on where the EXIT keyword is coded in the DBD. If the EXIT keyword is coded at the database level (DBD keyword), then changes for any segment in the database are captured unless overridden at the segment level using the NOLOG parameter. If the IMS Capture is specified on the DBD level and another vendor's data capture Exit is specified on the segment level, the Exit specification on the segment level overrides the Exit specification on the DBD level. If the EXIT keyword is coded at the segment level (SEGM keyword), then only the changes for that segment are captured.