Release 10.1A: OpenEdge Data Management:
Database Administration

> ## OpenEdge virtual system table schema descriptions

> Table 25–2 through Table 25–43 describe the schema for each virtual system table.

> Table 25–2: After-image log activity file (_ActAILog)
> Record | Description
> --- | ---
> _AiLog-AIWWrites | Number of after-image writes performed by the after-image writer (AIW). This is a subset of the total number of AI writes.
> _AiLog-BBuffWaits | Number of busy buffer waits.
> _AiLog-BytesWritn | Amount of AI data written to the AI file, in bytes.
> _AiLog-ForceWaits | Number of waiting-for-commit records to be written to disk.
> _AiLog-NoBufAvail | Total number of times a process had to wait because a buffer was not available.
> _AiLog-PartialWrt | Number of writes to the AI file made before the AI buffer is full.
> _AiLog-RecWriten | Number of records written to the AI`` file.
> _AiLog-TotWrites | Total number of writes to the AI file.
> _AiLog-Trans | Number of transactions committed to the AI file.
> _AiLog-UpTime | Number of seconds the AI file was open.

> Table 25–3: Before-image log activity file (_ActBILog)
> Record | Description
> --- | ---
> _BiLog-BBuffWaits | Number of times a process had to wait for a buffer that was busy.
> _BiLog-BIWWrites | Number of writes to the BI file performed by the before-image writer (BIW). For good performance, this number should be high in relation to the total number of BI writes.
> _BiLog-BytesRead | Number of bytes of data read from the BI file.
> _BiLog-BytesWrtn | Number of bytes of data written to the BI file.
> _BiLog-ClstrClose | Number of BI clusters filled and closed in preparation for reuse.
> _BiLog-EBuffWaits | Number of times a process had to wait because all buffers were full.
> _BiLog-ForceWaits | Number of waiting-for-commit records to be written to disk.
> _BiLog-ForceWrts | Number of waiting-for-commit records written to disk.
> _BiLog-PartialWrts | Number of writes to the BI file made before the BI buffer is full.
> _BiLog-RecRead | Number of BI records (notes) read from the BI file.
> _BiLog-RecWriten | Number of BI records (notes) written to the BI file.
> _BiLog-TotalWrts | Number of total writes to the BI file.
> _BiLog-TotReads | Number of BI blocks read from the BI file to undo transactions.
> _BiLog-Trans | Number of transactions committed to the BI`` file.
> _BiLog-UpTime | Number of seconds the BI file was open.

> Table 25–4: Buffer activity file (_ActBuffer)
> Record | Description
> --- | ---
> _Buffer-APWEnq | Number of modified buffers placed on the APW queue for writing.
> _Buffer-Chkpts | Number of checkpoint operations.
> _Buffer-Deferred | Total number of changes to blocks that occurred before the blocks were written. Each deferred write is potentially an I/O operation saved.
> _Buffer-Flushed | Number of blocks that were not written during the checkpoint and that had to be written all at once at the end of the checkpoint.
> _Buffer-LogicRds | Number of client requests for database block read operations.
> _Buffer-LogicWrts | Number of client requests for database block write operations.
> _Buffer-LRUSkips | Number of times a buffer on the LRU chain was skipped because it was locked or modified.
> _Buffer-LRUwrts | Number of blocks written to free a buffer for a read operation.
> _Buffer-Marked | Number of blocks scheduled to be written before the end of a checkpoint.
> _Buffer-OSRds | Number of database blocks read from disk.
> _Buffer-OSWrts | Number of database block writes to disk.
> _Buffer-Trans | Number of transactions committed.
> _Buffer-Uptime | Number of seconds the database was opened.

> Table 25–5: Index activity file (_ActIndex)
> Record | Description
> --- | ---
> _Index-Create | Number of new index entries generated.
> _Index-Delete | Number of index entries deleted.
> _Index-Find | Number of times an index entry was looked up.
> _Index-Free | Number of index blocks freed during deletes.
> _Index-Remove | Number of locks released at transaction end.
> _Index-Splits | Number of block splits resulting from index additions.
> _Index-Trans | Number of transactions committed.
> _Index-UpTime | Number of seconds the database was up.

> Table 25–6: Input/output activity file (_ActIOFile)
> Record | Description
> --- | ---
> _IOFile-BufReads | Number of buffered read operations performed on the file.
> _IOFile-BufWrites | Number of buffered write operations performed on the file.
> _IOFile-Extends | Number of extend operations performed on the file.
> _IOFile-FileName | Name of the file upon which operations are performed.
> _IOFile-Reads | Number of read operations performed on the file.
> _IOFile-Trans | Number of transactions committed.
> _IOFile-UbufReads | Number of unbuffered read operations performed on the file.
> _IOFile-UbufWrites | Number of unbuffered write operations performed on the file.
> _IOFile-UpTime | Number of seconds the database was up.
> _IOFile-Writes | Number of write operations performed on the file.

