CDC Guide for z/OS

10.4.0 HotFix 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.1
- 10.4.0

Back Next

Implementing the IFI306 OPT Statement for the DB2 ECCR

You can set the OPT keyword to Y or F in the IFI306 statement in the REPL2OPT DD configuration member to reduce the amount of data that DB2 passes to DB2 ECCR retrieves and improve CDC performance. This procedure describes how to implement the IF306 OPT statement and restart the ECCR.

When the IFI306 OPT keyword is set to Y or F, the DB2 ECCR cannot create event markers for DB2 QUIESCE operations in the PowerExchange Logger for z/OS log files. Verify that this restriction is tolerable in your environment before you implement the IFI306 OPT statement.

You can also use this procedure to remove the IFI306 OPT statement if it was previously implemented.

If you run the DB2 ECCR in a DB2 data-sharing environment, use the following QUIESCE command to shut down the DB2 ECCR:

MODIFY eccr_task_name,QUIESCE

If you shut down the DB2 ECCR with this QUIESCE command, or if you do not run the DB2 ECCR in a DB2 data-sharing environment, skip to Step 3.

If you cannot use the QUIESCE command to shut down the DB2 ECCR and you run the ECCR in a DB2 data-sharing environment, continue to Step 2.

In the EDMMSG data set, find message PWXEDM177012I and record the LAST DB2 READ LOC, which is an RBA or LRSN value, from this message.

PWXEDM177012I ECCR STATUS: LAST DB2 READ LOC rba_or_lrsn.data_sharing_member_id.sequence_number
OLDEST OPEN UOW {urid.data_sharing_member_id|*NONE*}

You will need this value to perform a special start of the DB2 ECCR.

Define the IFI306 OPT statement in the REPDB2OP member of the RUNLIB library, or in whichever member to which the REPL2OPT DD statement in the DB2 ECCR JCL points.

If you run the DB2 ECCR in a DB2 data-sharing environment and used the ECCR QUIESCE command to shut down the ECCR, or if you do not run the DB2 ECCR in a DB2 data-sharing environment, warm start the DB2 ECCR.

At this point, the implementation of the IFI306 OPT statement is complete.

If you run the DB2 ECCR in a DB2 data-sharing environment but did not
use the QUIESCE command to shut down the ECCR, perform the following substeps:

Special start the ECCR.

You must enter the STARTLOC parameter in the START statement in the REPDB2OP member of the RUNLIB library, or if the REPL2OPT DD in the ECCR JCL points to another member, enter the STARTLOC parameter in that member. For the STARTLOC value, enter the last read RBA or LRSN from message PWXEDM177012I. For example:

START STARTLOC=00000000000C9041C372 USEDIR,USESTAT

You do not need to issue a DB2 ECCR REFRESH command to activate use of the IFI306 OPT statement.

Edit the REPDB2OP member of the RUNLIB library again to specify the WARM parameter in the START statement.

The next time the DB2 ECCR is restarted, it resumes change capture from last read RBA or LRSN so that no data loss occurs.

Rename Saved Search

Table of Contents

CDC Guide for z/OS

CDC Guide for z/OS

Implementing the IFI306 OPT Statement for the DB2 ECCR

Implementing the IFI306 OPT Statement for the DB2 ECCR