onstat -g cdc Monitors the sessions involved in change data capture.
The command can take the following modifiers
| Modifier | Action |
|---|---|
| bufm | Displays information about the buffers being used by the session, including: The highest number of buffers used by the session. The number of buffers currently being used by the session. With the long option, the address of each allocated buffer. |
| config | Displays information about the session configuration, including: The read timeout setting for the session, in seconds. The maximum number of records returned by a read call. |
| db:owner.tabname | The fully-qualified name of the table for which to display information. |
| SID | Displays information for the specified session ID: The associated SQL session ID. The number of tables being captured by the session. With the long option, information about the number of records processed by the session. If you do not specify a session ID, or if you specify a session ID of 0, information for all sessions is displayed. |
| table | Displays information about the tables being captured, including: The number of tables being captured in a session. The full name of each table being captured. The time when data capture on each table started. With the long option, information about the captured columns for each table. |
| long | Provides additional detail for sessions, the bufm option, or the table option |
onstat -g cdc 104857639 long
IBM Informix Dynamic Server Version 14.10.FC3 -- On-Line -- Up 00:59:56 -- 17499516 Kbytes
CDC subsystem structure at 0x4429cc98
CDC session structure at 0x570c0d28
CDC session id: 104857639 (0x6400027)
Associated SQL session id: 200
Number of tables captured: 4
State: ACTIVATED (0x50534555)
Create time: 1634399471 (Sat Oct 16 10:51:11 2021)
Open time: 1634399471 (Sat Oct 16 10:51:11 2021)
Activate time: 1634399471 (Sat Oct 16 10:51:11 2021)
Activate Sequence Number: 0x12d42048448
Total client read calls: 54153
Last client read time: 1634402893 (Sat Oct 16 11:48:13 2021)
Last Sequence Number returned to client: 0x14a5b940500
Total number records examined: 244930849
Total number records kept (approximate): 2893696
Total number I/U/D records examined: 60451422
Total number I/U/D records kept (approximate): 2680114
Client required to close: NO
Read exit error code: 0
</div>
onstat -g cdc 104857639 table oninit:informix.t1200audit
IBM Informix Dynamic Server Version 14.10.FC3 -- On-Line -- Up 00:39:50 -- 17499516 Kbytes
CDC subsystem structure at 0x4429cc98
CDC session structure at 0x570c0d28
CDC session id: 104857639 (0x6400027)
Captured Table Manager found at 0x58866c08
Number of tables captured: 4
Table not captured: oninit:informix.t1200audit
</div>