Database Administrator Guide > Change Data Capture > Change Data Capture (CDC) for Ingres > Monitoring the Log reader activity via IMADB tables
Was this helpful?
Monitoring the Log reader activity via IMADB tables
The following two new tables are added to IMADB to monitor status of CDC sessions.
• ima_lgstream_sessions
• ima_lgstream_pub
ima_lgsream_sessions
The ima_lgstream_sessions table provides statistics on active CDC sessions.
 
Column Name
Type
Length
Description
vnode
varchar
64
The name of the virutal node where the CDC session is running.
lgs_index
varchar
32
Unique identifier for the CDC session.
lgs_name
varchar
256
The user-defined name of the CDC session.
lgs_lsn_high
integer
8
The high part of the Log Sequence Number (LSN) for the last record read.
lgs_lsn_low
integer
8
The sequence number of the last Log Generation Area (LGA) block read.
lgs_lga_block
integer
4
The block number within the last LGA sequence read.
lgs_lga_offset
integer
4
The byte offset within the last LGA block read.
lgs_jfa_fileseq
integer
4
The journal file sequence number read.
lgs_jfa_block
integer
4
The block number within the journal file read.
lgs_readtype
varchar
16
The type of read operation performed (e.g., LGA, JFA).
lgs_pubcount
integer
4
The total number of publications in the session.
lgs_begwork
integer
8
The number of BEGIN WORK transactions seen.
lgs_commit
integer
8
The number of COMMIT transactions seen.
lgs_rollback
integer
8
The number of ROLLBACK transactions seen.
lgs_insert
integer
8
The number of INSERT records seen.
lgs_update
integer
8
The number of UPDATE records seen.
lgs_delete
integer
8
The number of DELETE records seen.
lgs_truncate
integer
8
The number of TRUNCATE operations seen.
lgs_sp_rollback
integer
8
The number of SAVEPOINT ROLLBACK operations seen.
lgs_txnlog_recs
integer
8
The total number of transaction log records read.
lgs_jnllog_recs
integer
8
The total number of journal log records read.
ima_lgstream_pub table
The ima_lgstream_pub table provides statistics on individual table publications within a Logstream session.
Column Name
Type
Length
Description
vnode
varchar
64
The virtual node where the CDC session is running.
pub_index
varchar
32
A unique identifier for the publication.
lgs_name
varchar
256
The name of the CDC session to which the publication belongs.
pub_name
integer
256
The user-defined name of the publication.
tab_owner
integer
32
The owner of the published table.
tab_name
integer
256
The name of the published table.
lgs_insert
integer
8
The number of INSERT records processed for this publication.
lgs_update
integer
8
The number of UPDATE records processed for this publication.
lgs_delete
integer
8
The number of DELETE records processed for this publication.
lgs_truncate
integer
8
The number of TRUNCATE operations seen for this publication.
Last modified date: 01/27/2026