-- automatically generated then edited see README Informix-MIB DEFINITIONS ::= BEGIN IMPORTS DisplayString FROM RFC1213-MIB OBJECT-TYPE FROM RFC-1212 TimeTicks, Gauge, Counter, enterprises FROM RFC1155-SMI rdbmsDbIndex FROM RDBMS-MIB applIndex FROM APPLICATION-MIB; -- We define TimeStamp and DateAndTime directly instead of getting from V2. -- TimeStamp, DateAndTime -- FROM SNMPv2-TC -- We use Gauge rather than getting Gauge32 from V2 -- Gauge32 -- FROM SNMPv2-SMI; TimeStamp ::= TimeTicks DateAndTime ::= OCTET STRING (SIZE (8 .. 11)) -- created from informix (9904060000Z) informix OBJECT IDENTIFIER ::= { enterprises 893 } Identifier ::= OCTET STRING Kilobytes ::= INTEGER servers OBJECT IDENTIFIER ::= { informix 1 } onlineMIB OBJECT IDENTIFIER ::= { servers 1 } xpsMIB OBJECT IDENTIFIER ::= { servers 3 } onlineObjects OBJECT IDENTIFIER ::= { onlineMIB 1 } onServerTable OBJECT-TYPE SYNTAX SEQUENCE OF OnServerEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "Status and profile information maintained on a per-server basis." ::= { onlineObjects 1 } onServerEntry OBJECT-TYPE SYNTAX OnServerEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "An entry associated with a single instance of an active server." INDEX { applIndex } ::= { onServerTable 1 } OnServerEntry ::= SEQUENCE { onServerMode INTEGER, onServerCheckpointInProgress INTEGER, onServerPageSize INTEGER, onServerThreads Gauge, onServerVPs Gauge, onServerVirtualMemory Kilobytes, onServerResidentMemory Kilobytes, onServerMessageMemory Kilobytes, onServerIsamCalls Counter, onServerLatchWaits Counter, onServerLockRequests Counter, onServerLockWaits Counter, onServerBufferWaits Counter, onServerCheckpoints Counter, onServerCheckpointWaits Counter, onServerDeadLocks Counter, onServerLockTimeouts Counter, onServerLogicalLogRecords Counter, onServerLogicalLogPageWrites Counter, onServerLogicalLogWrites Counter, onServerBufferFlushes Counter, onServerForegroundWrites Counter, onServerLRUWrites Counter, onServerChunkWrites Counter, onServerReadAheadPages Counter, onServerReadAheadPagesUsed Counter, onServerSequentialScans Counter, onServerMemorySorts Counter, onServerDiskSorts Counter, onServerMaxSortSpace INTEGER (-2147483648..2147483647), onServerNetworkReads Counter, onServerNetworkWrites Counter, onServerPDQCalls Gauge, onServerTransactionCommits Counter, onServerTransactionRollBacks Counter, onServerTimeSinceLastCheckpoint TimeTicks, onServerCPUSystemTime TimeTicks, onServerCPUUserTime TimeTicks } onServerMode OBJECT-TYPE SYNTAX INTEGER { initializing(1), quiescent(2), fastRecovery(3), backingUp(4), shuttingDown(5), online(6), aborting(7), onlineReadOnly(8), microKernel(9) } ACCESS read-only STATUS mandatory DESCRIPTION "The current operating mode of the server." ::= { onServerEntry 1 } onServerCheckpointInProgress OBJECT-TYPE SYNTAX INTEGER { yes(1), no(2) } ACCESS read-only STATUS mandatory DESCRIPTION "The value of yes if a checkpoint is underway." ::= { onServerEntry 2 } onServerPageSize OBJECT-TYPE SYNTAX INTEGER ACCESS read-only STATUS mandatory DESCRIPTION "The size of a page for this server, in bytes." ::= { onServerEntry 3 } onServerThreads OBJECT-TYPE SYNTAX Gauge ACCESS read-only STATUS mandatory DESCRIPTION "The current number of threads." ::= { onServerEntry 4 } onServerVPs OBJECT-TYPE SYNTAX Gauge ACCESS read-only STATUS mandatory DESCRIPTION "The current number of virtual processors." ::= { onServerEntry 5 } onServerVirtualMemory OBJECT-TYPE SYNTAX Kilobytes ACCESS read-only STATUS mandatory DESCRIPTION "The current size of the virtual memory, in kilobytes." ::= { onServerEntry 6 } onServerResidentMemory OBJECT-TYPE SYNTAX Kilobytes ACCESS read-only STATUS mandatory DESCRIPTION "The current size of the resident memory, in kilobytes." ::= { onServerEntry 7 } onServerMessageMemory OBJECT-TYPE SYNTAX Kilobytes ACCESS read-only STATUS mandatory DESCRIPTION "The current size of the message buffer memory, in kilobytes." ::= { onServerEntry 8 } onServerIsamCalls OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The total number of ISAM-level operations (reads, writes, rewrites, deletes, commits, and rollbacks) executed so far." ::= { onServerEntry 9 } onServerLatchWaits OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The total number of times any thread waited for a latch." ::= { onServerEntry 10 } onServerLockRequests OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of lock requests handled so far." ::= { onServerEntry 11 } onServerLockWaits OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of times any transaction waited for a lock." ::= { onServerEntry 12 } onServerBufferWaits OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of buffer waits." ::= { onServerEntry 13 } onServerCheckpoints OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of checkpoints taken so far." ::= { onServerEntry 14 } onServerCheckpointWaits OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of checkpoint waits." ::= { onServerEntry 15 } onServerDeadLocks OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of deadlocks detected so far." ::= { onServerEntry 16 } onServerLockTimeouts OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of timeouts for locks so far." ::= { onServerEntry 17 } onServerLogicalLogRecords OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of records written to the logical log so far." ::= { onServerEntry 18 } onServerLogicalLogPageWrites OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of pages written to the logical log so far." ::= { onServerEntry 19 } onServerLogicalLogWrites OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of logical log writes so far." ::= { onServerEntry 20 } onServerBufferFlushes OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of times the buffers are flushed to disk so far." ::= { onServerEntry 21 } onServerForegroundWrites OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of foreground writes." ::= { onServerEntry 22 } onServerLRUWrites OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of LRU writes." ::= { onServerEntry 23 } onServerChunkWrites OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of chunk writes." ::= { onServerEntry 24 } onServerReadAheadPages OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of read-aheads for index and data pages." ::= { onServerEntry 25 } onServerReadAheadPagesUsed OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of read-ahead pages used." ::= { onServerEntry 26 } onServerSequentialScans OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of times a sequential scan is performed." ::= { onServerEntry 27 } onServerMemorySorts OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The total number of sorts that are done in memory." ::= { onServerEntry 28 } onServerDiskSorts OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of sorts that required disk space." ::= { onServerEntry 29 } onServerMaxSortSpace OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The maximum disk space used by a sort, in pages." ::= { onServerEntry 30 } onServerNetworkReads OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of network reads so far." ::= { onServerEntry 31 } onServerNetworkWrites OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of network writes so far." ::= { onServerEntry 32 } onServerPDQCalls OBJECT-TYPE SYNTAX Gauge ACCESS read-only STATUS mandatory DESCRIPTION "An instantaneous measure of current parallel query activity, to be used as a general measure of decision support activity." ::= { onServerEntry 33 } onServerTransactionCommits OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "Number of transactions committed by the server." ::= { onServerEntry 34 } onServerTransactionRollBacks OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "Number of transactions rollbacked by the server." ::= { onServerEntry 35 } onServerTimeSinceLastCheckpoint OBJECT-TYPE SYNTAX TimeTicks ACCESS read-only STATUS mandatory DESCRIPTION "Time (in centi-secs) since the last checkpoint occured." ::= { onServerEntry 36 } onServerCPUSystemTime OBJECT-TYPE SYNTAX TimeTicks ACCESS read-only STATUS mandatory DESCRIPTION "CPU SystemTime usage (in centi-secs)." ::= { onServerEntry 37 } onServerCPUUserTime OBJECT-TYPE SYNTAX TimeTicks ACCESS read-only STATUS mandatory DESCRIPTION "CPU UserTime usage (in centi-secs)." ::= { onServerEntry 38 } onDatabaseTable OBJECT-TYPE SYNTAX SEQUENCE OF OnDatabaseEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "The additional information of a database maintained by the OnLine Server." ::= { onlineObjects 2 } onDatabaseEntry OBJECT-TYPE SYNTAX OnDatabaseEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "An entry associated with a single database." INDEX { applIndex, rdbmsDbIndex } ::= { onDatabaseTable 1 } OnDatabaseEntry ::= SEQUENCE { onDatabaseDbspace Identifier, onDatabaseCreated DateAndTime, onDatabaseLogging INTEGER, onDatabaseOpenStatus INTEGER, onDatabaseUsers Gauge } onDatabaseDbspace OBJECT-TYPE SYNTAX Identifier ACCESS read-only STATUS mandatory DESCRIPTION "The name of the default dbspace for this database." ::= { onDatabaseEntry 1 } onDatabaseCreated OBJECT-TYPE SYNTAX DateAndTime ACCESS read-only STATUS mandatory DESCRIPTION "The date and time when this database was created." ::= { onDatabaseEntry 2 } onDatabaseLogging OBJECT-TYPE SYNTAX INTEGER { none(1), buffered(2), unbuffered(3), ansi(4) } ACCESS read-only STATUS mandatory DESCRIPTION "The logging status for this database." ::= { onDatabaseEntry 3 } onDatabaseOpenStatus OBJECT-TYPE SYNTAX INTEGER { notOpen(1), open(2), openExclusive(3) } ACCESS read-only STATUS mandatory DESCRIPTION "The open status for this database." ::= { onDatabaseEntry 4 } onDatabaseUsers OBJECT-TYPE SYNTAX Gauge ACCESS read-only STATUS mandatory DESCRIPTION "The number of users for this database." ::= { onDatabaseEntry 5 } onTableTable OBJECT-TYPE SYNTAX SEQUENCE OF OnTableEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "The information about the tables that are maintained by the OnLine Server." ::= { onlineObjects 3 } onTableEntry OBJECT-TYPE SYNTAX OnTableEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "An entry associated with a single table." INDEX { applIndex, rdbmsDbIndex, onTableIndex } ::= { onTableTable 1 } OnTableEntry ::= SEQUENCE { onTableIndex INTEGER, onTableName Identifier, onTableOwner Identifier, onTableType INTEGER, onTableLockLevel INTEGER, onTableCreated DateAndTime, onTableFirstDbspace Identifier, onTableRowSize INTEGER (-2147483648..2147483647), onTableRows INTEGER (-2147483648..2147483647), onTableColumns INTEGER (-2147483648..2147483647), onTableIndices INTEGER (-2147483648..2147483647), onTableExtents INTEGER (-2147483648..2147483647), onTablePagesAllocated INTEGER (-2147483648..2147483647), onTablePagesUsed INTEGER (-2147483648..2147483647), onTableFragments INTEGER (-2147483648..2147483647), onTableFragmentStrategy INTEGER, onTableActiveFragments INTEGER (-2147483648..2147483647) } onTableIndex OBJECT-TYPE SYNTAX INTEGER ACCESS not-accessible STATUS mandatory DESCRIPTION "An index to uniquely identify the table for an OnLine server." ::= { onTableEntry 1 } onTableName OBJECT-TYPE SYNTAX Identifier ACCESS read-only STATUS mandatory DESCRIPTION "The name of the table." ::= { onTableEntry 2 } onTableOwner OBJECT-TYPE SYNTAX Identifier ACCESS read-only STATUS mandatory DESCRIPTION "The name of the user who created the table." ::= { onTableEntry 3 } onTableType OBJECT-TYPE SYNTAX INTEGER { table(1), view(2), privateSynonym(3), synonym(4) } ACCESS read-only STATUS mandatory DESCRIPTION "The type of the table." ::= { onTableEntry 4 } onTableLockLevel OBJECT-TYPE SYNTAX INTEGER { page(1), row(2) } ACCESS read-only STATUS mandatory DESCRIPTION "The lock level used when updating the table." ::= { onTableEntry 5 } onTableCreated OBJECT-TYPE SYNTAX DateAndTime ACCESS read-only STATUS mandatory DESCRIPTION "The date and time when the table was created." ::= { onTableEntry 6 } onTableFirstDbspace OBJECT-TYPE SYNTAX Identifier ACCESS read-only STATUS mandatory DESCRIPTION "The name of the dbspace where the space for the table will be allocated. If the table is fragmented, this is the name of the dbspace for the first fragment of the table." ::= { onTableEntry 7 } onTableRowSize OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The size of a row in bytes in the table." ::= { onTableEntry 8 } onTableRows OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The current number of rows in the table." ::= { onTableEntry 9 } onTableColumns OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The current number of columns in the table." ::= { onTableEntry 10 } onTableIndices OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The number of keys to the table." ::= { onTableEntry 11 } onTableExtents OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The number of extents the table spans." ::= { onTableEntry 12 } onTablePagesAllocated OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The current number of pages allocated to the table." ::= { onTableEntry 13 } onTablePagesUsed OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The current number of pages used by the table." ::= { onTableEntry 14 } onTableFragments OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The number of fragments for the table. If the table is not fragmented, a value of zero is returned." ::= { onTableEntry 15 } onTableFragmentStrategy OBJECT-TYPE SYNTAX INTEGER { roundRobin(1), byExpression(2), tableBased(3) } ACCESS read-only STATUS mandatory DESCRIPTION "The strategy used to fragment the table. If the table is not fragmented, either noSuchInstance(SNMPv2) or noSuchName (SNMPv1) is returned." ::= { onTableEntry 16 } onTableActiveFragments OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The number of fragments that are actively used for this table. If the table is not fragmented, either noSuchInstance(SNMPv2) or noSuchName (SNMPv1) is returned." ::= { onTableEntry 17 } onActiveTableTable OBJECT-TYPE SYNTAX SEQUENCE OF OnActiveTableEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "The information kept about open tables." ::= { onlineObjects 4 } onActiveTableEntry OBJECT-TYPE SYNTAX OnActiveTableEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "An entry associated with a single opened table." INDEX { applIndex, rdbmsDbIndex, onTableIndex } ::= { onActiveTableTable 1 } OnActiveTableEntry ::= SEQUENCE { onActiveTableStatus INTEGER, onActiveTableIsBeingAltered INTEGER, onActiveTableUsers Gauge, onActiveTableLockRequests Counter, onActiveTableLockWaits Counter, onActiveTableLockTimeouts Counter, onActiveTableIsamReads Counter, onActiveTableIsamWrites Counter, onActiveTableBufferReads Counter, onActiveTableBufferWrites Counter } onActiveTableStatus OBJECT-TYPE SYNTAX INTEGER { notBusy(1), busy(2), dirty(3) } ACCESS read-only STATUS mandatory DESCRIPTION "The current status of an opened table: notBusy(1) indicates that the table is not currently being used; busy(2) indicates that the table is in use; dirty(3) indicates that the table data is modified. For a table that is fragmented, the status is derived from all the opened fragments of the table." ::= { onActiveTableEntry 1 } onActiveTableIsBeingAltered OBJECT-TYPE SYNTAX INTEGER { yes(1), no(2) } ACCESS read-only STATUS mandatory DESCRIPTION "The alter status of the table. A table is being altered if any of the following action are in progress: add/drop of an index; ALTER TABLE; alter page count updated; pages altered to latest schema." ::= { onActiveTableEntry 2 } onActiveTableUsers OBJECT-TYPE SYNTAX Gauge ACCESS read-only STATUS mandatory DESCRIPTION "The total number of users accessing this table." ::= { onActiveTableEntry 3 } onActiveTableLockRequests OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The total number of lock requests for this open table." ::= { onActiveTableEntry 4 } onActiveTableLockWaits OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The total number of lock waits for this open table." ::= { onActiveTableEntry 5 } onActiveTableLockTimeouts OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The total number of lock timeouts for this open table." ::= { onActiveTableEntry 6 } onActiveTableIsamReads OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The total number of ISAM reads for this open table." ::= { onActiveTableEntry 7 } onActiveTableIsamWrites OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The total number of ISAM writes for this open table." ::= { onActiveTableEntry 8 } onActiveTableBufferReads OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The total number of buffer reads for this open table." ::= { onActiveTableEntry 9 } onActiveTableBufferWrites OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The total number of buffer writes for this open table." ::= { onActiveTableEntry 10 } onFragmentTable OBJECT-TYPE SYNTAX SEQUENCE OF OnFragmentEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "The information about the fragments that are maintained for a table by the OnLine Server." ::= { onlineObjects 5 } onFragmentEntry OBJECT-TYPE SYNTAX OnFragmentEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "An entry associated with a single fragment of a table. If a table is not fragmented, there is no corresponding row entry in this table." INDEX { applIndex, rdbmsDbIndex, onTableIndex, onFragmentIndex } ::= { onFragmentTable 1 } OnFragmentEntry ::= SEQUENCE { onFragmentIndex INTEGER, onFragmentType INTEGER, onFragmentDbspace Identifier, onFragmentExpression DisplayString, onFragmentIndexName DisplayString, onFragmentExtents INTEGER (-2147483648..2147483647), onFragmentPagesAllocated INTEGER (-2147483648..2147483647), onFragmentPagesUsed INTEGER (-2147483648..2147483647), onFragmentIsamReads Counter, onFragmentIsamWrites Counter, onFragmentUsers Gauge, onFragmentLockRequests Counter, onFragmentLockWaits Counter, onFragmentLockTimeouts Counter } onFragmentIndex OBJECT-TYPE SYNTAX INTEGER ACCESS not-accessible STATUS mandatory DESCRIPTION "An index to uniquely identify a fragment of a table for an OnLine server. The index orders the fragments according to the onFragmentType, onFragmentIndexName, and the internally maintained evaluation position of the fragment." ::= { onFragmentEntry 1 } onFragmentType OBJECT-TYPE SYNTAX INTEGER { fragmentedIndex(1), fragmentedTable(2) } ACCESS read-only STATUS mandatory DESCRIPTION "The type of the fragment." ::= { onFragmentEntry 2 } onFragmentDbspace OBJECT-TYPE SYNTAX Identifier ACCESS read-only STATUS mandatory DESCRIPTION "The name of the dbspace where the disk space for this fragment is allocated." ::= { onFragmentEntry 3 } onFragmentExpression OBJECT-TYPE SYNTAX DisplayString ACCESS read-only STATUS mandatory DESCRIPTION "The name of the expression that created the fragment." ::= { onFragmentEntry 4 } onFragmentIndexName OBJECT-TYPE SYNTAX DisplayString ACCESS read-only STATUS mandatory DESCRIPTION "The name of the index that is used to created the fragment." ::= { onFragmentEntry 5 } onFragmentExtents OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The number of extents for this fragment." ::= { onFragmentEntry 6 } onFragmentPagesAllocated OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The size of all the extents of this fragment in pages." ::= { onFragmentEntry 7 } onFragmentPagesUsed OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The number of pages used by this fragment." ::= { onFragmentEntry 8 } onFragmentIsamReads OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of ISAM reads done on this fragment." ::= { onFragmentEntry 9 } onFragmentIsamWrites OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of ISAM writes done on this fragment." ::= { onFragmentEntry 10 } onFragmentUsers OBJECT-TYPE SYNTAX Gauge ACCESS read-only STATUS mandatory DESCRIPTION "The total number of users accessing this fragment." ::= { onFragmentEntry 11 } onFragmentLockRequests OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The total number of lock requests for this open fragment." ::= { onFragmentEntry 12 } onFragmentLockWaits OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The total number of lock waits for this open fragment." ::= { onFragmentEntry 13 } onFragmentLockTimeouts OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The total number of deadlock timeouts for this open fragment." ::= { onFragmentEntry 14 } onDbspaceTable OBJECT-TYPE SYNTAX SEQUENCE OF OnDbspaceEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "The information about all the dbspaces that are assigned to an OnLine Server." ::= { onlineObjects 6 } onDbspaceEntry OBJECT-TYPE SYNTAX OnDbspaceEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "An entry associated with a single dbspace of an OnLine Server." INDEX { applIndex, onDbspaceIndex } ::= { onDbspaceTable 1 } OnDbspaceEntry ::= SEQUENCE { onDbspaceIndex INTEGER, onDbspaceName Identifier, onDbspaceOwner Identifier, onDbspaceCreated DateAndTime, onDbspaceChunks INTEGER, onDbspaceType INTEGER, onDbspaceMirrorStatus INTEGER, onDbspaceRecoveryStatus INTEGER, onDbspaceBackupStatus INTEGER, onDbspaceMiscStatus INTEGER, onDbspacePagesAllocated INTEGER (-2147483648..2147483647), onDbspacePagesUsed INTEGER (-2147483648..2147483647), onDbspaceBackupDate DateAndTime, onDbspaceBackupLevel INTEGER, onDbspaceLastFullBackupDate DateAndTime } onDbspaceIndex OBJECT-TYPE SYNTAX INTEGER ACCESS not-accessible STATUS mandatory DESCRIPTION "An index to uniquely identify the dbspace for an OnLine server." ::= { onDbspaceEntry 1 } onDbspaceName OBJECT-TYPE SYNTAX Identifier ACCESS read-only STATUS mandatory DESCRIPTION "The name of the dbspace." ::= { onDbspaceEntry 2 } onDbspaceOwner OBJECT-TYPE SYNTAX Identifier ACCESS read-only STATUS mandatory DESCRIPTION "The name of the user who created the dbspace." ::= { onDbspaceEntry 3 } onDbspaceCreated OBJECT-TYPE SYNTAX DateAndTime ACCESS read-only STATUS mandatory DESCRIPTION "The date and time when the dbspace was created." ::= { onDbspaceEntry 4 } onDbspaceChunks OBJECT-TYPE SYNTAX INTEGER ACCESS read-only STATUS mandatory DESCRIPTION "The number of chunks assigned to the dbspace." ::= { onDbspaceEntry 5 } onDbspaceType OBJECT-TYPE SYNTAX INTEGER { regularDbspace(1), temporaryDbspace(2), blobDbspace(3) } ACCESS read-only STATUS mandatory DESCRIPTION "The enumerated flags describing the type of the dbspace." ::= { onDbspaceEntry 6 } onDbspaceMirrorStatus OBJECT-TYPE SYNTAX INTEGER { notMirrored(1), mirrored(2), mirrorDisabled(3), newlyMirrored(4) } ACCESS read-only STATUS mandatory DESCRIPTION "The enumerated flags describing the mirror status of the dbspace." ::= { onDbspaceEntry 7 } onDbspaceRecoveryStatus OBJECT-TYPE SYNTAX INTEGER { noRecoveryNeeded(1), doneRecovery(2), physicallyRecovered(3), logicallyRecovering(4) } ACCESS read-only STATUS mandatory DESCRIPTION "The enumerated flags describing the recovery status of the dbspace." ::= { onDbspaceEntry 8 } onDbspaceBackupStatus OBJECT-TYPE SYNTAX INTEGER { yes(1), no(2) } ACCESS read-only STATUS mandatory DESCRIPTION "The value of yes if the dbspace has been backed up." ::= { onDbspaceEntry 9 } onDbspaceMiscStatus OBJECT-TYPE SYNTAX INTEGER { none(1), aTableDropped(2) } ACCESS read-only STATUS mandatory DESCRIPTION "The enumerated flags describing the table status of the dbspace." ::= { onDbspaceEntry 10 } onDbspacePagesAllocated OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The total size in pages of all the primary chunks (and not the mirror chunks) assigned to the dbspace." ::= { onDbspaceEntry 11 } onDbspacePagesUsed OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The total number of used pages in all the primary chunks (and not the mirror chunks) assigned to the dbspace." ::= { onDbspaceEntry 12 } onDbspaceBackupDate OBJECT-TYPE SYNTAX DateAndTime ACCESS read-only STATUS mandatory DESCRIPTION "The date and time when the dbspace was last backed-up. If the dbspace is not backed-up, this returns a noSuchInstance(SNMPv2) or noSuchName (SNMPv1)." ::= { onDbspaceEntry 13 } onDbspaceBackupLevel OBJECT-TYPE SYNTAX INTEGER { completeBackup(1), incrementalLevelOne(2), incrementalLevelTwo(3) } ACCESS read-only STATUS mandatory DESCRIPTION "The level of the last backup action for this dbspace. If the dbspace is not backed-up, this returns a noSuchInstance(SNMPv2) or noSuchName (SNMPv1)." ::= { onDbspaceEntry 14 } onDbspaceLastFullBackupDate OBJECT-TYPE SYNTAX DateAndTime ACCESS read-only STATUS mandatory DESCRIPTION "The date and time when a dbspace was last backed-up completely at level zero. If the dbspace is not backed-up completely so far, this returns a noSuchInstance(SNMPv2) or noSuchName (SNMPv1)." ::= { onDbspaceEntry 15 } onChunkTable OBJECT-TYPE SYNTAX SEQUENCE OF OnChunkEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "The information about all the chunks that are assigned to an OnLine Server. " ::= { onlineObjects 7 } onChunkEntry OBJECT-TYPE SYNTAX OnChunkEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "An entry associated with a single chunk of a dbspace for an OnLine Server." INDEX { applIndex, onDbspaceIndex, onChunkIndex } ::= { onChunkTable 1 } OnChunkEntry ::= SEQUENCE { onChunkIndex INTEGER, onChunkFileName DisplayString, onChunkFileOffset INTEGER, onChunkPagesAllocated INTEGER (-2147483648..2147483647), onChunkPagesUsed INTEGER (-2147483648..2147483647), onChunkType INTEGER, onChunkStatus INTEGER, onChunkMirroring INTEGER, onChunkReads Counter, onChunkPageReads Counter, onChunkWrites Counter, onChunkPageWrites Counter, onChunkMirrorFileName DisplayString, onChunkMirrorFileOffset INTEGER, onChunkMirrorStatus INTEGER } onChunkIndex OBJECT-TYPE SYNTAX INTEGER ACCESS not-accessible STATUS mandatory DESCRIPTION "An index to uniquely identify the chunk within a dbspace for an OnLine server." ::= { onChunkEntry 1 } onChunkFileName OBJECT-TYPE SYNTAX DisplayString ACCESS read-only STATUS mandatory DESCRIPTION "The name of the device or file path name for this chunk." ::= { onChunkEntry 2 } onChunkFileOffset OBJECT-TYPE SYNTAX INTEGER ACCESS read-only STATUS mandatory DESCRIPTION "The starting offset position within a device or a file in pages for the chunk." ::= { onChunkEntry 3 } onChunkPagesAllocated OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The size of the chunk in pages." ::= { onChunkEntry 4 } onChunkPagesUsed OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The number of used pages in this chunk." ::= { onChunkEntry 5 } onChunkType OBJECT-TYPE SYNTAX INTEGER { regularChunk(1), blobChunk(2), stageBlob(3) } ACCESS read-only STATUS mandatory DESCRIPTION "The type and of the chunk." ::= { onChunkEntry 6 } onChunkStatus OBJECT-TYPE SYNTAX INTEGER { offline(1), online(2), recovering(3), inconsistent(4), dropped(5) } ACCESS read-only STATUS mandatory DESCRIPTION "The operating status of the chunk." ::= { onChunkEntry 7 } onChunkMirroring OBJECT-TYPE SYNTAX INTEGER { notMirrored(1), mirrored(2), newlyMirrored(3) } ACCESS read-only STATUS mandatory DESCRIPTION "The mirroring of the chunk." ::= { onChunkEntry 8 } onChunkReads OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of read operations performed on this chunk." ::= { onChunkEntry 9 } onChunkPageReads OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of pages read from this chunk." ::= { onChunkEntry 10 } onChunkWrites OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of write operations performed on this chunk." ::= { onChunkEntry 11 } onChunkPageWrites OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of pages written to this chunk." ::= { onChunkEntry 12 } onChunkMirrorFileName OBJECT-TYPE SYNTAX DisplayString ACCESS read-only STATUS mandatory DESCRIPTION "The name of the device or file path name for the mirror chunk." ::= { onChunkEntry 13 } onChunkMirrorFileOffset OBJECT-TYPE SYNTAX INTEGER ACCESS read-only STATUS mandatory DESCRIPTION "The starting offset position within a device or a file in pages for the mirror chunk." ::= { onChunkEntry 14 } onChunkMirrorStatus OBJECT-TYPE SYNTAX INTEGER { offline(1), online(2), recovering(3), inconsistent(4), dropped(5) } ACCESS read-only STATUS mandatory DESCRIPTION "The status of the mirror chunk." ::= { onChunkEntry 15 } onLogicalLogTable OBJECT-TYPE SYNTAX SEQUENCE OF OnLogicalLogEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "The information about all the logfile spaces that are assigned to an OnLine Server." ::= { onlineObjects 8 } onLogicalLogEntry OBJECT-TYPE SYNTAX OnLogicalLogEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "An entry associated with a single logfile space for an OnLine Server." INDEX { applIndex, onLogicalLogIndex } ::= { onLogicalLogTable 1 } OnLogicalLogEntry ::= SEQUENCE { onLogicalLogIndex INTEGER, onLogicalLogID INTEGER, onLogicalLogDbspace Identifier, onLogicalLogStatus INTEGER, onLogicalLogContainsLastCheckpoint INTEGER, onLogicalLogIsTemporary INTEGER, onLogicalLogPagesAllocated INTEGER (-2147483648..2147483647), onLogicalLogPagesUsed INTEGER (-2147483648..2147483647), onLogicalLogFillTime DateAndTime, onLogicalLogBackupDate DateAndTime } onLogicalLogIndex OBJECT-TYPE SYNTAX INTEGER ACCESS not-accessible STATUS mandatory DESCRIPTION "An index to uniquely identify the logical logfile for an OnLine server. This is the same as the logfile number." ::= { onLogicalLogEntry 1 } onLogicalLogID OBJECT-TYPE SYNTAX INTEGER ACCESS read-only STATUS mandatory DESCRIPTION "The unique ID assigned to this logical logfile by the OnLine server." ::= { onLogicalLogEntry 2 } onLogicalLogDbspace OBJECT-TYPE SYNTAX Identifier ACCESS read-only STATUS mandatory DESCRIPTION "The name of the dbspace where this logfile resides." ::= { onLogicalLogEntry 3 } onLogicalLogStatus OBJECT-TYPE SYNTAX INTEGER { newlyAdded(1), free(2), current(3), used(4), backedUpButNeeded(5) } ACCESS read-only STATUS mandatory DESCRIPTION "The type and status of the logfile." ::= { onLogicalLogEntry 4 } onLogicalLogContainsLastCheckpoint OBJECT-TYPE SYNTAX INTEGER { yes(1), no(2) } ACCESS read-only STATUS mandatory DESCRIPTION "The value of yes if the logfile contains the most recent checkpoint." ::= { onLogicalLogEntry 5 } onLogicalLogIsTemporary OBJECT-TYPE SYNTAX INTEGER { yes(1), no(2) } ACCESS read-only STATUS mandatory DESCRIPTION "The temporary status of the logfile." ::= { onLogicalLogEntry 6 } onLogicalLogPagesAllocated OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The number of pages assigned to the logfile." ::= { onLogicalLogEntry 7 } onLogicalLogPagesUsed OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The number of pages used in the logfile." ::= { onLogicalLogEntry 8 } onLogicalLogFillTime OBJECT-TYPE SYNTAX DateAndTime ACCESS read-only STATUS mandatory DESCRIPTION "The date and time when the logfile last filled up." ::= { onLogicalLogEntry 9 } onLogicalLogBackupDate OBJECT-TYPE SYNTAX DateAndTime ACCESS read-only STATUS mandatory DESCRIPTION "The date and time when the logical log was last backed-up. If the logical log is not backed-up, this returns a noSuchInstance(SNMPv2) or noSuchName (SNMPv1)." ::= { onLogicalLogEntry 10 } onPhysicalLogTable OBJECT-TYPE SYNTAX SEQUENCE OF OnPhysicalLogEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "The information about the physical logfile space that is assigned to an OnLine Server." ::= { onlineObjects 9 } onPhysicalLogEntry OBJECT-TYPE SYNTAX OnPhysicalLogEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "An entry associated with a single physical logfile space for an OnLine Server." INDEX { applIndex } ::= { onPhysicalLogTable 1 } OnPhysicalLogEntry ::= SEQUENCE { onPhysicalLogDbspace Identifier, onPhysicalLogBufferSize INTEGER, onPhysicalLogBufferUsed INTEGER, onPhysicalLogPageWrites Counter, onPhysicalLogWrites Counter, onPhysicalLogPagesAllocated INTEGER, onPhysicalLogPagesUsed INTEGER } onPhysicalLogDbspace OBJECT-TYPE SYNTAX Identifier ACCESS read-only STATUS mandatory DESCRIPTION "The name of the dbspace where this physical logfile resides." ::= { onPhysicalLogEntry 1 } onPhysicalLogBufferSize OBJECT-TYPE SYNTAX INTEGER ACCESS read-only STATUS mandatory DESCRIPTION "The size of the buffer in pages for the physical logging." ::= { onPhysicalLogEntry 2 } onPhysicalLogBufferUsed OBJECT-TYPE SYNTAX INTEGER ACCESS read-only STATUS mandatory DESCRIPTION "The number of pages in the physical log buffer that are used." ::= { onPhysicalLogEntry 3 } onPhysicalLogPageWrites OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of pages written to the physical log." ::= { onPhysicalLogEntry 4 } onPhysicalLogWrites OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of write operations to the disk for the physical log." ::= { onPhysicalLogEntry 5 } onPhysicalLogPagesAllocated OBJECT-TYPE SYNTAX INTEGER ACCESS read-only STATUS mandatory DESCRIPTION "The number of disk pages assigned to the physical logfile." ::= { onPhysicalLogEntry 6 } onPhysicalLogPagesUsed OBJECT-TYPE SYNTAX INTEGER ACCESS read-only STATUS mandatory DESCRIPTION "The number of pages used in the physical logfile." ::= { onPhysicalLogEntry 7 } onSessionTable OBJECT-TYPE SYNTAX SEQUENCE OF OnSessionEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "Status and profile information maintained on a per-session basis." ::= { onlineObjects 10 } onSessionEntry OBJECT-TYPE SYNTAX OnSessionEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "An entry associated with a single session." INDEX { applIndex, onSessionIndex } ::= { onSessionTable 1 } OnSessionEntry ::= SEQUENCE { onSessionIndex INTEGER, onSessionUserName DisplayString, onSessionUserProgramVersion Identifier, onSessionUserProcessId INTEGER, onSessionUserTime TimeTicks, onSessionState INTEGER, onSessionDatabase Identifier, onSessionCurrentMemory INTEGER (-2147483648..2147483647), onSessionThreads Gauge, onSessionLockRequests Counter, onSessionLocksHeld Counter, onSessionLockWaits Counter, onSessionLockTimeouts Counter, onSessionLogRecords Counter, onSessionIsamReads Counter, onSessionIsamWrites Counter, onSessionPageReads Counter, onSessionPageWrites Counter, onSessionLongTxs Counter, onSessionLogSpace Counter, onSessionHighwaterLogSpace Gauge, onSessionSqlStatement DisplayString, onSessionSqlIsolation INTEGER, onSessionSqlLockWaitMode INTEGER, onSessionSqlEstimatedCost INTEGER (-2147483648..2147483647), onSessionSqlEstimatedRows INTEGER (-2147483648..2147483647), onSessionSqlError INTEGER (-2147483648..2147483647), onSessionSqlIsamError INTEGER (-2147483648..2147483647), onSessionTransactionStatus INTEGER, onSessionTransactionBeginLog INTEGER (-2147483648..2147483647), onSessionTransactionLastLog INTEGER (-2147483648..2147483647), onSessionOriginatingCoserverId INTEGER (-2147483648..2147483647), onSessionOriginatingSessionId INTEGER (-2147483648..2147483647) } onSessionIndex OBJECT-TYPE SYNTAX INTEGER ACCESS not-accessible STATUS mandatory DESCRIPTION "An index to uniquely identify an OnLine session." ::= { onSessionEntry 1 } onSessionUserName OBJECT-TYPE SYNTAX DisplayString ACCESS read-only STATUS mandatory DESCRIPTION "An identifier for the user who started the session, in the form name@host(tty)." ::= { onSessionEntry 2 } onSessionUserProgramVersion OBJECT-TYPE SYNTAX Identifier ACCESS read-only STATUS mandatory DESCRIPTION "The version number of the front-end program of the session." ::= { onSessionEntry 3 } onSessionUserProcessId OBJECT-TYPE SYNTAX INTEGER ACCESS read-only STATUS mandatory DESCRIPTION "The unix process ID of the front-end program for the session." ::= { onSessionEntry 4 } onSessionUserTime OBJECT-TYPE SYNTAX TimeTicks ACCESS read-only STATUS mandatory DESCRIPTION "The time that user connected to the server." ::= { onSessionEntry 5 } onSessionState OBJECT-TYPE SYNTAX INTEGER { idle(1), active(2), waitingOnMutex(3), waitingOnCondition(4), waitingOnLock(5), waitingOnBuffer(6), waitingOnCheckPointing(7), waitingOnLogicalLogWrite(8), waitingOnTransaction(9) } ACCESS read-only STATUS mandatory DESCRIPTION "The state of the session, based on the combined state of the threads for the session: idle(1) indicates the session is open but idle; active(2) indicates all the threads of a session are busy and not waiting; others specify what a session is waiting for." ::= { onSessionEntry 6 } onSessionDatabase OBJECT-TYPE SYNTAX Identifier ACCESS read-only STATUS mandatory DESCRIPTION "The current connected database." ::= { onSessionEntry 7 } onSessionCurrentMemory OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The current memory used by the session in bytes." ::= { onSessionEntry 8 } onSessionThreads OBJECT-TYPE SYNTAX Gauge ACCESS read-only STATUS mandatory DESCRIPTION "The number of active threads for this session." ::= { onSessionEntry 9 } onSessionLockRequests OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of locks requested by the session so far." ::= { onSessionEntry 10 } onSessionLocksHeld OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of locks held by the session currently." ::= { onSessionEntry 11 } onSessionLockWaits OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of times the session has to wait for a lock so far." ::= { onSessionEntry 12 } onSessionLockTimeouts OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of times the session has to wait for locks long enough for the timeout to occur." ::= { onSessionEntry 13 } onSessionLogRecords OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of logical log records generated by the session so far." ::= { onSessionEntry 14 } onSessionIsamReads OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of ISAM read calls issued for the session so far. This number provides a measure of the logical read activity of the session." ::= { onSessionEntry 15 } onSessionIsamWrites OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of ISAM write calls issued for the session so far. This number provides a measure of the logical write activity of the session." ::= { onSessionEntry 16 } onSessionPageReads OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of page read calls issued for the session so far. This number provides a measure of the physical read activity of the session." ::= { onSessionEntry 17 } onSessionPageWrites OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of page write calls issued for the session so far. This number provides a measure of the physical write activity of the session." ::= { onSessionEntry 18 } onSessionLongTxs OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of long transactions generated by the session so far." ::= { onSessionEntry 19 } onSessionLogSpace OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The size of the logical log space used by the session so far, in bytes." ::= { onSessionEntry 20 } onSessionHighwaterLogSpace OBJECT-TYPE SYNTAX Gauge ACCESS read-only STATUS mandatory DESCRIPTION "The maximum size of the logical log space ever used by the session so far, in bytes." ::= { onSessionEntry 21 } onSessionSqlStatement OBJECT-TYPE SYNTAX DisplayString ACCESS read-only STATUS mandatory DESCRIPTION "The latest SQL statement issued by the session. The statement is truncated to utmost 250 characters. If the session has no SQL statement, any access to this object instance will result in noSuchInstance (SNMPv2) or noSuchName (SNMPv1) error." ::= { onSessionEntry 22 } onSessionSqlIsolation OBJECT-TYPE SYNTAX INTEGER { noTransactions(1), dirtyReads(2), readCommitted(3), cursorRecordLocked(4), repeatableRead(5) } ACCESS read-only STATUS mandatory DESCRIPTION "The isolation level for the latest SQL statement issued by the session. If the session has no SQL statement, any access to this object instance will result in noSuchInstance (SNMPv2) or noSuchName (SNMPv1) error." ::= { onSessionEntry 23 } onSessionSqlLockWaitMode OBJECT-TYPE SYNTAX INTEGER ACCESS read-only STATUS mandatory DESCRIPTION "The mode of the session if the isolation level requires waiting for a lock. If the value is -1, implies wait for the lock till the lock is available. A value of zero implies no waiting. Any other positive value gives the amount of time to wait for the lock, in seconds. If the session has no SQL statement, any access to this object instance will result in noSuchInstance (SNMPv2) or noSuchName (SNMPv1) error." ::= { onSessionEntry 24 } onSessionSqlEstimatedCost OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The estimated cost of the latest SQL statement of the session, as reported by the SET EXPLAIN. If the session has no SQL statement, any access to this object instance will result in noSuchInstance (SNMPv2) or noSuchName (SNMPv1) error." ::= { onSessionEntry 25 } onSessionSqlEstimatedRows OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The estimated number of rows selected by the latest SQL statement of the session, as reported by the SET EXPLAIN. If the session has no SQL statement, any access to this object instance will result in noSuchInstance (SNMPv2) or noSuchName (SNMPv1) error." ::= { onSessionEntry 26 } onSessionSqlError OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The error number for the last SQL statement of the session. If the session has no SQL statement, any access to this object instance will result in noSuchInstance (SNMPv2) or noSuchName (SNMPv1) error." ::= { onSessionEntry 27 } onSessionSqlIsamError OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The ISAM error number for the last SQL statement of the session. If the session has no SQL statement, any access to this object instance will result in noSuchInstance (SNMPv2) or noSuchName (SNMPv1) error." ::= { onSessionEntry 28 } onSessionTransactionStatus OBJECT-TYPE SYNTAX INTEGER { none(1), committing(2), rollingBack(3), rollingBackHeuristically(4), waiting(5) } ACCESS read-only STATUS mandatory DESCRIPTION "The status of the transaction for this session." ::= { onSessionEntry 29 } onSessionTransactionBeginLog OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The unique Id of the logical-log file in which the BEGIN WORK record was logged for a transaction of the session. If the session has no transaction, any access to this object instance will result in noSuchInstance (SNMPv2) or noSuchName (SNMPv1) error." ::= { onSessionEntry 30 } onSessionTransactionLastLog OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The unique ID of the logical-log file in which the last record was logged for a transaction of the session. If the session has no transaction, any access to this object instance will result in noSuchInstance (SNMPv2) or noSuchName (SNMPv1) error." ::= { onSessionEntry 31 } onSessionOriginatingCoserverId OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "An identifier for originating-coserver on whose behalf this local-session runs." ::= { onSessionEntry 32 } onSessionOriginatingSessionId OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The local-session-id of the global-session on the originating coserver, for which this session runs." ::= { onSessionEntry 33 } onLockTable OBJECT-TYPE SYNTAX SEQUENCE OF OnLockEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "This table contains information on all the active locks that are currently in use on a per-session basis. For each session, there are entries both for the locks in use by the session as well as the locks on which the session is waiting." ::= { onlineObjects 11 } onLockEntry OBJECT-TYPE SYNTAX OnLockEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "An entry associated with a single lock." INDEX { applIndex, onSessionIndex, onLockIndex } ::= { onLockTable 1 } OnLockEntry ::= SEQUENCE { onLockIndex INTEGER, onLockDatabaseName Identifier, onLockTableName Identifier, onLockType INTEGER, onLockGranularity INTEGER, onLockRowId INTEGER (-2147483648..2147483647), onLockWaiters Gauge, onLockGrantTime TimeTicks } onLockIndex OBJECT-TYPE SYNTAX INTEGER ACCESS not-accessible STATUS mandatory DESCRIPTION "An index to uniquely identify a single server-internal lock." ::= { onLockEntry 1 } onLockDatabaseName OBJECT-TYPE SYNTAX Identifier ACCESS read-only STATUS mandatory DESCRIPTION "The name of the database on which a lock is held." ::= { onLockEntry 2 } onLockTableName OBJECT-TYPE SYNTAX Identifier ACCESS read-only STATUS mandatory DESCRIPTION "The name of the table on which the lock is held." ::= { onLockEntry 3 } onLockType OBJECT-TYPE SYNTAX INTEGER { bytesLock(1), intentShared(2), shared(3), sharedByRepeatableRead(4), update(5), intentExclusive(6), sharedIntentExclusive(7), exclusive(8), exclusiveByRepeatableRead(9), waiting(10) } ACCESS read-only STATUS mandatory DESCRIPTION "If the type of lock is waiting(10), then this is an entry for a lock on which a given session is waiting. Otherwise, this identifies the type of lock that is being held by a given session." ::= { onLockEntry 4 } onLockGranularity OBJECT-TYPE SYNTAX INTEGER { table(1), page(2), row(3), index(4) } ACCESS read-only STATUS mandatory DESCRIPTION "The granularity level of the lock." ::= { onLockEntry 5 } onLockRowId OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The ID of the row of the table the lock is on." ::= { onLockEntry 6 } onLockWaiters OBJECT-TYPE SYNTAX Gauge ACCESS read-only STATUS mandatory DESCRIPTION "The current number of sessions waiting for this lock." ::= { onLockEntry 7 } onLockGrantTime OBJECT-TYPE SYNTAX TimeTicks ACCESS read-only STATUS mandatory DESCRIPTION "The elapsed time since the lock was granted, in centiseconds. If the session is waiting for the lock as indicated by the onLockType object being set to waiting(10), either noSuchInstance(SNMPv2) or noSuchName (SNMPv1) is returned." ::= { onLockEntry 8 } onBarTable OBJECT-TYPE SYNTAX SEQUENCE OF OnBarEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "Information about backup activity in OnLine Server." ::= { onlineObjects 12 } onBarEntry OBJECT-TYPE SYNTAX OnBarEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "An entry created each time a dbspace or logical log is backed up." INDEX { applIndex, onBarActivityIndex, onBarObjectIndex } ::= { onBarTable 1 } OnBarEntry ::= SEQUENCE { onBarActivityIndex INTEGER, onBarObjectIndex INTEGER, onBarObjectName Identifier, onBarObjectType INTEGER, onBarBackupLevel INTEGER, onBarActionStatus INTEGER (-2147483648..2147483647), onBarTimeStamp DateAndTime } onBarActivityIndex OBJECT-TYPE SYNTAX INTEGER ACCESS not-accessible STATUS mandatory DESCRIPTION "An index to uniquely identify an action within Bar activity." ::= { onBarEntry 1 } onBarObjectIndex OBJECT-TYPE SYNTAX INTEGER ACCESS not-accessible STATUS mandatory DESCRIPTION "An index to uniquely identify an object within an action." ::= { onBarEntry 2 } onBarObjectName OBJECT-TYPE SYNTAX Identifier ACCESS read-only STATUS mandatory DESCRIPTION "The name of the object." ::= { onBarEntry 3 } onBarObjectType OBJECT-TYPE SYNTAX INTEGER { blobSpace(1), rootDbspace(2), criticalDbspace(3), nonCriticalDbspace(4), logicalLog(5) } ACCESS read-only STATUS mandatory DESCRIPTION "The type of object for which a backup has taken place." ::= { onBarEntry 4 } onBarBackupLevel OBJECT-TYPE SYNTAX INTEGER { completeBackup(1), incrementalLevelOne(2), incrementalLevelTwo(3) } ACCESS read-only STATUS mandatory DESCRIPTION "The level of the backup action." ::= { onBarEntry 5 } onBarActionStatus OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The status of the action. A non-zero value is the error status returned by onbar." ::= { onBarEntry 6 } onBarTimeStamp OBJECT-TYPE SYNTAX DateAndTime ACCESS read-only STATUS mandatory DESCRIPTION "The date and time when this action ended." ::= { onBarEntry 7 } onActiveBarTable OBJECT-TYPE SYNTAX SEQUENCE OF OnActiveBarEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "Information about active backup or restore low-level (RSAM) activity in OnLine Server." ::= { onlineObjects 15 } onActiveBarEntry OBJECT-TYPE SYNTAX OnActiveBarEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "An entry created each time a backup or restore activity is started." INDEX { applIndex, onActiveBarIndex } ::= { onActiveBarTable 1 } OnActiveBarEntry ::= SEQUENCE { onActiveBarIndex INTEGER, onActiveBarActivityType INTEGER, onActiveBarObjectId INTEGER, onActiveBarActivityLevel INTEGER, onActiveBarElapsedTime TimeTicks, onActiveBarActivitySize INTEGER (-2147483648..2147483647), onActiveBarActivityScanned INTEGER (-2147483648..2147483647), onActiveBarActivityCompleted INTEGER (-2147483648..2147483647), onActiveBarActivityStatus INTEGER (-2147483648..2147483647) } onActiveBarIndex OBJECT-TYPE SYNTAX INTEGER ACCESS not-accessible STATUS mandatory DESCRIPTION "An index to uniquely identify an active backup or restore activity. This index is the Id of the session that started the activity." ::= { onActiveBarEntry 1 } onActiveBarActivityType OBJECT-TYPE SYNTAX INTEGER { dbspaceBackup(1), dbspaceRestore(2), logBackup(3), logRestore(4), systemBackup(5), systemRestore(6) } ACCESS read-only STATUS mandatory DESCRIPTION "The type of the onbar activity." ::= { onActiveBarEntry 2 } onActiveBarObjectId OBJECT-TYPE SYNTAX INTEGER ACCESS read-only STATUS mandatory DESCRIPTION "The Id of the target object of this activity. This will be the dbspace id or index if the object is a dbspace. This will be the logfile non-unique Id if the object is a logfile. The value will be zero if the activity is system backup or restore." ::= { onActiveBarEntry 3 } onActiveBarActivityLevel OBJECT-TYPE SYNTAX INTEGER { completeBackup(1), incrementalLevelOne(2), incrementalLevelTwo(3) } ACCESS read-only STATUS mandatory DESCRIPTION "The level of the onbar activity." ::= { onActiveBarEntry 4 } onActiveBarElapsedTime OBJECT-TYPE SYNTAX TimeTicks ACCESS read-only STATUS mandatory DESCRIPTION "The elapsed time since this activity has started, in centi-seconds." ::= { onActiveBarEntry 5 } onActiveBarActivitySize OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The number of used pages of the object that is to be scanned by this activity. For a dbspace, this will be the number of used pages. If it is the root dbspace, this includes the reserved pages and extents. For a logfile, this will be the used pages of the log. For a whole system backup, this include all the dbspaces and a snap-shot of the used logs. This value is refined as the activity progresses." ::= { onActiveBarEntry 6 } onActiveBarActivityScanned OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The number of pages scanned so far among the used pages of the activity object." ::= { onActiveBarEntry 7 } onActiveBarActivityCompleted OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The number of pages of data transfer completed so far for archiving. As all the scanned pages need not be archived, this value will be less than or equal to the scanned pages." ::= { onActiveBarEntry 8 } onActiveBarActivityStatus OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The status of the action. A non-zero value is the error status returned by onbar." ::= { onActiveBarEntry 9 } onSqlHostTable OBJECT-TYPE SYNTAX SEQUENCE OF OnSqlHostEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "The connectivity configuration specified in a SQLHOST file for the server." ::= { onlineObjects 13 } onSqlHostEntry OBJECT-TYPE SYNTAX OnSqlHostEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "A line within a SQLHOST file." INDEX { applIndex, onSqlHostIndex } ::= { onSqlHostTable 1 } OnSqlHostEntry ::= SEQUENCE { onSqlHostIndex INTEGER, onSqlHostName DisplayString, onSqlHostNetType DisplayString, onSqlHostServerName DisplayString, onSqlHostServiceName DisplayString, onSqlHostServicePort INTEGER (-2147483648..2147483647), onSqlHostOptions DisplayString } onSqlHostIndex OBJECT-TYPE SYNTAX INTEGER ACCESS not-accessible STATUS mandatory DESCRIPTION "An index to uniquely identify a line within a SQLHOST file." ::= { onSqlHostEntry 1 } onSqlHostName OBJECT-TYPE SYNTAX DisplayString ACCESS read-only STATUS mandatory DESCRIPTION "The name of a host." ::= { onSqlHostEntry 2 } onSqlHostNetType OBJECT-TYPE SYNTAX DisplayString ACCESS read-only STATUS mandatory DESCRIPTION "The connection type (e.g. ontlitcp) for a host." ::= { onSqlHostEntry 3 } onSqlHostServerName OBJECT-TYPE SYNTAX DisplayString ACCESS read-only STATUS mandatory DESCRIPTION "The name of the database server, or its alias." ::= { onSqlHostEntry 4 } onSqlHostServiceName OBJECT-TYPE SYNTAX DisplayString ACCESS read-only STATUS mandatory DESCRIPTION "The service name of the connection to the server." ::= { onSqlHostEntry 5 } onSqlHostServicePort OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The service port number of the connection to the server. This number is valid only for ONSOCTCP and ONTLITCP services. All others will have a value of zero." ::= { onSqlHostEntry 6 } onSqlHostOptions OBJECT-TYPE SYNTAX DisplayString ACCESS read-only STATUS mandatory DESCRIPTION "The set of key-value (key=value) pairs listing the various options for the server." ::= { onSqlHostEntry 7 } onSnmpTable OBJECT-TYPE SYNTAX SEQUENCE OF OnSnmpEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "Profile information kept about various SNMP objects that are defined for the OnLine Server." ::= { onlineObjects 14 } onSnmpEntry OBJECT-TYPE SYNTAX OnSnmpEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "An entry associated with a single snmp table." INDEX { applIndex, onSnmpIndex } ::= { onSnmpTable 1 } OnSnmpEntry ::= SEQUENCE { onSnmpIndex INTEGER, onSnmpName DisplayString, onSnmpOID OBJECT IDENTIFIER, onSnmpRefreshType INTEGER, onSnmpRefreshInterval TimeTicks, onSnmpNextRefresh TimeTicks, onSnmpRefreshes Counter, onSnmpHoldInterval TimeTicks, onSnmpRows INTEGER (-2147483648..2147483647), onSnmpColumns INTEGER (-2147483648..2147483647), onSnmpRetries Counter, onSnmpFailures Counter } onSnmpIndex OBJECT-TYPE SYNTAX INTEGER ACCESS not-accessible STATUS mandatory DESCRIPTION "An index to uniquely identify a SNMP Table for OnLine." ::= { onSnmpEntry 1 } onSnmpName OBJECT-TYPE SYNTAX DisplayString ACCESS read-only STATUS mandatory DESCRIPTION "The name of the Snmp table." ::= { onSnmpEntry 2 } onSnmpOID OBJECT-TYPE SYNTAX OBJECT IDENTIFIER ACCESS read-only STATUS mandatory DESCRIPTION "The object ID for the Snmp table in dot notation." ::= { onSnmpEntry 3 } onSnmpRefreshType OBJECT-TYPE SYNTAX INTEGER { oneShot(1), onDemand(2), onTimer(3) } ACCESS read-only STATUS mandatory DESCRIPTION "The refresh strategy for this table." ::= { onSnmpEntry 4 } onSnmpRefreshInterval OBJECT-TYPE SYNTAX TimeTicks ACCESS read-only STATUS mandatory DESCRIPTION "The refresh interval for this table. If the refresh strategy is onTimer, this contains the actual period. If the refresh strategy is onDemand or oneShot, this value is zero. The units are in centiseconds." ::= { onSnmpEntry 5 } onSnmpNextRefresh OBJECT-TYPE SYNTAX TimeTicks ACCESS read-only STATUS mandatory DESCRIPTION "The time interval in centiseconds after which the table is refreshed." ::= { onSnmpEntry 6 } onSnmpRefreshes OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of times the table is refreshed so far." ::= { onSnmpEntry 7 } onSnmpHoldInterval OBJECT-TYPE SYNTAX TimeTicks ACCESS read-only STATUS mandatory DESCRIPTION "The hold interval for this table after an refresh. If it is non-zero, it means that the cached values for this table are valid only for this amount of time after a refresh. The units are in centiseconds." ::= { onSnmpEntry 8 } onSnmpRows OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The current number of rows in this table." ::= { onSnmpEntry 9 } onSnmpColumns OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The current number of columns in this table." ::= { onSnmpEntry 10 } onSnmpRetries OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of times the access to a table caused retries, as a result of using the shared memory of the server for getting the instance values." ::= { onSnmpEntry 11 } onSnmpFailures OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of times the access to a table caused failures, as a result of using the shared memory of the server for getting the instance values. An access is treated as a failure after a certain number of retries fail." ::= { onSnmpEntry 12 } onXpsTable OBJECT-TYPE SYNTAX SEQUENCE OF OnXpsEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "Information about XPS Server." ::= { onlineObjects 16 } onXpsEntry OBJECT-TYPE SYNTAX OnXpsEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "An entry for each coserver of an XPS server." INDEX { applIndex } ::= { onXpsTable 1 } OnXpsEntry ::= SEQUENCE { onXpsSnmpIndex INTEGER, onXpsSnmpHost DisplayString } onXpsSnmpIndex OBJECT-TYPE SYNTAX INTEGER ACCESS read-only STATUS mandatory DESCRIPTION "An index to uniquely identify an XPS server by the xpssnmp subagent." ::= { onXpsEntry 1 } onXpsSnmpHost OBJECT-TYPE SYNTAX DisplayString ACCESS read-only STATUS mandatory DESCRIPTION "The name of the host where the XPS subagent is running." ::= { onXpsEntry 2 } onErSiteTable OBJECT-TYPE SYNTAX SEQUENCE OF OnErSiteEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "Information about remote servers used in replication. Table contains entries for all servers participating in Enterprise Replication." ::= { onlineObjects 17 } onErSiteEntry OBJECT-TYPE SYNTAX OnErSiteEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "An entry describing a replication queue." INDEX { applIndex, onErSiteIndex } ::= { onErSiteTable 1 } OnErSiteEntry ::= SEQUENCE { onErSiteIndex INTEGER, onErSiteName DisplayString, onErSiteState INTEGER, onErSiteConnectionState INTEGER, onErSiteConnectionChange DateAndTime, onErSiteIdleTimeout TimeTicks, onErSiteOutMsgs Counter, onErSiteOutBytes Counter, onErSiteInMsgs Counter, onErSiteInBytes Counter, onErSiteTransactions Counter, onErSiteCommits Counter, onErSiteAborts Counter, onErSiteLastReceived DateAndTime, onErSiteRowCommits Counter, onErSiteRowAborts Counter, onErSiteRcvLatency TimeTicks, onErSiteCommitLatency TimeTicks, onErSiteClockErrors Counter } onErSiteIndex OBJECT-TYPE SYNTAX INTEGER ACCESS not-accessible STATUS mandatory DESCRIPTION "The identifier that uniquely identifies a server as defined in the group entry in SQLHOSTS." ::= { onErSiteEntry 1 } onErSiteName OBJECT-TYPE SYNTAX DisplayString ACCESS read-only STATUS mandatory DESCRIPTION "The name of the replication site." ::= { onErSiteEntry 2 } onErSiteState OBJECT-TYPE SYNTAX INTEGER { inactive(1), active(2), suspend(3), quiescent(4), hold(5), delete(6), failed(7), unknown(8) } ACCESS read-only STATUS mandatory DESCRIPTION "The state of the replication activity for this site." ::= { onErSiteEntry 3 } onErSiteConnectionState OBJECT-TYPE SYNTAX INTEGER { idle(1), connected(2), disconnected(3), timeout(4), shutdown(5), error(6), unknown(7) } ACCESS read-only STATUS mandatory DESCRIPTION "The state of the connection to this site." ::= { onErSiteEntry 4 } onErSiteConnectionChange OBJECT-TYPE SYNTAX DateAndTime ACCESS read-only STATUS mandatory DESCRIPTION "The date and time when the connection state last changed." ::= { onErSiteEntry 5 } onErSiteIdleTimeout OBJECT-TYPE SYNTAX TimeTicks ACCESS read-only STATUS mandatory DESCRIPTION "The time limit for ER to wait for new data to send or receive. Value set when server was defined. If time limit is exceeded connection will be closed." ::= { onErSiteEntry 6 } onErSiteOutMsgs OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The total number of messages transmitted from current server to this site." ::= { onErSiteEntry 7 } onErSiteOutBytes OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The total number of bytes transmitted from current server to this site." ::= { onErSiteEntry 8 } onErSiteInMsgs OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The total number of messages received by current server from this site." ::= { onErSiteEntry 9 } onErSiteInBytes OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The total number of bytes received by current server from this site." ::= { onErSiteEntry 10 } onErSiteTransactions OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The total number of transactions received from this site." ::= { onErSiteEntry 11 } onErSiteCommits OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The total number of transactions received and committed from this site." ::= { onErSiteEntry 12 } onErSiteAborts OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The total number of transactions aborted from this site." ::= { onErSiteEntry 13 } onErSiteLastReceived OBJECT-TYPE SYNTAX DateAndTime ACCESS read-only STATUS mandatory DESCRIPTION "The date and time when last transaction was processed from this site." ::= { onErSiteEntry 14 } onErSiteRowCommits OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The total number of rows committed from this site." ::= { onErSiteEntry 15 } onErSiteRowAborts OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "Total number of rows aborted from this site." ::= { onErSiteEntry 16 } onErSiteRcvLatency OBJECT-TYPE SYNTAX TimeTicks ACCESS read-only STATUS mandatory DESCRIPTION "The average latency between commit time on source and receive time on target. Performance measure of network queueing delay." ::= { onErSiteEntry 17 } onErSiteCommitLatency OBJECT-TYPE SYNTAX TimeTicks ACCESS read-only STATUS mandatory DESCRIPTION "The average latency between commit time on source and commit time on target. Performance measure of network and server delay." ::= { onErSiteEntry 18 } onErSiteClockErrors OBJECT-TYPE SYNTAX Counter ACCESS read-only STATUS mandatory DESCRIPTION "The number of transactions received from this site with a time that is ahead of our current time. Indicates system clock synchronization problems." ::= { onErSiteEntry 19 } onErQueueTable OBJECT-TYPE SYNTAX SEQUENCE OF OnErQueueEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "Information about replication queues. Table contains entries for all servers participating in replication." ::= { onlineObjects 18 } onErQueueEntry OBJECT-TYPE SYNTAX OnErQueueEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "An entry describing a replication queue." INDEX { applIndex, onErQueueReplIndex, onErQueueSiteIndex } ::= { onErQueueTable 1 } OnErQueueEntry ::= SEQUENCE { onErQueueReplIndex INTEGER, onErQueueSiteIndex INTEGER, onErQueueReplName DisplayString, onErQueueSiteName DisplayString, onErQueueSize Gauge, onErQueueLastCommit DataAndTime, onErQueueLastAck DataAndTime } onErQueueReplIndex OBJECT-TYPE SYNTAX INTEGER ACCESS not-accessible STATUS mandatory DESCRIPTION "The identifier that uniquely identifies a replicant." ::= { onErQueueEntry 1 } onErQueueSiteIndex OBJECT-TYPE SYNTAX INTEGER ACCESS not-accessible STATUS mandatory DESCRIPTION "The identifier that uniquely identifies a server." ::= { onErQueueEntry 2 } onErQueueReplName OBJECT-TYPE SYNTAX DisplayString ACCESS read-only STATUS mandatory DESCRIPTION "The name used to describe the replicant or collection of replicants." ::= { onErQueueEntry 3 } onErQueueSiteName OBJECT-TYPE SYNTAX DisplayString ACCESS read-only STATUS mandatory DESCRIPTION "The name of the Entrprise Replication server." ::= { onErQueueEntry 4 } onErQueueSize OBJECT-TYPE SYNTAX Gauge ACCESS read-only STATUS mandatory DESCRIPTION "Current number of bytes in the send queue." ::= { onErQueueEntry 5 } onErQueueLastCommit OBJECT-TYPE SYNTAX DateAndTime ACCESS read-only STATUS mandatory DESCRIPTION "The date and time when last transaction was committed." ::= { onErQueueEntry 6 } onErQueueLastAck OBJECT-TYPE SYNTAX DateAndTime ACCESS read-only STATUS mandatory DESCRIPTION "The date and time when last data was acked." ::= { onErQueueEntry 7 } xpsObjects OBJECT IDENTIFIER ::= { xpsMIB 1 } xpsCoserverTable OBJECT-TYPE SYNTAX SEQUENCE OF XpsCoserverEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "Information/listing of all coservers which comprise the XPS server." ::= { xpsObjects 1 } xpsCoserverEntry OBJECT-TYPE SYNTAX XpsCoserverEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "An entry associated with a single instance of an active XPS-coserver." INDEX { applIndex, xpsCoserverIndex } ::= { xpsCoserverTable 1 } XpsCoserverEntry ::= SEQUENCE { xpsCoserverIndex INTEGER, xpsCoserverHostname DisplayString, xpsCoserverId INTEGER (-2147483648..2147483647), xpsCoserverRootDbspaceId INTEGER (-2147483648..2147483647) } xpsCoserverIndex OBJECT-TYPE SYNTAX INTEGER ACCESS not-accessible STATUS mandatory DESCRIPTION "An index to uniquely identify the coserver/member for an XPS server." ::= { xpsCoserverEntry 1 } xpsCoserverHostname OBJECT-TYPE SYNTAX DisplayString ACCESS read-only STATUS mandatory DESCRIPTION "The name of the host on which the coserver runs." ::= { xpsCoserverEntry 2 } xpsCoserverId OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The coserver-id of this XPS member." ::= { xpsCoserverEntry 3 } xpsCoserverRootDbspaceId OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The Id of root-dbspace for this coserver." ::= { xpsCoserverEntry 4 } xpsCogroupTable OBJECT-TYPE SYNTAX SEQUENCE OF XpsCogroupEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "Information/listing of all coserver-groups (cogroups) in the XPS server." ::= { xpsObjects 2 } xpsCogroupEntry OBJECT-TYPE SYNTAX XpsCogroupEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "An entry associated with a single instance of a cogroup in a XPS server." INDEX { applIndex, xpsCogroupIndex } ::= { xpsCogroupTable 1 } XpsCogroupEntry ::= SEQUENCE { xpsCogroupIndex INTEGER, xpsCogroupName DisplayString, xpsCogroupMemberCount INTEGER (-2147483648..2147483647), xpsCogroupIsClustered INTEGER } xpsCogroupIndex OBJECT-TYPE SYNTAX INTEGER ACCESS not-accessible STATUS mandatory DESCRIPTION "An index to uniquely identify the cogroup in a XPS server." ::= { xpsCogroupEntry 1 } xpsCogroupName OBJECT-TYPE SYNTAX DisplayString ACCESS read-only STATUS mandatory DESCRIPTION "The name of the cogroup within the XPS server." ::= { xpsCogroupEntry 2 } xpsCogroupMemberCount OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The number of coservers in the cogroup of the XPS server." ::= { xpsCogroupEntry 3 } xpsCogroupIsClustered OBJECT-TYPE SYNTAX INTEGER { yes(1), no(2) } ACCESS read-only STATUS mandatory DESCRIPTION "Whether the cogroup is clustered (yes) or not (no)." ::= { xpsCogroupEntry 4 } xpsCogroupMemberTable OBJECT-TYPE SYNTAX SEQUENCE OF XpsCogroupMemberEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "Information about all coservers within a XPS cogroup." ::= { xpsObjects 3 } xpsCogroupMemberEntry OBJECT-TYPE SYNTAX XpsCogroupMemberEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "An entry associated with a single instance of a coserver in a XPS cogroup." INDEX { applIndex, xpsCogroupIndex, xpsCogroupMemberIndex } ::= { xpsCogroupMemberTable 1 } XpsCogroupMemberEntry ::= SEQUENCE { xpsCogroupMemberIndex INTEGER, xpsCogroupMemberCoserverId INTEGER (-2147483648..2147483647) } xpsCogroupMemberIndex OBJECT-TYPE SYNTAX INTEGER ACCESS not-accessible STATUS mandatory DESCRIPTION "An index to uniquely identify the cogroup member in a XPS cogroup." ::= { xpsCogroupMemberEntry 1 } xpsCogroupMemberCoserverId OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The coserver-id of this XPS cogroup member." ::= { xpsCogroupMemberEntry 2 } xpsDbsliceTable OBJECT-TYPE SYNTAX SEQUENCE OF XpsDbsliceEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "Information about all Dbslices in a XPS server." ::= { xpsObjects 4 } xpsDbsliceEntry OBJECT-TYPE SYNTAX XpsDbsliceEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "An entry associated with a single instance of a Dbslice in a XPS server." INDEX { applIndex, xpsDbsliceIndex } ::= { xpsDbsliceTable 1 } XpsDbsliceEntry ::= SEQUENCE { xpsDbsliceIndex INTEGER, xpsDbsliceName DisplayString, xpsDbsliceDbspaceCount INTEGER (-2147483648..2147483647), xpsDbsliceIsMirrored INTEGER, xpsDbsliceIsBlobSlice INTEGER, xpsDbsliceIsTemp INTEGER } xpsDbsliceIndex OBJECT-TYPE SYNTAX INTEGER ACCESS not-accessible STATUS mandatory DESCRIPTION "An index to uniquely identify a Dbslice in a XPS server." ::= { xpsDbsliceEntry 1 } xpsDbsliceName OBJECT-TYPE SYNTAX DisplayString ACCESS read-only STATUS mandatory DESCRIPTION "The name of the Dbslice in the XPS server." ::= { xpsDbsliceEntry 2 } xpsDbsliceDbspaceCount OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The number of Dbspaces in this Dbslice of the XPS server." ::= { xpsDbsliceEntry 3 } xpsDbsliceIsMirrored OBJECT-TYPE SYNTAX INTEGER { yes(1), no(2) } ACCESS read-only STATUS mandatory DESCRIPTION "Whether the Dbslice is mirrored (yes) or not (no)." ::= { xpsDbsliceEntry 4 } xpsDbsliceIsBlobSlice OBJECT-TYPE SYNTAX INTEGER { yes(1), no(2) } ACCESS read-only STATUS mandatory DESCRIPTION "Whether the Dbslice is a blob-slice (yes) or not (no)." ::= { xpsDbsliceEntry 5 } xpsDbsliceIsTemp OBJECT-TYPE SYNTAX INTEGER { yes(1), no(2) } ACCESS read-only STATUS mandatory DESCRIPTION "Whether the Dbslice is temporary (yes) or not (no)." ::= { xpsDbsliceEntry 6 } xpsDbsliceDbspaceTable OBJECT-TYPE SYNTAX SEQUENCE OF XpsDbsliceDbspaceEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "Information about all Dbspaces within a Dbslice of a XPS server." ::= { xpsObjects 5 } xpsDbsliceDbspaceEntry OBJECT-TYPE SYNTAX XpsDbsliceDbspaceEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "An entry associated with a single instance of a Dbspace in a XPS Dbslice." INDEX { applIndex, xpsDbsliceIndex, xpsDbsliceDbspaceIndex } ::= { xpsDbsliceDbspaceTable 1 } XpsDbsliceDbspaceEntry ::= SEQUENCE { xpsDbsliceDbspaceIndex INTEGER, xpsDbsliceDbspaceHomeCoserverId INTEGER (-2147483648..2147483647) } xpsDbsliceDbspaceIndex OBJECT-TYPE SYNTAX INTEGER ACCESS not-accessible STATUS mandatory DESCRIPTION "An index to uniquely identify a Dbspace in a Dbslice of a XPS server." ::= { xpsDbsliceDbspaceEntry 1 } xpsDbsliceDbspaceHomeCoserverId OBJECT-TYPE SYNTAX INTEGER (-2147483648..2147483647) ACCESS read-only STATUS mandatory DESCRIPTION "The coserver-id of the home coserver of this dbspace." ::= { xpsDbsliceDbspaceEntry 2 } END