Changed data for partitioned key columns captured as delete and insert

Select this check box to specify that any update to primary key columns is captured as a DELETE and INSERT in the change data table rather than as an UPDATE.

Select this check box under any of the following circumstances:

• If your source applications update one or more columns of a target table primary key

• If your source applications update one or more columns of a target table partitioning key (DB2 Parallel Edition or DB2 MVS partitioned table space)

• If your source applications update one or more columns referenced in a subscription predicate of a target table

The Capture program treats updates to primary key columns as INSERT and DELETE statements, rather than UPDATE statements.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]