Table 20–1: Progress Virtual System Tables
Virtual System Table
|
Description
|
Where To Find In this Chapter
|
After-image Log Activity File (_ActAILog)
|
Displays after-image log activity, such as the number of after-image writes, records and bytes written, busy buffer waits, and log force waits.
|
|
Before-image Log Activity File (_ActBILog)
|
Displays before-image log activity, such as the number of before-image reads and writes, records and bytes written, number of records and bytes read and the number of busy and empty buffer and log force waits.
|
|
Buffer Activity File (_ActBuffer)
|
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.
|
|
Index Activity File (_ActIndex)
|
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.
|
|
Input/Output Activity File (_ActIOFile)
|
Displays information about input/output activity, including the number of reads, writes, and extends for each file.
|
|
Input/Output Type Activity File (_ActIOType)
|
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.
|
|
Lock Table Activity File (_ActLock)
|
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 Activity File (_ActOther)
|
Displays information about miscellaneous activity, including the number of commits, undo operations, semaphore waits, master block flushes, and database up time.
|
|
Page Writer Activity File (_ActPWs)
|
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 Activity File (_ActRecord)
|
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 Activity File (_ActServer)
|
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 Activity File (_ActSpace)
|
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 Activity File (_ActSummary)
|
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.
|
|
Area Status File (_AreaStatus)
|
Displays a variety of data about that status of areas.
|
|
Block File (_Block)
|
Displays information about a specific block.
|
|
Buffer Status File (_BuffStatus)
|
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.
|
|
Checkpoint File (_Checkpoint)
|
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.
|
|
Database Connection File (_Connect)
|
Displays information about two-phase commit, batch user, and device connections.
|
|
Database Status File (_DbStatus)
|
Displays a wide variety of status data.
|
|
Database File Status File (_Filelist)
|
Displays the file name, file size, and the size of every database file and extent.
|
|
Index Statistics File (_IndexStat)
|
Displays statistics on the number of accesses to a specific range of indexes.
|
|
Latch Statistics File (_Latch)
|
Displays statistics on latch and latch queue activity.
|
|
License Management (_License)
|
Provides information about the number of users and connections.
|
|
Lock Table Status File (_Lock)
|
Displays the status of the lock table, including the user number, the user name, lock type, RECID number, flags, and chain.
|
|
Lock Request File (_LockReq)
|
Displays information about lock requests, including user name and number, record locks and waits, schema locks and waits, and transaction locks and waits.
|
|
Logging File (_Logging)
|
Includes before-image and after-image logging information and two-phase commit status.
|
|
Master Block File (_MstrBlk)
|
Displays before-image and after-image information about the master block and other master block status.
|
|
User Connection (_MyConnection)
|
Provides information about a user and the number of private read-only buffers allowed and in use.
|
|
Resource Queue Statistics File (_Resrc)
|
Displays statistics on resource queue utilization.
|
|
Segments File (_Segments)
|
Reports the segment number, segment size, and the number of free and used segments.
|
|
Servers File (_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.
|
|
Startup File (_Startup)
|
Displays the values of the database startup parameters that were used.
|
|
Index and Table Statistics Range (_StatBase)
|
Displays basic table and index statistics.
|
|
Table Statistics File (_TableStat)
|
Displays statistics on the number of accesses to a specific range of tables.
|
|
Transaction File (_Trans)
|
Includes information such as transaction number, state, start time, duration, user number, coordinator name, and transaction.
|
|
Transaction End Lock Statistics (_TxeLock)
|
Includes statistics about Transaction End Locks.
|
|
Database Input/Output File (_UserIO)
|
Displays information about the database input/output operations, including user number and name and the number of accesses, reads, and writes.
|
|
Record Locking Table File (_UserLock)
|
Displays the contents of the record locking table, such as user name, chain, number, record ID, lock type, and flags.
|
|
User Status (_UserStatus)
|
Displays the progress of the IDXMOVE, TABLEMOVE, and INDEXCOMPACT utilities, such as the phase the utility is in, the user number, the tables and indexes worked on, the current position in the record chain, and the number of blocks accessed, records moved, and tables and indexes compacted.
|
|