Override table lock and queue drain - Connect_CDC - connect_cdc_mimix_share - Latest

Connect CDC Getting Started Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
Latest
Language
English
Product name
Connect CDC
Title
Connect CDC Getting Started Guide
Copyright
2024
First publish date
2003
Last edition
2024-07-19
Last publish date
2024-07-19T23:32:53.515937

You may not want to place a lock on your source table. If you specify 0 (zero) for the timeout option, the block and queue drain are bypassed, and the capture command continues to execute. This could possibly leave the queues in an inconsistent state if data is lost when the mirror table is dropped. The 0 (zero) option was added because you may not want to block your production tables if there is substantial activity. When you choose this option, keep in mind, that the data can become inconsistent in the queues and you will have to execute delete queues and re-synch your data.