CDC Guide for Linux, UNIX, and Windows

10.5
- 10.5.9
- 10.5.8
- 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

Initializing the Capture Catalog Table

To initialize the PowerExchange capture catalog table, run the DTLUCUDB utility with the SNAPSHOT command. You should need to do this task only once.

To specify the command, use the following syntax:

DTLUCUDB SNAPSHOT [DB=database_name] [CCATALOG=capture_catalog_name] [UID=user_id] [EPWD=encrypted_password] [REPLACE=Y|N]

If the capture catalog table contains existing rows of data, you must set the REPLACE parameter to Y to enable PowerExchange to overwrite the data. For a new capture catalog table, accept the default of N.

After the snapshot successfully completes, back up the capture catalog table to create a point of consistency for recovery.

If you run the DTLUCUDB SNAPSHOT command while the Db2 catalog is being updated, the snapshot fails. If this failure occurs, run the SNAPSHOT command again after the Db2 catalog updates are complete.

Rename Saved Search

Table of Contents

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Initializing the Capture Catalog Table

Initializing the Capture Catalog Table