> Table 25–7: Input/output type activity file (_ActIOType)
> Record | Description
> --- | ---
> _IOType-AiRds | Number of AI read operations.
> _IOType-AiWrts | Number of AI write operations.
> _IOType-BiRds | Number of BI read operations.
> _IOType-BiWrts | Number of BI write operations.
> _IOType-DataReads | Number of reads of data blocks.
> _IOType-DataWrts | Number of writes to data blocks.
> _IOType-IdxRds | Number of reads of index blocks.
> _IOType-IdxWrts | Number of writes to index blocks.
> _IOType-Trans | Number of transactions committed.
> _IOType-UpTime | Number of seconds the database was up.

> Table 25–8: Lock table activity file (_ActLock)
> Record | Description
> --- | ---
> _Lock-CanclReq | Number of lock requests that were cancelled.
> _Lock-Downgrade | Number of locks that were downgraded.
> _Lock-ExclFind | Number of exclusive find requests granted.
> _Lock-ExclLock | Number of exclusive lock requests.
> _Lock-ExclReq | Number of requests for exclusive locks granted.
> _Lock-ExclWait | Number of times processes waited for an exclusive lock.
> _Lock-RecGetLock | Number of requests for record get locks granted.
> _Lock-RecGetReq | Number of record get locks granted.
> _Lock-RecGetWait | Number of times processes waited for record gets.
> _Lock-RedReq | Number of duplicate requests granted.
> _Lock-ShrFind | Number of share find requests granted.
> _Lock-ShrLock | Number of share lock requests granted.
> _Lock-ShrReq | Number of requests for share locks.
> _Lock-ShrWait | Number of times processes waited for share lock.
> _Lock-Trans | Number of transactions committed.
> _Lock-UpgLock | Number of requests for lock upgrades granted.
> _Lock-UpgReq | Number of requests to upgrade a lock from shared lock to exclusive lock.
> _Lock-UpgWait | Number of times processes waited for upgrades.
> _Lock-UpTime | Number of seconds the database was up.

> Table 25–9: Other activity file (_ActOther)
> Record | Description
> --- | ---
> _Other-Commit | Number of transactions committed.
> _Other-FlushMblk | Number of times the database master block was written to disk.
> _Other-Trans | Transactions committed.
> _Other-Undo | Number of transactions rolled back.
> _Other-UpTime | Number of seconds the database was up.
> _Other-Wait | Number of times a process had to wait for a resource.

> Table 25–10: Page writer activity file (_ActPWs)
> Record | Description
> --- | ---
> _PW-ApwQWrites | Number of buffers written to clear the APW queue.
> _PW-BuffsScaned | Number of buffers scanned during each cycle.
> _PW-BufsCkp | Number of buffers checkpointed.
> _PW-Checkpoints | Number of checkpoints that have occurred.
> _PW-CkpQWrites | Number of buffers written from the checkpoint queue.
> _PW-DBWrites | Number of database write operations performed by the APW.
> _PW-Flushed | Number of blocks that were not written during the checkpoint and had to be written all at once at the end of the checkpoint.
> _PW-Marked | Number of buffers that were scheduled to be written before the end of the checkpoint.
> _PW-ScanCycles | Number of scan cycles. During a scan cycle, the APW scans a portion of the buffer pool to look for modified buffers.
> _PW-ScanWrites | Number of buffers written during the scan cycle.
> _PW-TotDBWrites | Total number of database write operations performed by all processes.
> _PW-Trans | Number of transactions committed.
> _PW-UpTime | Number of seconds the database was up.

> Table 25–11: Record activity file (_ActRecord)
> Record | Description
> --- | ---
> _Record-BytesCreat | Number of bytes created.
> _Record-BytesDel | Number of bytes deleted.
> _Record-BytesRead | Number of bytes read.
> _Record-BytesUpd | Number of bytes updated.
> _Record-FragCreat | Number of fragments created.
> _Record-FragDel | Number of fragments deleted.
> _Record-FragRead | Number of fragments read.
> _Record-FragUpd | Number of fragments updated.
> _Record-RecCreat | Number of records created.
> _Record-RecDel | Number of records deleted.
> _Record-RecRead | Number of records read.
> _Record-RecUpd | Number of records updated.
> _Record-Trans | Number of transactions committed.
> _Record-UpTime | Number of seconds the database was up.

