EDPROP—Enable data propagation


Use the Modify Enable DataPropagator or the EDPROP command to specify whether to use IMS DataPropagator to propagate SQL changes to tables that are defined with the setting DATA CAPTURE CHANGES.

Modify Enable DataPropagator panel

DDTG DBI1 Modify Enable DataPropagator
Command ===> _________________________________________________________________

 Command: CURRENT
Description . . . . . . . . : ENABLE DATA PROPAGATION

Type the new Enable DataPropagator indicator you wish to change to. Then press Enter.

Enable DataPropagator Indicator
Enabled . . . . . . . . . . (Y or N)

Command syntax and parameters

image2018-12-21_13-0-55.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

Information is saved during the BIND process.

When you set DESCSTAT to Y, there is a slight increase in the space a plan or package needs on DASD and in the EDM pool.

N

Information is not saved during the BIND process.

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

Dprop support

DSNTIPB

None

DSN6SPRM

EDPROP

 

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

OPERTUNE for DB2 12.1