CDC Guide for z/OS

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

Back Next

DB2 ECCR Capture Directory Tables

The DB2 ECCR uses a set of DB2 tables, called the capture directory tables, to track information about DB2 tables registered for CDC.

The capture directory tables are created during PowerExchange installation. They must reside in their own database and table space on the DB2 subsystem to which the DB2 ECCR connects for change capture.

The following table describes the purpose of each DB2 ECCR capture directory table:

Table Name	Description
TCAPCOLUMNS	Stores catalog and status information for all of the columns in the tables that are registered for change data capture.
TCAPFIELDS	Stores information about the columns that use a field procedure exit routine (FIELDPROC) and that are in tables registered for change data capture.
TCAPSTATUS	Stores status information about all of the tables that are registered for change data capture.
TCAPTABLES	Stores catalog and status information for the tables that are registered for change data capture.
TCAPTABLESPACE	Stores catalog and status information for all table spaces in the DB2 catalog, including table spaces that do not contain registered tables.
TCAPUPDATE	Stores information that the DB2 ECCR uses to coordinate the handling of the DB2 log read process.
TCAPWORK	Stores changes to the DB2 system catalog tables until the UOW that contains these changes is committed. If you need to create a full image copy of the table space that contains the TCAPWORK table, run the DB2 COPY utility with the SHRLEVEL CHANGE option. If you use the SHRLEVEL REFERENCE option instead, the DB2 ECCR ends abnormally.

In the z/OS Installation Assistant, you specify a DB2 creator name for the DB2 capture directory tables and a DB2 owner for the DB2 ECCR plans and packages. You also specify the following information for customizing the jobs that create these tables and related DB2 objects:

DB2 subsystem identifier (SSID)

Database name

STOGROUP

TCAPWORK buffer pool name

The XIDDB220 member of the RUNLIB library creates the DB2 table spaces, tables, and indexes for the DB2 ECCR capture directory tables. The SETUPDB2 job submits the XIDDB220 job. The DDL for the capture directory tables are in the following RUNLIB members:

DB2TGEN: Creates the database and the table space for each table.
DB2SGENB: Creates the capture directory tables for a DB2 database. The XIDDB22O job uses this member.
DB2IGEN: Creates the unique index for each of the tables.