analytics/informix/etc/onmibV2.mib

   Informix-MIB DEFINITIONS ::= BEGIN

   IMPORTS
       MODULE-IDENTITY, OBJECT-TYPE, enterprises, 
       Counter32, Gauge32, Integer32, TimeTicks
         FROM SNMPv2-SMI
       TEXTUAL-CONVENTION, DisplayString, DateAndTime, TimeStamp
         FROM SNMPv2-TC
       applGroup, applIndex
         FROM APPLICATION-MIB
       rdbmsDbIndex
         FROM RDBMS-MIB;

   informix MODULE-IDENTITY
	LAST-UPDATED "9904060000Z"
	ORGANIZATION "IBM Corporation"
	CONTACT-INFO
		"IBM Corporation
		 133 Westchester Avenue
		 White Plains, New York 10604
		 1-800-772-2227
		 http://www.ibm.com"
	DESCRIPTION
		"The MIB module describing objects for
		 IBM/Informix products."

       ::= { enterprises 893 }

   Identifier ::= TEXTUAL-CONVENTION
	DISPLAY-HINT "28a"
	STATUS current
	DESCRIPTION
		"Represents a string used to name a database, table,
		 or other labeled object; limited to the NVT ASCII
		 repertoire specified in RFC 854."
	SYNTAX OCTET STRING (SIZE (1..28))

   Kilobytes ::= TEXTUAL-CONVENTION
	DISPLAY-HINT "d"
	STATUS current
	DESCRIPTION
		"Represents a size, in multiples of 1024."
	SYNTAX INTEGER (0..2147483647)

   servers    OBJECT IDENTIFIER ::= { informix 1 }

   onlineMIB  OBJECT IDENTIFIER ::= { servers  1 }

-- cdrMIB     OBJECT IDENTIFIER ::= { servers  2 }
-- was used for the ODS 7.2 CDR SNMP subagent which
-- has been obsoleted in 7.3 and later

   xpsMIB     OBJECT IDENTIFIER ::= { servers  3 }


-- -----------------
-- Online MIB tables
-- -----------------
   onlineObjects OBJECT IDENTIFIER ::= { onlineMIB 1 }

