CDC Guide for Linux, UNIX, and Windows

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

Back Next

Stopping Db2 CDC

You might need to stop change data capture for a Db2 source table to perform troubleshooting or routine maintenance tasks, such as maintenance on the capture catalog table or redistribution of table data across reconfigured database partitions.

To stop change data capture, use one of the following methods:

Open the capture registration for a source table, and change the

Status

option from

Active

History

After you set the status to

History

, you cannot activate the registration again. This status change permanently stops change data capture based on the capture registration.

To temporarily stop change data capture, alter the Db2 table to specify the DATA CAPTURE NONE clause:

ALTER owner.table_name DATA CAPTURE NONE

When DATA CAPTURE NONE is specified, Db2 no longer writes changes to the Db2 log files in expanded format. Because CDC requires expanded format, PowerExchange can no longer capture change data for the table from the log files. If you set it back to DATA CAPTURE CHANGES, you might need to rematerialize the targets.

Rename Saved Search

Table of Contents

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Stopping Db2 CDC

Stopping Db2 CDC