Model update process - Connect_CDC - connect_cdc_mimix_share - Latest

The queues must be drained for model update because one or more tables may be disabled for capture during the model update process. 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.

The model update process involves the following activities:

1. Determines what tables have changed

2. Places a read-only table lock on the changed tables

3. Drains queues for all changed tables

4. Disables capture

5. Instantiates a new model and metabase

6. Re-enables capture

7. Removes table locks