> Table 25–12: Server activity file (_ActServer)
> Record | Description
> --- | ---
> _Server-ByteRec | Number of bytes received by the server.
> _Server-ByteSent | Number of bytes sent by the server.
> _Server-MsgRec | Number of network packets received by the server.
> _Server-MsgSent | Number of network packets sent by the server.
> _Server-QryRec | Number of query requests received.
> _Server-RecRec | Number of records received.
> _Server-RecSent | Number of records sent.
> _Server-TimeSlice | Number of query time slice switches.
> _Server-Trans | Number of transactions committed.
> _Server-UpTime | Number of seconds the database was up.

> Table 25–13: Space allocation activity file (_ActSpace)
> Record | Description
> --- | ---
> _Space-AllocNewRm | Number of times space was allocated for a record or record fragment.
> _Space-BackAdd | Number of blocks added to the back of the rm chain.
> _Space-BytesAlloc | Number of bytes allocated for record fragments.
> _Space-DbExd | Number of times the database was extended.
> _Space-Examined | Number of blocks examined in the rm chain while looking for space for a record fragment.
> _Space-FromFree | Number of times space was allocated from the free chain.
> _Space-FromRm | Number of times space was allocated from the rm chain.
> _Space-Front2Back | Number of blocks moved from the front to the back of the rm chain.
> _Space-FrontAdd | Number of blocks added to the front of the rm chain.
> _Space-Locked | Number of locked rm entries removed.
> _Space-Removed | Number of blocks removed from the rm chain.
> _Space-RetFree | Number of times a block was returned to the free chain.
> _Space-TakeFree | Number of times a block was used from the free chain.
> _Space-Trans | Number of transactions committed.
> _Space-UpTime | Number of seconds the database was up.

> Table 25–14: Summary activity file (_ActSummary)
> Record | Description
> --- | ---
> _Summary-AiWrites | Number of AI blocks written to disk.
> _Summary-BiReads | Number of BI blocks read.
> _Summary-BiWrites | Number of BI blocks written to disk.
> _Summary-Chkpts | Number of checkpoints that have been performed.
> _Summary-Commits | Number of transactions all users have committed.
> _Summary-DbAccesses | Number of times users have waited for shared and exclusive locks on a database buffer.
> _Summary-DbReads | Number of database blocks read.
> _Summary-DbWrites | Number of database blocks written to disk.
> _Summary-Flushed | Number of database buffers that have been flushed to disk because they were not written by the time the checkpoint ended.
> _Summary-RecCreat | Number of records created.
> _Summary-RecDel | Number of records deleted.
> _Summary-RecLock | Number of record locks used.
> _Summary-RecReads | Number of records read.
> _Summary-RecUpd | Number of records updated.
> _Summary-RecWait | Number of times users have waited to access a locked record.
> _Summary-TransComm | Number of transactions committed.
> _Summary-Undos | Number of transactions rolled back.
> _Summary-Uptime | Number of seconds the database was up.

> Table 25–15: Area status file (_AreaStatus)
> Record | Description
> --- | ---
> _AreaStatus-Areanum | Area number.
> _AreaStatus-Areaname | Area name.
> _AreaStatus-Totblocks | Total number of blocks in an area.
> _AreaStatus-Hiwater | Highest block used.
> _AreaStatus-Extents | Number of extents in an area.
> _AreaStatus-Lastextent | Name of extent where high-water mark resides.
> _AreaStatus-Freenum | Number of blocks on the free chain.
> _AreaStatus-Rmnum | Number of blocks on the rm chain.

> Table 25–16: Block file (_Block)
> Record | Description
> --- | ---
> _Block-Area | Block area number.
> _Block-BkupCtr | Backup counter.
> _Block-Block | Data section of the block.
> _Block-ChainType | Chain type.
> _Block-Dbkey | Dbkey.
> _Block-NextDbkey | Next Dbkey in the appropriate chain.
> _Block-Type | Type of block.
> _Block-Update | Number of times the block has been updated.

> Table 25–17: Buffer status file (_BuffStatus)
> Record | Description
> --- | ---
> _BfStatus-APWQ | Number of buffers on the page writer queue.
> _BfStatus-CKPMarked | Number of buffers currently marked for checkpoint.
> _BfStatus-CKPQ | Number of buffers on the checkpoint queue.
> _BfStatus-HashSize | Size of the buffer hash table.
> _BfStatus-LastCkpNum | Most recent checkpoint number. As checkpoints begin, they are assigned a sequential number from the start of the session. The number is also the number of checkpoints that have occurred.
> _BfStatus-LRU | Number of buffers on the least recently used (LRU) chain.
> _BfStatus-ModBuffs | Number of dirty (modified) buffers.
> _BfStatus-TotBufs | Number of buffers in the buffer cache.
> _BfStatus-UsedBuffs | Number of buffers used.

