"Pro2Queues" Data Collector - SUPERCEDES Pro2Activity
For a detailed discussion of these metrics, see ProTop Real-Time - Pro2 Queues (2).
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_pro2q | (temptable name) | ||
rq_Depth | Depth | char | Number of records waiting to be replicated in this queue |
rq_disabledTbls | Disabled | num | Number of tables configured but not being replicated |
rq_enabledTbls | Enabled | num | Number of tables being replicated |
rq_lagTime | Queue Lag | num | Age of the oldest unprocessed record in this queue |
rq_oldTblDB | Source DB | char | The PRO2 name for the database containing the table being processed by this queue |
rq_oldTblName | Oldest Table | char | Name of the table being processed by this queue |
rq_orphanTbls | Orphans | num | Number of tables containing orphan replication queue records |
rq_pausedTbls | Paused | num | Number of configured tables for which replication is currently paused |
rq_qNum | QNum | num | Queue Number |
rq_qStatus | Status | char | Queue Status |
rq_qType | Action | char | After replication what happens to the queue record? Values are: "Delete", "Mark" and keep or "Audit" |