Informix-MIB DEFINITIONS ::= BEGIN IMPORTS MODULE-IDENTITY, OBJECT-TYPE, enterprises, Counter32, Gauge32, Integer32, TimeTicks FROM SNMPv2-SMI TEXTUAL-CONVENTION, DisplayString, DateAndTime, TimeStamp FROM SNMPv2-TC applGroup, applIndex FROM APPLICATION-MIB rdbmsDbIndex FROM RDBMS-MIB; informix MODULE-IDENTITY LAST-UPDATED "9904060000Z" ORGANIZATION "IBM Corporation" CONTACT-INFO "IBM Corporation 133 Westchester Avenue White Plains, New York 10604 1-800-772-2227 http://www.ibm.com" DESCRIPTION "The MIB module describing objects for IBM/Informix products." ::= { enterprises 893 } Identifier ::= TEXTUAL-CONVENTION DISPLAY-HINT "28a" STATUS current DESCRIPTION "Represents a string used to name a database, table, or other labeled object; limited to the NVT ASCII repertoire specified in RFC 854." SYNTAX OCTET STRING (SIZE (1..28)) Kilobytes ::= TEXTUAL-CONVENTION DISPLAY-HINT "d" STATUS current DESCRIPTION "Represents a size, in multiples of 1024." SYNTAX INTEGER (0..2147483647) servers OBJECT IDENTIFIER ::= { informix 1 } onlineMIB OBJECT IDENTIFIER ::= { servers 1 } -- cdrMIB OBJECT IDENTIFIER ::= { servers 2 } -- was used for the ODS 7.2 CDR SNMP subagent which -- has been obsoleted in 7.3 and later xpsMIB OBJECT IDENTIFIER ::= { servers 3 } -- ----------------- -- Online MIB tables -- ----------------- onlineObjects OBJECT IDENTIFIER ::= { onlineMIB 1 } -- Server Table onServerTable OBJECT-TYPE SYNTAX SEQUENCE OF OnServerEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "Status and profile information maintained on a per-server basis." ::= { onlineObjects 1 } onServerEntry OBJECT-TYPE SYNTAX OnServerEntry MAX-ACCESS not-accessible STATUS current 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 Gauge32, onServerVPs Gauge32, onServerVirtualMemory Kilobytes, onServerResidentMemory Kilobytes, onServerMessageMemory Kilobytes, onServerIsamCalls Counter32, onServerLatchWaits Counter32, onServerLockRequests Counter32, onServerLockWaits Counter32, onServerBufferWaits Counter32, onServerCheckpoints Counter32, onServerCheckpointWaits Counter32, onServerDeadLocks Counter32, onServerLockTimeouts Counter32, onServerLogicalLogRecords Counter32, onServerLogicalLogPageWrites Counter32, onServerLogicalLogWrites Counter32, onServerBufferFlushes Counter32, onServerForegroundWrites Counter32, onServerLRUWrites Counter32, onServerChunkWrites Counter32, onServerReadAheadPages Counter32, onServerReadAheadPagesUsed Counter32, onServerSequentialScans Counter32, onServerMemorySorts Counter32, onServerDiskSorts Counter32, onServerMaxSortSpace Integer32, onServerNetworkReads Counter32, onServerNetworkWrites Counter32, onServerPDQCalls Gauge32, onServerTransactionCommits Counter32, onServerTransactionRollBacks Counter32, 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) } MAX-ACCESS read-only STATUS current DESCRIPTION "The current operating mode of the server." ::= {onServerEntry 1} onServerCheckpointInProgress OBJECT-TYPE SYNTAX INTEGER { yes(1), no(2) } MAX-ACCESS read-only STATUS current DESCRIPTION "The value of yes if a checkpoint is underway." ::= {onServerEntry 2} onServerPageSize OBJECT-TYPE SYNTAX INTEGER (1..2147483647) MAX-ACCESS read-only STATUS current DESCRIPTION "The size of a page for this server, in bytes." ::= {onServerEntry 3} onServerThreads OBJECT-TYPE SYNTAX Gauge32 MAX-ACCESS read-only STATUS current DESCRIPTION "The current number of threads." ::= {onServerEntry 4} onServerVPs OBJECT-TYPE SYNTAX Gauge32 MAX-ACCESS read-only STATUS current DESCRIPTION "The current number of virtual processors." ::= {onServerEntry 5} onServerVirtualMemory OBJECT-TYPE SYNTAX Kilobytes MAX-ACCESS read-only STATUS current DESCRIPTION "The current size of the virtual memory, in kilobytes." ::= {onServerEntry 6} onServerResidentMemory OBJECT-TYPE SYNTAX Kilobytes MAX-ACCESS read-only STATUS current DESCRIPTION "The current size of the resident memory, in kilobytes." ::= {onServerEntry 7} onServerMessageMemory OBJECT-TYPE SYNTAX Kilobytes MAX-ACCESS read-only STATUS current DESCRIPTION "The current size of the message buffer memory, in kilobytes." ::= {onServerEntry 8} onServerIsamCalls OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of ISAM-level operations (reads, writes, rewrites, deletes, commits, and rollbacks) executed so far." ::= {onServerEntry 9} onServerLatchWaits OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of times any thread waited for a latch." ::= {onServerEntry 10} onServerLockRequests OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of lock requests handled so far." ::= {onServerEntry 11} onServerLockWaits OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of times any transaction waited for a lock." ::= {onServerEntry 12} onServerBufferWaits OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of buffer waits." ::= {onServerEntry 13} onServerCheckpoints OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of checkpoints taken so far." ::= {onServerEntry 14} onServerCheckpointWaits OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of checkpoint waits." ::= {onServerEntry 15} onServerDeadLocks OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of deadlocks detected so far." ::= {onServerEntry 16} onServerLockTimeouts OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of timeouts for locks so far." ::= {onServerEntry 17} onServerLogicalLogRecords OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of records written to the logical log so far." ::= {onServerEntry 18} onServerLogicalLogPageWrites OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of pages written to the logical log so far." ::= {onServerEntry 19} onServerLogicalLogWrites OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of logical log writes so far." ::= {onServerEntry 20} onServerBufferFlushes OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of times the buffers are flushed to disk so far." ::= {onServerEntry 21} onServerForegroundWrites OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of foreground writes." ::= {onServerEntry 22} onServerLRUWrites OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of LRU writes." ::= {onServerEntry 23} onServerChunkWrites OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of chunk writes." ::= {onServerEntry 24} onServerReadAheadPages OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of read-aheads for index and data pages." ::= {onServerEntry 25} onServerReadAheadPagesUsed OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of read-ahead pages used." ::= {onServerEntry 26} onServerSequentialScans OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of times a sequential scan is performed." ::= {onServerEntry 27} onServerMemorySorts OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of sorts that are done in memory." ::= {onServerEntry 28} onServerDiskSorts OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of sorts that required disk space." ::= {onServerEntry 29} onServerMaxSortSpace OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The maximum disk space used by a sort, in pages." ::= {onServerEntry 30} onServerNetworkReads OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of network reads so far." ::= {onServerEntry 31} onServerNetworkWrites OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of network writes so far." ::= {onServerEntry 32} onServerPDQCalls OBJECT-TYPE SYNTAX Gauge32 MAX-ACCESS read-only STATUS current 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 Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "Number of transactions committed by the server." ::= {onServerEntry 34} onServerTransactionRollBacks OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "Number of transactions rollbacked by the server." ::= {onServerEntry 35} onServerTimeSinceLastCheckpoint OBJECT-TYPE SYNTAX TimeTicks MAX-ACCESS read-only STATUS current DESCRIPTION "Time (in centi-secs) since the last checkpoint occured." ::= {onServerEntry 36} onServerCPUSystemTime OBJECT-TYPE SYNTAX TimeTicks MAX-ACCESS read-only STATUS current DESCRIPTION "CPU SystemTime usage (in centi-secs)." ::= {onServerEntry 37} onServerCPUUserTime OBJECT-TYPE SYNTAX TimeTicks MAX-ACCESS read-only STATUS current DESCRIPTION "CPU UserTime usage (in centi-secs)." ::= {onServerEntry 38} -- Database Table onDatabaseTable OBJECT-TYPE SYNTAX SEQUENCE OF OnDatabaseEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "The additional information of a database maintained by the OnLine Server." ::= { onlineObjects 2 } onDatabaseEntry OBJECT-TYPE SYNTAX OnDatabaseEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "An entry associated with a single database." INDEX {applIndex, rdbmsDbIndex} ::= { onDatabaseTable 1 } OnDatabaseEntry ::= SEQUENCE { onDatabaseDbspace Identifier, onDatabaseCreated DateAndTime, onDatabaseLogging INTEGER, onDatabaseOpenStatus INTEGER, onDatabaseUsers Gauge32 } onDatabaseDbspace OBJECT-TYPE SYNTAX Identifier MAX-ACCESS read-only STATUS current DESCRIPTION "The name of the default dbspace for this database." ::= {onDatabaseEntry 1} onDatabaseCreated OBJECT-TYPE SYNTAX DateAndTime MAX-ACCESS read-only STATUS current 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) } MAX-ACCESS read-only STATUS current DESCRIPTION "The logging status for this database." ::= {onDatabaseEntry 3} onDatabaseOpenStatus OBJECT-TYPE SYNTAX INTEGER { notOpen(1), open(2), openExclusive(3) } MAX-ACCESS read-only STATUS current DESCRIPTION "The open status for this database." ::= {onDatabaseEntry 4} onDatabaseUsers OBJECT-TYPE SYNTAX Gauge32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of users for this database." ::= {onDatabaseEntry 5} -- Table Table onTableTable OBJECT-TYPE SYNTAX SEQUENCE OF OnTableEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "The information about the tables that are maintained by the OnLine Server." ::= { onlineObjects 3 } onTableEntry OBJECT-TYPE SYNTAX OnTableEntry MAX-ACCESS not-accessible STATUS current 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 Integer32, onTableRows Integer32, onTableColumns Integer32, onTableIndices Integer32, onTableExtents Integer32, onTablePagesAllocated Integer32, onTablePagesUsed Integer32, onTableFragments Integer32, onTableFragmentStrategy INTEGER, onTableActiveFragments Integer32 } onTableIndex OBJECT-TYPE SYNTAX INTEGER (1..2147483647) MAX-ACCESS not-accessible STATUS current DESCRIPTION "An index to uniquely identify the table for an OnLine server." ::= {onTableEntry 1} onTableName OBJECT-TYPE SYNTAX Identifier MAX-ACCESS read-only STATUS current DESCRIPTION "The name of the table." ::= {onTableEntry 2} onTableOwner OBJECT-TYPE SYNTAX Identifier MAX-ACCESS read-only STATUS current 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) } MAX-ACCESS read-only STATUS current DESCRIPTION "The type of the table." ::= {onTableEntry 4} onTableLockLevel OBJECT-TYPE SYNTAX INTEGER { page(1), row(2) } MAX-ACCESS read-only STATUS current DESCRIPTION "The lock level used when updating the table." ::= {onTableEntry 5} onTableCreated OBJECT-TYPE SYNTAX DateAndTime MAX-ACCESS read-only STATUS current DESCRIPTION "The date and time when the table was created." ::= {onTableEntry 6} onTableFirstDbspace OBJECT-TYPE SYNTAX Identifier MAX-ACCESS read-only STATUS current 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 Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The size of a row in bytes in the table." ::= {onTableEntry 8} onTableRows OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The current number of rows in the table." ::= {onTableEntry 9} onTableColumns OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The current number of columns in the table." ::= {onTableEntry 10} onTableIndices OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of keys to the table." ::= {onTableEntry 11} onTableExtents OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of extents the table spans." ::= {onTableEntry 12} onTablePagesAllocated OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The current number of pages allocated to the table." ::= {onTableEntry 13} onTablePagesUsed OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The current number of pages used by the table." ::= {onTableEntry 14} onTableFragments OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current 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) } MAX-ACCESS read-only STATUS current 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 Integer32 MAX-ACCESS read-only STATUS current 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} -- Active Table Table onActiveTableTable OBJECT-TYPE SYNTAX SEQUENCE OF OnActiveTableEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "The information kept about open tables." ::= { onlineObjects 4 } onActiveTableEntry OBJECT-TYPE SYNTAX OnActiveTableEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "An entry associated with a single opened table." INDEX {applIndex, rdbmsDbIndex, onTableIndex } ::= { onActiveTableTable 1 } OnActiveTableEntry ::= SEQUENCE { onActiveTableStatus INTEGER, onActiveTableIsBeingAltered INTEGER, onActiveTableUsers Gauge32, onActiveTableLockRequests Counter32, onActiveTableLockWaits Counter32, onActiveTableLockTimeouts Counter32, onActiveTableIsamReads Counter32, onActiveTableIsamWrites Counter32, onActiveTableBufferReads Counter32, onActiveTableBufferWrites Counter32 } onActiveTableStatus OBJECT-TYPE SYNTAX INTEGER { notBusy(1), busy(2), dirty(3) } MAX-ACCESS read-only STATUS current 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) } MAX-ACCESS read-only STATUS current 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 Gauge32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of users accessing this table." ::= {onActiveTableEntry 3} onActiveTableLockRequests OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of lock requests for this open table." ::= {onActiveTableEntry 4} onActiveTableLockWaits OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of lock waits for this open table." ::= {onActiveTableEntry 5} onActiveTableLockTimeouts OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of lock timeouts for this open table." ::= {onActiveTableEntry 6} onActiveTableIsamReads OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of ISAM reads for this open table." ::= {onActiveTableEntry 7} onActiveTableIsamWrites OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of ISAM writes for this open table." ::= {onActiveTableEntry 8} onActiveTableBufferReads OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of buffer reads for this open table." ::= {onActiveTableEntry 9} onActiveTableBufferWrites OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of buffer writes for this open table." ::= {onActiveTableEntry 10} -- Fragment Table onFragmentTable OBJECT-TYPE SYNTAX SEQUENCE OF OnFragmentEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "The information about the fragments that are maintained for a table by the OnLine Server." ::= { onlineObjects 5 } onFragmentEntry OBJECT-TYPE SYNTAX OnFragmentEntry MAX-ACCESS not-accessible STATUS current 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 Integer32, onFragmentPagesAllocated Integer32, onFragmentPagesUsed Integer32, onFragmentIsamReads Counter32, onFragmentIsamWrites Counter32, onFragmentUsers Gauge32, onFragmentLockRequests Counter32, onFragmentLockWaits Counter32, onFragmentLockTimeouts Counter32 } onFragmentIndex OBJECT-TYPE SYNTAX INTEGER (1..2147483647) MAX-ACCESS not-accessible STATUS current 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) } MAX-ACCESS read-only STATUS current DESCRIPTION "The type of the fragment." ::= {onFragmentEntry 2} onFragmentDbspace OBJECT-TYPE SYNTAX Identifier MAX-ACCESS read-only STATUS current DESCRIPTION "The name of the dbspace where the disk space for this fragment is allocated." ::= {onFragmentEntry 3} onFragmentExpression OBJECT-TYPE SYNTAX DisplayString MAX-ACCESS read-only STATUS current DESCRIPTION "The name of the expression that created the fragment." ::= {onFragmentEntry 4} onFragmentIndexName OBJECT-TYPE SYNTAX DisplayString MAX-ACCESS read-only STATUS current DESCRIPTION "The name of the index that is used to created the fragment." ::= {onFragmentEntry 5} onFragmentExtents OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of extents for this fragment." ::= {onFragmentEntry 6} onFragmentPagesAllocated OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The size of all the extents of this fragment in pages." ::= {onFragmentEntry 7} onFragmentPagesUsed OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of pages used by this fragment." ::= {onFragmentEntry 8} onFragmentIsamReads OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of ISAM reads done on this fragment. This counter will reset to zero prematurely when the fragment is no longer active." ::= {onFragmentEntry 9} onFragmentIsamWrites OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of ISAM writes done on this fragment. This counter will reset to zero prematurely when the fragment is no longer active." ::= {onFragmentEntry 10} onFragmentUsers OBJECT-TYPE SYNTAX Gauge32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of users accessing this fragment." ::= {onFragmentEntry 11} onFragmentLockRequests OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of lock requests for this open fragment. This counter will reset to zero prematurely when the fragment is no longer active." ::= {onFragmentEntry 12} onFragmentLockWaits OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of lock waits for this open fragment. This counter will reset to zero prematurely when the fragment is no longer active." ::= {onFragmentEntry 13} onFragmentLockTimeouts OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of deadlock timeouts for this open fragment. This counter will reset to zero prematurely when the fragment is no longer active." ::= {onFragmentEntry 14} -- Dbspace Table onDbspaceTable OBJECT-TYPE SYNTAX SEQUENCE OF OnDbspaceEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "The information about all the dbspaces that are assigned to an OnLine Server." ::= { onlineObjects 6 } onDbspaceEntry OBJECT-TYPE SYNTAX OnDbspaceEntry MAX-ACCESS not-accessible STATUS current 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 Integer32, onDbspacePagesUsed Integer32, onDbspaceBackupDate DateAndTime, onDbspaceBackupLevel INTEGER, onDbspaceLastFullBackupDate DateAndTime } onDbspaceIndex OBJECT-TYPE SYNTAX INTEGER (1..2147483647) MAX-ACCESS not-accessible STATUS current DESCRIPTION "An index to uniquely identify the dbspace for an OnLine server." ::= {onDbspaceEntry 1} onDbspaceName OBJECT-TYPE SYNTAX Identifier MAX-ACCESS read-only STATUS current DESCRIPTION "The name of the dbspace." ::= {onDbspaceEntry 2} onDbspaceOwner OBJECT-TYPE SYNTAX Identifier MAX-ACCESS read-only STATUS current DESCRIPTION "The name of the user who created the dbspace." ::= {onDbspaceEntry 3} onDbspaceCreated OBJECT-TYPE SYNTAX DateAndTime MAX-ACCESS read-only STATUS current DESCRIPTION "The date and time when the dbspace was created." ::= {onDbspaceEntry 4} onDbspaceChunks OBJECT-TYPE SYNTAX INTEGER (1..2147483647) MAX-ACCESS read-only STATUS current DESCRIPTION "The number of chunks assigned to the dbspace." ::= {onDbspaceEntry 5} onDbspaceType OBJECT-TYPE SYNTAX INTEGER { regularDbspace(1), temporaryDbspace(2), blobDbspace(3) } MAX-ACCESS read-only STATUS current 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) } MAX-ACCESS read-only STATUS current 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) } MAX-ACCESS read-only STATUS current DESCRIPTION "The enumerated flags describing the recovery status of the dbspace." ::= {onDbspaceEntry 8} onDbspaceBackupStatus OBJECT-TYPE SYNTAX INTEGER { yes(1), no(2) } MAX-ACCESS read-only STATUS current DESCRIPTION "The value of yes if the dbspace has been backed up." ::= {onDbspaceEntry 9} onDbspaceMiscStatus OBJECT-TYPE SYNTAX INTEGER { none(1), aTableDropped(2) } MAX-ACCESS read-only STATUS current DESCRIPTION "The enumerated flags describing the table status of the dbspace." ::= {onDbspaceEntry 10} onDbspacePagesAllocated OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current 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 Integer32 MAX-ACCESS read-only STATUS current 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 MAX-ACCESS read-only STATUS current 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) } MAX-ACCESS read-only STATUS current 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 MAX-ACCESS read-only STATUS current 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} -- Chunk Table onChunkTable OBJECT-TYPE SYNTAX SEQUENCE OF OnChunkEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "The information about all the chunks that are assigned to an OnLine Server. " ::= { onlineObjects 7 } onChunkEntry OBJECT-TYPE SYNTAX OnChunkEntry MAX-ACCESS not-accessible STATUS current 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 Integer32, onChunkPagesUsed Integer32, onChunkType INTEGER, onChunkStatus INTEGER, onChunkMirroring INTEGER, onChunkReads Counter32, onChunkPageReads Counter32, onChunkWrites Counter32, onChunkPageWrites Counter32, onChunkMirrorFileName DisplayString, onChunkMirrorFileOffset INTEGER, onChunkMirrorStatus INTEGER } onChunkIndex OBJECT-TYPE SYNTAX INTEGER (1..2147483647) MAX-ACCESS not-accessible STATUS current DESCRIPTION "An index to uniquely identify the chunk within a dbspace for an OnLine server." ::= {onChunkEntry 1} onChunkFileName OBJECT-TYPE SYNTAX DisplayString MAX-ACCESS read-only STATUS current DESCRIPTION "The name of the device or file path name for this chunk." ::= {onChunkEntry 2} onChunkFileOffset OBJECT-TYPE SYNTAX INTEGER (0..2147483647) MAX-ACCESS read-only STATUS current DESCRIPTION "The starting offset position within a device or a file in pages for the chunk." ::= {onChunkEntry 3} onChunkPagesAllocated OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The size of the chunk in pages." ::= {onChunkEntry 4} onChunkPagesUsed OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of used pages in this chunk." ::= {onChunkEntry 5} onChunkType OBJECT-TYPE SYNTAX INTEGER { regularChunk(1), blobChunk(2), stageBlob(3) } MAX-ACCESS read-only STATUS current DESCRIPTION "The type and of the chunk." ::= {onChunkEntry 6} onChunkStatus OBJECT-TYPE SYNTAX INTEGER { offline(1), online(2), recovering(3), inconsistent(4), dropped(5) } MAX-ACCESS read-only STATUS current DESCRIPTION "The operating status of the chunk." ::= {onChunkEntry 7} onChunkMirroring OBJECT-TYPE SYNTAX INTEGER { notMirrored(1), mirrored(2), newlyMirrored(3) } MAX-ACCESS read-only STATUS current DESCRIPTION "The mirroring of the chunk." ::= {onChunkEntry 8} onChunkReads OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of read operations performed on this chunk." ::= {onChunkEntry 9} onChunkPageReads OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of pages read from this chunk." ::= {onChunkEntry 10} onChunkWrites OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of write operations performed on this chunk." ::= {onChunkEntry 11} onChunkPageWrites OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of pages written to this chunk." ::= {onChunkEntry 12} onChunkMirrorFileName OBJECT-TYPE SYNTAX DisplayString MAX-ACCESS read-only STATUS current DESCRIPTION "The name of the device or file path name for the mirror chunk." ::= {onChunkEntry 13} onChunkMirrorFileOffset OBJECT-TYPE SYNTAX INTEGER (0..2147483647) MAX-ACCESS read-only STATUS current 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) } MAX-ACCESS read-only STATUS current DESCRIPTION "The status of the mirror chunk." ::= {onChunkEntry 15} -- Logical Log Table onLogicalLogTable OBJECT-TYPE SYNTAX SEQUENCE OF OnLogicalLogEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "The information about all the logfile spaces that are assigned to an OnLine Server." ::= { onlineObjects 8 } onLogicalLogEntry OBJECT-TYPE SYNTAX OnLogicalLogEntry MAX-ACCESS not-accessible STATUS current 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 Integer32, onLogicalLogPagesUsed Integer32, onLogicalLogFillTime DateAndTime, onLogicalLogBackupDate DateAndTime } onLogicalLogIndex OBJECT-TYPE SYNTAX INTEGER (1..2147483647) MAX-ACCESS not-accessible STATUS current 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 (0..2147483647) MAX-ACCESS read-only STATUS current DESCRIPTION "The unique ID assigned to this logical logfile by the OnLine server." ::= {onLogicalLogEntry 2} onLogicalLogDbspace OBJECT-TYPE SYNTAX Identifier MAX-ACCESS read-only STATUS current 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) } MAX-ACCESS read-only STATUS current DESCRIPTION "The type and status of the logfile." ::= {onLogicalLogEntry 4} onLogicalLogContainsLastCheckpoint OBJECT-TYPE SYNTAX INTEGER { yes(1), no(2) } MAX-ACCESS read-only STATUS current DESCRIPTION "The value of yes if the logfile contains the most recent checkpoint." ::= {onLogicalLogEntry 5} onLogicalLogIsTemporary OBJECT-TYPE SYNTAX INTEGER { yes(1), no(2) } MAX-ACCESS read-only STATUS current DESCRIPTION "The temporary status of the logfile." ::= {onLogicalLogEntry 6} onLogicalLogPagesAllocated OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of pages assigned to the logfile." ::= {onLogicalLogEntry 7} onLogicalLogPagesUsed OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of pages used in the logfile." ::= {onLogicalLogEntry 8} onLogicalLogFillTime OBJECT-TYPE SYNTAX DateAndTime MAX-ACCESS read-only STATUS current DESCRIPTION "The date and time when the logfile last filled up." ::= {onLogicalLogEntry 9} onLogicalLogBackupDate OBJECT-TYPE SYNTAX DateAndTime MAX-ACCESS read-only STATUS current 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} -- Physical Log Table onPhysicalLogTable OBJECT-TYPE SYNTAX SEQUENCE OF OnPhysicalLogEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "The information about the physical logfile space that is assigned to an OnLine Server." ::= { onlineObjects 9 } onPhysicalLogEntry OBJECT-TYPE SYNTAX OnPhysicalLogEntry MAX-ACCESS not-accessible STATUS current 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 Counter32, onPhysicalLogWrites Counter32, onPhysicalLogPagesAllocated INTEGER, onPhysicalLogPagesUsed INTEGER } onPhysicalLogDbspace OBJECT-TYPE SYNTAX Identifier MAX-ACCESS read-only STATUS current DESCRIPTION "The name of the dbspace where this physical logfile resides." ::= {onPhysicalLogEntry 1} onPhysicalLogBufferSize OBJECT-TYPE SYNTAX INTEGER (1..2147483647) MAX-ACCESS read-only STATUS current DESCRIPTION "The size of the buffer in pages for the physical logging." ::= {onPhysicalLogEntry 2} onPhysicalLogBufferUsed OBJECT-TYPE SYNTAX INTEGER (0..2147483647) MAX-ACCESS read-only STATUS current DESCRIPTION "The number of pages in the physical log buffer that are used." ::= {onPhysicalLogEntry 3} onPhysicalLogPageWrites OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of pages written to the physical log." ::= {onPhysicalLogEntry 4} onPhysicalLogWrites OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of write operations to the disk for the physical log." ::= {onPhysicalLogEntry 5} onPhysicalLogPagesAllocated OBJECT-TYPE SYNTAX INTEGER (0..2147483647) MAX-ACCESS read-only STATUS current DESCRIPTION "The number of disk pages assigned to the physical logfile." ::= {onPhysicalLogEntry 6} onPhysicalLogPagesUsed OBJECT-TYPE SYNTAX INTEGER (0..2147483647) MAX-ACCESS read-only STATUS current DESCRIPTION "The number of pages used in the physical logfile." ::= {onPhysicalLogEntry 7} -- Session Table onSessionTable OBJECT-TYPE SYNTAX SEQUENCE OF OnSessionEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "Status and profile information maintained on a per-session basis." ::= { onlineObjects 10 } onSessionEntry OBJECT-TYPE SYNTAX OnSessionEntry MAX-ACCESS not-accessible STATUS current 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 Integer32, onSessionThreads Gauge32, onSessionLockRequests Counter32, onSessionLocksHeld Counter32, onSessionLockWaits Counter32, onSessionLockTimeouts Counter32, onSessionLogRecords Counter32, onSessionIsamReads Counter32, onSessionIsamWrites Counter32, onSessionPageReads Counter32, onSessionPageWrites Counter32, onSessionLongTxs Counter32, onSessionLogSpace Counter32, onSessionHighwaterLogSpace Gauge32, onSessionSqlStatement DisplayString, onSessionSqlIsolation INTEGER, onSessionSqlLockWaitMode INTEGER, onSessionSqlEstimatedCost Integer32, onSessionSqlEstimatedRows Integer32, onSessionSqlError Integer32, onSessionSqlIsamError Integer32, onSessionTransactionStatus INTEGER, onSessionTransactionBeginLog Integer32, onSessionTransactionLastLog Integer32, onSessionOriginatingCoserverId Integer32, onSessionOriginatingSessionId Integer32 } onSessionIndex OBJECT-TYPE SYNTAX INTEGER (1..2147483647) MAX-ACCESS not-accessible STATUS current DESCRIPTION "An index to uniquely identify an OnLine session." ::= {onSessionEntry 1} onSessionUserName OBJECT-TYPE SYNTAX DisplayString MAX-ACCESS read-only STATUS current DESCRIPTION "An identifier for the user who started the session, in the form name@host(tty)." ::= {onSessionEntry 2} onSessionUserProgramVersion OBJECT-TYPE SYNTAX Identifier MAX-ACCESS read-only STATUS current DESCRIPTION "The version number of the front-end program of the session." ::= {onSessionEntry 3} onSessionUserProcessId OBJECT-TYPE SYNTAX INTEGER (0..2147483647) MAX-ACCESS read-only STATUS current DESCRIPTION "The unix process ID of the front-end program for the session." ::= {onSessionEntry 4} onSessionUserTime OBJECT-TYPE SYNTAX TimeTicks MAX-ACCESS read-only STATUS current 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) } MAX-ACCESS read-only STATUS current 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 MAX-ACCESS read-only STATUS current DESCRIPTION "The current connected database." ::= {onSessionEntry 7} onSessionCurrentMemory OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The current memory used by the session in bytes." ::= {onSessionEntry 8} onSessionThreads OBJECT-TYPE SYNTAX Gauge32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of active threads for this session." ::= {onSessionEntry 9} onSessionLockRequests OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of locks requested by the session so far." ::= {onSessionEntry 10} onSessionLocksHeld OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of locks held by the session currently." ::= {onSessionEntry 11} onSessionLockWaits OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of times the session has to wait for a lock so far." ::= {onSessionEntry 12} onSessionLockTimeouts OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current 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 Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of logical log records generated by the session so far." ::= {onSessionEntry 14} onSessionIsamReads OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current 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 Counter32 MAX-ACCESS read-only STATUS current 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 Counter32 MAX-ACCESS read-only STATUS current 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 Counter32 MAX-ACCESS read-only STATUS current 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 Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of long transactions generated by the session so far." ::= {onSessionEntry 19} onSessionLogSpace OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The size of the logical log space used by the session so far, in bytes." ::= {onSessionEntry 20} onSessionHighwaterLogSpace OBJECT-TYPE SYNTAX Gauge32 MAX-ACCESS read-only STATUS current 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 (SIZE (0..2048)) MAX-ACCESS read-only STATUS current 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) } MAX-ACCESS read-only STATUS current 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 (-1..2147483647) MAX-ACCESS read-only STATUS current 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 Integer32 MAX-ACCESS read-only STATUS current 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 Integer32 MAX-ACCESS read-only STATUS current 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 Integer32 MAX-ACCESS read-only STATUS current 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 Integer32 MAX-ACCESS read-only STATUS current 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) } MAX-ACCESS read-only STATUS current DESCRIPTION "The status of the transaction for this session." ::= {onSessionEntry 29} onSessionTransactionBeginLog OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current 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 Integer32 MAX-ACCESS read-only STATUS current 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 Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "An identifier for originating-coserver on whose behalf this local-session runs." ::= {onSessionEntry 32} onSessionOriginatingSessionId OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The local-session-id of the global-session on the originating coserver, for which this session runs." ::= {onSessionEntry 33} -- Lock Table onLockTable OBJECT-TYPE SYNTAX SEQUENCE OF OnLockEntry MAX-ACCESS not-accessible STATUS current 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 MAX-ACCESS not-accessible STATUS current 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 Integer32, onLockWaiters Gauge32, onLockGrantTime TimeTicks } onLockIndex OBJECT-TYPE SYNTAX INTEGER (1..2147483647) MAX-ACCESS not-accessible STATUS current DESCRIPTION "An index to uniquely identify a single server-internal lock." ::= {onLockEntry 1} onLockDatabaseName OBJECT-TYPE SYNTAX Identifier MAX-ACCESS read-only STATUS current DESCRIPTION "The name of the database on which a lock is held." ::= {onLockEntry 2} onLockTableName OBJECT-TYPE SYNTAX Identifier MAX-ACCESS read-only STATUS current 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) } MAX-ACCESS read-only STATUS current 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) } MAX-ACCESS read-only STATUS current DESCRIPTION "The granularity level of the lock." ::= {onLockEntry 5} onLockRowId OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The ID of the row of the table the lock is on." ::= {onLockEntry 6} onLockWaiters OBJECT-TYPE SYNTAX Gauge32 MAX-ACCESS read-only STATUS current DESCRIPTION "The current number of sessions waiting for this lock." ::= {onLockEntry 7} onLockGrantTime OBJECT-TYPE SYNTAX TimeTicks MAX-ACCESS read-only STATUS current 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} -- onbar Backup/Restore Table onBarTable OBJECT-TYPE SYNTAX SEQUENCE OF OnBarEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "Information about backup activity in OnLine Server." ::= { onlineObjects 12 } onBarEntry OBJECT-TYPE SYNTAX OnBarEntry MAX-ACCESS not-accessible STATUS current 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 Integer32, onBarTimeStamp DateAndTime } onBarActivityIndex OBJECT-TYPE SYNTAX INTEGER (1..2147483647) MAX-ACCESS not-accessible STATUS current DESCRIPTION "An index to uniquely identify an action within Bar activity." ::= {onBarEntry 1} onBarObjectIndex OBJECT-TYPE SYNTAX INTEGER (1..2147483647) MAX-ACCESS not-accessible STATUS current DESCRIPTION "An index to uniquely identify an object within an action." ::= {onBarEntry 2} onBarObjectName OBJECT-TYPE SYNTAX Identifier MAX-ACCESS read-only STATUS current DESCRIPTION "The name of the object." ::= {onBarEntry 3} onBarObjectType OBJECT-TYPE SYNTAX INTEGER { blobSpace(1), rootDbspace(2), criticalDbspace(3), nonCriticalDbspace(4), logicalLog(5) } MAX-ACCESS read-only STATUS current 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) } MAX-ACCESS read-only STATUS current DESCRIPTION "The level of the backup action." ::= {onBarEntry 5} onBarActionStatus OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The status of the action. A non-zero value is the error status returned by onbar." ::= {onBarEntry 6} onBarTimeStamp OBJECT-TYPE SYNTAX DateAndTime MAX-ACCESS read-only STATUS current DESCRIPTION "The date and time when this action ended." ::= {onBarEntry 7} -- onactivebar Active Backup/Restore Table onActiveBarTable OBJECT-TYPE SYNTAX SEQUENCE OF OnActiveBarEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "Information about active backup or restore low-level (RSAM) activity in OnLine Server." ::= { onlineObjects 15 } onActiveBarEntry OBJECT-TYPE SYNTAX OnActiveBarEntry MAX-ACCESS not-accessible STATUS current 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 Integer32, onActiveBarActivityScanned Integer32, onActiveBarActivityCompleted Integer32, onActiveBarActivityStatus Integer32 } onActiveBarIndex OBJECT-TYPE SYNTAX INTEGER (1..2147483647) MAX-ACCESS not-accessible STATUS current 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)} MAX-ACCESS read-only STATUS current DESCRIPTION "The type of the onbar activity." ::= {onActiveBarEntry 2} onActiveBarObjectId OBJECT-TYPE SYNTAX INTEGER (0..2147483647) MAX-ACCESS read-only STATUS current 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) } MAX-ACCESS read-only STATUS current DESCRIPTION "The level of the onbar activity." ::= {onActiveBarEntry 4} onActiveBarElapsedTime OBJECT-TYPE SYNTAX TimeTicks MAX-ACCESS read-only STATUS current DESCRIPTION "The elapsed time since this activity has started, in centi-seconds." ::= {onActiveBarEntry 5} onActiveBarActivitySize OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current 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 Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of pages scanned so far among the used pages of the activity object." ::= {onActiveBarEntry 7} onActiveBarActivityCompleted OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current 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 Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The status of the action. A non-zero value is the error status returned by onbar." ::= {onActiveBarEntry 9} -- SQLHOST Table onSqlHostTable OBJECT-TYPE SYNTAX SEQUENCE OF OnSqlHostEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "The connectivity configuration specified in a SQLHOST file for the server." ::= { onlineObjects 13 } onSqlHostEntry OBJECT-TYPE SYNTAX OnSqlHostEntry MAX-ACCESS not-accessible STATUS current 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 Integer32, onSqlHostOptions DisplayString } onSqlHostIndex OBJECT-TYPE SYNTAX INTEGER (1..2147483647) MAX-ACCESS not-accessible STATUS current DESCRIPTION "An index to uniquely identify a line within a SQLHOST file." ::= {onSqlHostEntry 1} onSqlHostName OBJECT-TYPE SYNTAX DisplayString MAX-ACCESS read-only STATUS current DESCRIPTION "The name of a host." ::= {onSqlHostEntry 2} onSqlHostNetType OBJECT-TYPE SYNTAX DisplayString MAX-ACCESS read-only STATUS current DESCRIPTION "The connection type (e.g. ontlitcp) for a host." ::= {onSqlHostEntry 3} onSqlHostServerName OBJECT-TYPE SYNTAX DisplayString MAX-ACCESS read-only STATUS current DESCRIPTION "The name of the database server, or its alias." ::= {onSqlHostEntry 4} onSqlHostServiceName OBJECT-TYPE SYNTAX DisplayString MAX-ACCESS read-only STATUS current DESCRIPTION "The service name of the connection to the server." ::= {onSqlHostEntry 5} onSqlHostServicePort OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current 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 MAX-ACCESS read-only STATUS current DESCRIPTION "The set of key-value (key=value) pairs listing the various options for the server." ::= {onSqlHostEntry 7} -- SNMP subagent state Table (for internal use only) onSnmpTable OBJECT-TYPE SYNTAX SEQUENCE OF OnSnmpEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "Profile information kept about various SNMP objects that are defined for the OnLine Server." ::= { onlineObjects 14 } onSnmpEntry OBJECT-TYPE SYNTAX OnSnmpEntry MAX-ACCESS not-accessible STATUS current 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 Counter32, onSnmpHoldInterval TimeTicks, onSnmpRows Integer32, onSnmpColumns Integer32, onSnmpRetries Counter32, onSnmpFailures Counter32 } onSnmpIndex OBJECT-TYPE SYNTAX INTEGER (1..2147483647) MAX-ACCESS not-accessible STATUS current DESCRIPTION "An index to uniquely identify a SNMP Table for OnLine." ::= {onSnmpEntry 1} onSnmpName OBJECT-TYPE SYNTAX DisplayString MAX-ACCESS read-only STATUS current DESCRIPTION "The name of the Snmp table." ::= {onSnmpEntry 2} onSnmpOID OBJECT-TYPE SYNTAX OBJECT IDENTIFIER MAX-ACCESS read-only STATUS current DESCRIPTION "The object ID for the Snmp table in dot notation." ::= {onSnmpEntry 3} onSnmpRefreshType OBJECT-TYPE SYNTAX INTEGER { oneShot(1), onDemand(2), onTimer(3) } MAX-ACCESS read-only STATUS current DESCRIPTION "The refresh strategy for this table." ::= {onSnmpEntry 4} onSnmpRefreshInterval OBJECT-TYPE SYNTAX TimeTicks MAX-ACCESS read-only STATUS current 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 MAX-ACCESS read-only STATUS current DESCRIPTION "The time interval in centiseconds after which the table is refreshed." ::= {onSnmpEntry 6} onSnmpRefreshes OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of times the table is refreshed so far." ::= {onSnmpEntry 7} onSnmpHoldInterval OBJECT-TYPE SYNTAX TimeTicks MAX-ACCESS read-only STATUS current 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 Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The current number of rows in this table." ::= {onSnmpEntry 9} onSnmpColumns OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The current number of columns in this table." ::= {onSnmpEntry 10} onSnmpRetries OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current 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 Counter32 MAX-ACCESS read-only STATUS current 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} -- XPS specific table reported by each coserver onXpsTable OBJECT-TYPE SYNTAX SEQUENCE OF OnXpsEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "Information about XPS Server." ::= { onlineObjects 16 } onXpsEntry OBJECT-TYPE SYNTAX OnXpsEntry MAX-ACCESS not-accessible STATUS current 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 (1..2147483647) MAX-ACCESS read-only STATUS current DESCRIPTION "An index to uniquely identify an XPS server by the xpssnmp subagent." ::= {onXpsEntry 1} onXpsSnmpHost OBJECT-TYPE SYNTAX DisplayString MAX-ACCESS read-only STATUS current DESCRIPTION "The name of the host where the XPS subagent is running." ::= {onXpsEntry 2} -- Enterprise Replication tables onErSiteTable OBJECT-TYPE SYNTAX SEQUENCE OF OnErSiteEntry MAX-ACCESS not-accessible STATUS current 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 MAX-ACCESS not-accessible STATUS current 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 Counter32, onErSiteOutBytes Counter32, onErSiteInMsgs Counter32, onErSiteInBytes Counter32, onErSiteTransactions Counter32, onErSiteCommits Counter32, onErSiteAborts Counter32, onErSiteLastReceived DateAndTime, onErSiteRowCommits Counter32, onErSiteRowAborts Counter32, onErSiteRcvLatency TimeTicks, onErSiteCommitLatency TimeTicks, onErSiteClockErrors Counter32 } onErSiteIndex OBJECT-TYPE SYNTAX INTEGER (1..65536) MAX-ACCESS not-accessible STATUS current DESCRIPTION "The identifier that uniquely identifies a server as defined in the group entry in SQLHOSTS." ::= { onErSiteEntry 1 } onErSiteName OBJECT-TYPE SYNTAX DisplayString MAX-ACCESS read-only STATUS current 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) } MAX-ACCESS read-only STATUS current 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) } MAX-ACCESS read-only STATUS current DESCRIPTION "The state of the connection to this site." ::= { onErSiteEntry 4 } onErSiteConnectionChange OBJECT-TYPE SYNTAX DateAndTime MAX-ACCESS read-only STATUS current DESCRIPTION "The date and time when the connection state last changed." ::= {onErSiteEntry 5 } onErSiteIdleTimeout OBJECT-TYPE SYNTAX TimeTicks MAX-ACCESS read-only STATUS current 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 Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of messages transmitted from current server to this site." ::= { onErSiteEntry 7 } onErSiteOutBytes OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of bytes transmitted from current server to this site." ::= { onErSiteEntry 8 } onErSiteInMsgs OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of messages received by current server from this site." ::= { onErSiteEntry 9 } onErSiteInBytes OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of bytes received by current server from this site." ::= { onErSiteEntry 10 } onErSiteTransactions OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of transactions received from this site." ::= { onErSiteEntry 11 } onErSiteCommits OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of transactions received and committed from this site." ::= { onErSiteEntry 12 } onErSiteAborts OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of transactions aborted from this site." ::= { onErSiteEntry 13 } onErSiteLastReceived OBJECT-TYPE SYNTAX DateAndTime MAX-ACCESS read-only STATUS current DESCRIPTION "The date and time when last transaction was processed from this site." ::= { onErSiteEntry 14 } onErSiteRowCommits OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of rows committed from this site." ::= { onErSiteEntry 15 } onErSiteRowAborts OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "Total number of rows aborted from this site." ::= { onErSiteEntry 16 } onErSiteRcvLatency OBJECT-TYPE SYNTAX TimeTicks MAX-ACCESS read-only STATUS current 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 MAX-ACCESS read-only STATUS current 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 Counter32 MAX-ACCESS read-only STATUS current 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 MAX-ACCESS not-accessible STATUS current DESCRIPTION "Information about replication queues. Table contains entries for all servers participating in replication." ::= { onlineObjects 18} onErQueueEntry OBJECT-TYPE SYNTAX OnErQueueEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "An entry describing a replication queue." INDEX { applIndex, onErQueueReplIndex, onErQueueSiteIndex } ::= { onErQueueTable 1 } OnErQueueEntry ::= SEQUENCE { onErQueueReplIndex INTEGER, onErQueueSiteIndex INTEGER, onErQueueReplName DisplayString, onErQueueSiteName DisplayString, onErQueueSize Gauge32, onErQueueLastCommit DataAndTime, onErQueueLastAck DataAndTime } onErQueueReplIndex OBJECT-TYPE SYNTAX INTEGER (1..65536) MAX-ACCESS not-accessible STATUS current DESCRIPTION "The identifier that uniquely identifies a replicant." ::= { onErQueueEntry 1 } onErQueueSiteIndex OBJECT-TYPE SYNTAX INTEGER (1..65536) MAX-ACCESS not-accessible STATUS current DESCRIPTION "The identifier that uniquely identifies a server." ::= { onErQueueEntry 2 } onErQueueReplName OBJECT-TYPE SYNTAX DisplayString MAX-ACCESS read-only STATUS current DESCRIPTION "The name used to describe the replicant or collection of replicants." ::= { onErQueueEntry 3 } onErQueueSiteName OBJECT-TYPE SYNTAX DisplayString MAX-ACCESS read-only STATUS current DESCRIPTION "The name of the Entrprise Replication server." ::= { onErQueueEntry 4 } onErQueueSize OBJECT-TYPE SYNTAX Gauge32 MAX-ACCESS read-only STATUS current DESCRIPTION "Current number of bytes in the send queue." ::= { onErQueueEntry 5 } onErQueueLastCommit OBJECT-TYPE SYNTAX DateAndTime MAX-ACCESS read-only STATUS current DESCRIPTION "The date and time when last transaction was committed." ::= { onErQueueEntry 6 } onErQueueLastAck OBJECT-TYPE SYNTAX DateAndTime MAX-ACCESS read-only STATUS current DESCRIPTION "The date and time when last data was acked." ::= { onErQueueEntry 7 } -- End of OnLine MIB -- -------------- -- XPS MIB tables -- -------------- xpsObjects OBJECT IDENTIFIER ::= { xpsMIB 1 } -- Xps Coserver Table xpsCoserverTable OBJECT-TYPE SYNTAX SEQUENCE OF XpsCoserverEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "Information/listing of all coservers which comprise the XPS server." ::= { xpsObjects 1 } xpsCoserverEntry OBJECT-TYPE SYNTAX XpsCoserverEntry MAX-ACCESS not-accessible STATUS current 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 Integer32, xpsCoserverRootDbspaceId Integer32 } xpsCoserverIndex OBJECT-TYPE SYNTAX INTEGER (1..2147483647) MAX-ACCESS not-accessible STATUS current DESCRIPTION "An index to uniquely identify the coserver/member for an XPS server." ::= {xpsCoserverEntry 1} xpsCoserverHostname OBJECT-TYPE SYNTAX DisplayString MAX-ACCESS read-only STATUS current DESCRIPTION "The name of the host on which the coserver runs." ::= {xpsCoserverEntry 2} xpsCoserverId OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The coserver-id of this XPS member." ::= {xpsCoserverEntry 3} xpsCoserverRootDbspaceId OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The Id of root-dbspace for this coserver." ::= {xpsCoserverEntry 4} -- Xps Cogroup Table xpsCogroupTable OBJECT-TYPE SYNTAX SEQUENCE OF XpsCogroupEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "Information/listing of all coserver-groups (cogroups) in the XPS server." ::= { xpsObjects 2 } xpsCogroupEntry OBJECT-TYPE SYNTAX XpsCogroupEntry MAX-ACCESS not-accessible STATUS current 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 Integer32, xpsCogroupIsClustered INTEGER } xpsCogroupIndex OBJECT-TYPE SYNTAX INTEGER (1..2147483647) MAX-ACCESS not-accessible STATUS current DESCRIPTION "An index to uniquely identify the cogroup in a XPS server." ::= {xpsCogroupEntry 1} xpsCogroupName OBJECT-TYPE SYNTAX DisplayString MAX-ACCESS read-only STATUS current DESCRIPTION "The name of the cogroup within the XPS server." ::= {xpsCogroupEntry 2} xpsCogroupMemberCount OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of coservers in the cogroup of the XPS server." ::= {xpsCogroupEntry 3} xpsCogroupIsClustered OBJECT-TYPE SYNTAX INTEGER { yes(1), no(2) } MAX-ACCESS read-only STATUS current DESCRIPTION "Whether the cogroup is clustered (yes) or not (no)." ::= {xpsCogroupEntry 4} -- Xps Cogroup Member Table xpsCogroupMemberTable OBJECT-TYPE SYNTAX SEQUENCE OF XpsCogroupMemberEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "Information about all coservers within a XPS cogroup." ::= { xpsObjects 3 } xpsCogroupMemberEntry OBJECT-TYPE SYNTAX XpsCogroupMemberEntry MAX-ACCESS not-accessible STATUS current 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 Integer32 } xpsCogroupMemberIndex OBJECT-TYPE SYNTAX INTEGER (1..2147483647) MAX-ACCESS not-accessible STATUS current DESCRIPTION "An index to uniquely identify the cogroup member in a XPS cogroup." ::= {xpsCogroupMemberEntry 1} xpsCogroupMemberCoserverId OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The coserver-id of this XPS cogroup member." ::= {xpsCogroupMemberEntry 2} -- Xps Dbslice Table xpsDbsliceTable OBJECT-TYPE SYNTAX SEQUENCE OF XpsDbsliceEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "Information about all Dbslices in a XPS server." ::= { xpsObjects 4 } xpsDbsliceEntry OBJECT-TYPE SYNTAX XpsDbsliceEntry MAX-ACCESS not-accessible STATUS current 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 Integer32, xpsDbsliceIsMirrored INTEGER, xpsDbsliceIsBlobSlice INTEGER, xpsDbsliceIsTemp INTEGER } xpsDbsliceIndex OBJECT-TYPE SYNTAX INTEGER (1..2147483647) MAX-ACCESS not-accessible STATUS current DESCRIPTION "An index to uniquely identify a Dbslice in a XPS server." ::= {xpsDbsliceEntry 1} xpsDbsliceName OBJECT-TYPE SYNTAX DisplayString MAX-ACCESS read-only STATUS current DESCRIPTION "The name of the Dbslice in the XPS server." ::= {xpsDbsliceEntry 2} xpsDbsliceDbspaceCount OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of Dbspaces in this Dbslice of the XPS server." ::= {xpsDbsliceEntry 3} xpsDbsliceIsMirrored OBJECT-TYPE SYNTAX INTEGER { yes(1), no(2) } MAX-ACCESS read-only STATUS current DESCRIPTION "Whether the Dbslice is mirrored (yes) or not (no)." ::= {xpsDbsliceEntry 4} xpsDbsliceIsBlobSlice OBJECT-TYPE SYNTAX INTEGER { yes(1), no(2) } MAX-ACCESS read-only STATUS current DESCRIPTION "Whether the Dbslice is a blob-slice (yes) or not (no)." ::= {xpsDbsliceEntry 5} xpsDbsliceIsTemp OBJECT-TYPE SYNTAX INTEGER { yes(1), no(2) } MAX-ACCESS read-only STATUS current DESCRIPTION "Whether the Dbslice is temporary (yes) or not (no)." ::= {xpsDbsliceEntry 6} -- Xps DbsliceDbspace Table xpsDbsliceDbspaceTable OBJECT-TYPE SYNTAX SEQUENCE OF XpsDbsliceDbspaceEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "Information about all Dbspaces within a Dbslice of a XPS server." ::= { xpsObjects 5 } xpsDbsliceDbspaceEntry OBJECT-TYPE SYNTAX XpsDbsliceDbspaceEntry MAX-ACCESS not-accessible STATUS current 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 Integer32 } xpsDbsliceDbspaceIndex OBJECT-TYPE SYNTAX INTEGER (1..2147483647) MAX-ACCESS not-accessible STATUS current DESCRIPTION "An index to uniquely identify a Dbspace in a Dbslice of a XPS server." ::= {xpsDbsliceDbspaceEntry 1} xpsDbsliceDbspaceHomeCoserverId OBJECT-TYPE SYNTAX Integer32 MAX-ACCESS read-only STATUS current DESCRIPTION "The coserver-id of the home coserver of this dbspace." ::= {xpsDbsliceDbspaceEntry 2} END