> Table 25–18: Checkpoint File (_Checkpoint)
> Record | Description
> --- | ---
> _Checkpoint-ApwQ | Number of blocks written by the APW queue and replaced on the least recently used (LRU) chain by APWs.
> _Checkpoint-CptQ | Number of blocks written from the checkpoint queue by the APWs.
> _Checkpoint-Dirty | Number of modified blocks scheduled to be written.
> _Checkpoint-Flush | Total number of blocks not written during the checkpoint that had to be written all at once at the end of the checkpoint.
> _Checkpoint-Len | Length of time required to complete the checkpoint.
> _Checkpoint-Scan | Number of blocks written by the APWs during the scan cycle.
> _Checkpoint-Time | Time the checkpoint began.

> Table 25–19: Code Features (_Code-Feature)
> Field name | Data type | Description
> --- | --- | ---
> _CodeFeature_Name | Character | Name of the database feature.
> _CodeFeature_Supported | Character | “1” indicates the code supports this database feature. “0” indicates the code does not support this feature.
> _CodeFeature_Required | Character | “1” indicates this feature is required to be active in any database this code opens. “0” indicates the database does not require this feature to be active.
> _CodeFeature-Res01 | Character | Reserved for future use.
> _CodeFeature-Res02 | Integer | Reserved for future use.

> Table 25–20: Database connection file (_Connect)
> Record | Description
> --- | ---
> _Connect-2phase | Displays a two-phase commit flag, either “yes” or “no.”
> _Connect-Batch | Displays batch users status.
> _Connect-Device | Device from which the user has connected to the database.
> _Connect-Disconnect | Displays a disconnect flag.
> _Connect-Interrupt | Displays an interrupt flag.
> _Connect-Name | Displays the user name used for the connection.
> _Connect-Pid | Displays the process ID of the user session.
> _Connect-Resync | Displays a flag that indicates the database is resyncing.
> _Connect-SemId | Displays the semaphore ID.
> _Connect-SemNum | Displays the semaphore number.
> _Connect-Server | Identifies the server if the connection is remote.
> _Connect-Time | Time the user connected to the database.
> _Connect-transId | Displays the current transaction ID.
> _Connect-Type | Displays the connection type: SELF, REMC, BROK, SERV, or BTCH.
> _Connect-Usr | Displays the user number.
> _Connect-Wait | Displays the shared memory resource the user is waiting on.
> _Connect-Wait1 | Displays additional wait flags.

> Table 25–21: Database features (_Database-Feature)
> Field Name | Data Type | Description
> --- | --- | ---
> _DBFeature_Name | Character | Name of the database feature.
> _DBFeature_Enabled | Character | “1” indicates the feature is enabled. “0” indicates the feature is not enabled.
> _DBFeature_Active | Character | “1” indicates this feature is active within the database. “0” indicates this feature is not active.
> DBFeature-Res01 | Character | Reserved for future use.
> DBFeature-Res02 | Integer | Reserved for future use.

> Table 25–22: Database status file (_DbStatus)
> Record | Description
> --- | ---
> _DbStatus-AiBlkSize | Number of bytes in an after-image block.
> _DbStatus-BiBlkSize | Number of bytes in a before-image block.
> _DbStatus-BiClSize | Number of kilobytes in the before-image cluster.
> _DbStatus-BiOpen | Most recent BI file open.
> _DbStatus-BiSize | Logical size of the BI file. You can use this in conjunction with the _DbStatus-BiClSize value to determine the number of clusters in the BI file.
> _DbStatus-BiTrunc | Time since the last truncate.
> _DbStatus-CacheStamp | Schema cache file time stamp.
> _DbStatus-Changed | Flag indicating if database has changed since last backup.
> _DbStatus-ClVersMinor | Client minor version number.
> _DbStatus-Codepage | The value in this field is not maintained. This field will be removed in a future release.
> _DbStatus-Collation | The value in this field is not maintained. This field will be removed in a future release.
> _DbStatus-CreateDate | Date and time of database creation.
> _DbStatus-DbBlkSize | Database block size.
> _DbStatus-DbVers | Database version number.
> _DbStatus-DbVersMinor | Database minor version number.
> _DbStatus-EmptyBlks | Number of empty blocks in the database.
> _DbStatus-FbDate | Most recent full backup.
> _DbStatus-FreeBlks | Number of free blocks in the database.
> _DbStatus-HiWater | Database blocks high-water mark.
> _DbStatus-IbDate | Most recent incremental backup.
> _DbStatus-IbSeq | Sequence of last incremental backup.
> _DbStatus-Integrity | DbStatus-Integrity enabled flag (`-i`).
> _DbStatus-IntFlags | Integrity flags.
> _DbStatus-LastOpen | Most recent database open.
> _DbStatus-LastTable | Highest table number defined.
> _DbStatus-LastTran | Last transaction ID.
> _DbStatus-MostLocks | Lock table high-water mark.
> _DbStatus-NumAreas | Number of areas.
> _DbStatus-NumLocks | Lock table entries in use.
> _DbStatus-NumSems | Number of semaphores.
> _DbStatus-PrevOpen | Previous database open.
> _DbStatus-RMFreeBlks | Number of rm blocks with free space.
> _DbStatus-SharedMemVer | Shared memory version number.
> _DbStatus-ShmVers | Shared memory version number.
> _DbStatus-Starttime | Time when the database was started.
> _DbStatus-State | State of the database.
> _DbStatus-Tainted | Damaged database flags.
> _DbStatus-TotalBlks | Number of blocks allocated to the database.

