cdcq Data Collector

"cdcq" Data Collector

For a detailed discussion of these metrics, see ProTop Real-Time - CDC Processing Queue (C) and and ProTop Trends - Latches and Resources

To set up an alert on a metric listed here, make note of the Data Collector name at the top of this page, the Alertable Metric and Data Type from the table below and visit Alert Configuration.

Alertable Metric ProTop RT Label Data Type Description
tt_cdcq     (temptable name)
cdcdtz1 Oldest Change char Date/Timestamp of the oldest change
cdcdtz2 Latest Change char Date/Timestamp of the most recent change
cdcLagStr Lag Time char String version of Lag (Seconds)
cdclagTime Lag (Seconds) num In seconds, how far behind current processing is the queue
cdcTblName Table char Name of the database table
s1 First num Oldest unprocessed change
s2 Last num Most recent unprocessed change
sq Queued num Number of changes in queue
zTblNum   num Hidden alertable field, source database table number