analytics/informix/etc/onmibV1.mib

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