> Table 25–23: Database file status file (_Filelist)
> Record | Description
> --- | ---
> _FileList-BlkSize | Block size of the file.
> _FileList-Extend | Amount of most recent extend in blocks.
> _FileList-LogicalSz | Logical file size, in blocks.
> _FileList-Name | Name of the file.
> _FileList-Openmode | Displays the mode in which the file is opened.
> _FileList-Size | Size of the file.

> Table 25–24: Index statistics file (_IndexStat)
> Record | Description
> --- | ---
> _IndexStat-Blockdelete | Number of block deletes that have occurred to the index.
> _IndexStat-Delete | Number of times delete access has occurred to the index.
> _IndexStat-Create | Number of times create access has occurred to the index.
> _IndexStat-Read | Number of times read access has occurred to the index.
> _IndexStat-Split | Number of split operations that have occurred to the index.

> Table 25–25: Latch statistics file (_Latch)
> Record | Description
> --- | ---
> _Latch-Busy | Latch busy count.
> _Latch-Hold | User number of the last latch holder.
> _Latch-Lock | Latch lock count.
> _Latch-LockedT | Used for calculation of duration of lock.
> _Latch-LockT | Number, in microseconds, the latch was locked.
> _Latch-Name | Latch name.
> _Latch-Qhold | User number of the last queue holder.
> _Latch-Spin | Latch spin count.
> _Latch-Type | Latch type.
> _Latch-Wait | Latch wait (nap) count.
> _Latch-WaitT | Number, in microseconds, of wait or spin time.

> Table 25–26: License management (_License)
> Record | Description
> --- | ---
> _Lic-ActiveConns | Number of active connections.
> _Lic-BatchConns | Number of current batch connections.
> _Lic-CurrConns | Number of current connections.
> _Lic-MaxActive | Maximum number of active connections.
> _Lic-MaxBatch | Maximum number of batch connections.
> _Lic-MaxCurrent | Maximum number of current connections.
> _Lic-MinActive | Minimum number of active users.
> _Lic-MinBatch | Minimum number of batch connections.
> _Lic-MinCurrent | Minimum number of current connections.
> _Lic-ValidUsers | Number of valid license users.

> Table 25–27: Lock table status file (_Lock)
> Record | Description
> --- | ---
> _Lock-Chain | Chain number.
> _Lock-Flags | Flags for the lock. The flags specify a share lock (S), exclusive lock (X), a lock upgraded from share to exclusive (U), a lock in limbo (L), or a queued lock (Q).
> _Lock-Name | User name.
> _Lock-RecId | RECID of the record and lock table entry.
> _Lock-Table | Table name.
> _Lock-Type | Type of lock (for example, REC, RGET).
> _Lock-Usr | User number of the user who owns the lock entry.

> Table 25–28: Lock request file (_LockReq)
> Record | Description
> --- | ---
> _LockReq-ExclFind | Number of exclusive lock finds acquired by the user.
> _LockReq-Name | User name.
> _LockReq-Num | User number.
> _LockReq-RecLock | Number of record locks acquired by the user.
> _LockReq-RecWait | Number of times the user had to wait for a record lock.
> _LockReq-SchLock | Number of schema locks acquired by the user.
> _LockReq-SchWait | Number of times the user had to wait for a schema lock.
> _LockReq-ShrFind | Number of share lock finds acquired by the user.
> _LockReq-TrnLock | Number of transaction locks acquired by the user.
> _LockReq-TrnWait | Number of times the user had to wait for a transaction lock.

