The TM EXIT Capture Agent is an IMS user exit provided by Precisely that captures changes as they are applied to the Database by IMS. The EXIT Keyword must be specified on either the SEGM or DBD keywords in the IMS Database Descriptor along with the <exit_name> which by default is named SQDICDCL.
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.
EXIT=(<exit_name> | *, LOG | NOLOG, KEY, DATA, PATH | NOPATH,(CASCADE,KEY,DATA,PATH|NOPATH))| 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. |
Notes:
- 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.
- The <exit_name> While IMS requires unique capture exit names, it does not have to be SQDICDCL. Customers that use multiple capture exits can specify any name they choose.