Virtual System Tables

Virtual System Tables (VSTs) allow you to examine the status of a database and monitor its performance. The following lists describe each VST that is viewable through the VST WebTool. For more information on VSTs see the OpenEdge Data Management: Database Administration manual.

Status Tables
  2-Phase Commit Displays details of two-phase commit status.
  AI Log Displays details of after-image status.
  Backup Displays information on the latest full and incremental backups.
  BI Log Displays details of before-image status.
  Buffers Displays status of Progress buffers, such as the number of buffers that are in the buffer cache, that are currently in use, that are empty, or that are on the LRU chain, page writer queue, or checkpoint queue.
  Database Displays a wide variety of database status information.
  Files Displays information on open files, including ID, size, and path name.
  Logging Summarizes before-image, after-image, and two-phase commit status.
  Servers Displays status of Progress servers running on the system, such as the server number, process ID, and type; the protocol used; the number of logins and current users; the maximum number of users; and the server's port number.
  Shared Memory Reports the segment number, segment size, and the number of free and used segments.

Lock Tables
  All Locks Displays the status of the lock table, including the user number, the user name, lock type, RECID number, flags, and chain.
  By User Displays the contents of the record-locking table, including user name, chain, number, RECID number, lock type, and flags.

Activity Tables
  AI Log Displays after-image log activity, such as the number of after-image writes, records and bytes written, busy buffer waits, and log force waits.
  BI Log Displays before-image log activity, such as the number of after-image writes, records and bytes written, busy buffer waits, and log force waits.
  Buffer Cache
 
 		 Displays the activity of the database buffer cache, such as the number of logical reads and writes, OS reads and writes, checkpoints, deferred writes, LRU skips and writes, and APW enqueues.
  I/O Ops. by File Displays information about input/output activity, including the number of reads, writes, and extends for each file.
  I/O Ops. by Type Displays information about types of input/output activity, such as database reads and writes, before-image and after-image reads, total reads, before-image and after-image writes, committed transactions, and database up time.
  Index Displays index activity, such as the number of entry finds, creates, and deletes, the number of locked entries removed, and the numbers of split and free blocks.
  Lock Table Displays Lock Table activity, including the number of share, exclusive, upgrade, Rec Get, and redundant requests; the number of exclusive, Rec Get, share, and upgrade grants; the number of exclusive, Rec Get, share, and upgrade waits; the number of downgrades, transactions committed, cancelled requests, and database up time.
  Other
 		 Displays information about miscellaneous activity, including the number of commits, undo operations, semaphore waits, master block flushes, and database up time.
  Page Writers Displays information about asynchronous page writer (APW) activity, including the number of APW queue and database writes, checkpoint and scan writes, total database writes; the number of buffers scanned and checkpointed; the number of checkpoints, checkpoint flushes, and marks; the number of scan cycles, committed transactions, and database up time.
  Record Displays record activity information, including the number of bytes created, deleted, read, and updated; the number of fragments created, deleted, read, and updated; the number of records created, deleted, read, and updated; the number of transactions committed; and database up time.
  Server Displays server activity information, including the number of bytes sent and received, the number of messages sent and received, the number of queries received, the number of records sent and received, the number of query time slice switches, the number of transactions committed, and database up time.
  Space Allocation Displays space allocation information, including the number of database extends, the number of times a block was used from and returned to the free chain, the number of times space was allocated for a record, from the RM chain, or from the free chain, the number of bytes allocated for record fragments, the number of RM blocks examined or removed, the number of blocks added to the front or back of the RM chain, the number of moved blocks, the number of locked chain entries, the number of transactions committed, and database up time.
  Summary Displays general information about database activity, including the number of transactions committed and rolled back; the number of records read, updated, created, and deleted; the number of record locks and waits; the number of database reads and writes; before-image and after-image information; and buffer information.

Client Tables
  Active Transactions Displays active transactions.
  All Processes Displays information about all two-phase commit, batch user and device connections to the database.
  Background Displays all clients that are not local, interactive, or remote.
  Blocked Clients Displays blocked clients.
  Local Batch Displays local, batch clients.
  Local Interactive Displays local, interactive clients that are using shared memory.
  Remote Clients Displays clients that are connected through a network.

Other Tables
  Checkpoints Displays information about each checkpoint, including the checkpoint number and beginning time, the time required to complete the checkpoint, and the number of modified blocks scheduled to be written. The file also describes APW-written blocks.
  Lock Requests Displays information about lock requests, including user name and number, record locks and waits, schema locks and waits, and transaction locks and waits.
  Startup Paramaters Displays the values of the database startup parameters.

WebSpeed Glossary