PROUTIL DISABLECDC qualifier

Disables Change Data Capture (CDC) from your database.

Syntax

proutil db-name -C disablecdc

Parameters

db-name

The name of the database where you are disabling CDC.

Successful execution of DISABLECDC removes the CDC schema, the change tracking table, and the CDC feature bit from your database.

Prior to disabling CDC, all CDC policies and change tables must be deleted.

Disabling CDC performs the following:

Checks that the _CDC-Table-Policy and _CDC-Field-Policy tables are empty, which signals that all Change Tables have been dropped from the database. If any tables are found, DISABLECDC exits with an error.

Removes the Table Policy table and its indexes.

Removes the Field Policy table and its indexes.

Removes Change Tracking Table and its indexes. If the table has records in it, removing the table effectively deletes all its records.

Deactivates the Feature Bit Map for CDC.

If Auditing is enabled, writes an Audit Event record for disabling CDC.

See:

PROUTIL ENABLECDC qualifier