-- Server Table

   onServerTable OBJECT-TYPE
       SYNTAX SEQUENCE OF OnServerEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "Status and profile information maintained on a per-server basis."
       ::= { onlineObjects 1 }
 
   onServerEntry OBJECT-TYPE
       SYNTAX OnServerEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "An entry associated with a single instance of an active server."
       INDEX {applIndex}
       ::= { onServerTable 1 }

   OnServerEntry ::= SEQUENCE {
       onServerMode
       INTEGER,
       onServerCheckpointInProgress
       INTEGER,
       onServerPageSize
       INTEGER,
       onServerThreads
       Gauge32,
       onServerVPs
       Gauge32,
       onServerVirtualMemory
       Kilobytes,
       onServerResidentMemory
       Kilobytes,
       onServerMessageMemory
       Kilobytes,
       onServerIsamCalls
       Counter32,
       onServerLatchWaits
       Counter32,
       onServerLockRequests
       Counter32,
       onServerLockWaits
       Counter32,
       onServerBufferWaits
       Counter32,
       onServerCheckpoints
       Counter32,
       onServerCheckpointWaits
       Counter32,
       onServerDeadLocks
       Counter32,
       onServerLockTimeouts
       Counter32,
       onServerLogicalLogRecords
       Counter32,
       onServerLogicalLogPageWrites
       Counter32,
       onServerLogicalLogWrites
       Counter32,
       onServerBufferFlushes
       Counter32,
       onServerForegroundWrites
       Counter32,
       onServerLRUWrites
       Counter32,
       onServerChunkWrites
       Counter32,
       onServerReadAheadPages
       Counter32,
       onServerReadAheadPagesUsed
       Counter32,
       onServerSequentialScans
       Counter32,
       onServerMemorySorts
       Counter32,
       onServerDiskSorts
       Counter32,
       onServerMaxSortSpace
       Integer32,
       onServerNetworkReads
       Counter32,
       onServerNetworkWrites
       Counter32,
       onServerPDQCalls
       Gauge32,
       onServerTransactionCommits
       Counter32,
       onServerTransactionRollBacks
       Counter32,
       onServerTimeSinceLastCheckpoint
       TimeTicks,
       onServerCPUSystemTime
       TimeTicks,
       onServerCPUUserTime
       TimeTicks
       }

   onServerMode OBJECT-TYPE
       SYNTAX INTEGER { initializing(1), quiescent(2), fastRecovery(3), 
                        backingUp(4), shuttingDown(5), online(6), 
                        aborting(7), onlineReadOnly(8), microKernel(9) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The current operating mode of the server."
       ::= {onServerEntry 1}

   onServerCheckpointInProgress OBJECT-TYPE
       SYNTAX INTEGER { yes(1), no(2) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The value of yes if a checkpoint is underway."
       ::= {onServerEntry 2}

   onServerPageSize OBJECT-TYPE
       SYNTAX INTEGER (1..2147483647)
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The size of a page for this server, in bytes."
       ::= {onServerEntry 3}

   onServerThreads OBJECT-TYPE
       SYNTAX Gauge32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The current number of threads."
       ::= {onServerEntry 4}

   onServerVPs OBJECT-TYPE
       SYNTAX Gauge32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The current number of virtual processors."
       ::= {onServerEntry 5}

   onServerVirtualMemory OBJECT-TYPE
       SYNTAX Kilobytes
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The current size of the virtual memory, in kilobytes."
       ::= {onServerEntry 6}

   onServerResidentMemory OBJECT-TYPE
       SYNTAX Kilobytes
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The current size of the resident memory, in kilobytes."
       ::= {onServerEntry 7}

   onServerMessageMemory OBJECT-TYPE
       SYNTAX Kilobytes
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The current size of the message buffer memory, in kilobytes."
       ::= {onServerEntry 8}

   onServerIsamCalls OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The total number of ISAM-level operations (reads, writes,
	  rewrites, deletes, commits, and rollbacks) executed so far."
       ::= {onServerEntry 9}

   onServerLatchWaits OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The total number of times any thread waited for a latch."
       ::= {onServerEntry 10}

   onServerLockRequests OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of lock requests handled so far."
       ::= {onServerEntry 11}

   onServerLockWaits OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of times any transaction waited for a lock."
       ::= {onServerEntry 12}

   onServerBufferWaits OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of buffer waits."
       ::= {onServerEntry 13}

   onServerCheckpoints OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of checkpoints taken so far."
       ::= {onServerEntry 14}

   onServerCheckpointWaits OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of checkpoint waits."
       ::= {onServerEntry 15}

   onServerDeadLocks OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of deadlocks detected so far."
       ::= {onServerEntry 16}

   onServerLockTimeouts OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of timeouts for locks so far."
       ::= {onServerEntry 17}

   onServerLogicalLogRecords OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of records written to the logical log so far."
       ::= {onServerEntry 18}

   onServerLogicalLogPageWrites OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of pages written to the logical log so far."
       ::= {onServerEntry 19}

   onServerLogicalLogWrites OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of logical log writes so far."
       ::= {onServerEntry 20}

   onServerBufferFlushes OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of times the buffers are flushed to disk so far."
       ::= {onServerEntry 21}

   onServerForegroundWrites OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of foreground writes."
       ::= {onServerEntry 22}

   onServerLRUWrites OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of LRU writes."
       ::= {onServerEntry 23}

   onServerChunkWrites OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of chunk writes."
       ::= {onServerEntry 24}

   onServerReadAheadPages OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of read-aheads for index and data pages."
       ::= {onServerEntry 25}

   onServerReadAheadPagesUsed OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of read-ahead pages used."
       ::= {onServerEntry 26}

   onServerSequentialScans OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of times a sequential scan is performed."
       ::= {onServerEntry 27}

   onServerMemorySorts OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The total number of sorts that are done in memory."
       ::= {onServerEntry 28}

   onServerDiskSorts OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of sorts that required disk space."
       ::= {onServerEntry 29}

   onServerMaxSortSpace OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The maximum disk space used by a sort, in pages."
       ::= {onServerEntry 30}

   onServerNetworkReads OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of network reads so far."
       ::= {onServerEntry 31}

   onServerNetworkWrites OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of network writes so far."
       ::= {onServerEntry 32}

   onServerPDQCalls OBJECT-TYPE
       SYNTAX Gauge32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "An instantaneous measure of current parallel query activity,
	  to be used as a general measure of decision support activity."
       ::= {onServerEntry 33}

   onServerTransactionCommits OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "Number of transactions committed by the server."
       ::= {onServerEntry 34}

   onServerTransactionRollBacks OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "Number of transactions rollbacked by the server."
       ::= {onServerEntry 35}

   onServerTimeSinceLastCheckpoint OBJECT-TYPE
       SYNTAX TimeTicks
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "Time (in centi-secs) since the last checkpoint occured."
       ::= {onServerEntry 36}

   onServerCPUSystemTime OBJECT-TYPE
       SYNTAX TimeTicks
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "CPU SystemTime usage (in centi-secs)."
       ::= {onServerEntry 37}

   onServerCPUUserTime OBJECT-TYPE
       SYNTAX TimeTicks
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "CPU UserTime usage (in centi-secs)."
       ::= {onServerEntry 38}

-- Database Table

   onDatabaseTable OBJECT-TYPE
       SYNTAX SEQUENCE OF OnDatabaseEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "The additional information of a database maintained
            by the OnLine Server."
       ::= { onlineObjects 2 }
 
   onDatabaseEntry OBJECT-TYPE
       SYNTAX OnDatabaseEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "An entry associated with a single database."
       INDEX {applIndex, rdbmsDbIndex}
       ::= { onDatabaseTable 1 }
 
   OnDatabaseEntry ::= SEQUENCE {
       onDatabaseDbspace
           Identifier,
       onDatabaseCreated
           DateAndTime,
       onDatabaseLogging
           INTEGER,
       onDatabaseOpenStatus
           INTEGER,
       onDatabaseUsers
           Gauge32
   }
 
   onDatabaseDbspace OBJECT-TYPE
       SYNTAX Identifier
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The name of the default dbspace for this database."
       ::= {onDatabaseEntry 1}

   onDatabaseCreated OBJECT-TYPE
       SYNTAX DateAndTime
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The date and time when this database was created."
       ::= {onDatabaseEntry 2}

   onDatabaseLogging OBJECT-TYPE
       SYNTAX INTEGER { none(1), buffered(2), unbuffered(3), ansi(4) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The logging status for this database."
       ::= {onDatabaseEntry 3}

   onDatabaseOpenStatus OBJECT-TYPE
       SYNTAX INTEGER { notOpen(1), open(2), openExclusive(3) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The open status for this database."
       ::= {onDatabaseEntry 4}

   onDatabaseUsers OBJECT-TYPE
       SYNTAX Gauge32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of users for this database."
       ::= {onDatabaseEntry 5}

-- Table Table

   onTableTable OBJECT-TYPE
       SYNTAX SEQUENCE OF OnTableEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "The information about the tables that are maintained
            by the OnLine Server."
       ::= { onlineObjects 3 }
 
   onTableEntry OBJECT-TYPE
       SYNTAX OnTableEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "An entry associated with a single table."
       INDEX {applIndex, rdbmsDbIndex, onTableIndex}
       ::= { onTableTable 1 }

   OnTableEntry ::= SEQUENCE {
       onTableIndex
       INTEGER,
       onTableName
       Identifier,
       onTableOwner
       Identifier,
       onTableType
       INTEGER,
       onTableLockLevel
       INTEGER,
       onTableCreated
       DateAndTime,
       onTableFirstDbspace
       Identifier,
       onTableRowSize
       Integer32,
       onTableRows
       Integer32,
       onTableColumns
       Integer32,
       onTableIndices
       Integer32,
       onTableExtents
       Integer32,
       onTablePagesAllocated
       Integer32,
       onTablePagesUsed
       Integer32,
       onTableFragments
       Integer32,
       onTableFragmentStrategy
       INTEGER,
       onTableActiveFragments
       Integer32
   }

   onTableIndex OBJECT-TYPE
       SYNTAX INTEGER (1..2147483647)
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
         "An index to uniquely identify the table for an OnLine
          server."
       ::= {onTableEntry 1}

   onTableName OBJECT-TYPE
       SYNTAX Identifier
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The name of the table."
       ::= {onTableEntry 2}
 
   onTableOwner OBJECT-TYPE
       SYNTAX Identifier
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The name of the user who created the table."
       ::= {onTableEntry 3}

   onTableType OBJECT-TYPE
       SYNTAX INTEGER {
        table(1), view(2), privateSynonym(3), synonym(4)
        }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The type of the table."
       ::= {onTableEntry 4}

   onTableLockLevel OBJECT-TYPE
       SYNTAX INTEGER { page(1), row(2) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The lock level used when updating the table."
       ::= {onTableEntry 5}

   onTableCreated OBJECT-TYPE
       SYNTAX DateAndTime
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The date and time when the table was created."
       ::= {onTableEntry 6}

   onTableFirstDbspace OBJECT-TYPE
       SYNTAX Identifier
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The name of the dbspace where the space for the table will be
          allocated. If the table is fragmented, this is the name of the
          dbspace for the first fragment of the table."
       ::= {onTableEntry 7}

   onTableRowSize OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The size of a row in bytes in the table."
       ::= {onTableEntry 8}

   onTableRows OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The current number of rows in the table."
       ::= {onTableEntry 9}

   onTableColumns OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The current number of columns in the table."
       ::= {onTableEntry 10}

   onTableIndices OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of keys to the table."
       ::= {onTableEntry 11}

   onTableExtents OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of extents the table spans."
       ::= {onTableEntry 12}

   onTablePagesAllocated OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The current number of pages allocated to the table."
       ::= {onTableEntry 13}

   onTablePagesUsed OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The current number of pages used by the table."
       ::= {onTableEntry 14}

   onTableFragments OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of fragments for the table. If the table is not
          fragmented, a value of zero is returned."
       ::= {onTableEntry 15}

   onTableFragmentStrategy OBJECT-TYPE
       SYNTAX INTEGER { roundRobin(1), byExpression(2), tableBased(3) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The strategy used to fragment the table.  If the table is not
          fragmented, either noSuchInstance(SNMPv2) or noSuchName (SNMPv1)
          is returned."
       ::= {onTableEntry 16}

   onTableActiveFragments OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of fragments that are actively used for this table.
          If the table is not fragmented, either noSuchInstance(SNMPv2) or 
          noSuchName (SNMPv1) is returned."
       ::= {onTableEntry 17}

-- Active Table Table

   onActiveTableTable OBJECT-TYPE
       SYNTAX SEQUENCE OF OnActiveTableEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "The information kept about open tables."
       ::= { onlineObjects 4 }
 
   onActiveTableEntry OBJECT-TYPE
       SYNTAX OnActiveTableEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "An entry associated with a single opened table."
       INDEX {applIndex, rdbmsDbIndex, onTableIndex }
       ::= { onActiveTableTable 1 }

   OnActiveTableEntry ::= SEQUENCE {
       onActiveTableStatus
       INTEGER,
       onActiveTableIsBeingAltered
       INTEGER,
       onActiveTableUsers
       Gauge32,
       onActiveTableLockRequests
       Counter32,
       onActiveTableLockWaits
       Counter32,
       onActiveTableLockTimeouts
       Counter32,
       onActiveTableIsamReads
       Counter32,
       onActiveTableIsamWrites
       Counter32,
       onActiveTableBufferReads
       Counter32,
       onActiveTableBufferWrites
       Counter32
   }

   onActiveTableStatus OBJECT-TYPE
       SYNTAX INTEGER { notBusy(1), busy(2), dirty(3) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The current status of an opened table:
	      notBusy(1) indicates that the table is not currently being used;
	      busy(2) indicates that the table is in use;
	      dirty(3) indicates that the table data is modified.
	  For a table that is fragmented, the status is derived from
	  all the opened fragments of the table."
       ::= {onActiveTableEntry 1}

   onActiveTableIsBeingAltered OBJECT-TYPE
       SYNTAX INTEGER { yes(1), no(2) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The alter status of the table.  A table is being altered
          if any of the following action are in progress:
	      add/drop of an index;
	      ALTER TABLE;
	      alter page count updated;
	      pages altered to latest schema."
       ::= {onActiveTableEntry 2}

   onActiveTableUsers OBJECT-TYPE
       SYNTAX Gauge32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The total number of users accessing this table."
       ::= {onActiveTableEntry 3}

   onActiveTableLockRequests OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The total number of lock requests for this open table."
       ::= {onActiveTableEntry 4}

   onActiveTableLockWaits OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The total number of lock waits for this open table."
       ::= {onActiveTableEntry 5}

   onActiveTableLockTimeouts OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The total number of lock timeouts for this open table."
       ::= {onActiveTableEntry 6}

   onActiveTableIsamReads OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The total number of ISAM reads for this open table."
       ::= {onActiveTableEntry 7}

   onActiveTableIsamWrites OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The total number of ISAM writes for this open table."
       ::= {onActiveTableEntry 8}

   onActiveTableBufferReads OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The total number of buffer reads for this open table."
       ::= {onActiveTableEntry 9}

   onActiveTableBufferWrites OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The total number of buffer writes for this open table."
       ::= {onActiveTableEntry 10}

-- Fragment Table

   onFragmentTable OBJECT-TYPE
       SYNTAX SEQUENCE OF OnFragmentEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "The information about the fragments that are maintained
            for a table by the OnLine Server."
       ::= { onlineObjects 5 }
 
   onFragmentEntry OBJECT-TYPE
       SYNTAX OnFragmentEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "An entry associated with a single fragment of a table. If a
            table is not fragmented, there is no corresponding row entry 
            in this table."
       INDEX {applIndex, rdbmsDbIndex, onTableIndex, onFragmentIndex}
       ::= { onFragmentTable 1 }

   OnFragmentEntry ::= SEQUENCE {
       onFragmentIndex
       INTEGER,
       onFragmentType
       INTEGER,
       onFragmentDbspace
       Identifier,
       onFragmentExpression
       DisplayString,
       onFragmentIndexName
       DisplayString,
       onFragmentExtents
       Integer32,
       onFragmentPagesAllocated
       Integer32,
       onFragmentPagesUsed
       Integer32,
       onFragmentIsamReads
       Counter32,
       onFragmentIsamWrites
       Counter32,
       onFragmentUsers
       Gauge32,
       onFragmentLockRequests
       Counter32,
       onFragmentLockWaits
       Counter32,
       onFragmentLockTimeouts
       Counter32
       }

   onFragmentIndex OBJECT-TYPE
       SYNTAX INTEGER (1..2147483647)
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
         "An index to uniquely identify a fragment of a table for an OnLine
          server. The index orders the fragments according to the 
          onFragmentType, onFragmentIndexName, and the internally maintained
          evaluation position of the fragment."
       ::= {onFragmentEntry 1}

   onFragmentType OBJECT-TYPE
       SYNTAX INTEGER { fragmentedIndex(1), fragmentedTable(2) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The type of the fragment."
       ::= {onFragmentEntry 2}

   onFragmentDbspace OBJECT-TYPE
       SYNTAX Identifier
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The name of the dbspace where the disk space for this
          fragment is allocated."
       ::= {onFragmentEntry 3}

   onFragmentExpression OBJECT-TYPE
       SYNTAX DisplayString
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The name of the expression that created the fragment."
       ::= {onFragmentEntry 4}

   onFragmentIndexName OBJECT-TYPE
       SYNTAX DisplayString
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The name of the index that is used to created the fragment."
       ::= {onFragmentEntry 5}

   onFragmentExtents OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of extents for this fragment."
       ::= {onFragmentEntry 6}

   onFragmentPagesAllocated OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The size of all the extents of this fragment in pages."
       ::= {onFragmentEntry 7}

   onFragmentPagesUsed OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of pages used by this fragment."
       ::= {onFragmentEntry 8}

   onFragmentIsamReads OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of ISAM reads done on this fragment.
          This counter will reset to zero prematurely when the fragment
          is no longer active."
       ::= {onFragmentEntry 9}

   onFragmentIsamWrites OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of ISAM writes done on this fragment.
          This counter will reset to zero prematurely when the fragment
          is no longer active."
       ::= {onFragmentEntry 10}

   onFragmentUsers OBJECT-TYPE
       SYNTAX Gauge32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The total number of users accessing this fragment."
       ::= {onFragmentEntry 11}

   onFragmentLockRequests OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The total number of lock requests for this open fragment.
          This counter will reset to zero prematurely when the fragment
          is no longer active."
       ::= {onFragmentEntry 12}

   onFragmentLockWaits OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The total number of lock waits for this open fragment.
          This counter will reset to zero prematurely when the fragment
          is no longer active."
       ::= {onFragmentEntry 13}

   onFragmentLockTimeouts OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The total number of deadlock timeouts for this open fragment.
          This counter will reset to zero prematurely when the fragment
          is no longer active."
       ::= {onFragmentEntry 14}

-- Dbspace Table

   onDbspaceTable OBJECT-TYPE
       SYNTAX SEQUENCE OF OnDbspaceEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "The information about all the dbspaces that are assigned to an
            OnLine Server."
       ::= { onlineObjects 6 }

   onDbspaceEntry OBJECT-TYPE
       SYNTAX OnDbspaceEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "An entry associated with a single dbspace of an OnLine Server."
       INDEX {applIndex, onDbspaceIndex}
       ::= { onDbspaceTable 1 }

   OnDbspaceEntry ::= SEQUENCE {
       onDbspaceIndex
           INTEGER,
       onDbspaceName
           Identifier,
       onDbspaceOwner
           Identifier,
       onDbspaceCreated
           DateAndTime,
       onDbspaceChunks
           INTEGER,
       onDbspaceType
           INTEGER,
       onDbspaceMirrorStatus
           INTEGER,
       onDbspaceRecoveryStatus
           INTEGER,
       onDbspaceBackupStatus
           INTEGER,
       onDbspaceMiscStatus
           INTEGER,
       onDbspacePagesAllocated
           Integer32,
       onDbspacePagesUsed
           Integer32,
       onDbspaceBackupDate
           DateAndTime,
       onDbspaceBackupLevel
           INTEGER,
       onDbspaceLastFullBackupDate
           DateAndTime
   }

   onDbspaceIndex OBJECT-TYPE
       SYNTAX INTEGER (1..2147483647)
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
         "An index to uniquely identify the dbspace for an OnLine server."
       ::= {onDbspaceEntry 1}

   onDbspaceName OBJECT-TYPE
       SYNTAX Identifier
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The name of the dbspace."
       ::= {onDbspaceEntry 2}

   onDbspaceOwner OBJECT-TYPE
       SYNTAX Identifier
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The name of the user who created the dbspace."
       ::= {onDbspaceEntry 3}

   onDbspaceCreated OBJECT-TYPE
       SYNTAX DateAndTime
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The date and time when the dbspace was created."
       ::= {onDbspaceEntry 4}

   onDbspaceChunks OBJECT-TYPE
       SYNTAX INTEGER (1..2147483647)
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of chunks assigned to the dbspace."
       ::= {onDbspaceEntry 5}

   onDbspaceType OBJECT-TYPE
       SYNTAX INTEGER { regularDbspace(1), temporaryDbspace(2),
                        blobDbspace(3) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The enumerated flags describing the type of the dbspace."
       ::= {onDbspaceEntry 6}
 
   onDbspaceMirrorStatus OBJECT-TYPE
       SYNTAX INTEGER { notMirrored(1), mirrored(2), mirrorDisabled(3),
                        newlyMirrored(4) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The enumerated flags describing the mirror status of the
          dbspace."
       ::= {onDbspaceEntry 7}

   onDbspaceRecoveryStatus OBJECT-TYPE
       SYNTAX INTEGER { noRecoveryNeeded(1), doneRecovery(2), 
                        physicallyRecovered(3), logicallyRecovering(4)
                      }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The enumerated flags describing the recovery status of the
          dbspace."
       ::= {onDbspaceEntry 8}

   onDbspaceBackupStatus OBJECT-TYPE
       SYNTAX INTEGER { yes(1), no(2) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The value of yes if the dbspace has been backed up."
       ::= {onDbspaceEntry 9}
 
   onDbspaceMiscStatus OBJECT-TYPE
       SYNTAX INTEGER { none(1), aTableDropped(2) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The enumerated flags describing the table status of the dbspace."
       ::= {onDbspaceEntry 10}

   onDbspacePagesAllocated OBJECT-TYPE
       SYNTAX Integer32 
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The total size in pages of all the primary chunks (and not the
          mirror chunks) assigned to the dbspace."
       ::= {onDbspaceEntry 11}

   onDbspacePagesUsed OBJECT-TYPE
       SYNTAX Integer32 
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The total number of used pages in all the primary chunks (and not
          the mirror chunks) assigned to the dbspace."
       ::= {onDbspaceEntry 12}

   onDbspaceBackupDate OBJECT-TYPE
       SYNTAX DateAndTime
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The date and time when the dbspace was last backed-up. If the
          dbspace is not backed-up, this returns a noSuchInstance(SNMPv2) or
          noSuchName (SNMPv1)."
       ::= {onDbspaceEntry 13}

   onDbspaceBackupLevel OBJECT-TYPE
       SYNTAX INTEGER { completeBackup(1), incrementalLevelOne(2),
                        incrementalLevelTwo(3) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The level of the last backup action for this dbspace. If the
          dbspace is not backed-up, this returns a noSuchInstance(SNMPv2) or
          noSuchName (SNMPv1)."
       ::= {onDbspaceEntry 14}

   onDbspaceLastFullBackupDate OBJECT-TYPE
       SYNTAX DateAndTime
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The date and time when a dbspace was last backed-up completely at
          level zero. If the dbspace is not backed-up completely so far, this 
          returns a noSuchInstance(SNMPv2) or noSuchName (SNMPv1)."
       ::= {onDbspaceEntry 15}

-- Chunk Table

   onChunkTable OBJECT-TYPE
       SYNTAX SEQUENCE OF OnChunkEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "The information about all the chunks that are assigned to an
            OnLine Server. "
       ::= { onlineObjects 7 }

   onChunkEntry OBJECT-TYPE
       SYNTAX OnChunkEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "An entry associated with a single chunk of a dbspace
            for an OnLine Server."
       INDEX {applIndex, onDbspaceIndex, onChunkIndex}
       ::= { onChunkTable 1 }

   OnChunkEntry ::= SEQUENCE {
       onChunkIndex
           INTEGER,
       onChunkFileName
           DisplayString,
       onChunkFileOffset
           INTEGER,
       onChunkPagesAllocated
           Integer32,
       onChunkPagesUsed
           Integer32,
       onChunkType
           INTEGER,
       onChunkStatus
           INTEGER,
       onChunkMirroring
           INTEGER,
       onChunkReads
           Counter32,
       onChunkPageReads
           Counter32,
       onChunkWrites
           Counter32,
       onChunkPageWrites
           Counter32,
       onChunkMirrorFileName
           DisplayString,
       onChunkMirrorFileOffset
           INTEGER,
       onChunkMirrorStatus
           INTEGER
   }
 
   onChunkIndex OBJECT-TYPE
       SYNTAX INTEGER (1..2147483647)
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
         "An index to uniquely identify the chunk within a dbspace
          for an OnLine server."
       ::= {onChunkEntry 1}

   onChunkFileName OBJECT-TYPE
       SYNTAX DisplayString
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The name of the device or file path name for this chunk."
       ::= {onChunkEntry 2}
 
   onChunkFileOffset OBJECT-TYPE
       SYNTAX INTEGER (0..2147483647)
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The starting offset position within a device or a file in pages
          for the chunk."
       ::= {onChunkEntry 3}
 
   onChunkPagesAllocated OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The size of the chunk in pages."
       ::= {onChunkEntry 4}
 
   onChunkPagesUsed OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of used pages in this chunk."
       ::= {onChunkEntry 5}

   onChunkType OBJECT-TYPE
       SYNTAX INTEGER { regularChunk(1), blobChunk(2), stageBlob(3) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The type and of the chunk."
       ::= {onChunkEntry 6}
 
   onChunkStatus OBJECT-TYPE
       SYNTAX INTEGER { offline(1), online(2), recovering(3),
                        inconsistent(4), dropped(5) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The operating status of the chunk."
       ::= {onChunkEntry 7}
 
   onChunkMirroring OBJECT-TYPE
       SYNTAX INTEGER { notMirrored(1), mirrored(2), newlyMirrored(3) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The mirroring of the chunk."
       ::= {onChunkEntry 8}

   onChunkReads OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of read operations performed on this chunk."
       ::= {onChunkEntry 9}
 
   onChunkPageReads OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of pages read from this chunk."
       ::= {onChunkEntry 10}
 
   onChunkWrites OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of write operations performed on this chunk."
       ::= {onChunkEntry 11}
 
   onChunkPageWrites OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of pages written to this chunk."
       ::= {onChunkEntry 12}
 
   onChunkMirrorFileName OBJECT-TYPE
       SYNTAX DisplayString
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The name of the device or file path name for the mirror chunk."
       ::= {onChunkEntry 13}

    onChunkMirrorFileOffset OBJECT-TYPE
       SYNTAX INTEGER (0..2147483647)
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The starting offset position within a device or a file in pages
          for the mirror chunk."
       ::= {onChunkEntry 14}
 
   onChunkMirrorStatus OBJECT-TYPE
       SYNTAX INTEGER { offline(1), online(2), recovering(3),
                        inconsistent(4), dropped(5) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
          "The status of the mirror chunk."
       ::= {onChunkEntry 15}
 
-- Logical Log Table

   onLogicalLogTable OBJECT-TYPE
       SYNTAX SEQUENCE OF OnLogicalLogEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "The information about all the logfile spaces that are
            assigned to an OnLine Server."
       ::= { onlineObjects 8 }
 
   onLogicalLogEntry OBJECT-TYPE
       SYNTAX OnLogicalLogEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "An entry associated with a single logfile space
            for an OnLine Server."
       INDEX {applIndex, onLogicalLogIndex}
       ::= { onLogicalLogTable 1 }
 
   OnLogicalLogEntry ::= SEQUENCE {
       onLogicalLogIndex
           INTEGER,
       onLogicalLogID
           INTEGER,
       onLogicalLogDbspace
           Identifier,
       onLogicalLogStatus
           INTEGER,
       onLogicalLogContainsLastCheckpoint
           INTEGER,
       onLogicalLogIsTemporary
           INTEGER,
       onLogicalLogPagesAllocated
           Integer32,
       onLogicalLogPagesUsed
           Integer32,
       onLogicalLogFillTime
           DateAndTime,
       onLogicalLogBackupDate
           DateAndTime
   }
 
   onLogicalLogIndex OBJECT-TYPE
       SYNTAX INTEGER (1..2147483647)
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
         "An index to uniquely identify the logical logfile for an OnLine
          server. This is the same as the logfile number."
       ::= {onLogicalLogEntry 1}
 
   onLogicalLogID OBJECT-TYPE
       SYNTAX INTEGER (0..2147483647)
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The unique ID assigned to this logical logfile by the OnLine
          server."
       ::= {onLogicalLogEntry 2}
 
   onLogicalLogDbspace OBJECT-TYPE
       SYNTAX Identifier
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The name of the dbspace where this logfile resides."
       ::= {onLogicalLogEntry 3}
 
   onLogicalLogStatus OBJECT-TYPE
       SYNTAX INTEGER    {  newlyAdded(1), free(2), current(3), used(4),
                            backedUpButNeeded(5)
                         }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The type and status of the logfile."
       ::= {onLogicalLogEntry 4}
 
   onLogicalLogContainsLastCheckpoint OBJECT-TYPE
       SYNTAX INTEGER { yes(1), no(2) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The value of yes if the logfile contains the most recent checkpoint."
       ::= {onLogicalLogEntry 5}
 
   onLogicalLogIsTemporary OBJECT-TYPE
       SYNTAX INTEGER { yes(1), no(2) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The temporary status of the logfile."
       ::= {onLogicalLogEntry 6}
 
   onLogicalLogPagesAllocated OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of pages assigned to the logfile."
       ::= {onLogicalLogEntry 7}

   onLogicalLogPagesUsed OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of pages used in the logfile."
       ::= {onLogicalLogEntry 8}
 
   onLogicalLogFillTime OBJECT-TYPE
       SYNTAX DateAndTime
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The date and time when the logfile last filled up."
       ::= {onLogicalLogEntry 9}

   onLogicalLogBackupDate OBJECT-TYPE
       SYNTAX DateAndTime
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The date and time when the logical log was last backed-up. If the
          logical log is not backed-up, this returns a noSuchInstance(SNMPv2) or
          noSuchName (SNMPv1)."
       ::= {onLogicalLogEntry 10}

-- Physical Log Table

   onPhysicalLogTable OBJECT-TYPE
       SYNTAX SEQUENCE OF OnPhysicalLogEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "The information about the physical logfile space that is 
            assigned to an OnLine Server."
       ::= { onlineObjects 9 }

   onPhysicalLogEntry OBJECT-TYPE
       SYNTAX OnPhysicalLogEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "An entry associated with a single physical logfile space 
            for an OnLine Server."
       INDEX {applIndex}
       ::= { onPhysicalLogTable 1 }

   OnPhysicalLogEntry ::= SEQUENCE {
       onPhysicalLogDbspace
           Identifier,
       onPhysicalLogBufferSize
           INTEGER,
       onPhysicalLogBufferUsed
           INTEGER,
       onPhysicalLogPageWrites
           Counter32,
       onPhysicalLogWrites
           Counter32,
       onPhysicalLogPagesAllocated
           INTEGER,
       onPhysicalLogPagesUsed
           INTEGER
   }

   onPhysicalLogDbspace OBJECT-TYPE
       SYNTAX Identifier
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The name of the dbspace where this physical logfile resides."
       ::= {onPhysicalLogEntry 1}

   onPhysicalLogBufferSize OBJECT-TYPE
       SYNTAX INTEGER (1..2147483647)
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The size of the buffer in pages for the physical logging."
       ::= {onPhysicalLogEntry 2}

   onPhysicalLogBufferUsed OBJECT-TYPE
       SYNTAX INTEGER (0..2147483647)
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of pages in the physical log buffer that are used."
       ::= {onPhysicalLogEntry 3}

   onPhysicalLogPageWrites OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of pages written to the physical log."
       ::= {onPhysicalLogEntry 4}

   onPhysicalLogWrites OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of write operations to the disk for the physical log."
       ::= {onPhysicalLogEntry 5}

   onPhysicalLogPagesAllocated OBJECT-TYPE
       SYNTAX INTEGER (0..2147483647)
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of disk pages assigned to the physical logfile."
       ::= {onPhysicalLogEntry 6}

   onPhysicalLogPagesUsed OBJECT-TYPE
       SYNTAX INTEGER (0..2147483647)
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of pages used in the physical logfile."
       ::= {onPhysicalLogEntry 7}

-- Session Table

   onSessionTable OBJECT-TYPE
       SYNTAX SEQUENCE OF OnSessionEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "Status and profile information maintained on a per-session basis."
       ::= { onlineObjects 10 }
 
   onSessionEntry OBJECT-TYPE
       SYNTAX OnSessionEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "An entry associated with a single session."
       INDEX {applIndex, onSessionIndex}
       ::= { onSessionTable 1 }

   OnSessionEntry ::= SEQUENCE {
       onSessionIndex
       INTEGER,
       onSessionUserName
       DisplayString,
       onSessionUserProgramVersion
       Identifier,
       onSessionUserProcessId
       INTEGER,
       onSessionUserTime
       TimeTicks,
       onSessionState
       INTEGER,
       onSessionDatabase
       Identifier,
       onSessionCurrentMemory
       Integer32,
       onSessionThreads
       Gauge32,
       onSessionLockRequests
       Counter32,
       onSessionLocksHeld
       Counter32,
       onSessionLockWaits
       Counter32,
       onSessionLockTimeouts
       Counter32,
       onSessionLogRecords
       Counter32,
       onSessionIsamReads
       Counter32,
       onSessionIsamWrites
       Counter32,
       onSessionPageReads
       Counter32,
       onSessionPageWrites
       Counter32,
       onSessionLongTxs
       Counter32,
       onSessionLogSpace
       Counter32,
       onSessionHighwaterLogSpace
       Gauge32,
       onSessionSqlStatement
       DisplayString,
       onSessionSqlIsolation
       INTEGER,
       onSessionSqlLockWaitMode
       INTEGER,
       onSessionSqlEstimatedCost
       Integer32,
       onSessionSqlEstimatedRows
       Integer32,
       onSessionSqlError
       Integer32,
       onSessionSqlIsamError
       Integer32,
       onSessionTransactionStatus
       INTEGER,
       onSessionTransactionBeginLog
       Integer32,
       onSessionTransactionLastLog
       Integer32,
       onSessionOriginatingCoserverId
       Integer32,
       onSessionOriginatingSessionId
       Integer32
       }

   onSessionIndex OBJECT-TYPE
       SYNTAX INTEGER (1..2147483647)
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
         "An index to uniquely identify an OnLine session."
       ::= {onSessionEntry 1}

   onSessionUserName OBJECT-TYPE
       SYNTAX DisplayString
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "An identifier for the user who started the session, in the form
          name@host(tty)."
       ::= {onSessionEntry 2}

   onSessionUserProgramVersion OBJECT-TYPE
       SYNTAX Identifier
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The version number of the front-end program of the session."
       ::= {onSessionEntry 3}

   onSessionUserProcessId OBJECT-TYPE
       SYNTAX INTEGER (0..2147483647)
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The unix process ID of the front-end program for the session."
       ::= {onSessionEntry 4}

   onSessionUserTime OBJECT-TYPE
       SYNTAX TimeTicks
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The time that user connected to the server."
       ::= {onSessionEntry 5}

   onSessionState OBJECT-TYPE
       SYNTAX INTEGER { idle(1), active(2), waitingOnMutex(3),
                        waitingOnCondition(4), waitingOnLock(5),
                        waitingOnBuffer(6), waitingOnCheckPointing(7),
                        waitingOnLogicalLogWrite(8), 
                        waitingOnTransaction(9) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The state of the session, based on the combined state of the
	  threads for the session:
	      idle(1) indicates the session is open but idle;
	      active(2) indicates all the threads of a session are
			busy and not waiting;
	      others specify what a session is waiting for."
       ::= {onSessionEntry 6}

   onSessionDatabase OBJECT-TYPE
       SYNTAX Identifier
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The current connected database."
       ::= {onSessionEntry 7}

   onSessionCurrentMemory OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The current memory used by the session in bytes."
       ::= {onSessionEntry 8}

   onSessionThreads OBJECT-TYPE
       SYNTAX Gauge32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of active threads for this session."
       ::= {onSessionEntry 9}

   onSessionLockRequests OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of locks requested by the session so far."
       ::= {onSessionEntry 10}

   onSessionLocksHeld OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of locks held by the session currently."
       ::= {onSessionEntry 11}

   onSessionLockWaits OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of times the session has to wait for a lock so far."
       ::= {onSessionEntry 12}

   onSessionLockTimeouts OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of times the session has to wait for locks long
	  enough for the timeout to occur."
       ::= {onSessionEntry 13}

   onSessionLogRecords OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of logical log records generated by the session so far."
       ::= {onSessionEntry 14}

   onSessionIsamReads OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of ISAM read calls issued for the session so far.
          This number provides a measure of the logical read activity
          of the session."
       ::= {onSessionEntry 15}

   onSessionIsamWrites OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of ISAM write calls issued for the session so far.
          This number provides a measure of the logical write activity
          of the session."
       ::= {onSessionEntry 16}

   onSessionPageReads OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of page read calls issued for the session so far.
          This number provides a measure of the physical read activity
          of the session."
       ::= {onSessionEntry 17}

   onSessionPageWrites OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of page write calls issued for the session so far.
          This number provides a measure of the physical write activity
          of the session."
       ::= {onSessionEntry 18}

   onSessionLongTxs OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of long transactions generated by the session so far."
       ::= {onSessionEntry 19}

   onSessionLogSpace OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The size of the logical log space used by the session so far,
	  in bytes."
       ::= {onSessionEntry 20}

   onSessionHighwaterLogSpace OBJECT-TYPE
       SYNTAX Gauge32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The maximum size of the logical log space ever used by the 
          session so far, in bytes."
       ::= {onSessionEntry 21}

   onSessionSqlStatement OBJECT-TYPE
       SYNTAX DisplayString (SIZE (0..2048))
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The latest SQL statement issued by the session. The statement
          is truncated to utmost 250 characters. If the session has
          no SQL statement, any access to this object instance will result in 
          noSuchInstance (SNMPv2) or noSuchName (SNMPv1) error."
       ::= {onSessionEntry 22}

   onSessionSqlIsolation OBJECT-TYPE
       SYNTAX INTEGER { noTransactions(1), dirtyReads(2), readCommitted(3), 
                        cursorRecordLocked(4), repeatableRead(5) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The isolation level for the latest SQL statement issued by the
          session. If the session has no SQL statement, any access to 
          this object instance will result in noSuchInstance (SNMPv2) or
          noSuchName (SNMPv1) error."
       ::= {onSessionEntry 23}

   onSessionSqlLockWaitMode OBJECT-TYPE
       SYNTAX INTEGER (-1..2147483647)
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The mode of the session if the isolation level requires waiting
          for a lock. If the value is -1, implies wait for the lock till
          the lock is available. A value of zero implies no waiting. Any 
          other positive value gives the amount of time to wait for the
          lock, in seconds. If the session has no SQL statement, any access
          to this object instance will result in noSuchInstance (SNMPv2)
          or noSuchName (SNMPv1) error."
       ::= {onSessionEntry 24}

   onSessionSqlEstimatedCost OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The estimated cost of the latest SQL statement of the session, 
          as reported by the SET EXPLAIN. If the session has no SQL
          statement, any access to this object instance will result in
          noSuchInstance (SNMPv2) or noSuchName (SNMPv1) error."
       ::= {onSessionEntry 25}

   onSessionSqlEstimatedRows OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The estimated number of rows selected by the latest SQL 
          statement of the session, as reported by the SET EXPLAIN. 
          If the session has no SQL statement, any access to this object 
          instance will result in noSuchInstance (SNMPv2) or 
          noSuchName (SNMPv1) error."
       ::= {onSessionEntry 26}

   onSessionSqlError OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The error number for the last SQL statement of the session.
          If the session has no SQL statement, any access to this object 
          instance will result in noSuchInstance (SNMPv2) or 
          noSuchName (SNMPv1) error."
       ::= {onSessionEntry 27}

   onSessionSqlIsamError OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The ISAM error number for the last SQL statement of the session.
          If the session has no SQL statement, any access to this object 
          instance will result in noSuchInstance (SNMPv2) or 
          noSuchName (SNMPv1) error."
       ::= {onSessionEntry 28}

   onSessionTransactionStatus OBJECT-TYPE
       SYNTAX INTEGER { none(1), committing(2), rollingBack(3), 
                        rollingBackHeuristically(4), waiting(5) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The status of the transaction for this session."
       ::= {onSessionEntry 29}

   onSessionTransactionBeginLog OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The unique Id of the logical-log file in which the BEGIN WORK 
          record was logged for a transaction of the session.
          If the session has no transaction, any access to this object 
          instance will result in noSuchInstance (SNMPv2) or 
          noSuchName (SNMPv1) error."
       ::= {onSessionEntry 30}

   onSessionTransactionLastLog OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The unique ID of the logical-log file in which the last 
          record was logged for a transaction of the session.
          If the session has no transaction, any access to this object 
          instance will result in noSuchInstance (SNMPv2) or 
          noSuchName (SNMPv1) error."
       ::= {onSessionEntry 31}

   onSessionOriginatingCoserverId OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "An identifier for originating-coserver on whose behalf this
          local-session runs."
       ::= {onSessionEntry 32}

   onSessionOriginatingSessionId OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The local-session-id of the global-session on the originating
          coserver, for which this session runs."
       ::= {onSessionEntry 33}

-- Lock Table

   onLockTable OBJECT-TYPE
       SYNTAX SEQUENCE OF OnLockEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "This table contains information on all the active locks that are
	    currently in use on a per-session basis. For each session, there
	    are entries both for the locks in use by the session as well as
	    the locks on which the session is waiting."
            
       ::= { onlineObjects 11 }
 
   onLockEntry OBJECT-TYPE
       SYNTAX OnLockEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "An entry associated with a single lock."
       INDEX {applIndex, onSessionIndex, onLockIndex}
       ::= { onLockTable 1 }

   OnLockEntry ::= SEQUENCE {
       onLockIndex
       INTEGER,
       onLockDatabaseName
       Identifier,
       onLockTableName
       Identifier,
       onLockType
       INTEGER,
       onLockGranularity
       INTEGER,
       onLockRowId
       Integer32,
       onLockWaiters
       Gauge32,
       onLockGrantTime
       TimeTicks
       }

   onLockIndex OBJECT-TYPE
       SYNTAX INTEGER (1..2147483647)
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
         "An index to uniquely identify a single server-internal lock."
       ::= {onLockEntry 1}

   onLockDatabaseName OBJECT-TYPE
       SYNTAX Identifier
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The name of the database on which a lock is held."
       ::= {onLockEntry 2}

   onLockTableName OBJECT-TYPE
       SYNTAX Identifier
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The name of the table on which the lock is held."
       ::= {onLockEntry 3}

   onLockType OBJECT-TYPE
       SYNTAX INTEGER {
                          bytesLock(1),
                          intentShared(2),
                          shared(3),
                          sharedByRepeatableRead(4),
                          update(5),
                          intentExclusive(6),
                          sharedIntentExclusive(7),
                          exclusive(8),
                          exclusiveByRepeatableRead(9),
                          waiting(10)
                      }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "If the type of lock is waiting(10), then this is an entry for a lock
	  on which a given session is waiting.  Otherwise, this identifies the
	  type of lock that is being held by a given session."
       ::= {onLockEntry 4}

   onLockGranularity OBJECT-TYPE
       SYNTAX INTEGER { table(1), page(2), row(3), index(4) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The granularity level of the lock."
       ::= {onLockEntry 5}

   onLockRowId OBJECT-TYPE
       SYNTAX Integer32 
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The ID of the row of the table the lock is on."
       ::= {onLockEntry 6}

   onLockWaiters OBJECT-TYPE
       SYNTAX Gauge32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The current number of sessions waiting for this lock."
       ::= {onLockEntry 7}

   onLockGrantTime OBJECT-TYPE
       SYNTAX TimeTicks
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The elapsed time since the lock was granted, in centiseconds.
          If the session is waiting for the lock as indicated by the 
          onLockType object being set to waiting(10), either
	  noSuchInstance(SNMPv2) or noSuchName (SNMPv1) is returned."
       ::= {onLockEntry 8}

-- onbar Backup/Restore Table

   onBarTable OBJECT-TYPE
       SYNTAX SEQUENCE OF OnBarEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "Information about backup activity in OnLine Server."
       ::= { onlineObjects 12 }
 
   onBarEntry OBJECT-TYPE
       SYNTAX OnBarEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "An entry created each time a dbspace or logical log is backed up."
       INDEX {applIndex, onBarActivityIndex, onBarObjectIndex}
       ::= { onBarTable 1 }

   OnBarEntry ::= SEQUENCE {
       onBarActivityIndex
       INTEGER,
       onBarObjectIndex
       INTEGER,
       onBarObjectName
       Identifier,
       onBarObjectType
       INTEGER,
       onBarBackupLevel
       INTEGER,
       onBarActionStatus
       Integer32,
       onBarTimeStamp
       DateAndTime
       }

   onBarActivityIndex OBJECT-TYPE
       SYNTAX INTEGER (1..2147483647)
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
         "An index to uniquely identify an action within Bar activity."
       ::= {onBarEntry 1}

   onBarObjectIndex OBJECT-TYPE
       SYNTAX INTEGER (1..2147483647)
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
         "An index to uniquely identify an object within an action."
       ::= {onBarEntry 2}

   onBarObjectName OBJECT-TYPE
       SYNTAX Identifier
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The name of the object."
       ::= {onBarEntry 3}

   onBarObjectType OBJECT-TYPE
       SYNTAX INTEGER { blobSpace(1), rootDbspace(2), criticalDbspace(3),
                        nonCriticalDbspace(4), logicalLog(5) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The type of object for which a backup has taken place."
       ::= {onBarEntry 4}

   onBarBackupLevel OBJECT-TYPE
       SYNTAX INTEGER { completeBackup(1), incrementalLevelOne(2),
                        incrementalLevelTwo(3) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The level of the backup action."
       ::= {onBarEntry 5}

   onBarActionStatus OBJECT-TYPE
       SYNTAX Integer32 
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The status of the action. A non-zero value is the error status
	  returned by onbar."
       ::= {onBarEntry 6}

   onBarTimeStamp OBJECT-TYPE
       SYNTAX DateAndTime 
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The date and time when this action ended."
       ::= {onBarEntry 7}

-- onactivebar Active Backup/Restore Table

   onActiveBarTable OBJECT-TYPE
       SYNTAX SEQUENCE OF OnActiveBarEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "Information about active backup or restore low-level (RSAM)
            activity in OnLine Server."
       ::= { onlineObjects 15 }
 
   onActiveBarEntry OBJECT-TYPE
       SYNTAX OnActiveBarEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "An entry created each time a backup or restore activity is started."
       INDEX {applIndex, onActiveBarIndex}
       ::= { onActiveBarTable 1 }

   OnActiveBarEntry ::= SEQUENCE {
       onActiveBarIndex
       INTEGER,
       onActiveBarActivityType
       INTEGER,
       onActiveBarObjectId
       INTEGER,
       onActiveBarActivityLevel
       INTEGER,
       onActiveBarElapsedTime
       TimeTicks,
       onActiveBarActivitySize
       Integer32,
       onActiveBarActivityScanned
       Integer32,
       onActiveBarActivityCompleted
       Integer32,
       onActiveBarActivityStatus
       Integer32
       }

   onActiveBarIndex OBJECT-TYPE
       SYNTAX INTEGER (1..2147483647)
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
         "An index to uniquely identify an active backup or restore
          activity. This index is the Id of the session that started
          the activity."
       ::= {onActiveBarEntry 1}

   onActiveBarActivityType OBJECT-TYPE
       SYNTAX INTEGER {dbspaceBackup(1), dbspaceRestore(2), logBackup(3),
                        logRestore(4), systemBackup(5), systemRestore(6)}
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The type of the onbar activity."
       ::= {onActiveBarEntry 2}

   onActiveBarObjectId OBJECT-TYPE
       SYNTAX INTEGER (0..2147483647)
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The Id of the target object of this activity. This will be
          the dbspace id or index if the object is a dbspace. This will
          be the logfile non-unique Id if the object is a logfile. The
          value will be zero if the activity is system backup or restore."
       ::= {onActiveBarEntry 3}

   onActiveBarActivityLevel OBJECT-TYPE
       SYNTAX INTEGER { completeBackup(1), incrementalLevelOne(2),
                        incrementalLevelTwo(3) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The level of the onbar activity."
       ::= {onActiveBarEntry 4}

   onActiveBarElapsedTime OBJECT-TYPE
       SYNTAX TimeTicks 
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The elapsed time since this activity has started, in centi-seconds."
       ::= {onActiveBarEntry 5}

   onActiveBarActivitySize OBJECT-TYPE
       SYNTAX Integer32 
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of used pages of the object that is to be
          scanned by this activity.
          For a dbspace, this will be the number of used pages.
          If it is the root dbspace, this includes the reserved pages and
          extents. For a logfile, this will be the used pages of the log.
          For a whole system backup, this include all the dbspaces and
          a snap-shot of the used logs. This value is refined as the
          activity progresses."
       ::= {onActiveBarEntry 6}

   onActiveBarActivityScanned OBJECT-TYPE
       SYNTAX Integer32 
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of pages scanned so far among the used pages of the
          activity object." 
       ::= {onActiveBarEntry 7}

   onActiveBarActivityCompleted OBJECT-TYPE
       SYNTAX Integer32 
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of pages of data transfer completed so far for 
          archiving. As all the scanned pages need not be archived, this
          value will be less than or equal to the scanned pages."
       ::= {onActiveBarEntry 8}

   onActiveBarActivityStatus OBJECT-TYPE
       SYNTAX Integer32 
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The status of the action. A non-zero value is the error status
	  returned by onbar."
       ::= {onActiveBarEntry 9}

-- SQLHOST Table

   onSqlHostTable OBJECT-TYPE
       SYNTAX SEQUENCE OF OnSqlHostEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "The connectivity configuration specified in a SQLHOST file
	    for the server."
       ::= { onlineObjects 13 }
 
   onSqlHostEntry OBJECT-TYPE
       SYNTAX OnSqlHostEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "A line within a SQLHOST file."
       INDEX {applIndex, onSqlHostIndex}
       ::= { onSqlHostTable 1 }

   OnSqlHostEntry ::= SEQUENCE {
       onSqlHostIndex
       INTEGER,
       onSqlHostName
       DisplayString,
       onSqlHostNetType
       DisplayString,
       onSqlHostServerName
       DisplayString,
       onSqlHostServiceName
       DisplayString,
       onSqlHostServicePort
       Integer32,
       onSqlHostOptions
       DisplayString
       }

   onSqlHostIndex OBJECT-TYPE
       SYNTAX INTEGER (1..2147483647)
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
         "An index to uniquely identify a line within a SQLHOST file."
       ::= {onSqlHostEntry 1}

   onSqlHostName OBJECT-TYPE
       SYNTAX DisplayString
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The name of a host."
       ::= {onSqlHostEntry 2}

   onSqlHostNetType OBJECT-TYPE
       SYNTAX DisplayString
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The connection type (e.g. ontlitcp) for a host."
       ::= {onSqlHostEntry 3}

   onSqlHostServerName OBJECT-TYPE
       SYNTAX DisplayString
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The name of the database server, or its alias."
       ::= {onSqlHostEntry 4}

   onSqlHostServiceName OBJECT-TYPE
       SYNTAX DisplayString
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The service name of the connection to the server."
       ::= {onSqlHostEntry 5}

   onSqlHostServicePort OBJECT-TYPE
      SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The service port number of the connection to the server. This
          number is valid only for ONSOCTCP and ONTLITCP services. All
          others will have a value of zero."
       ::= {onSqlHostEntry 6}

   onSqlHostOptions OBJECT-TYPE
       SYNTAX DisplayString
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The set of key-value (key=value) pairs listing the
          various options for the server." 
       ::= {onSqlHostEntry 7}

-- SNMP subagent state Table (for internal use only)

   onSnmpTable OBJECT-TYPE
       SYNTAX SEQUENCE OF OnSnmpEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "Profile information kept about various SNMP objects that are  
            defined for the OnLine Server."
       ::= { onlineObjects 14 }
 
   onSnmpEntry OBJECT-TYPE
       SYNTAX OnSnmpEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "An entry associated with a single snmp table."
       INDEX {applIndex, onSnmpIndex}
       ::= { onSnmpTable 1 }

   OnSnmpEntry ::= SEQUENCE {
       onSnmpIndex
       INTEGER,
       onSnmpName
       DisplayString,
       onSnmpOID
       OBJECT IDENTIFIER,
       onSnmpRefreshType
       INTEGER,
       onSnmpRefreshInterval
       TimeTicks,
       onSnmpNextRefresh
       TimeTicks,
       onSnmpRefreshes
       Counter32,
       onSnmpHoldInterval
       TimeTicks,
       onSnmpRows
       Integer32,
       onSnmpColumns
       Integer32,
       onSnmpRetries
       Counter32,
       onSnmpFailures
       Counter32
       }

   onSnmpIndex OBJECT-TYPE
       SYNTAX INTEGER (1..2147483647)
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
         "An index to uniquely identify a SNMP Table for OnLine."
       ::= {onSnmpEntry 1}

   onSnmpName OBJECT-TYPE
       SYNTAX DisplayString
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The name of the Snmp table."
       ::= {onSnmpEntry 2}

   onSnmpOID OBJECT-TYPE
       SYNTAX OBJECT IDENTIFIER
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The object ID for the Snmp table in dot notation."
       ::= {onSnmpEntry 3}

   onSnmpRefreshType OBJECT-TYPE
       SYNTAX INTEGER { oneShot(1), onDemand(2), onTimer(3) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The refresh strategy for this table."
       ::= {onSnmpEntry 4}

   onSnmpRefreshInterval OBJECT-TYPE
       SYNTAX TimeTicks
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The refresh interval for this table. If the refresh strategy
          is onTimer, this contains the actual period. If the refresh
          strategy is onDemand or oneShot, this value is zero. The
          units are in centiseconds." 
       ::= {onSnmpEntry 5}

   onSnmpNextRefresh OBJECT-TYPE
       SYNTAX TimeTicks
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The time interval in centiseconds after which the table is
          refreshed."
       ::= {onSnmpEntry 6}

   onSnmpRefreshes OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of times the table is refreshed so far."
       ::= {onSnmpEntry 7}

   onSnmpHoldInterval OBJECT-TYPE
       SYNTAX TimeTicks
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The hold interval for this table after an refresh. If it is 
          non-zero, it means that the cached values for this table are
          valid only for this amount of time after a refresh. The
          units are in centiseconds." 
       ::= {onSnmpEntry 8}

   onSnmpRows OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The current number of rows in this table."
       ::= {onSnmpEntry 9}

   onSnmpColumns OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The current number of columns in this table."
       ::= {onSnmpEntry 10}

   onSnmpRetries OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of times the access to a table caused retries, as
          a result of using the shared memory of the server for getting
          the instance values."
       ::= {onSnmpEntry 11}

   onSnmpFailures OBJECT-TYPE
       SYNTAX Counter32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of times the access to a table caused failures, as
          a result of using the shared memory of the server for getting
          the instance values. An access is treated as a failure after
          a certain number of retries fail."
       ::= {onSnmpEntry 12}

-- XPS specific table reported by each coserver

   onXpsTable OBJECT-TYPE
       SYNTAX SEQUENCE OF OnXpsEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "Information about XPS Server."
       ::= { onlineObjects 16 }
 
   onXpsEntry OBJECT-TYPE
       SYNTAX OnXpsEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "An entry for each coserver of an XPS server."
       INDEX {applIndex}
       ::= { onXpsTable 1 }

   OnXpsEntry ::= SEQUENCE {
       onXpsSnmpIndex
       INTEGER,
       onXpsSnmpHost
       DisplayString
       }

   onXpsSnmpIndex OBJECT-TYPE
       SYNTAX INTEGER (1..2147483647)
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "An index to uniquely identify an XPS server by the xpssnmp subagent."
       ::= {onXpsEntry 1}

   onXpsSnmpHost OBJECT-TYPE
       SYNTAX DisplayString
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The name of the host where the XPS subagent is running."
       ::= {onXpsEntry 2}

-- Enterprise Replication tables

   onErSiteTable OBJECT-TYPE
       SYNTAX  SEQUENCE OF OnErSiteEntry
       MAX-ACCESS  not-accessible
       STATUS current
       DESCRIPTION
	 "Information about remote servers used in replication.
	  Table contains entries for all servers participating
	  in Enterprise Replication."
       ::= { onlineObjects  17}
    
   onErSiteEntry OBJECT-TYPE
       SYNTAX  OnErSiteEntry
       MAX-ACCESS  not-accessible
       STATUS  current
       DESCRIPTION
	  "An entry describing a replication queue."
       INDEX   { applIndex, onErSiteIndex }
       ::= { onErSiteTable  1 }
    
   OnErSiteEntry ::= SEQUENCE {
	onErSiteIndex		     INTEGER,
	onErSiteName		     DisplayString,
	onErSiteState		     INTEGER,
	onErSiteConnectionState	     INTEGER,
	onErSiteConnectionChange     DateAndTime,
	onErSiteIdleTimeout	     TimeTicks,
	onErSiteOutMsgs		     Counter32,
	onErSiteOutBytes	     Counter32,
	onErSiteInMsgs		     Counter32,
	onErSiteInBytes		     Counter32,
	onErSiteTransactions	     Counter32,
	onErSiteCommits		     Counter32,
	onErSiteAborts		     Counter32,
	onErSiteLastReceived	     DateAndTime,
	onErSiteRowCommits	     Counter32,
	onErSiteRowAborts	     Counter32,
	onErSiteRcvLatency	     TimeTicks,
	onErSiteCommitLatency	     TimeTicks,
	onErSiteClockErrors	     Counter32
	}

    onErSiteIndex OBJECT-TYPE
	SYNTAX INTEGER (1..65536)
	MAX-ACCESS  not-accessible
	STATUS	current
	DESCRIPTION
		"The identifier that uniquely identifies a server
		 as defined in the group entry in SQLHOSTS."
	::= { onErSiteEntry  1 }
    
    onErSiteName OBJECT-TYPE
	SYNTAX	DisplayString
	MAX-ACCESS  read-only
	STATUS	current
	DESCRIPTION
		"The name of the replication site."
	::= { onErSiteEntry  2 }
    
    onErSiteState  OBJECT-TYPE
	SYNTAX	INTEGER {
		inactive(1), active(2), suspend(3), quiescent(4), 
		hold(5), delete(6), failed(7), unknown(8)
		}
	MAX-ACCESS  read-only
	STATUS	current
	DESCRIPTION
	   "The state of the replication activity for this site."
	::= { onErSiteEntry  3 }

    onErSiteConnectionState OBJECT-TYPE
	SYNTAX	INTEGER {
		idle(1), connected(2), disconnected(3), timeout(4),	
		shutdown(5), error(6), unknown(7)
		}
	MAX-ACCESS  read-only
	STATUS	current
	DESCRIPTION
	   "The state of the connection to this site."
	::= { onErSiteEntry  4 }
    
    onErSiteConnectionChange OBJECT-TYPE
	SYNTAX DateAndTime
	MAX-ACCESS read-only
	STATUS current
	DESCRIPTION
	   "The date and time when the connection state last changed."
       ::= {onErSiteEntry 5 }

    onErSiteIdleTimeout OBJECT-TYPE
	SYNTAX	TimeTicks
	MAX-ACCESS  read-only
	STATUS	current
	DESCRIPTION
	   "The time limit for ER to wait for new data to send or receive.
	    Value set when server was defined. If time limit is exceeded
	    connection will be closed."
	::= { onErSiteEntry  6 }

    onErSiteOutMsgs OBJECT-TYPE
	SYNTAX	Counter32
	MAX-ACCESS  read-only
	STATUS	current
	DESCRIPTION
	   "The total number of messages transmitted from current
	    server to this site."
	::= { onErSiteEntry  7 }
    
    onErSiteOutBytes OBJECT-TYPE
	SYNTAX	Counter32
	MAX-ACCESS  read-only
	STATUS	current
	DESCRIPTION
	   "The total number of bytes transmitted from current
	    server to this site."
	::= { onErSiteEntry  8 }
    
    onErSiteInMsgs OBJECT-TYPE
	SYNTAX	Counter32
	MAX-ACCESS  read-only
	STATUS	current
	DESCRIPTION
	   "The total number of messages received by current
	    server from this site."
	::= { onErSiteEntry 9 }
    
    onErSiteInBytes OBJECT-TYPE
	SYNTAX	Counter32
	MAX-ACCESS  read-only
	STATUS	current
	DESCRIPTION
	   "The total number of bytes received by current
	    server from this site."
	::= { onErSiteEntry 10 }

    onErSiteTransactions OBJECT-TYPE
	SYNTAX	Counter32
	MAX-ACCESS  read-only
	STATUS	current
	DESCRIPTION
	   "The total number of transactions received from this site."
	::= { onErSiteEntry 11 }
    
    onErSiteCommits OBJECT-TYPE
	SYNTAX	Counter32
	MAX-ACCESS  read-only
	STATUS	current
	DESCRIPTION
	   "The total number of transactions received 
	    and committed from this site."
	::= { onErSiteEntry 12 }
    
    onErSiteAborts OBJECT-TYPE
	SYNTAX	Counter32
	MAX-ACCESS  read-only
	STATUS	current
	DESCRIPTION
	   "The total number of transactions aborted from this site."
	::= { onErSiteEntry 13 }
    
    onErSiteLastReceived OBJECT-TYPE
	SYNTAX DateAndTime
	MAX-ACCESS  read-only
	STATUS	current
	DESCRIPTION
	   "The date and time when last transaction was processed from this site."
	::= { onErSiteEntry  14 }

    onErSiteRowCommits OBJECT-TYPE
	SYNTAX	Counter32
	MAX-ACCESS  read-only
	STATUS	current
	DESCRIPTION
	   "The total number of rows committed from this site."
	::= { onErSiteEntry 15 }
    
    onErSiteRowAborts OBJECT-TYPE
	SYNTAX	Counter32
	MAX-ACCESS  read-only
	STATUS	current
	DESCRIPTION
	   "Total number of rows aborted from this site."
	::= { onErSiteEntry 16 }

    onErSiteRcvLatency OBJECT-TYPE
	SYNTAX TimeTicks
	MAX-ACCESS read-only
	STATUS current
	DESCRIPTION
	   "The average latency between commit time on source and
	    receive time on target. Performance measure of network
	    queueing delay."
	::= { onErSiteEntry 17 }

    onErSiteCommitLatency OBJECT-TYPE
	SYNTAX TimeTicks
	MAX-ACCESS read-only
	STATUS current
	DESCRIPTION
	   "The average latency between commit time on source and
	    commit time on target. Performance measure of network
	    and server delay."
	::= { onErSiteEntry 18 }

    onErSiteClockErrors OBJECT-TYPE
	SYNTAX Counter32
	MAX-ACCESS read-only
	STATUS current
	DESCRIPTION
	   "The number of transactions received from this site
	    with a time that is ahead of our current time. 
	    Indicates system clock synchronization problems."
	::= { onErSiteEntry 19 }

   onErQueueTable OBJECT-TYPE
       SYNTAX  SEQUENCE OF OnErQueueEntry
       MAX-ACCESS  not-accessible
       STATUS current
       DESCRIPTION
	 "Information about replication queues.
	  Table contains entries for all servers participating
	  in replication."
       ::= { onlineObjects  18}
    
   onErQueueEntry OBJECT-TYPE
       SYNTAX  OnErQueueEntry
       MAX-ACCESS  not-accessible
       STATUS  current
       DESCRIPTION
	  "An entry describing a replication queue."
       INDEX   { applIndex, onErQueueReplIndex, onErQueueSiteIndex }
       ::= { onErQueueTable  1 }


   OnErQueueEntry ::= SEQUENCE {
	onErQueueReplIndex	INTEGER,
	onErQueueSiteIndex	INTEGER,
	onErQueueReplName	DisplayString,
	onErQueueSiteName	DisplayString,
	onErQueueSize		Gauge32,
	onErQueueLastCommit	DataAndTime,
	onErQueueLastAck	DataAndTime
	}

    onErQueueReplIndex OBJECT-TYPE
	SYNTAX INTEGER (1..65536)
	MAX-ACCESS   not-accessible
	STATUS	current
	DESCRIPTION
		"The identifier that uniquely identifies a replicant."
	::= { onErQueueEntry  1 }

    onErQueueSiteIndex OBJECT-TYPE
	SYNTAX INTEGER (1..65536)
	MAX-ACCESS  not-accessible
	STATUS	current
	DESCRIPTION
		"The identifier that uniquely identifies a server."
	::= { onErQueueEntry  2 }

    onErQueueReplName OBJECT-TYPE
	SYNTAX	DisplayString
	MAX-ACCESS  read-only
	STATUS	current
	DESCRIPTION
		"The name used to describe the replicant or collection of
		 replicants."
	::= { onErQueueEntry  3 }

    onErQueueSiteName OBJECT-TYPE
	SYNTAX	DisplayString
	MAX-ACCESS  read-only
	STATUS	current
	DESCRIPTION
		"The name of the Entrprise Replication server."
	::= { onErQueueEntry  4 }

    onErQueueSize OBJECT-TYPE
	SYNTAX Gauge32
	MAX-ACCESS  read-only
	STATUS	current
	DESCRIPTION
	    "Current number of bytes in the send queue."
	::= { onErQueueEntry  5 }
		
    onErQueueLastCommit OBJECT-TYPE
	SYNTAX DateAndTime
	MAX-ACCESS  read-only
	STATUS	current
	DESCRIPTION
	   "The date and time when last transaction was committed."
	::= { onErQueueEntry  6 }

    onErQueueLastAck OBJECT-TYPE
	SYNTAX DateAndTime
	MAX-ACCESS  read-only
	STATUS	current
	DESCRIPTION
	   "The date and time when last data was acked."
	::= { onErQueueEntry  7 }

-- End of OnLine MIB

-- --------------
-- XPS MIB tables
-- --------------
   xpsObjects OBJECT IDENTIFIER ::= { xpsMIB  1 }

-- Xps Coserver Table

   xpsCoserverTable OBJECT-TYPE
       SYNTAX SEQUENCE OF XpsCoserverEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "Information/listing of all coservers which comprise
            the XPS server."
       ::= { xpsObjects 1 }
 
   xpsCoserverEntry OBJECT-TYPE
       SYNTAX XpsCoserverEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "An entry associated with a single instance of an active 
            XPS-coserver."
       INDEX {applIndex, xpsCoserverIndex}
       ::= { xpsCoserverTable 1 }

   XpsCoserverEntry ::= SEQUENCE {
       xpsCoserverIndex
       INTEGER,
       xpsCoserverHostname
       DisplayString,
       xpsCoserverId
       Integer32,
       xpsCoserverRootDbspaceId
       Integer32
       }

   xpsCoserverIndex OBJECT-TYPE
       SYNTAX INTEGER (1..2147483647)
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
         "An index to uniquely identify the coserver/member for an XPS
          server."
       ::= {xpsCoserverEntry 1}

   xpsCoserverHostname OBJECT-TYPE
       SYNTAX DisplayString
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The name of the host on which the coserver runs."
       ::= {xpsCoserverEntry 2}

   xpsCoserverId OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The coserver-id of this XPS member."
       ::= {xpsCoserverEntry 3}

   xpsCoserverRootDbspaceId OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The Id of root-dbspace for this coserver."
       ::= {xpsCoserverEntry 4}


-- Xps Cogroup Table

   xpsCogroupTable OBJECT-TYPE
       SYNTAX SEQUENCE OF XpsCogroupEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "Information/listing of all coserver-groups (cogroups) in
            the XPS server."
       ::= { xpsObjects 2 }

   xpsCogroupEntry OBJECT-TYPE
       SYNTAX XpsCogroupEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "An entry associated with a single instance of a cogroup
            in a XPS server."
       INDEX {applIndex, xpsCogroupIndex}
       ::= { xpsCogroupTable 1 }

   XpsCogroupEntry ::= SEQUENCE {
       xpsCogroupIndex
       INTEGER,
       xpsCogroupName
       DisplayString,
       xpsCogroupMemberCount
       Integer32,
       xpsCogroupIsClustered
       INTEGER
       }

   xpsCogroupIndex OBJECT-TYPE
       SYNTAX INTEGER (1..2147483647)
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
         "An index to uniquely identify the cogroup in a XPS server."
       ::= {xpsCogroupEntry 1}

   xpsCogroupName OBJECT-TYPE
       SYNTAX DisplayString
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The name of the cogroup within the XPS server."
       ::= {xpsCogroupEntry 2}

   xpsCogroupMemberCount OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of coservers in the cogroup of the XPS server."
       ::= {xpsCogroupEntry 3}

   xpsCogroupIsClustered OBJECT-TYPE
       SYNTAX INTEGER { yes(1), no(2) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "Whether the cogroup is clustered (yes) or not (no)."
       ::= {xpsCogroupEntry 4}

-- Xps Cogroup Member Table

   xpsCogroupMemberTable OBJECT-TYPE
       SYNTAX SEQUENCE OF XpsCogroupMemberEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "Information about all coservers within a XPS cogroup."
       ::= { xpsObjects 3 }

   xpsCogroupMemberEntry OBJECT-TYPE
       SYNTAX XpsCogroupMemberEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "An entry associated with a single instance of a coserver
            in a XPS cogroup."
       INDEX {applIndex, xpsCogroupIndex, xpsCogroupMemberIndex }
       ::= { xpsCogroupMemberTable 1 }

   XpsCogroupMemberEntry ::= SEQUENCE {
       xpsCogroupMemberIndex
       INTEGER,
       xpsCogroupMemberCoserverId
       Integer32
       }

   xpsCogroupMemberIndex OBJECT-TYPE
       SYNTAX INTEGER (1..2147483647)
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
         "An index to uniquely identify the cogroup member in a 
          XPS cogroup."
       ::= {xpsCogroupMemberEntry 1}

   xpsCogroupMemberCoserverId OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The coserver-id of this XPS cogroup member."
       ::= {xpsCogroupMemberEntry 2}

-- Xps Dbslice Table

   xpsDbsliceTable OBJECT-TYPE
       SYNTAX SEQUENCE OF XpsDbsliceEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "Information about all Dbslices in a XPS server."
       ::= { xpsObjects 4 }

   xpsDbsliceEntry OBJECT-TYPE
       SYNTAX XpsDbsliceEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "An entry associated with a single instance of a Dbslice
            in a XPS server."
       INDEX {applIndex, xpsDbsliceIndex }
       ::= { xpsDbsliceTable 1 }

   XpsDbsliceEntry ::= SEQUENCE {
       xpsDbsliceIndex
       INTEGER,
       xpsDbsliceName
       DisplayString,
       xpsDbsliceDbspaceCount
       Integer32,
       xpsDbsliceIsMirrored
       INTEGER,
       xpsDbsliceIsBlobSlice
       INTEGER,
       xpsDbsliceIsTemp
       INTEGER
       }

   xpsDbsliceIndex OBJECT-TYPE
       SYNTAX INTEGER (1..2147483647)
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
         "An index to uniquely identify a Dbslice in a XPS server."
       ::= {xpsDbsliceEntry 1}

   xpsDbsliceName OBJECT-TYPE
       SYNTAX DisplayString
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The name of the Dbslice in the XPS server."
       ::= {xpsDbsliceEntry 2}

   xpsDbsliceDbspaceCount OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The number of Dbspaces in this Dbslice of the XPS server."
       ::= {xpsDbsliceEntry 3}

   xpsDbsliceIsMirrored OBJECT-TYPE
       SYNTAX INTEGER { yes(1), no(2) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "Whether the Dbslice is mirrored (yes) or not (no)."
       ::= {xpsDbsliceEntry 4}

   xpsDbsliceIsBlobSlice OBJECT-TYPE
       SYNTAX INTEGER { yes(1), no(2) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "Whether the Dbslice is a blob-slice (yes) or not (no)."
       ::= {xpsDbsliceEntry 5}

   xpsDbsliceIsTemp OBJECT-TYPE
       SYNTAX INTEGER { yes(1), no(2) }
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "Whether the Dbslice is temporary (yes) or not (no)."
       ::= {xpsDbsliceEntry 6}

-- Xps DbsliceDbspace Table

   xpsDbsliceDbspaceTable OBJECT-TYPE
       SYNTAX SEQUENCE OF XpsDbsliceDbspaceEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "Information about all Dbspaces within a Dbslice of a XPS 
            server."
       ::= { xpsObjects 5 }

   xpsDbsliceDbspaceEntry OBJECT-TYPE
       SYNTAX XpsDbsliceDbspaceEntry
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
           "An entry associated with a single instance of a Dbspace
            in a XPS Dbslice."
       INDEX {applIndex, xpsDbsliceIndex, xpsDbsliceDbspaceIndex }
       ::= { xpsDbsliceDbspaceTable 1 }

   XpsDbsliceDbspaceEntry ::= SEQUENCE {
       xpsDbsliceDbspaceIndex
       INTEGER,
       xpsDbsliceDbspaceHomeCoserverId
       Integer32
       }

   xpsDbsliceDbspaceIndex OBJECT-TYPE
       SYNTAX INTEGER (1..2147483647)
       MAX-ACCESS not-accessible
       STATUS current
       DESCRIPTION
         "An index to uniquely identify a Dbspace in a Dbslice of
          a XPS server."
       ::= {xpsDbsliceDbspaceEntry 1}

   xpsDbsliceDbspaceHomeCoserverId OBJECT-TYPE
       SYNTAX Integer32
       MAX-ACCESS read-only
       STATUS current
       DESCRIPTION
         "The coserver-id of the home coserver of this dbspace."
       ::= {xpsDbsliceDbspaceEntry 2}


END