Progress
Database Administration
Guide and Reference


Progress Virtual System Table Schema Descriptions

Table 20–2 through Table 20–40 describe the schema for each virtual system table.

Table 20–2: After-image Log Activity File (_ActAILog) 
Record
Description
_AiLog-AIWWrites
Number of after-image (AI) 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 20–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 20–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 20–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 20–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 20–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 20–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 20–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 20–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 20–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 20–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 20–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 20–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 20–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-Highwater
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 20–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 20–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 20–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 20–19: 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 20–20: 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 before-image (.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
Database character set.
_DbStatus-Collation
Database collation name.
_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 20–21: 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 20–22: 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 20–23: 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 20–24: 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 20–25: 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 20–26: 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 20–27: 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 that Progress uses 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. Progress Software recommends that you use after-imaging if you use two-phase commit.
_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 Progress reuses a BI cluster. 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. Progress Software does not recommend buffered I/O.
_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 20–28: 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 highwater 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 20–29: User Connection (_MyConnection) 
Record
Description
_MyConn-NumSeqBuffers
Number of private read-only buffers currently allowed.
_MyConn-Pid
This user’s process ID.
_MyConn-UsedSeqBuffers
Number of private read-only buffers currently in use.
_MyConn-UserId
The user’s user ID.

Table 20–30: 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 20–31: 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 20–32: 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 20–33: 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 20–34: Index and Table Statistics Range (_StatBase) 
Record
Description
_IndexBase
Index statistics base.
_TableBase
Table statistics base.

Table 20–35: 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 20–36: 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 20–37: 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 0.
_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.)

Table 20–38: 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 20–39: 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 20–40: 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.
_UserStatus-Target
The end value of the counter (if known).
_UserStatus-UserId
User number.


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