Deactivate CDC feature on a database without a CDC license

You can deactivate CDC on a database that has CDC enabled, even if you do not have a license. To do so, use the proutil deactivateCDC function on the CDC enabled database.

It is a common practice for Database Administrators to copy the backup file of a production CDC enabled database and then later restore it for use in a development or testing environment. Usually, the development or testing environments do not have a CDC license, as holding multiple license can become expensive. Consequently, when the CDC-enabled database is restored, the database cannot be brought online because there is no CDC license. Similarly, Database Administrators cannot disable the CDC features on the backup database because there are CDC policies in place, and removing those features also requires a CDC license.

However, Database Administrators can use the proutil deactivateCDC command line utility on the CDC-enabled database to deactivate CDC. This command does not require a CDC license and it also does not require the Database Administrator to purge the CDC data or remove the CDC policies. After the command is issued, all the subsequent write jobs to CDC data tables are stopped and the database is then accessible with, or without, a CDC license. This command can be executed while the database is online or offline.

If you need to reactivate CDC on your database, you can do so with the counterpart to deactivateCDC, activateCDC. Keep in mind that a CDC license is required to reactivate CDC on a database, as well as all of the CDC activities. When reactivated, all of the activities that were stopped on the database resume. This command can be executed while the database is online or offline.

For more information, see PROUTIL DEACTIVATECDC qualifier.

For more information, see PROUTIL ACTIVATECDC qualifier.