> Table 25–29: Logging file (_Logging)
> Record | Description
> --- | ---
> _Logging-2PC | “Yes” indicates that two-phase commit is enabled; “No” indicates that two-phase commit is disabled.
> _Logging-2PCNickName | Nickname used to identify the coordinator database. You specify a nickname when you enable two-phase commit.
> _Logging-2PCPriority | Priority for the coordinator database. You specify the priority when you enable two-phase commit.
> _Logging-AiBegin | Date of the last AIMAGE BEGIN command.
> _Logging-AiBlkSize | Size of the after-image block. You can change the AI block size. This reduces I/O rates on disks that have AI files.
> _Logging-AiBuffs | Number of buffers in the AI buffer pool. You can change the number of AI buffers with the After-image Buffers (-`aibufs`) startup parameter. The default value is 1.
> _Logging-AiCurrExt | Current after-image extent.
> _Logging-AiExtents | Number of AI files or extents.
> _Logging-AiGenNum | Generation number of the current AI extent.
> _Logging-AiIO | After-image I/O. “Reliable” indicates that synchronous or direct I/O is being used for AI writes. “Buffered” indicates that buffered I/O is being used for AI writes.
> _Logging-AiJournal | “YES” indicates that after-imaging is enabled; “NO” indicates that after-imaging is disabled.
> _Logging-AiLogSize | Number of kilobytes in the AI log file, if the AI extent in use is variable length. If the AI extent in use is fixed length, the value is 0.
> _Logging-AiNew | Date of the last AIMAGE NEW command.
> _Logging-AiOpen | Date when the AI log was last opened.
> _Logging-BiBlkSize | BI block size.
> _Logging-BiBuffs | Number of BI buffers.
> _Logging-BiBytesFree | Number of free bytes remaining in the current BI cluster.
> _Logging-BiClAge | Period of time that must pass before a BI cluster is reused. This period ensures that database blocks flushed at checkpoint are moved from the UNIX buffers on disk. When this occurs, the transaction is durably recorded on disk.
> _Logging-BiClSize | BI cluster size.
> _Logging-BiExtents | Number of BI extents.
> _Logging-BiFullBuffs | Number of full BI buffers.
> _Logging-BiIO | One of the following: “Reliable” indicates that synchronous or direct I/O is being used for BI writes; “BUFFERED” indicates that buffered I/O is being used for BI writes.
> _Logging-BiLogSize | Number of kilobytes in the BI file.
> _Logging-CommitDelay | Current value of the Delayed BI File Write (-`Mf`) parameter.
> _Logging-CrashProt | “Yes” indicates that crash protection is enabled; “No” indicates that crash protection is disabled.
> _Logging-LastCkp | Time of the last checkpoint.

> Table 25–30: Master block file (_MstrBlk)
> Record | Description
> --- | ---
> _MstrBlk-AiBlksize | Number of bytes in an AI block.
> _MstrBlk-BiBlksize | Number of bytes in a BI block.
> _MstrBlk-BiOpen | Date and time the BI file was last opened.
> _MstrBlk-BiPrev | Previous value of _MstrBlk-biopen.
> _MstrBlk-BiState | Current state of BI file.
> _MstrBlk-Cfilnum | Highest file number currently defined in the database.
> _MstrBlk-Crdate | Date and time of database creation.
> _MstrBlk-Dbstate | Current state of the database.
> _MstrBlk-Dbvers | Database version number.
> _MstrBlk-Fbdate | Date and time of the last full backup.
> _MstrBlk-Hiwater | Database blocks high-water mark.
> _MstrBlk-Ibdate | Date and time of most recent incremental backup.
> _MstrBlk-Ibseq | Sequence of last incremental backup.
> _MstrBlk-Integrity | Database integrity enabled flag.
> _MstrBlk-Lasttask | Last transaction ID.
> _MstrBlk-Oppdate | Date and time of previous database open.
> _MstrBlk-Oprdate | Date and time of most recent database open.
> _MstrBlk-Rlclsize | Current BI cluster size.
> _MstrBlk-Rltime | Time since last before-image file truncate.
> _MstrBlk-Tainted | Database damaged flags.
> _MstrBlk-Timestamp | Schema cache file time stamp.
> _MstrBlk-Totblks | Number of blocks allocated to the database.

> Table 25–31: User connection (_MyConnection)
> Record | Description
> --- | ---
> _MyConn-NumSeqBuffers | Number of private read-only buffers currently allowed.
> _MyConn-Pid | The user’s process ID.
> _MyConn-UsedSeqBuffers | Number of private read-only buffers currently in use.
> _MyConn-UserId | The user’s user number.

> Table 25–32: Resource queue statistics file (_Resrc)
> Record | Description
> --- | ---
> _Resrc-Name | Resource queue name.
> _Resrc-Lock | Resource queue lock count.
> _Resrc-Wait | Resource queue wait count.
> _Resrc-Time | Resource queue wait time.

> Table 25–33: Segments file (_Segments)
> Record | Description
> --- | ---
> _Segment-ByteFree | Number of free bytes in this shared memory segment.
> _Segment-BytesUsed | Number of bytes used in this shared memory segment.
> _Segments-Segld | Segment ID.
> _Segments-SegSize | Segment size.

> Table 25–34: Servers file (_Servers)
> Record | Description
> --- | ---
> _Server-CurrUsers | Number of current users connected to this server.
> _Server-Logins | Number of established logins.
> _Server-MaxUsers | Maximum number of logins available on the server.
> _Server-Num | Server number.
> _Server-Pid | Process ID of the server.
> _Server-PortNum | TCP/IP port number of the server.
> _Server-Protocol | Protocol supported by the server.
> _Server-Type | Server type.

