DB2 Change Data Capture

Select this option to enable CDC.

This setting corresponds to the <cdcdb2> variable in the INSTPARM file.

Plan

The DB2 ECCR plan name. This value can be up to eight characters in length.

Default is PWXCPV

xn

, where

x

is a letter and

n

is a number that together correspond to the PowerExchange version. For example, for PowerExchange 10.1, the default name is PWXCPVA1.

This setting corresponds to the <zccdb2plan> or < zccdb2plan8> variable in the INSTPARM file. The <zccddb2plan8> variable value is padded with 8 bytes.

Package Collection Name

The collection ID that is used for the DB2 ECCR packages. This value can be up to 70 characters in length.

Default is the plan name.

This setting corresponds to the <zcccollid> variable in the INSTPARM file.

Capture Database Name

The name of the DB2 database to contain the DB2 ECCR capture directory tables.

Default is PWXCCDDB.

This setting corresponds to the <zccdbname> variable in the INSTPARM file.

STOGROUP

The DB2 STOGROUP for the DB2 ECCR capture directory tables, table spaces, and indexes. You can choose an existing STOGROUP name. If you do not specify a STOGROUP, the DB2 defaults apply.

Default is SYSDEFLT.

This setting corresponds to the <zstogroup> variable in the INSTPARM file.

CDC Plan Owner Name

The owner name that PowerExchange uses to bind the DB2 plan and packages for the DB2 ECCR during installation.

Default is the

Logon ID

value from the

Select Global Parameters

page.

This setting corresponds to the <zdb2owner> variable in the INSTPARM file.

TCAP Table Owner Name

The owner name that PowerExchange uses to create the PowerExchange capture directory (TCAP) tables and indexes during installation. These objects are required for CDC.

Default is the

Logon ID

value from the

Select Global Parameters

page.

This setting corresponds to the <zdb2tcapowner> variable in the INSTPARM file.

TCAPWORK Buffer Pool Name

The name of the DB2 buffer pool to be used for the DB2 ECCR TCAPWORK table space.

This buffer pool must be at least 16 KB in size. Based on the buffer pool size, enter one of the following names for the buffer pool:

For a 16-KB buffer pool, enter
BP16K
n
, where the
n
variable is a number from 0 to 9.
For a 32-KB buffer pool, enter
BP32K
or
BP32K
n
, where the
n
variable is a number from 1 to 9.

Default is BP16K0.

This setting corresponds to the <zbufpool> variable in the INSTPARM file.

CA Name

The name of the DB2 ECCR, which identifies the DB2 ECCR to the PowerExchange Logger. Define this value in the CA NAME statement in the REPDB2CT member of the RUNLIB library.

Because the DB2 ECCR uses this name to request a global resource lock, this value must be unique within a sysplex.

Default is PWXDB201.

This setting corresponds to the <zdb2caname> variable in the INSTPARM file.

Advanced Parms

Enables you to define advanced parameters.

To change an advanced parameter value, complete the following steps:

In the
Value
column, click the cell for the parameter.
To sort parameters, click a column header. For example, to sort by parameter name, click the
Parameter Name
header.
Enter the parameter value, and click
OK
.

If you define advanced parameters, you cannot restore these parameters to default values by using the

Restore Defaults

button.

Restore Defaults

Restores default values.