CHGDC—Change data capture


Use the Modify Change Data Capture panel or the CHGDC command to specify whether to use IMS DataPropagator to propagate SQL changes to tables that are defined with the setting DATA CAPTURE CHANGES.

Modify Change Data Capture panel

DDTG DBI1 Modify Change Data Capture
Command ===> _________________________________________________________________

 Command: CURRENT
Description . . . . . . . . : CHANGE DATA CAPTURE

Type the new change data capture indicator you wish to change to. Then press Enter.

Change Data Capture Indicator
Enabled . . . . . . . . . . (Y or N)

Command syntax and parameters

image2018-12-20_15-31-59.png

Value

Description

DB2ssid

Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies.

opertuneID

OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job).

Y

IMS DataPropagator will propagate the SQL changes.

N

The SQL changes will not be propagated.

NORESET

The changes you request remain in effect until the Db2 subsystem is cycled.

Db2 parameter values

Field

Installation panel

CLIST parameter

ZPARM macro

ZPARM parameter

Data capture enabled

DSNTIPB

None

DSN6SPRM

CHGDC

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

OPERTUNE for DB2 13.1