Enable and disable command execution - Connect_CDC - connect_cdc_mimix_share - Latest

The queues must be drained because when a table is disabled for capture, the corresponding cdc mirror table is dropped and any pending data contained in the mirror table will be lost.

When you enable capture for a request:

1. A read-only table lock is placed on all tables in the request

2. Drains all tables

3. Disables all tables

4. Enables all tables

5. Lock is removed as soon as the command completes.

When you enable capture for a table:

1. A read-only table lock is placed on the table

2. Drains the table

3. Disables the table

4. Enables the table

5. Lock is removed as soon as the command completes