CDC Guide for z/OS

10.4.1
- 10.5.8
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Specifying the EXIT Parameter in the DBD Statement

For IMS to write log records from which the PowerExchange IMS log-based ECCR can capture data, you must specify the IMS Data Capture EXIT parameter in the DBD statement that the DBDGEN utility uses.

The EXIT parameter causes IMS to create log record type x'99' for data that IMS logs for a segment. The IMS log-based ECCR reads the x'99' records to capture change data.

The following example DBD statement includes the EXIT parameter:

DBD NAME=DBFSAMD3,ACCESS=DEDB,RMNAME=DBFHDC40,
    EXIT=(*,KEY,PATH,(CASCADE,KEY,PATH),LOG)

Use of the EXIT parameter increases the number of x'99' log records for the IMS online and batch regions. If you need to reduce the number of x'99' records, edit the EXIT parameter to change PATH to NOPATH. PATH causes IMS to log the entire hierarchical path for the segment, whereas NOPATH causes IMS to log only the segment. However, you can use NOPATH only if the PowerExchange capture registrations each represent a single segment.

IMS 12 introduced some additional EXIT options for Fast Path databases, which might interfere with ECCR change data capture. If your source is an IMS 12 or later Fast Path database, Informatica recommends that you do not specify the following options in the EXIT parameter:

NOBEFORE
. No before data is included in X'99' log records for REPL calls. As a result, the ECCR cannot capture the IMS REPL operations.

NODLET
. No X'99' log records are written for DLET calls. As a result, the ECCR cannot capture the delete operations.

NODLET with CASCADE
. If children of a segment are registered for change capture and you delete the parent segment, the ECCR does not capture the delete for the segment but does capture the deletes for the children.

For more information about the EXIT parameter, see the IBM IMS reference information for the system utility DBDGEN.

Rename Saved Search

Table of Contents

CDC Guide for z/OS

CDC Guide for z/OS

Specifying the EXIT Parameter in the DBD Statement

Specifying the EXIT Parameter in the DBD Statement