LOB Activity is only available for OpenEdge version 12 and later.
"LOBActivity" Data Collector
For a detailed discussion of these metrics, see ProTop Real-Time - LOB Activity (l).
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_LOBAct | (temptable name) | ||
LOBAreaNum | Area# | num | Database area containing the LOB |
LOBAvgRow | Avg Sz | num | Average size of the LOB |
LOBCr | Create | num | Number of LOBs created |
LOBDl | Delete | num | Number of LOBs deleted |
LOBMaxRow | Max Sz | num | Maximum size of the LOB |
LOBMinRow | Min Sz | num | Minimum size of the LOB |
LOBName | LOB Name | char | Name of the LOB |
LOBNum | LOB# | num | Unique LOB ID |
LOBOSRd | OS Read | num | Number of operating system reads |
LOBPool | BX | char | Shows whether cached LOB blocks are found in the primary buffer pool (B1) or alternate buffer pool (B2) |
LOBRd | Read | num | Number of LOB reads |
LOBRecs | #Recs | num | Number of records containing the LOB field |
LOBUp | Update | num | Number of LOB updates |