Override table lock and queue drain - Connect_CDC - connect_cdc_mimix_share - 6.x

Connect CDC Getting Started Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
6.x
ft:locale
en-US
Product name
Connect CDC
ft:title
Connect CDC Getting Started Guide
Copyright
2025
First publish date
2003
ft:lastEdition
2026-02-25
ft:lastPublication
2026-02-25T19:01:02.274000
L1_Product_Gateway
Integrate
L2_Product_Segment
Data Integration
L3_Product_Brand
Precisely Connect
L4_Investment_Segment
Application Data Integration
L5_Product_Group
ADI - Connect
L6_Product_Name
Connect CDC

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.