Interpret capture/storage status - connect_cdc_sqdata - Latest

Connect CDC (SQData) Change Data Capture

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Change Data Capture
Copyright
2024
First publish date
2000
Last updated
2024-11-25
Published on
2024-11-25T15:05:48.570404
The status of the Capture/Storage Agents can be found in the second line of the output from both the SQDconf and sqdmon display commands and provide information about the current operational status as well as an indication of the state of the Transient Storage Pool.
SQDF901I Configuration file : /home/sqdata+/<capture_agent_name>/<capture_agent_name>_store.cab
SQDF902I Status             : MOUNTED,STARTED

Possible values include combinations of the following:

Status Console Description
MOUNTED   On-line and Ready
NOTMOUNTED   Off-line, No active process (on z/OS, no active Job or Task)
STARTED   Capture and Publishing are active
PAUSED   Capture Paused and waiting on a command, Publishing continues until all transient data is consumed
STOPPED   Capture and Publishing are suspended
STALLED   One or more target Engines not connected or not responding
FULL   Transient Storage Pool Full. Normal, but high latency likely due to target side performance. Capture will stop reading logs long enough for space to be freed.
DEADLOCK Y CRITICAL CONDITION, Storage Pool TOO SMALL, Cannot hold existing Unit of Work (UOW), MUST expand Storage Pool before Capture and Publishing can continue, which can be done while Capture is running.

Each line of the display is prefixed with a Message Number corresponding to the information on that line. In the case of Status, message number SQDF902I is displayed. Certain messages, particularly those that require intervention will also be directed to the Operator Console on z/OS and the system log on Linux and AIX,including the DEADLOCK condition: SQDF207E DEADLOCK CONDITION DETECTED FOR <type>cdc_store.cab The Deadlock state requires intervention. See the section, Size the transient storage pool and adjust the Number of Blocks or Files allocated to the Store Pool or add another mount point/directory where additional files can be allocated, by modifying the CDCSTORE configuration file as described in Modify Transient Storage Pool.