Model update process - Connect_CDC - connect_cdc_mimix_share - 5 - 5.8

Connect CDC Advanced User Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC Advanced User Guide
Copyright
2023
First publish date
2003
ft:lastEdition
2023-09-27
ft:lastPublication
2023-09-27T18:12:55.651884

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

Note: You can continue inserting, updating, or deleting rows during Model Update for DB2/400, MS SQL Server, Postgres, and UDB. In other databases, you may experience data loss if you continue.