onServerTable
The following list summarizes this table:
- Contents:
- Status and profile information about each active database server
- Index:
- applIndex
- Scope of a row:
- One database server
The table has the following MIB objects.
| MIB Object | Description |
|---|---|
| applIndex | See applTable |
| onServerMode | Mode of the database server:
|
| onServerCheckpointInProgress | Checkpoint status:
|
| onServerPageSize | Size of a page, in bytes |
| onServerThreads | Number of active threads |
| onServerVPs | Number of virtual processors |
| onServerVirtualMemory | Total virtual memory used, in kilobytes |
| onServerResidentMemory | Total resident memory used, in kilobytes |
| onServerMessageMemory | Total message memory used, in kilobytes |
| onServerIsamCalls | Sum of all reads, writes, rewrites, deletes, commits, and rollbacks to and from the database table |
| onServerLatchWaits | Number of latch waits |
| onServerLockRequests | Number of lock requests |
| onServerLockWaits | Number of lock waits |
| onServerBufferWaits | Number of buffer waits |
| onServerCheckpointWaits | Number of checkpoint waits |
| onServerDeadLocks | Number of deadlocks |
| onServerLockTimeouts | Number of deadlock time outs |
| onServerLogicalLogRecords | Number of logical-log records |
| onServerLogicalLogPageWrites | Number of logical-log page writes |
| onServerLogicalLogWrites | Number of logical-log writes |
| onServerBufferFlushes | Number of buffer flushes |
| onServerForegroundWrites | Number of foreground writes |
| onServerLRUWrites | Number of LRU writes |
| onServerChunkWrites | Number of chunk writes |
| onServerReadAheadPages | Number of read-ahead pages This value includes data and index read-ahead pages. |
| onServerReadAheadPagesUsed | Number of read-ahead pages used |
| onServerSequentialScans | Number of sequential scans |
| onServerMemorySorts | Number of memory sorts |
| onServerDiskSorts | Number of disk sorts |
| onServerMaxSortSpace | Maximum disk space that a sort uses, in pages |
| onServerNetworkReads | Number of network reads |
| onServerNetworkWrites | Number of network writes |
| onServerPDQCalls | Number of parallel-processing actions performed |
| onServerTransactionCommits | Number of committed transactions |
| onServerTransactionRollbacks | Number of rolled-back transactions |
| onServerTimeSinceLastCheckpoint | Length of time since the last checkpoint, in hundredths of second |
| onServerCPUSystemTime | Amount of CPU time that the database server has used in System Mode, in hundredths of second |
| onServerCPUUserTime | Amount of CPU time that the database server has used in User Mode, in hundredths of second |