Replication Guide and Reference

Restrictions When Running the Capture Program

The following actions cause the Capture program to terminate while it is running. Stop the Capture program if you want to perform any of the following tasks:

Cancel an existing replication source.
Drop a replication source table.
Make changes that affect the structure of source tables. This includes changes resulting from data definition language or utilities. Structural changes can compromise the data integrity of the copies.

Other Capture program restrictions are:

Changes are not captured when the database is running with LOGMODE=N.
One change data table exists per user table defined to the Capture program.
You must specify DATA CAPTURE CHANGES on the CREATE or ALTER TABLE statement for the user tables.
Tables with field procedures for columns (FIELDPROC specified on CREATE or ALTER TABLE) are not supported by Capture for VSE.
There can be only one Capture program running per DB2 server for VSE database, and each Capture program runs in its own partition.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]