"Configuration" Data Collector
For a detailed discussion of these metrics, see ProTop Real-Time - Configuration Viewer (c) and ProTop Trends - Configuration Dashboard.
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_Configuration | (temptable name) | ||
| afterImaging | After-Imaging | char | Status of After-Imaging |
| aiArchiver | AI Archiver | char | Status of After-Image archiving |
| aiAreas | AI Areas | num | Number of After-Image areas defined |
| aiBlkSize | AI Block Size | num | AI file block size in bytes |
| aiBuffers | num | Specifies the number of after-image memory buffers | |
| aiSeq | AI Sequence# | num | Filled AI files since the database server process started |
| aiSettings | AI Area Type | char | Types of AI files - Disabled, Fixed, Variable, or Mixed |
| aiSize | num | ||
| aiStall | -aistall | char | If all AI files are filled, suspends database activity until an AI extent is emptied |
| allocBlks | Alloc Size | num | |
| areaConfig | Area Config | char | The type of database area configuration. Should be “Extended: type 2" |
| b2 | -B2 | num | Size of alternative database server memory buffers in number of memory blocks |
| biBlkSize | BI Block Size | num | BI file block size in bytes |
| biBuffers | -bibufs | num | Specifies the number of before-image memory buffers |
| biClstrAge | BI Clustr Age | num | Specifies the number of seconds before OpenEdge reuses a before-image cluster |
| biClstrSize | BI Cluster Size | num | BI file cluster size in bytes |
| biDelay | BI Delay (-Mf) | num | Value, in seconds, of the delay before the database engine synchronously writes to disk the last before-image file records at the end of each transaction |
| biIOMode | BI IO (-r) | char | Indicates whether or not IO to the BI file is buffered. Don't use -r in ordinary circumstances |
| biSize | BI Size | num | Size of the BI file in MB |
| biStall | -bistall | char | Quiets the database when the recovery log threshold is reached, without performing an emergency shutdown |
| biThold | -bihold | num | The maximum size, in bytes, to which recovery log files can grow before the database performs an emergency shutdown. Using the -bistall parameter with -bithold prevents the emergency shutdown; instead, the database ceases activity until the BI extent is emptied |
| bpMax | -Bpmax | num | Maximum total number of client session private buffers |
| cnxPerServ | Cnx/Srv (-Ma) | num | Maximum number of remote users per database server |
| cpInternal | -cpinternal | char | Identifies the code page used in memory and for graphical clients |
| cpTerm | -cpterm | char | Identifies the code page used for I/O with character terminals |
| db2PC | char | Whether or not two-phase commit is enabled | |
| dbaAge | dbAnalys Age | num | Number of days since the last dbanlys was run |
| dbaAsOf | dbanlys as of | char | Date the last dbanlys was run |
| dbaAsOfStr | char | String version of date the last dbanalys was run | |
| dbAuditing | DB Auditing | char | Indicates the status of database auditing |
| dbBkUpAge | Backup Age | char | String version of the elapsed time since the last full backup using probkup including days i.e. 10d 15:08. Will contain "Never!" if a backup has not occured. Third-party backups, OS backups, and incremental backups are not tracked. |
| dbBlkSize | DB Block Size | num | Database block size in bytes |
| dbBuffers | DB Buffers, -B | num | Size of database server memory buffers in number of memory blocks |
| dbCheck | -DbCheck | char | Whether Database Consistency Check is enabled. When enabled, this option applies consistency checks to all index blocks and record blocks for record and index write operations |
| dbEmpty | num | Unused database blocks | |
| dbHost | char | Name of the server running this database | |
| dbIdxBld | Index Rebuild | char | Indicates if an index needs to be rebuilt |
| dbIntegrity | Crash Prot (-i) | char | Status of crash protection. (-i) startup parameter. Don't use -i in ordinary circumstances |
| dbLogName | char | Database logical name assigned at client session startup | |
| dbPhysName | char | Physical name of the database | |
| dbProVersion | db Version | char | Version of Progress running this database |
| dbSHMFree | num | Number of bytes available in shared memory segments | |
| dbSHMpinned | SHM Pinned | char | Indicates whether or not the database server has requested the operating system to avoid swapping shared memory. Ignored on Windows and AIX. See https://knowledgebase.progress.com/articles/Article/P8856 |
| dbSHMSeg | # SHM Segs | num | Number of shared memory segments |
| dbSHMSegSize | SHM Seg Sz | num | Maximum number of bytes in a shared memory segment |
| dbSHMSize | num | Blocks in database buffers multiplied by database block size | |
| dbSize | DB Size | num | Size, in bytes, of the database |
| dbSpin | -Spin | num | Specifies the number of times a process tries to acquire a latch before pausing |
| dbTainted | Tainted (-F) | char | Indicates if entry into the database was forced |
| dbUpTime | DB Up Time | char | Length of time the database server process has been running |
| deployType | char | ||
| directIO | -directio | char | Whether or not direct IO is enabled. In normal circumstances, it should never be enabled |
| excessIdx | Excess Idx | num | -indexrangesize minus the highest actual index number |
| excessSHM | -Mxs | num | The value of the shared-memory overflow area. The overflow area is appended to the shared memory area. If the overflow area is too small, the database engine exits |
| excessTbl | num | -tablerangesize minus the highest actual table number | |
| failClusters | char | Is this database configured for Failover Clusters? | |
| hashLatchFact | -hashlatchfactor | num | Number of latches allocated for the Buffer pool Hash Table (BHT) entries as a percent of BHT size |
| hashPct | -hash% | num | The number of hash table entries in the database memory buffers as a percentage of the total number of database memory buffers |
| hashTbl | -hash | num | The number of hash table entries to use for the buffer pool |
| idxBase | IdxStat Base | num | Lowest index number of the indexes being monitored statistically |
| idxRange | IdxStat Range | num | Highest index number of indexes being monitored statistically |
| largeFiles | Large Files | char | Indicates if the OS has been set to accept files larger than two gigabytes |
| lgFileDays | num | Database log file age in days since last truncate | |
| lgFileSize | num | Database log file size | |
| lkHash | -lkHash | num | Size of the hash table that controls access to the lock table |
| lkTableSize | Lock Tbl (-L) | num | Maximum allowable concurrent number of record locks |
| lkTblHWMpct | num | Lock table High Water Mark as Percent of Lock Table size | |
| lrgExtent | num | Size of largest database extent | |
| lru2Skips | -lru2skips | num | The number of times to access a database alternative memory buffer before moving it to the end of the LRU chain |
| lruSkips | -lruskips | num | The number of times to access a database memory buffer before moving it to the end of the LRU chain |
| maxConnect | Sessions (-n) | num | Maximum number of concurrent connections to the database |
| maxMsg | Max Msg (-Mm) | num | Specifies the standard message buffer size, in bytes. Message buffers are used to move records between the database and remote clients (client/server) |
| maxServers | Maz Srvs (-Mn) | num | Maximum number of remote client servers that can be started on the system |
| memCheck | -MemCheck | char | Enables memory overwrite checking for the buffer pool. Memory consistency check detects illegal operations in memory movement, such as a buffer copy with a negative length of data, or a memory move to an incorrect location. The purpose Memory consistency check is to prevent memory corruption |
| minCnx | Min Cnx (-Mi) | num | Number of remote users on a server before the broker starts another server |
| nMsgWait | -Nmsgwait | num | Number of seconds a server waits for a remote network message before checking for other events such as a database shutdown or forced disconnect of a remote client |
| numAreas | # Ext Areas | num | Number of database areas |
| numExtents | # of Extents | num | Number of database extents |
| numIdx | # App Indexes | num | Number of indexes defined in the database |
| numLOBs | # of LOBs | num | Number of Large Objects defined in the database |
| numTbl | # App Tables | num | Number of Tables defined in the database |
| oeReplication | OE Replication | char | Status of OE Replication use for this database |
| omSize | -omsize | num | Size of the object cache for all database objects |
| pfDelay | PF Delay | char | Enables a delay when sending the first network message for queries with prefetch capabilities |
| pfFactor | PF Factor | num | Establish the percentage of a network message required to contain prefetched data before sending the message to a waiting remote client |
| pfNumRecs | PF #Recs | num | Number of prefetch records to put in a network message before sending the message to a waiting remote client |
| pfPriority | PF Priority | num | Utilizes a "pollskip" that adds n records to the network message of an in-process prefetch query without additional polling |
| pica | -pica | num | The size of the database service communications area in kilobytes. The database service communications area is used to store after-image block write notifications intended for OpenEdge Replication |
| proBits | num | ||
| proVersionAge | DLC Age | num | Age of the version of Progress running this database |
| proVersionDate | char | Date the running version of Progress was published | |
| ptAsOf | char | Date the running version of ProTop was built | |
| ptVersion | ProTop Version | char | Version of ProTop |
| recSpaceDepth | -recspacesearchdep | num | How deep in the Record Free Chain to search, to find a block with enough free space to fit data, before allocating a new clusters worth of space instead from the Empty Chain where the Area High Water Mark (HWM) is raised |
| rpbSettings | RPB Settings | char | Records per block setting |
| schemaUsed | Schema Area | char | Has the schema area been used to store application data? |
| semSets | -semsets | num | The number of semaphore sets available to the broker |
| sqlStats | SQL upd stats | num | Age of the last run of “UPDATE STATISTICS” |
| sqlStatsStr | SQL stats Age | char | String Version of Age of the last run of “UPDATE STATISTICS” |
| sqlStatsTS | SQL stats TS | char | Date/Time stamp of the last run of "UPDATE STATISTICS" |
| tblBase | TblStat Base | num | Lowest file number of the files being statistically monitored |
| tblRange | TblStat Range | num | Highest file number of files being monitored statistically |
| unMonIdx | Unmonitrd Idx | num | Number of Indexes not being monitored due to -indexrangesize too low |
| unMonTbl | Unmonitrd Tbl | num | Number of Tables not being statistically monitored due to -tablerangesize too low |
| varBlks | Var Size | num | |
| warnAreas | Areas Full | num | |
| worstArea | Worst Area | num | In areas with fixed extents, the area making the most use of its variable extent |
| xdbVersion | DB Version | char | Progress version used to create this database (can be one behind the version of Progress running it) |