"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 |