![ProTop-helpnb.png]](https://help.wss.com/hs-fs/hubfs/ProTop-helpnb.png?height=39&name=ProTop-helpnb.png){kind=small}
omSizeConfiguration Viewer (c)
The configuration panel provides a snapshot of the current database configuration. This information is also available on the web in the ProTop Trends dashboard (requires the commercial version of ProTop).
DB Status and Recoverability
| Field | Alertable Metric* | Description |
| DB Version | xdbVersion | Progress OpenEdge version |
| DLC Age | proVersionAge | How long Progress has been installed |
| OS Type | N/A | Operating system type |
| DB Up Time | dbUpTime | Length of time the database has been up |
| Backup Age | dbBkUpAge | 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. |
| Crash Prot (-i) | dbIntegrity | Status of crash protection. (-i) startup parameter |
| BI IO (-r) | biIOMode | Indicates whether or not IO to the BI file is buffered |
| Tainted (-F) | dbTainted | Indicates if entry into the database was forced |
| Index Rebuild | dbIdxBld | Indicates if the index rebuild flag has been raised |
| After-Imaging | afterImaging | Status of after-imaging |
| Large Files | largeFiles | Indicates if the OS has been set to accept files larger than two gigabytes |
| OE Replication | oeReplication | Status of OpenEdge Replication |
| DB Auditing | dbAuditing | Status of database auditing |
| -DbCheck | dbCheck | Indicates if the -DbCheck parameter has been enabled |
| -MemCheck | memCheck | Indicates if the -MemCheck parameter has been enabled |
*Requires data collector "Configuration" in pt3agent.cfg. With the commercial version of ProTop, you can configure alerts using the metric names in this column. For a full list of metrics, see the Alertable Metrics section.
Physical DB Parameters
| Field | Alertable Metric* | Description |
| DB Size | dbSize | Size of the database |
| Alloc Size | N/A | Amount of disk space allocated to the database |
| Var Size | N/A | Size of database variable extent(s) |
| BI Size | biSize | Size of the BI file in MB |
| DB Block Size | dbBlkSize | Database block size in bytes |
| BI Cluster Size | biClstrSize | BI file cluster size in bytes |
| AI Block Size | aiBlkSize | AI file block size in bytes |
| BI Block Size | biBlkSize | BI file block size in bytes |
Important Performance Parameters
| Field | Alertable Metric* | Description |
| DB Buffers, -B | dbBuffers | Size of database server memory buffers in number of memory blocks |
| -B2 | b2 | Size of alternative database server memory buffers in number of memory blocks |
| -Bpmax | bpMax | Maximum total number of client session private buffers |
| -spin | dbSpin | Specifies the number of times a process tries to acquire a latch before pausing |
| -lruskips | lruSkips | The number of times to access a database memory buffer before moving it to the end of the LRU chain |
| -lru2skips | lru2Skips | The number of times to access a database alternative memory buffer before moving it to the end of the LRU chain |
| -hash | hashTbl | The number of hash table entries to use for the buffer pool |
| -hash% | hashPct | The number of hash table entries in the database memory buffers as a percentage of the total number of database memory buffers |
| -hashlatchfactor | hashLatchFact | Number of latches allocated for the Buffer pool Hash Table (BHT) entries as a percent of BHT size |
| -omsize | omSize | Size of the object cache for all database objects |
| -pica | pica | 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 |
| -respacesearchdep | recSpaceDepth | 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 |
| -aibufs | aiBuffers | Specifies the number of after-image memory buffers |
| -bibufs | biBuffers | Specifies the number of before-image memory buffers |
| -directio | directio | Whether or not direct IO is enabled. In normal circumstances, it should not be enabled. |
Misc Parameters
| Field | Alertable Metric* | Description |
| Sessions (-n) | N/A | Maximum number of concurrent connections to the database |
| Max Srvs (-Mn) | maxServers | Maximum number of remote client servers that can be started on the system |
| Cnx/Srv (-Ma) | cnxPerServ | Maximum number of remote users per database server |
| Min Cnx(-Mi) | minCnx | Number of remote users on a server before the broker starts another server |
| Max Msg (-Mm) | maxMsg | Specifies the standard message buffer size, in bytes. Message buffers are used to move records between the database an d remote clients (client/server). |
| PF Delay | pfDelay | Enables a delay when sending the first network message for queries with prefetch capabilities |
| PF Factor | pfFactor | Establish the percentage of a network message required to contain prefetched data before sending the message to a wa iting remote client |
| PF #Recs | pfNumRecs | Number of prefetch records to put in a network message before sending the message to a waiting remote client |
| PF Priority | pfPriority | Utilizes a "pollskip" that adds n records to the network message of an in-process prefetch query without additio nal polling |
| -Nmsgwait | nMsgWait | The number of seconds a server waits for a remote network message before checking for other events such as a datab ase shutdown or forced disconnect of a remote client |
Table and Index Range Parameters
| Field | Alertable Metric* | Description |
| # of LOBs | numLOBs | Number of Large Objects defined in the database |
| # App Tables | numTbl | Number of tables defined in the database |
| TblStat Base | tblBase | Lowest file number of files being monitored statistically |
| TblStat Range | tblRange | Highest file number of files being monitored statistically |
| Unmonitored Tbl | UnMonTbl | Number of files not being monitored statistically |
| # App Indexes | numIdx | Number of indexes defined in the database |
| IdxStat Base | idxBase | Lowest index number of indexes being monitored statistically |
| IdxStat Range | idxRange | Highest index number of indexes being monitored statistically |
| Unmonitored Idx | UnMonIdx | Number of indexes not being monitored statistically |
Storage Area Configuration
| Field | Alertable Metric* | Description |
| # of LOBs | numLOBs | Number of large objects in the database |
Parameters Not to be Messed With
| Field | Alertable Metric* | Description |
| Direct IO | directIo | Whether or not direct IO is enabled. In normal circumstances, it should never be enabled. |
| -bistall | biStall | Quiets the database when the recovery log threshold is reached, without performing an emergency shutdown |
| -aistall | aiStall | If all AI files are filled, suspends database activity until an AI extent is emptied |
| BI Cluster Age | biClstrAge | Specifies the number of seconds before OpenEdge reuses a before-image cluster |
| -Bpmax | bpMax | Maximum total number of client session private buffers |
| -DbCheck | dbCheck | 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. |
Shared Memory Parameters
| Field | Alertable Metric* | Description |
| -Mxs | excessSHM | 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. |
| SHM Seg Sz | dbSHMSegSize | Maximum number of bytes in a shared memory segment |
| SHM Alloc | dbSHMSize | Number of bytes allocated to shared memory segments |
| SHM Free | dbSHMFree | Number of bytes available in shared memory segments |
| # SHM Segs | dbSHMSeg | Number of shared memory segments |
| SHM Pinned | dbSHMpinned | 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. |
Storage Area Configuration
| Field | Alertable Metric* | Description |
| Area Config | areaConfig | The type of database area configuration. Should be “Extended type 2" |
| # Extent Areas | numAreas | Number of different disk areas holding database extents |
| # of Extents | numExtents | Number of extent files in the database |
| Lrgst Extent | lrgExtent | Size, in bytes, of the largest extent associated with the database |
| Schema Area | N/A | Number of the area containing the schema extent |
| RPB Settings | rpbSettings | Records per block setting |
| Areas Full | N/A | Number of database areas filled |
| Worst Area | worstArea | In areas with fixed extents, the area making the most use of its variable extent |
| AI Areas | aiAreas | Number of After-Imaging areas defined |
| AI Area Type | aiSettings | Types of AI files - Disabled, Fixed, Variable, or Mixed |
| AI Sequence# | aiSeq | Filled AI files since the database server process started |
| AI Archiver | aiArchiver | Status of after-image archive |
Miscellaneous Information
| Field | Alertable Metric* | Description |
| .lg File Age | lgFileDays | Age of the current database log file |
| .lg File Sz | lgFileSize | Size, in bytes, of the current database log file |
| dbanlys Age | dbaAge | Number of days since the last dbanlys was run |
| dbanlys as of | dbaAsOf | Time the last dbanlys was run |
| SQL stats Age | sqlStats | Age of the last run of “UPDATE STATISTICS” |
| SQL stats TS | sqlStatsTS | Date/Time stamp of the last run of "UPDATE STATISTICS" |
*Requires data collector "Configuration" in pt3agent.cfg. With the commercial version of ProTop, you can configure alerts using the metric names in this column. For a full list of metrics, see the Alertable Metrics section.