> Table 25–35: Startup file (_Startup)
> Record | Description
> --- | ---
> _Startup-AiBuffs | Number of after-image buffers.
> _Startup-AiName | Value of the After-image Filename (-`a`) startup parameter.
> _Startup-APWBuffs | Value of the Page Writer Scan (-`pwscan`) parameter.
> _Startup-APWMaxWrites | Value of the Page Writer Maximum Buffers (-`pwwmax`) startup parameter.
> _Startup-APWQTime | Value of the Page Writer Queue Delay (-`pwqdelay`) startup parameter.
> _Startup-APWSTime | Value of the Page Writer Scan Delay (-`pwsdelay`) parameter.
> _Startup-BiBuffs | Number of before-image buffers.
> _Startup-BiDelay | Delay of before-image flush (`-mf`).
> _Startup-BiIO | Before-image file I/O (-`r`, -`R`).
> _Startup-BiName | Before-image filename (-`g`).
> _Startup-BiTrunc | Before-image truncate interval (-`G`).
> _Startup-Buffs | Number of database buffers (-`B`).
> _Startup-CrashProt | No crash protection (-`i`).
> _Startup-Directio | Direct I/O data transfer (-`directio`). Field is set to 1 when -`directio` is specified.
> _Startup-LockTable | Maximum size of the locking table.
> _Startup-MaxClients | Value of the Maximum Clients per Server (-`Ma`) startup parameter.
> _Startup-MaxServers | Value of the Maximum Servers (-`Mn`) startup parameter.
> _Startup-MaxUsers | Value of the Maximum Users (-`n`) startup parameter.
> _Startup-Spin | Number of spinlock tries before time-out occurs.

> Table 25–36: Index and table statistics range (_StatBase)
> Record | Description
> --- | ---
> _IndexBase | Index statistics base.
> _TableBase | Table statistics base.

> Table 25–37: Table statistics file (_TableStat)
> Record | Description
> --- | ---
> _TableStat-Create | Number of times create access has occurred to the table.
> _TableStat-Delete | Number of times delete access has occurred to the table.
> _TableStat-Read | Number of times read access has occurred to the table.
> _TableStat-Update | Number of times update access has occurred to the table.

> Table 25–38: Transaction file (_Trans)
> Record | Description
> --- | ---
> _Trans-Coord | Name of the coordinator database.
> _Trans-CoordTx | Current coordinator transaction number.
> _Trans-Counter | Transaction count.
> _Trans-Duration | Number of seconds the transaction required to complete.
> _Trans-Flags | Transaction flags.
> _Trans-Misc | Miscellaneous information.
> _Trans-Num | Transaction number.
> _Trans-State | Transaction state.
> _Trans-Txtime | Transaction start time.
> _Trans-Usrnum | User number of the user running the distributed transaction.

> Table 25–39: Transaction end lock statistics (_TxeLock)
> Record | Description
> --- | ---
> _Txe-Locks | Total number of times that transaction end lock is requested.
> _Txe-Lockss | Number of concurrently held locks. (Only valid for update and commit locks.)
> _Txe-Time | Not yet implemented. Always “?.”
> _Txe-Type | Type of transaction end lock, such as update or commit.
> _Txe-Waits | Number of times a transaction end lock request has been queued; how many times you had to wait.
> _Txe-Waitss | Number of concurrently queued locks. (Only valid for update and commit locks.)
> _Txe-Wait-Time | Not yet implemented. Always “?.”

> Table 25–40: Database input/output file (_UserIO)
> Record | Description
> --- | ---
> _UserIO-AiRead | Number of AI read operations performed by the process.
> _UserIO-AiWrite | Number of AI write operations performed by the process.
> _UserIO-BiRead | Number of BI read operations performed by the process.
> _UserIO-BiWrite | Number of BI write operations performed by the process.
> _UserIO-DbAccess | Number of database access operations performed by the process.
> _UserIO-DbRead | Number of database read operations performed by the process.
> _UserIO-DbWrite | Number of database write operations performed by the process.
> _UserIO-Name | User name of the process.
> _UserIO-Usr | User number of the process.

> Table 25–41: Record locking table file (_UserLock)
> Record | Description
> --- | ---
> _UserLock-Chain | Type of chain should always be REC, the record lock chain.
> _UserLock-Flags | Any of four possible types of flags: L (LIMBO lock), P (PURGED lock entry), Q (QUEUED lock request), and U (UPGRADE request).
> _UserLock-Misc | Miscellaneous information.
> _UserLock-Name | User name of the process owning the lock.
> _UserLock-Recid | Record ID for the record being locked.
> _UserLock-Type | One of the three lock types: EXCL (EXCLUSIVE-LOCK), SHR (SHARE-LOCK), or NOLK (NO-LOCK).
> _UserLock-Usr | User number of the process owning the lock.

