_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.

_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.

_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.

_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.

_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.

_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.

_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.

_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.

_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.

_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.

_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.

_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.

_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.

_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.

_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.

_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.

_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.

_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.

_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.

_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.

_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.

_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.

_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.

_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.

_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.

_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.

_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.

_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.

_Resrc-Name

Resource queue name.

_Resrc-Lock

Resource queue lock count.

_Resrc-Wait

Resource queue wait count.

_Resrc-Time

Resource queue wait time.

_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.

_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.

_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.

_IndexBase

Index statistics base.

_TableBase

Table statistics base.

_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.

_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.

_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.)

_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.

_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.

_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.