CDC Guide for Linux, UNIX, and Windows

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

Back Next

Creating the Capture Catalog Table

The PowerExchange capture catalog table stores information about the CDC source tables, column definitions, and valid Db2 log positions. You must create this table in the same database that contains the source tables from which change data is captured.

If the database has multiple partitions, the capture catalog table stores positioning information for each partition. If the database has only a single partition, the capture catalog table still contains positioning information for the partition.

Use the following DDL to create the capture catalog table:

CREATE TABLE DTLCCATALOG (
    VTSTIME  TIMESTAMP       NOT NULL,
    VTSACC   INTEGER         NOT NULL,
    NODENUM  SMALLINT        NOT NULL,
    SEQ      INTEGER         NOT NULL,
    TBSCHEMA VARCHAR(128),
    TBNAME   VARCHAR(128),
    OP       VARCHAR(1024)   NOT NULL,
    PRIMARY KEY(VTSTIME, VTSACC, NODENUM, SEQ) )
;

In this DDL, the table name is DTLCCATALOG. If necessary, you can specify another table name.

Informatica recommends that you place the PowerExchange capture catalog table in the Db2 catalog partition.

Rename Saved Search

Table of Contents

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Creating the Capture Catalog Table

Creating the Capture Catalog Table