DB2 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:

• Remove an existing replication source.

• 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.

Capture for MVS does not support certain programmatic statements for the source table. See Data Restrictions for a list of these statements.

Other Capture program restrictions are:

• Capture for MVS does not support compressed data for a source table if you use DB2 for MVS Version 3.1.

• If the Capture program shuts itself down, you should perform a cold start if the database does not have or support the archive log. DB2 for MVS Version 3.1 does not support the archive log.

• User tables must be created or altered using the DATA CAPTURE CHANGES option.

• Capture does not capture any changes made by DB2 utilities, even if you specify LOG=YES.

• If you are using DB2 for MVS/ESA Version 4.1 or higher, only one instance of the Capture program can run on any subsystem that is a member of a data-sharing group. The DB2 log interface is serial, not parallel. The Capture program must read merged log records from all data sharing members.

[ DB2 List of Books | Search the DB2 Books ]