> Table 25–42: User status (_UserStatus)
> Record | Description
> --- | ---
> _UserStatus-Counter | Count blocks accessed, records moved, tables moved, or indexes compacted, etc.
> _UserStatus-ObjectId | The table or index worked on.
> _UserStatus-ObjectType | The type of object worked on.
> _UserStatus-Operation | Name of the online utility for which status is being monitored.
> _UserStatus-State | The state the utility is in. See Table 25–43 for descriptions of utility states.
> _UserStatus-Target | The end value of the counter (if known).
> _UserStatus-UserId | User number.

> Table 25–43: _UserStatus-State descriptions
> _UserStatus-State value | Utility | Description
> --- | --- | ---
> 11 | PROUTIL | Attempting to get a table lock.
> 12 | PROUTIL | Attempting to get an administration lock.
> 13 | PROUTIL | Attempting to lock a storage object.
> 24 | PROUTIL TABLEMOVE | Copying records from one area to another.
> 25 | PROUTIL TABLEMOVE | Creating a new, alternate index.
> 26 | PROUTIL TABLEMOVE | Removing records from the source area after copying from source to target.
> 27 | PROUTIL TABLEMOVE | Removing old indexes.
> 31 | PROUTIL IDXMOVE | Creating a new index.
> 32 | PROUTIL IDXMOVE | Removing old index.
> 41 | PROUTIL IDXCOMPACT | Scanning the index delete chain.
> 42 | PROUTIL IDXCOMPACT | Compacting a non-leaf index block.
> 43 | PROUTIL IDXCOMPACT | Compacting a leaf index block.
> 51 | PROUTIL IDXFIX | Scanning the record manager blocks in a database.
> 52 | PROUTIL IDXFIX | Scanning the index blocks.
> 53 | PROUTIL IDXFIX | Comparing index dbkeys for chosen indexes.
> 54 | PROUTIL IDXFIX | Building the target indexes from the source index.
> 55 | PROUTIL ENABLELARGEFILES | Performing an operation on a binary large object (BLOB).
> 60 | PROBKUP | Initializing area descriptors.
> 61 | PROBKUP | Backing up active before-image clusters.
> 62 | PROBKUP | Estimating size of backup files.
> 63 | PROBKUP | Flushing the buffer pool and before-image buffers.
> 64 | PROBKUP | Backing up area object blocks.
> 65 | PROBKUP | Backing up the before-image file.
> 66 | PROBKUP | Backing up the database blocks per area.
> 70 | PROUTIL DBANALYS | Examining the record manager chain.
> 71 | PROUTIL DBANALYS | Examining the index delete chain.
> 72 | PROUTIL DBANALYS | Examining the free chain.
> 73 | PROUTIL DBANALYS | Examining each database block.
> 74 | PROUTIL DBANALYS | Gathering fragmentation statistics.
> 80 | PROUTIL DUMP | Validating user input.
> 81 | PROUTIL DUMP | Validating column index.
> 82 | PROUTIL DUMP | Validating column data type.
> 83 | PROUTIL DUMP | Dumping records from the specified table using the specified index.
> 90 | PROUTIL IDXMOVE | Validating user input.
> 91 | PROUTIL IDXMOVE | Validating target area.
> 92 | PROUTIL IDXMOVE | Attempting to get a table lock.
> 93 | PROUTIL IDXMOVE | Moving the index blocks from source to target areas.
> 100 | PROUTIL IDXFIX | Creating new indexes for schema index rebuilds.
> 101 | PROUTIL IDXFIX | Scanning all blocks with index blocks of interest.
> 102 | PROUTIL IDXFIX | Scanning all blocks with index or record manager blocks of interest.
> 103 | PROUTIL IDXFIX | Scanning all blocks to reconstruct the indexes.
> 104 | PROUTIL IDXFIX | Rebuilding indexes from the sort files.
> 105 | PROUTIL IDXFIX | Activating every rebuilt index.
> 106 | PROUTIL IDXFIX | Deleting old schema indexes.
> 110 | PROUTIL TABLEMOVE | Validating user input.
> 111 | PROUTIL TABLEMOVE | Validating target area.
> 112 | PROUTIL TABLEMOVE | Attempting to get a table lock.
> 113 | PROUTIL TABLEMOVE | Looking for inactive indexes.
> 114 | PROUTIL TABLEMOVE | Deleting template record from source area.
> 115 | PROUTIL TABLEMOVE | Moving table from source to target area.
> 116 | PROUTIL TABLEMOVE | Creating template record in target area.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095