|
Packit |
022b05 |
RDBMS-MIB DEFINITIONS ::= BEGIN
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
IMPORTS
|
|
Packit |
022b05 |
MODULE-IDENTITY, OBJECT-TYPE, NOTIFICATION-TYPE,
|
|
Packit |
022b05 |
OBJECT-IDENTITY, Counter32, Gauge32, Integer32
|
|
Packit |
022b05 |
FROM SNMPv2-SMI
|
|
Packit |
022b05 |
MODULE-COMPLIANCE, OBJECT-GROUP
|
|
Packit |
022b05 |
FROM SNMPv2-CONF
|
|
Packit |
022b05 |
DisplayString, DateAndTime, AutonomousType
|
|
Packit |
022b05 |
FROM SNMPv2-TC
|
|
Packit |
022b05 |
applIndex, applGroups
|
|
Packit |
022b05 |
FROM NETWORK-SERVICES-MIB
|
|
Packit |
022b05 |
mib-2
|
|
Packit |
022b05 |
FROM RFC1213-MIB;
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsMIB MODULE-IDENTITY
|
|
Packit |
022b05 |
LAST-UPDATED "9406150655Z"
|
|
Packit |
022b05 |
ORGANIZATION "IETF RDBMSMIB Working Group"
|
|
Packit |
022b05 |
CONTACT-INFO
|
|
Packit |
022b05 |
" David Brower
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
Postal: The ASK Group, INGRES DBMS Development
|
|
Packit |
022b05 |
1080 Marina Village Parkway
|
|
Packit |
022b05 |
Alameda, CA 94501
|
|
Packit |
022b05 |
US
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
Tel: +1 510 748 3418
|
|
Packit |
022b05 |
Fax: +1 510 748 2770
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
E-mail: daveb@ingres.com"
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The MIB module to describe objects for generic relational
|
|
Packit |
022b05 |
databases."
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
::= { mib-2 39 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsObjects OBJECT IDENTIFIER ::= { rdbmsMIB 1 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
----------------------------------------------------------------
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbTable OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX SEQUENCE OF RdbmsDbEntry
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The table of databases installed on a system."
|
|
Packit |
022b05 |
::= { rdbmsObjects 1 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbEntry OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX RdbmsDbEntry
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"An entry for a single database on the host. Whether a
|
|
Packit |
022b05 |
particular database is represented by a row in rdbmsDbTable
|
|
Packit |
022b05 |
may be dependent on the activity level of that database,
|
|
Packit |
022b05 |
according to the product's implementation. An instance of
|
|
Packit |
022b05 |
rdbmsRelState having the value active, other, or restricted
|
|
Packit |
022b05 |
implies that an entry, corresponding to that instance, will
|
|
Packit |
022b05 |
be present."
|
|
Packit |
022b05 |
INDEX { rdbmsDbIndex }
|
|
Packit |
022b05 |
::= { rdbmsDbTable 1 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
RdbmsDbEntry ::=
|
|
Packit |
022b05 |
SEQUENCE {
|
|
Packit |
022b05 |
rdbmsDbIndex INTEGER,
|
|
Packit |
022b05 |
rdbmsDbPrivateMibOID OBJECT IDENTIFIER,
|
|
Packit |
022b05 |
rdbmsDbVendorName DisplayString,
|
|
Packit |
022b05 |
rdbmsDbName DisplayString,
|
|
Packit |
022b05 |
rdbmsDbContact DisplayString
|
|
Packit |
022b05 |
}
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbIndex OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX INTEGER (1..2147483647)
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"A numeric index, unique among all the databases from all
|
|
Packit |
022b05 |
products on this host. This value is a surrogate for the
|
|
Packit |
022b05 |
conceptually unique key, which is {PrivateMibOID,
|
|
Packit |
022b05 |
databasename}"
|
|
Packit |
022b05 |
::= { rdbmsDbEntry 1 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbPrivateMibOID OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX OBJECT IDENTIFIER
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The authoritative identification for the private MIB for
|
|
Packit |
022b05 |
this database, presumably based on the vendor, e.g., {
|
|
Packit |
022b05 |
enterprises 111 <optional subidentifiers>} for Oracle
|
|
Packit |
022b05 |
databases, {enterprises 757 <optional subidentifiers>} for
|
|
Packit |
022b05 |
Ingres databases, { enterprises 897
|
|
Packit |
022b05 |
subidentifiers>} for Sybase databases, etc.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
If no OBJECT IDENTIFIER exists for the private MIB, attempts
|
|
Packit |
022b05 |
to access this object will return noSuchName (SNMPv1)
|
|
Packit |
022b05 |
or noSuchInstance (SNMPv2)."
|
|
Packit |
022b05 |
::= { rdbmsDbEntry 2 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbVendorName OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX DisplayString
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The name of the vendor whose RDBMS manages this database,
|
|
Packit |
022b05 |
for informational purposes."
|
|
Packit |
022b05 |
::= { rdbmsDbEntry 3 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbName OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX DisplayString
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The name of this database, in a product specific format. The
|
|
Packit |
022b05 |
product may need to qualify the name in some way to resolve
|
|
Packit |
022b05 |
conflicts if it is possible for a database name to be
|
|
Packit |
022b05 |
duplicated on a host. It might be necessary to construct a
|
|
Packit |
022b05 |
hierarchical name embedding the RDBMS instance/installation
|
|
Packit |
022b05 |
on the host, and/or the owner of the database. For instance,
|
|
Packit |
022b05 |
'/test-installation/database-owner/database-name'."
|
|
Packit |
022b05 |
::= { rdbmsDbEntry 4 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbContact OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX DisplayString
|
|
Packit |
022b05 |
MAX-ACCESS read-write
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The textual identification of the contact person for this
|
|
Packit |
022b05 |
managed database, together with information on how to contact
|
|
Packit |
022b05 |
this person.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
Note: if there is no server associated with this database, an
|
|
Packit |
022b05 |
agent may need to keep this in other persistent storage,
|
|
Packit |
022b05 |
e.g., a configuration file.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
Note that a compliant agent does not need to
|
|
Packit |
022b05 |
allow write access to this object."
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
::= { rdbmsDbEntry 5 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
----------------------------------------------------------------
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbInfoTable OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX SEQUENCE OF RdbmsDbInfoEntry
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The table of additional information about databases present
|
|
Packit |
022b05 |
on the host."
|
|
Packit |
022b05 |
::= { rdbmsObjects 2 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbInfoEntry OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX RdbmsDbInfoEntry
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"Information that must be present if the database is actively
|
|
Packit |
022b05 |
opened. If the database is not actively opened, then
|
|
Packit |
022b05 |
attempts to access corresponding instances in this table may
|
|
Packit |
022b05 |
result in either noSuchName (SNMPv1) or noSuchInstance
|
|
Packit |
022b05 |
(SNMPv2). 'Actively opened' means at least one of the
|
|
Packit |
022b05 |
rdbmsRelState entries for this database in the rdbmsRelTable
|
|
Packit |
022b05 |
is active(2)."
|
|
Packit |
022b05 |
INDEX { rdbmsDbIndex }
|
|
Packit |
022b05 |
::= { rdbmsDbInfoTable 1 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
RdbmsDbInfoEntry ::=
|
|
Packit |
022b05 |
SEQUENCE {
|
|
Packit |
022b05 |
rdbmsDbInfoProductName DisplayString,
|
|
Packit |
022b05 |
rdbmsDbInfoVersion DisplayString,
|
|
Packit |
022b05 |
rdbmsDbInfoSizeUnits INTEGER,
|
|
Packit |
022b05 |
rdbmsDbInfoSizeAllocated INTEGER,
|
|
Packit |
022b05 |
rdbmsDbInfoSizeUsed INTEGER,
|
|
Packit |
022b05 |
rdbmsDbInfoLastBackup DateAndTime
|
|
Packit |
022b05 |
}
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbInfoProductName OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX DisplayString
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The textual product name of the server that created or last
|
|
Packit |
022b05 |
restructured this database. The format is product specific."
|
|
Packit |
022b05 |
::= { rdbmsDbInfoEntry 1 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbInfoVersion OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX DisplayString
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The version number of the server that created or last
|
|
Packit |
022b05 |
restructured this database. The format is product specific."
|
|
Packit |
022b05 |
::= { rdbmsDbInfoEntry 2 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbInfoSizeUnits OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX INTEGER {
|
|
Packit |
022b05 |
bytes(1),
|
|
Packit |
022b05 |
kbytes(2),
|
|
Packit |
022b05 |
mbytes(3),
|
|
Packit |
022b05 |
gbytes(4),
|
|
Packit |
022b05 |
tbytes(5)
|
|
Packit |
022b05 |
}
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"Identification of the units used to measure the size of this
|
|
Packit |
022b05 |
database in rdbmsDbInfoSizeAllocated and rdbmsDbInfoSizeUsed.
|
|
Packit |
022b05 |
bytes(1) indicates individual bytes, kbytes(2) indicates
|
|
Packit |
022b05 |
units of kilobytes, mbytes(3) indicates units of megabytes,
|
|
Packit |
022b05 |
gbytes(4) indicates units of gigabytes, and tbytes(5)
|
|
Packit |
022b05 |
indicates units of terabytes. All are binary multiples -- 1K
|
|
Packit |
022b05 |
= 1024. If writable, changes here are reflected in the get
|
|
Packit |
022b05 |
values of the associated objects."
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
::= { rdbmsDbInfoEntry 3 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbInfoSizeAllocated OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX INTEGER (1..2147483647)
|
|
Packit |
022b05 |
MAX-ACCESS read-write
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The estimated size of this database (in
|
|
Packit |
022b05 |
rdbmsDbInfoSizeUnits), which is the disk space that has been
|
|
Packit |
022b05 |
allocated to it and is no longer available to users on this
|
|
Packit |
022b05 |
host. rdbmsDbInfoSize does not necessarily indicate the
|
|
Packit |
022b05 |
amount of space actually in use for database data. Some
|
|
Packit |
022b05 |
databases may support extending allocated size, and others
|
|
Packit |
022b05 |
may not.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
Note that a compliant agent does not need to
|
|
Packit |
022b05 |
allow write access to this object."
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
-- Note: computing SizeAllocated may be expensive, and SNMP
|
|
Packit |
022b05 |
-- agents might cache the value to increase performance.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
::= { rdbmsDbInfoEntry 4 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbInfoSizeUsed OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX INTEGER (1..2147483647)
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The estimated size of this database, in rdbmsDbInfoSizeUnits,
|
|
Packit |
022b05 |
which is actually in use for database data."
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
-- Note: computing SizeUsed may be expensive, and SNMP
|
|
Packit |
022b05 |
-- agents might cache the value to increase performance.
|
|
Packit |
022b05 |
::= { rdbmsDbInfoEntry 5 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbInfoLastBackup OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX DateAndTime
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The date and time that the latest complete or partial backup
|
|
Packit |
022b05 |
of the database was taken. If a database has never been
|
|
Packit |
022b05 |
backed up, then attempts to access this object will
|
|
Packit |
022b05 |
result in either noSuchName (SNMPv1) or noSuchInstance
|
|
Packit |
022b05 |
(SNMPv2)."
|
|
Packit |
022b05 |
::= { rdbmsDbInfoEntry 6 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
----------------------------------------------------------------
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbParamTable OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX SEQUENCE OF RdbmsDbParamEntry
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The table of configuration parameters for a database.
|
|
Packit |
022b05 |
Entries should be populated according to the following
|
|
Packit |
022b05 |
guidelines:
|
|
Packit |
022b05 |
(1) The value should be specified through administrative
|
|
Packit |
022b05 |
(human) intervention.
|
|
Packit |
022b05 |
(2) It should be configured on a per-database basis.
|
|
Packit |
022b05 |
(3) One of the following is true:
|
|
Packit |
022b05 |
(a) The parameter has a non-numeric value;
|
|
Packit |
022b05 |
(b) The current value is numeric, but it only changes due
|
|
Packit |
022b05 |
to human intervention;
|
|
Packit |
022b05 |
(c) The current value is numeric and dynamic, but the
|
|
Packit |
022b05 |
RDBMS does not track access/allocation failures
|
|
Packit |
022b05 |
related to the parameter;
|
|
Packit |
022b05 |
(d) The current value is numeric and dynamic, the
|
|
Packit |
022b05 |
RDBMS tracks changes in access/allocation failures
|
|
Packit |
022b05 |
related to the parameter, but the failure has no
|
|
Packit |
022b05 |
significant impact on RDBMS performance or
|
|
Packit |
022b05 |
availability.
|
|
Packit |
022b05 |
(e) The current value is numeric and dynamic, the
|
|
Packit |
022b05 |
RDBMS tracks changes in access/allocation failures
|
|
Packit |
022b05 |
related to the parameter, the failure has
|
|
Packit |
022b05 |
significant impact on RDBMS performance or
|
|
Packit |
022b05 |
availability, and is shown in the
|
|
Packit |
022b05 |
rdbmsDbLimitedResource table."
|
|
Packit |
022b05 |
::= { rdbmsObjects 3 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbParamEntry OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX RdbmsDbParamEntry
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"An entry for a single configuration parameter for a database.
|
|
Packit |
022b05 |
Parameters with single values have a subindex value of one.
|
|
Packit |
022b05 |
If the parameter is naturally considered to contain a
|
|
Packit |
022b05 |
variable number of members of a class, e.g. members of the
|
|
Packit |
022b05 |
DBA user group, or files which are part of the database, then
|
|
Packit |
022b05 |
it must be presented as a set of rows. If, on the other
|
|
Packit |
022b05 |
hand, the parameter represents a set of choices from a class,
|
|
Packit |
022b05 |
e.g. the permissions on a file or the options chosen out of
|
|
Packit |
022b05 |
the set of all options allowed, AND is guaranteed to always
|
|
Packit |
022b05 |
fit in the 255 character length of a DisplayString, then it
|
|
Packit |
022b05 |
may be presented as a comma separated list with a subindex
|
|
Packit |
022b05 |
value of one. Zero may not be used as a subindex value.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
If the database is not actively opened, then attempts
|
|
Packit |
022b05 |
to access corresponding instances in this table may result in
|
|
Packit |
022b05 |
either noSuchName (SNMPv1) or noSuchInstance (SNMPv2).
|
|
Packit |
022b05 |
'Actively opened' means at least one of the
|
|
Packit |
022b05 |
rdbmsRelState entries for this database in the rdbmsRelTable
|
|
Packit |
022b05 |
is active(2)."
|
|
Packit |
022b05 |
INDEX { rdbmsDbIndex, rdbmsDbParamName, rdbmsDbParamSubIndex }
|
|
Packit |
022b05 |
::= { rdbmsDbParamTable 1 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
RdbmsDbParamEntry ::=
|
|
Packit |
022b05 |
SEQUENCE {
|
|
Packit |
022b05 |
rdbmsDbParamName DisplayString,
|
|
Packit |
022b05 |
rdbmsDbParamSubIndex INTEGER,
|
|
Packit |
022b05 |
rdbmsDbParamID AutonomousType,
|
|
Packit |
022b05 |
rdbmsDbParamCurrValue DisplayString,
|
|
Packit |
022b05 |
rdbmsDbParamComment DisplayString
|
|
Packit |
022b05 |
}
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbParamName OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX DisplayString (SIZE (1..64))
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The name of a configuration parameter for a database. This
|
|
Packit |
022b05 |
name is product-specific. The length is limited to 64
|
|
Packit |
022b05 |
characters to constrain the number of sub-identifiers needed
|
|
Packit |
022b05 |
for instance identification (and to minimize network
|
|
Packit |
022b05 |
traffic)."
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
::= { rdbmsDbParamEntry 1 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbParamSubIndex OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX INTEGER (1..2147483647)
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The subindex value for this parameter. If the parameter is
|
|
Packit |
022b05 |
naturally considered to contain a variable number of members
|
|
Packit |
022b05 |
of a class, e.g. members of the DBA user group, or files
|
|
Packit |
022b05 |
which are part of the database, then it must be presented as
|
|
Packit |
022b05 |
a set of rows. If, on the other hand, the parameter
|
|
Packit |
022b05 |
represents a set of choices from a class, e.g. the
|
|
Packit |
022b05 |
permissions on a file or the options chosen out of the set of
|
|
Packit |
022b05 |
all options allowed, AND is guaranteed to always fit in the
|
|
Packit |
022b05 |
255 character length of a DisplayString, then it may be
|
|
Packit |
022b05 |
presented as a comma separated list with a subindex value of
|
|
Packit |
022b05 |
one. Zero may not be used as a value."
|
|
Packit |
022b05 |
::= { rdbmsDbParamEntry 2 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbParamID OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX AutonomousType
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The ID of the parameter which may be described in some other
|
|
Packit |
022b05 |
MIB (e.g., an enterprise-specific MIB module). If there is
|
|
Packit |
022b05 |
no ID for this rdbmsDbParamName, attempts to access this
|
|
Packit |
022b05 |
object will return noSuchName (SNMPv1) or noSuchInstance
|
|
Packit |
022b05 |
(SNMPv2)."
|
|
Packit |
022b05 |
::= { rdbmsDbParamEntry 3 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbParamCurrValue OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX DisplayString
|
|
Packit |
022b05 |
MAX-ACCESS read-write
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The value for a configuration parameter now in effect, the
|
|
Packit |
022b05 |
actual setting for the database. While there may multiple
|
|
Packit |
022b05 |
values in the temporal domain of interest (for instance, the
|
|
Packit |
022b05 |
value to take effect at the next restart), this is the
|
|
Packit |
022b05 |
current setting.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
Note that a compliant agent does not need to
|
|
Packit |
022b05 |
allow write access to this object."
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
::= { rdbmsDbParamEntry 4 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbParamComment OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX DisplayString
|
|
Packit |
022b05 |
MAX-ACCESS read-write
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"Annotation which describes the purpose of a configuration
|
|
Packit |
022b05 |
parameter or the reason for a particular parameter's
|
|
Packit |
022b05 |
setting.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
Note that a compliant agent does not need to
|
|
Packit |
022b05 |
allow write access to this object."
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
::= { rdbmsDbParamEntry 5 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
----------------------------------------------------------------
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbLimitedResourceTable OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX SEQUENCE OF RdbmsDbLimitedResourceEntry
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The table of limited resources that are kept per-database."
|
|
Packit |
022b05 |
::= { rdbmsObjects 4 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbLimitedResourceEntry OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX RdbmsDbLimitedResourceEntry
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"An entry for a single limited resource kept per-database.
|
|
Packit |
022b05 |
A limited resource has maximum use determined by a parameter
|
|
Packit |
022b05 |
that might or might not be changeable at run time, or visible
|
|
Packit |
022b05 |
in the rdbmsDbParamTable. Examples would be the number of
|
|
Packit |
022b05 |
available locks, or disk space on a partition. Arrays of
|
|
Packit |
022b05 |
resources are supported through an integer sub index, which
|
|
Packit |
022b05 |
should have the value of one for single-instance names.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
Limited resources that are shared across databases, are best
|
|
Packit |
022b05 |
put in the rdbmsSvrLimitedResourceTable instead of this one.
|
|
Packit |
022b05 |
If the database is not actively opened, then attempts to
|
|
Packit |
022b05 |
access corresponding instances in this table may result in
|
|
Packit |
022b05 |
either noSuchName (SNMPv1) or noSuchInstance (SNMPv2).
|
|
Packit |
022b05 |
'Actively opened' means at least one of the rdbmsRelState
|
|
Packit |
022b05 |
entries for this database in the rdbmsRelTable is active(2)."
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
INDEX { rdbmsDbIndex, rdbmsDbLimitedResourceName }
|
|
Packit |
022b05 |
::= { rdbmsDbLimitedResourceTable 1 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
RdbmsDbLimitedResourceEntry ::=
|
|
Packit |
022b05 |
SEQUENCE {
|
|
Packit |
022b05 |
rdbmsDbLimitedResourceName DisplayString,
|
|
Packit |
022b05 |
rdbmsDbLimitedResourceID AutonomousType,
|
|
Packit |
022b05 |
rdbmsDbLimitedResourceLimit INTEGER,
|
|
Packit |
022b05 |
rdbmsDbLimitedResourceCurrent INTEGER,
|
|
Packit |
022b05 |
rdbmsDbLimitedResourceHighwater INTEGER,
|
|
Packit |
022b05 |
rdbmsDbLimitedResourceFailures Counter32,
|
|
Packit |
022b05 |
rdbmsDbLimitedResourceDescription DisplayString
|
|
Packit |
022b05 |
}
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbLimitedResourceName OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX DisplayString
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The name of the resource, for instance 'global locks' or
|
|
Packit |
022b05 |
'locks for the FOO database', or 'data space on /dev/rdsk/5s0
|
|
Packit |
022b05 |
for FOO'. The length is limited to 64 characters to constrain
|
|
Packit |
022b05 |
the number of sub-identifiers needed for instance
|
|
Packit |
022b05 |
identification (and to minimize network traffic)."
|
|
Packit |
022b05 |
::= { rdbmsDbLimitedResourceEntry 1 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbLimitedResourceID OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX AutonomousType
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The ID of the resource which may be described in some other
|
|
Packit |
022b05 |
MIB (e.g., an enterprise-specific MIB module). If there is
|
|
Packit |
022b05 |
no ID for this rdbmsDbLimitedResourceName, attempts to access
|
|
Packit |
022b05 |
this object will return noSuchName (SNMPv1) or noSuchInstance
|
|
Packit |
022b05 |
(SNMPv2)."
|
|
Packit |
022b05 |
::= { rdbmsDbLimitedResourceEntry 2 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbLimitedResourceLimit OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX INTEGER (1..2147483647)
|
|
Packit |
022b05 |
MAX-ACCESS read-write
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The maximum value the resource use may attain.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
Note that a compliant agent does not need to
|
|
Packit |
022b05 |
allow write access to this object."
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
::= { rdbmsDbLimitedResourceEntry 3 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbLimitedResourceCurrent OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX INTEGER (1..2147483647)
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The current value for the resource."
|
|
Packit |
022b05 |
::= { rdbmsDbLimitedResourceEntry 4 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbLimitedResourceHighwater OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX INTEGER (1..2147483647)
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The maximum value of the resource seen since applUpTime
|
|
Packit |
022b05 |
was reset for the earliest server which has the database
|
|
Packit |
022b05 |
actively opened.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
If there are two servers with the database open, and the
|
|
Packit |
022b05 |
oldest one dies, the proper way to invalidate the value is by
|
|
Packit |
022b05 |
resetting sysUpTime."
|
|
Packit |
022b05 |
::= { rdbmsDbLimitedResourceEntry 5 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbLimitedResourceFailures OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX Counter32
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The number of times the system wanted to exceed the limit of
|
|
Packit |
022b05 |
the resource since applUpTime was reset for the earliest
|
|
Packit |
022b05 |
server which has the database actively opened.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
If there are two servers with the DB open, and the
|
|
Packit |
022b05 |
oldest one dies, the proper way to invalidate the value is by
|
|
Packit |
022b05 |
resetting sysUpTime."
|
|
Packit |
022b05 |
::= { rdbmsDbLimitedResourceEntry 6 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbLimitedResourceDescription OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX DisplayString
|
|
Packit |
022b05 |
MAX-ACCESS read-write
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"A description of the resource and the meaning of the integer
|
|
Packit |
022b05 |
units used for Limit, Current, and Highwater.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
Note that a compliant agent does not need to
|
|
Packit |
022b05 |
allow write access to this object."
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
::= { rdbmsDbLimitedResourceEntry 7 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
----------------------------------------------------------------
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvTable OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX SEQUENCE OF RdbmsSrvEntry
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The table of database servers running or installed
|
|
Packit |
022b05 |
on a system."
|
|
Packit |
022b05 |
::= { rdbmsObjects 5 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvEntry OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX RdbmsSrvEntry
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"An entry for a single database server. A server is an
|
|
Packit |
022b05 |
independent entity that provides access to one or more
|
|
Packit |
022b05 |
databases. Failure of one does not affect access to
|
|
Packit |
022b05 |
databases through any other servers. There might be one or
|
|
Packit |
022b05 |
more servers providing access to a database. A server may be
|
|
Packit |
022b05 |
a 'process' or collection of 'processes', as interpreted by
|
|
Packit |
022b05 |
the product."
|
|
Packit |
022b05 |
INDEX { applIndex }
|
|
Packit |
022b05 |
::= { rdbmsSrvTable 1 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
RdbmsSrvEntry ::=
|
|
Packit |
022b05 |
SEQUENCE {
|
|
Packit |
022b05 |
rdbmsSrvPrivateMibOID OBJECT IDENTIFIER,
|
|
Packit |
022b05 |
rdbmsSrvVendorName DisplayString,
|
|
Packit |
022b05 |
rdbmsSrvProductName DisplayString,
|
|
Packit |
022b05 |
rdbmsSrvContact DisplayString
|
|
Packit |
022b05 |
}
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvPrivateMibOID OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX OBJECT IDENTIFIER
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The authoritative identification for the private MIB for this
|
|
Packit |
022b05 |
server, presumably based on the vendor, e.g., { enterprises
|
|
Packit |
022b05 |
111 <optional subidentifiers>} for Oracle servers, {
|
|
Packit |
022b05 |
enterprises 757 <optional subidentifiers>} for Ingres
|
|
Packit |
022b05 |
servers, { enterprises 897 <optional subidentifiers>} for
|
|
Packit |
022b05 |
Sybase servers, etc.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
If no OBJECT IDENTIFIER exists for the private MIB, attempts
|
|
Packit |
022b05 |
to access this object will return noSuchName (SNMPv1)
|
|
Packit |
022b05 |
or noSuchInstance (SNMPv2)."
|
|
Packit |
022b05 |
::= { rdbmsSrvEntry 1 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvVendorName OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX DisplayString
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The name of the vendor whose RDBMS manages this database,
|
|
Packit |
022b05 |
for informational purposes."
|
|
Packit |
022b05 |
::= { rdbmsSrvEntry 2 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvProductName OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX DisplayString
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The product name of this server. This is normally the
|
|
Packit |
022b05 |
vendor's formal name for the product, in product specific
|
|
Packit |
022b05 |
format."
|
|
Packit |
022b05 |
::= { rdbmsSrvEntry 3 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvContact OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX DisplayString
|
|
Packit |
022b05 |
MAX-ACCESS read-write
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The textual identification of the contact person for this
|
|
Packit |
022b05 |
managed server, together with information on how to contact
|
|
Packit |
022b05 |
this person.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
Note: if there is no active server associated with this
|
|
Packit |
022b05 |
object, an agent may need to keep this in other persistent
|
|
Packit |
022b05 |
storage, e.g., a configuration file.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
Note that a compliant agent does not need to
|
|
Packit |
022b05 |
allow write access to this object."
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
::= { rdbmsSrvEntry 4 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
----------------------------------------------------------------
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvInfoTable OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX SEQUENCE OF RdbmsSrvInfoEntry
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The table of additional information about database servers.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
Entries in this table correspond to applications in the
|
|
Packit |
022b05 |
NETWORK-SERVICES-MIB applTable. Some objects in that table are
|
|
Packit |
022b05 |
application-specific. When they are associated with an RDBMS
|
|
Packit |
022b05 |
server in this table, the objects have the following
|
|
Packit |
022b05 |
meanings.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
applName - The name of this server, i.e., the process or
|
|
Packit |
022b05 |
group of processes providing access to this database. The
|
|
Packit |
022b05 |
exact format will be product and host specific.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
applVersion - The version number of this server, in product
|
|
Packit |
022b05 |
specific format.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
applOperStatus - up(1) means operational and available for
|
|
Packit |
022b05 |
general use. down(2) means the server is not available for
|
|
Packit |
022b05 |
use, but is known to the agent. The other states have broad
|
|
Packit |
022b05 |
meaning, and may need to be supplemented by the vendor
|
|
Packit |
022b05 |
private MIB. Halted(3) implies an administrative state of
|
|
Packit |
022b05 |
unavailability. Congested(4) implies a resource or or
|
|
Packit |
022b05 |
administrative limit is prohibiting new inbound associations.
|
|
Packit |
022b05 |
The 'available soon' description of restarting(5) may include
|
|
Packit |
022b05 |
an indeterminate amount of recovery.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
applLastChange is the time the agent noticed the most recent
|
|
Packit |
022b05 |
change to applOperStatus.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
applInboundAssociation is the number of currently active
|
|
Packit |
022b05 |
local and remote conversations (usually SQL connects).
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
applOutboundAssociations is not provided by this MIB.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
applAccumulatedInboundAssociations is the total number of
|
|
Packit |
022b05 |
local and remote conversations started since the server came
|
|
Packit |
022b05 |
up.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
applAccumulatedOutbound associations is not provided by this
|
|
Packit |
022b05 |
MIB.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
applLastInboundActivity is the time the most recent local or
|
|
Packit |
022b05 |
remote conversation was attempted or disconnected.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
applLastOutboundActivity is not provided by this MIB.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
applRejectedInboundAssociations is the number of local or
|
|
Packit |
022b05 |
remote conversations rejected by the server for
|
|
Packit |
022b05 |
administrative reasons or because of resource limitations.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
applFailedOutboundAssociations is not provided by this MIB."
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
::= { rdbmsObjects 6 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvInfoEntry OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX RdbmsSrvInfoEntry
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"Information that must be present for a single 'up' database
|
|
Packit |
022b05 |
server, with visibility determined by the value of the
|
|
Packit |
022b05 |
corresponding applOperStatus object. If an instance of
|
|
Packit |
022b05 |
applOperStatus is not up(1), then attempts to access
|
|
Packit |
022b05 |
corresponding instances in this table may result in either
|
|
Packit |
022b05 |
noSuchName (SNMPv1) or noSuchInstance (SNMPv2) being returned
|
|
Packit |
022b05 |
by the agent."
|
|
Packit |
022b05 |
INDEX { applIndex }
|
|
Packit |
022b05 |
::= { rdbmsSrvInfoTable 1 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
RdbmsSrvInfoEntry ::=
|
|
Packit |
022b05 |
SEQUENCE {
|
|
Packit |
022b05 |
rdbmsSrvInfoStartupTime DateAndTime,
|
|
Packit |
022b05 |
rdbmsSrvInfoFinishedTransactions Gauge32,
|
|
Packit |
022b05 |
rdbmsSrvInfoDiskReads Counter32,
|
|
Packit |
022b05 |
rdbmsSrvInfoDiskWrites Counter32,
|
|
Packit |
022b05 |
rdbmsSrvInfoLogicalReads Counter32,
|
|
Packit |
022b05 |
rdbmsSrvInfoLogicalWrites Counter32,
|
|
Packit |
022b05 |
rdbmsSrvInfoPageWrites Counter32,
|
|
Packit |
022b05 |
rdbmsSrvInfoPageReads Counter32,
|
|
Packit |
022b05 |
rdbmsSrvInfoDiskOutOfSpaces Counter32,
|
|
Packit |
022b05 |
rdbmsSrvInfoHandledRequests Counter32,
|
|
Packit |
022b05 |
rdbmsSrvInfoRequestRecvs Counter32,
|
|
Packit |
022b05 |
rdbmsSrvInfoRequestSends Counter32,
|
|
Packit |
022b05 |
rdbmsSrvInfoHighwaterInboundAssociations Gauge32,
|
|
Packit |
022b05 |
rdbmsSrvInfoMaxInboundAssociations Gauge32
|
|
Packit |
022b05 |
}
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvInfoStartupTime OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX DateAndTime
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The date and time at which this server was last started."
|
|
Packit |
022b05 |
::= { rdbmsSrvInfoEntry 1 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvInfoFinishedTransactions OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX Gauge32
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The number of transactions visible to this server that have
|
|
Packit |
022b05 |
been completed by either commit or abort. Some database
|
|
Packit |
022b05 |
operations, such as read-only queries, may not result in the
|
|
Packit |
022b05 |
creation of a transaction."
|
|
Packit |
022b05 |
::= { rdbmsSrvInfoEntry 2 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvInfoDiskReads OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX Counter32
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The total number of reads of database files issued to the
|
|
Packit |
022b05 |
operating system by this server since startup. Numbers are
|
|
Packit |
022b05 |
not comparable between products. What constitutes a
|
|
Packit |
022b05 |
readand how it is accounted is product-specific."
|
|
Packit |
022b05 |
::= { rdbmsSrvInfoEntry 3 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvInfoLogicalReads OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX Counter32
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The total number of logical reads of database files made
|
|
Packit |
022b05 |
internally by this server since startup. The values of this
|
|
Packit |
022b05 |
object and those of rdbmsSrvInfoDiskReads reveal the effect
|
|
Packit |
022b05 |
of caching on read operation. Numbers are not comparable
|
|
Packit |
022b05 |
between products, and may only be meaningful when aggregated
|
|
Packit |
022b05 |
across all servers sharing a common cache."
|
|
Packit |
022b05 |
::= { rdbmsSrvInfoEntry 4 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvInfoDiskWrites OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX Counter32
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The total number of writes to database files issued to the
|
|
Packit |
022b05 |
operating system by this server since startup. Numbers are
|
|
Packit |
022b05 |
not comparable between products."
|
|
Packit |
022b05 |
::= { rdbmsSrvInfoEntry 5 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvInfoLogicalWrites OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX Counter32
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The total number of times parts of the database files have
|
|
Packit |
022b05 |
been marked 'dirty' and in need of writing to the disk. This
|
|
Packit |
022b05 |
value and rdbmsSrvInfoDiskWrites give some indication of the
|
|
Packit |
022b05 |
effect of 'write-behind' strategies in reducing the number of
|
|
Packit |
022b05 |
disk writes compared to database operations. Because the
|
|
Packit |
022b05 |
writes may be done by servers other than those marking the
|
|
Packit |
022b05 |
parts of the database files dirty, these values may only be
|
|
Packit |
022b05 |
meaningful when aggregated across all servers sharing a
|
|
Packit |
022b05 |
common cache. Numbers are not comparable between products."
|
|
Packit |
022b05 |
::= { rdbmsSrvInfoEntry 6 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvInfoPageReads OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX Counter32
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The total number of pages in database files read by this
|
|
Packit |
022b05 |
server since startup. 'Pages' are product specific units of
|
|
Packit |
022b05 |
disk i/o operations. This value, along with
|
|
Packit |
022b05 |
rdbmsSrvInfoDiskReads, reveals the effect of any grouping
|
|
Packit |
022b05 |
read-ahead that may be used to enhance performance of some
|
|
Packit |
022b05 |
queries, such as scans."
|
|
Packit |
022b05 |
::= { rdbmsSrvInfoEntry 7}
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvInfoPageWrites OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX Counter32
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The total number of pages in database files written by this
|
|
Packit |
022b05 |
server since startup. Pages are product-specific units of
|
|
Packit |
022b05 |
disk I/O. This value, with rdbmsSrvInfoDiskWrites, shows the
|
|
Packit |
022b05 |
effect of write strategies that collapse logical writes of
|
|
Packit |
022b05 |
contiguous pages into single calls to the operating system."
|
|
Packit |
022b05 |
::= { rdbmsSrvInfoEntry 8 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvInfoDiskOutOfSpaces OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX Counter32
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The total number of times the server has been unable to
|
|
Packit |
022b05 |
obtain disk space that it wanted, since server startup. This
|
|
Packit |
022b05 |
would be inspected by an agent on receipt of an
|
|
Packit |
022b05 |
rdbmsOutOfSpace trap."
|
|
Packit |
022b05 |
::= { rdbmsSrvInfoEntry 9 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvInfoHandledRequests OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX Counter32
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The total number of requests made to the server on inbound
|
|
Packit |
022b05 |
associations. The meaning of 'requests' is product specific,
|
|
Packit |
022b05 |
and is not comparable between products.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
This is intended to encapsulate high level semantic
|
|
Packit |
022b05 |
operations between clients and servers, or between peers.
|
|
Packit |
022b05 |
For instance, one request might correspond to a 'select' or
|
|
Packit |
022b05 |
an 'insert' statement. It is not intended to capture disk
|
|
Packit |
022b05 |
i/o described in rdbmsSrvInfoDiskReads and
|
|
Packit |
022b05 |
rdbmsSrvInfoDiskWrites."
|
|
Packit |
022b05 |
::= { rdbmsSrvInfoEntry 10 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvInfoRequestRecvs OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX Counter32
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The number of receive operations made processing any requests
|
|
Packit |
022b05 |
on inbound associations. The meaning of operations is product
|
|
Packit |
022b05 |
specific, and is not comparable between products.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
This is intended to capture lower-level i/o operations than
|
|
Packit |
022b05 |
shown by HandledRequests, between clients and servers, or
|
|
Packit |
022b05 |
between peers. For instance, it might roughly correspond to
|
|
Packit |
022b05 |
the amount of data given with an 'insert' statement. It is
|
|
Packit |
022b05 |
not intended to capture disk i/o described in
|
|
Packit |
022b05 |
rdbmsSrvInfoDiskReads and rdbmsSrvInfoDiskWrites."
|
|
Packit |
022b05 |
::= { rdbmsSrvInfoEntry 11 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvInfoRequestSends OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX Counter32
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The number of send operations made processing requests
|
|
Packit |
022b05 |
handled on inbound associations. The meaning of operations
|
|
Packit |
022b05 |
is product specific, and is not comparable between products.
|
|
Packit |
022b05 |
This is intended to capture lower-level i/o operations than
|
|
Packit |
022b05 |
shown by HandledRequests, between between clients and
|
|
Packit |
022b05 |
servers, or between peers. It might roughly correspond to
|
|
Packit |
022b05 |
the number of rows returned by a 'select' statement. It is
|
|
Packit |
022b05 |
not intended to capture disk i/o described in DiskReads."
|
|
Packit |
022b05 |
::= { rdbmsSrvInfoEntry 12 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvInfoHighwaterInboundAssociations OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX Gauge32
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The greatest number of inbound associations that have been
|
|
Packit |
022b05 |
simultaneously open to this server since startup."
|
|
Packit |
022b05 |
::= { rdbmsSrvInfoEntry 13 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvInfoMaxInboundAssociations OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX Gauge32
|
|
Packit |
022b05 |
MAX-ACCESS read-write
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The greatest number of inbound associations that can be
|
|
Packit |
022b05 |
simultaneously open with this server. If there is no limit,
|
|
Packit |
022b05 |
then the value should be zero.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
Note that a compliant agent does not need to
|
|
Packit |
022b05 |
allow write access to this object."
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
::= { rdbmsSrvInfoEntry 14 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
----------------------------------------------------------------
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvParamTable OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX SEQUENCE OF RdbmsSrvParamEntry
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The table of configuration parameters for a server. Entries
|
|
Packit |
022b05 |
should be populated according to the following guidelines:
|
|
Packit |
022b05 |
(1) The value should be specified through administrative
|
|
Packit |
022b05 |
(human) intervention.
|
|
Packit |
022b05 |
(2) It should be configured on a per-server or a more global
|
|
Packit |
022b05 |
basis, with duplicate entries for each server sharing
|
|
Packit |
022b05 |
use of the parameter.
|
|
Packit |
022b05 |
(3) One of the following is true:
|
|
Packit |
022b05 |
(a) The parameter has a non-numeric value;
|
|
Packit |
022b05 |
(b) The current value is numeric, but it only changes due
|
|
Packit |
022b05 |
to human intervention;
|
|
Packit |
022b05 |
(c) The current value is numeric and dynamic, but the
|
|
Packit |
022b05 |
RDBMS does not track access/allocation failures
|
|
Packit |
022b05 |
related to the parameter;
|
|
Packit |
022b05 |
(d) The current value is numeric and dynamic, the
|
|
Packit |
022b05 |
RDBMS tracks changes in access/allocation failures
|
|
Packit |
022b05 |
related to the parameter, but the failure has no
|
|
Packit |
022b05 |
significant impact on RDBMS performance or
|
|
Packit |
022b05 |
availability.
|
|
Packit |
022b05 |
(e) The current value is numeric and dynamic, the
|
|
Packit |
022b05 |
RDBMS tracks changes in access/allocation failures
|
|
Packit |
022b05 |
related to the parameter, the failure has
|
|
Packit |
022b05 |
significant impact on RDBMS performance or
|
|
Packit |
022b05 |
availability, and is shown in the
|
|
Packit |
022b05 |
rdbmsSrvLimitedResource table."
|
|
Packit |
022b05 |
::= { rdbmsObjects 7 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvParamEntry OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX RdbmsSrvParamEntry
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"An entry for a single configuration parameter for a server.
|
|
Packit |
022b05 |
Parameters with single values have a subindex value of one.
|
|
Packit |
022b05 |
If the parameter is naturally considered to contain a
|
|
Packit |
022b05 |
variable number of members of a class, e.g. members of the
|
|
Packit |
022b05 |
DBA user group, or tracepoints active in the server, then it
|
|
Packit |
022b05 |
must be presented as a set of rows. If, on the other hand,
|
|
Packit |
022b05 |
the parameter represents a set of choices from a class,
|
|
Packit |
022b05 |
e.g. the permissions on a file or the options chosen out of
|
|
Packit |
022b05 |
the set of all options allowed, AND is guaranteed to always
|
|
Packit |
022b05 |
fit in the 255 character length of a DisplayString, then it
|
|
Packit |
022b05 |
may be presented as a comma separated list with a subindex
|
|
Packit |
022b05 |
value of one. Zero may not be used as a subindex value.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
Entries for a server must be present if the value of the
|
|
Packit |
022b05 |
corresponding applOperStatus object is up(1). If an instance
|
|
Packit |
022b05 |
of applOperStatus is not up(1), then attempts to access
|
|
Packit |
022b05 |
corresponding instances in this table may result in either
|
|
Packit |
022b05 |
noSuchName (SNMPv1) or noSuchInstance (SNMPv2) being returned
|
|
Packit |
022b05 |
by the agent."
|
|
Packit |
022b05 |
INDEX { applIndex, rdbmsSrvParamName, rdbmsSrvParamSubIndex }
|
|
Packit |
022b05 |
::= { rdbmsSrvParamTable 1 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
RdbmsSrvParamEntry ::=
|
|
Packit |
022b05 |
SEQUENCE {
|
|
Packit |
022b05 |
rdbmsSrvParamName DisplayString,
|
|
Packit |
022b05 |
rdbmsSrvParamSubIndex INTEGER,
|
|
Packit |
022b05 |
rdbmsSrvParamID AutonomousType,
|
|
Packit |
022b05 |
rdbmsSrvParamCurrValue DisplayString,
|
|
Packit |
022b05 |
rdbmsSrvParamComment DisplayString
|
|
Packit |
022b05 |
}
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvParamName OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX DisplayString (SIZE (1..64))
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The name of a configuration parameter for a server. This
|
|
Packit |
022b05 |
name is product-specific. The length is limited to 64
|
|
Packit |
022b05 |
characters to constrain the number of sub-identifiers needed
|
|
Packit |
022b05 |
for instance identification (and to minimize network
|
|
Packit |
022b05 |
traffic)."
|
|
Packit |
022b05 |
::= { rdbmsSrvParamEntry 1 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvParamSubIndex OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX INTEGER (1..2147483647)
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The subindex value for this parameter. If the parameter is
|
|
Packit |
022b05 |
naturally considered to contain a variable number of members
|
|
Packit |
022b05 |
of a class, e.g. members of the DBA user group, or files
|
|
Packit |
022b05 |
which are part of the database, then it must be presented as
|
|
Packit |
022b05 |
a set of rows. If, on the other hand, the parameter
|
|
Packit |
022b05 |
represents a set of choices from a class, e.g. the
|
|
Packit |
022b05 |
permissions on a file or the options chosen out of the set of
|
|
Packit |
022b05 |
all options allowed, AND is guaranteed to always fit in the
|
|
Packit |
022b05 |
255 character length of a DisplayString, then it may be
|
|
Packit |
022b05 |
presented as a comma separated list with a subindex value of
|
|
Packit |
022b05 |
one. Zero may not be used as a value."
|
|
Packit |
022b05 |
::= { rdbmsSrvParamEntry 2 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvParamID OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX AutonomousType
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The ID of the parameter which may be described in some
|
|
Packit |
022b05 |
other MIB. If there is no ID for this rdbmsSrvParamName,
|
|
Packit |
022b05 |
attempts to access this object will return noSuchName
|
|
Packit |
022b05 |
(SNMPv1) or noSuchInstance (SNMPv2)."
|
|
Packit |
022b05 |
::= { rdbmsSrvParamEntry 3 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvParamCurrValue OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX DisplayString
|
|
Packit |
022b05 |
MAX-ACCESS read-write
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The value for a configuration parameter now in effect, the
|
|
Packit |
022b05 |
actual setting for the server. While there may multiple
|
|
Packit |
022b05 |
values in the temporal domain of interest (for instance, the
|
|
Packit |
022b05 |
value to take effect at the next restart), this is the
|
|
Packit |
022b05 |
current setting.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
Note that a compliant agent does not need to
|
|
Packit |
022b05 |
allow write access to this object."
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
::= { rdbmsSrvParamEntry 4 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvParamComment OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX DisplayString
|
|
Packit |
022b05 |
MAX-ACCESS read-write
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"Annotation which describes the purpose of a configuration
|
|
Packit |
022b05 |
parameter or the reason for a particular parameter's
|
|
Packit |
022b05 |
setting.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
Note that a compliant agent does not need to
|
|
Packit |
022b05 |
allow write access to this object."
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
::= { rdbmsSrvParamEntry 5 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
----------------------------------------------------------------
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvLimitedResourceTable OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX SEQUENCE OF RdbmsSrvLimitedResourceEntry
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The table of limited resources relevant to a server."
|
|
Packit |
022b05 |
::= { rdbmsObjects 8 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvLimitedResourceEntry OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX RdbmsSrvLimitedResourceEntry
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"An entry for a single limited resource kept by the server.
|
|
Packit |
022b05 |
A limited resource has maximum use determined by a parameter
|
|
Packit |
022b05 |
that might or might not changeable at run time, or visible in
|
|
Packit |
022b05 |
the rbmsSrvParamTable. Examples would be the number of
|
|
Packit |
022b05 |
available locks, or number of concurrent executions allowed
|
|
Packit |
022b05 |
in a server. Arrays of resources are supported through an
|
|
Packit |
022b05 |
integer subindex, which should have the value of one for
|
|
Packit |
022b05 |
single-instance names.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
Limited resources that are shared across servers or databases
|
|
Packit |
022b05 |
are best duplicated in this table across
|
|
Packit |
022b05 |
all servers accessing the resource."
|
|
Packit |
022b05 |
INDEX { applIndex, rdbmsSrvLimitedResourceName }
|
|
Packit |
022b05 |
::= { rdbmsSrvLimitedResourceTable 1 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
RdbmsSrvLimitedResourceEntry ::=
|
|
Packit |
022b05 |
SEQUENCE {
|
|
Packit |
022b05 |
rdbmsSrvLimitedResourceName DisplayString,
|
|
Packit |
022b05 |
rdbmsSrvLimitedResourceID AutonomousType,
|
|
Packit |
022b05 |
rdbmsSrvLimitedResourceLimit INTEGER,
|
|
Packit |
022b05 |
rdbmsSrvLimitedResourceCurrent INTEGER,
|
|
Packit |
022b05 |
rdbmsSrvLimitedResourceHighwater INTEGER,
|
|
Packit |
022b05 |
rdbmsSrvLimitedResourceFailures Counter32,
|
|
Packit |
022b05 |
rdbmsSrvLimitedResourceDescription DisplayString
|
|
Packit |
022b05 |
}
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvLimitedResourceName OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX DisplayString
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The name of the resource, for instance 'threads' or
|
|
Packit |
022b05 |
'semaphores', or 'buffer pages'"
|
|
Packit |
022b05 |
::= { rdbmsSrvLimitedResourceEntry 1 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvLimitedResourceID OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX AutonomousType
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The ID of the resource which may be described in some other
|
|
Packit |
022b05 |
MIB. If there is no ID for this rdbmsSrvLimitedResourceName,
|
|
Packit |
022b05 |
attempts to access this object will return noSuchName
|
|
Packit |
022b05 |
(SNMPv1) or noSuchInstance (SNMPv2)."
|
|
Packit |
022b05 |
::= { rdbmsSrvLimitedResourceEntry 2 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvLimitedResourceLimit OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX INTEGER (1..2147483647)
|
|
Packit |
022b05 |
MAX-ACCESS read-write
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The maximum value the resource use may attain.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
Note that a compliant agent does not need to
|
|
Packit |
022b05 |
allow write access to this object."
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
::= { rdbmsSrvLimitedResourceEntry 3 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvLimitedResourceCurrent OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX INTEGER (1..2147483647)
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The current value for the resource."
|
|
Packit |
022b05 |
::= { rdbmsSrvLimitedResourceEntry 4 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvLimitedResourceHighwater OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX INTEGER (1..2147483647)
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The maximum value of the resource seen since applUpTime
|
|
Packit |
022b05 |
was reset."
|
|
Packit |
022b05 |
::= { rdbmsSrvLimitedResourceEntry 5 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvLimitedResourceFailures OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX Counter32
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The number of times the system wanted to exceed the limit of
|
|
Packit |
022b05 |
the resource since applUpTime was reset."
|
|
Packit |
022b05 |
::= { rdbmsSrvLimitedResourceEntry 6 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvLimitedResourceDescription OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX DisplayString
|
|
Packit |
022b05 |
MAX-ACCESS read-write
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"A description of the resource and the meaning of the integer
|
|
Packit |
022b05 |
units used for Limit, Current, and Highwater.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
Note that a compliant agent does not need to
|
|
Packit |
022b05 |
allow write access to this object."
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
::= { rdbmsSrvLimitedResourceEntry 7 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
----------------------------------------------------------------
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsRelTable OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX SEQUENCE OF RdbmsRelEntry
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"A table relating databases and servers present on a host."
|
|
Packit |
022b05 |
::= { rdbmsObjects 9 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsRelEntry OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX RdbmsRelEntry
|
|
Packit |
022b05 |
MAX-ACCESS not-accessible
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"An entry relating a single database server to a single
|
|
Packit |
022b05 |
database to which it may provide access. The table is
|
|
Packit |
022b05 |
indexed first by the index of rdbmsDbTable, and then
|
|
Packit |
022b05 |
rdbmsSrvTable, so that all servers capable of providing
|
|
Packit |
022b05 |
access to a given database may be found by SNMP traversal
|
|
Packit |
022b05 |
operations (get-next and get-bulk). The makeup of this table
|
|
Packit |
022b05 |
depends on the product's architecture, e.g. if it is one
|
|
Packit |
022b05 |
server - many databases, then each server will appear n
|
|
Packit |
022b05 |
times, where n is the number of databases it may access, and
|
|
Packit |
022b05 |
each database will appear once. If the architecture is one
|
|
Packit |
022b05 |
database - many servers, then each server will appear once
|
|
Packit |
022b05 |
and each database will appear n times, where n is the number
|
|
Packit |
022b05 |
of servers that may be accessing it."
|
|
Packit |
022b05 |
INDEX { rdbmsDbIndex, applIndex }
|
|
Packit |
022b05 |
::= { rdbmsRelTable 1 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
RdbmsRelEntry ::=
|
|
Packit |
022b05 |
SEQUENCE {
|
|
Packit |
022b05 |
rdbmsRelState INTEGER,
|
|
Packit |
022b05 |
rdbmsRelActiveTime DateAndTime
|
|
Packit |
022b05 |
}
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsRelState OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX INTEGER{
|
|
Packit |
022b05 |
other(1),
|
|
Packit |
022b05 |
active(2),
|
|
Packit |
022b05 |
available(3),
|
|
Packit |
022b05 |
restricted(4),
|
|
Packit |
022b05 |
unavailable(5)
|
|
Packit |
022b05 |
}
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The state of this server's access to this database.
|
|
Packit |
022b05 |
Active(2) means the server is actively using the database.
|
|
Packit |
022b05 |
Available(3) means the server could use the database if
|
|
Packit |
022b05 |
necessary. Restricted(4) means the database is in some
|
|
Packit |
022b05 |
administratively determined state of less-than-complete
|
|
Packit |
022b05 |
availability. Unavailable(5) means the database is not
|
|
Packit |
022b05 |
available through this server. Other(1) means the
|
|
Packit |
022b05 |
database/server is in some other condition, possibly
|
|
Packit |
022b05 |
described in the vendor private MIB."
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
::= { rdbmsRelEntry 1 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsRelActiveTime OBJECT-TYPE
|
|
Packit |
022b05 |
SYNTAX DateAndTime
|
|
Packit |
022b05 |
MAX-ACCESS read-only
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The time the database was made active by the server. If an
|
|
Packit |
022b05 |
instance of rdbmsRelState is not active(1), then attempts to
|
|
Packit |
022b05 |
access the corresponding instance of this object may result
|
|
Packit |
022b05 |
in either noSuchName (SNMPv1) or noSuchInstance (SNMPv2)
|
|
Packit |
022b05 |
being returned by the agent."
|
|
Packit |
022b05 |
::= { rdbmsRelEntry 2 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
----------------------------------------------------------------
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
-- Well known resources for which limits, high water marks,
|
|
Packit |
022b05 |
-- access or allocation failures, and current levels of use
|
|
Packit |
022b05 |
-- are possibly available in either the rdbmsDbLimitedResources
|
|
Packit |
022b05 |
-- or the rdbmsSrvLimitedResources tables.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsWellKnownLimitedResources OBJECT IDENTIFIER
|
|
Packit |
022b05 |
::= { rdbmsObjects 10 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsLogSpace OBJECT-IDENTITY
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"Storage allocated for redo and undo logs."
|
|
Packit |
022b05 |
::= { rdbmsWellKnownLimitedResources 1}
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
----------------------------------------------------------------
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsTraps OBJECT IDENTIFIER ::= { rdbmsMIB 2 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsStateChange NOTIFICATION-TYPE
|
|
Packit |
022b05 |
OBJECTS { rdbmsRelState }
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"An rdbmsStateChange trap signifies that one of the database
|
|
Packit |
022b05 |
server/databases managed by this agent has changed its
|
|
Packit |
022b05 |
rdbmsRelState in a way that makes it less accessible for use.
|
|
Packit |
022b05 |
For these purposes, both active(2) and available(3) are
|
|
Packit |
022b05 |
considered fully accessible. The state sent with the trap is
|
|
Packit |
022b05 |
the new, less accessible state."
|
|
Packit |
022b05 |
::= { rdbmsTraps 1 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsOutOfSpace NOTIFICATION-TYPE
|
|
Packit |
022b05 |
OBJECTS { rdbmsSrvInfoDiskOutOfSpaces }
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"An rdbmsOutOfSpace trap signifies that one of the database
|
|
Packit |
022b05 |
servers managed by this agent has been unable to allocate
|
|
Packit |
022b05 |
space for one of the databases managed by this agent. Care
|
|
Packit |
022b05 |
should be taken to avoid flooding the network with these
|
|
Packit |
022b05 |
traps."
|
|
Packit |
022b05 |
::= { rdbmsTraps 2 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
----------------------------------------------------------------
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
-- compliance information
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsConformance OBJECT IDENTIFIER ::= { rdbmsMIB 3 }
|
|
Packit |
022b05 |
rdbmsCompliances OBJECT IDENTIFIER ::= { rdbmsConformance 1 }
|
|
Packit |
022b05 |
rdbmsGroups OBJECT IDENTIFIER ::= { rdbmsConformance 2 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
-- compliance statements
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsCompliance MODULE-COMPLIANCE
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The compliance statement for SNMP entities which
|
|
Packit |
022b05 |
implement the RDBMS MIB"
|
|
Packit |
022b05 |
MODULE HOST-RESOURCES-MIB
|
|
Packit |
022b05 |
MANDATORY-GROUPS { hrSystem }
|
|
Packit |
022b05 |
MODULE NETWORK-SERVICES-MIB
|
|
Packit |
022b05 |
MANDATORY-GROUPS { applGroups }
|
|
Packit |
022b05 |
MODULE RDBMS-MIB
|
|
Packit |
022b05 |
MANDATORY-GROUPS { rdbmsGroup }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
GROUP rdbmsGroup
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"The rdbmsGroup is mandatory, but no write access
|
|
Packit |
022b05 |
to objects is required for compliance."
|
|
Packit |
022b05 |
OBJECT rdbmsDbContact
|
|
Packit |
022b05 |
MIN-ACCESS read-only
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"A compliant system need not allow write-access to this
|
|
Packit |
022b05 |
object."
|
|
Packit |
022b05 |
OBJECT rdbmsDbParamCurrValue
|
|
Packit |
022b05 |
MIN-ACCESS read-only
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"A compliant system need not allow write-access to this
|
|
Packit |
022b05 |
object."
|
|
Packit |
022b05 |
OBJECT rdbmsDbParamComment
|
|
Packit |
022b05 |
MIN-ACCESS read-only
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"A compliant system need not allow write-access to this
|
|
Packit |
022b05 |
object."
|
|
Packit |
022b05 |
OBJECT rdbmsDbLimitedResourceLimit
|
|
Packit |
022b05 |
MIN-ACCESS read-only
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"A compliant system need not allow write-access to this
|
|
Packit |
022b05 |
object."
|
|
Packit |
022b05 |
OBJECT rdbmsDbLimitedResourceDescription
|
|
Packit |
022b05 |
MIN-ACCESS read-only
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"A compliant system need not allow write-access to this
|
|
Packit |
022b05 |
object."
|
|
Packit |
022b05 |
OBJECT rdbmsSrvContact
|
|
Packit |
022b05 |
MIN-ACCESS read-only
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"A compliant system need not allow write-access to this
|
|
Packit |
022b05 |
object."
|
|
Packit |
022b05 |
OBJECT rdbmsSrvInfoMaxInboundAssociations
|
|
Packit |
022b05 |
MIN-ACCESS read-only
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"A compliant system need not allow write-access to this
|
|
Packit |
022b05 |
object."
|
|
Packit |
022b05 |
OBJECT rdbmsSrvParamCurrValue
|
|
Packit |
022b05 |
MIN-ACCESS read-only
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"A compliant system need not allow write-access to this
|
|
Packit |
022b05 |
object."
|
|
Packit |
022b05 |
OBJECT rdbmsSrvParamComment
|
|
Packit |
022b05 |
MIN-ACCESS read-only
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"A compliant system need not allow write-access to this
|
|
Packit |
022b05 |
object."
|
|
Packit |
022b05 |
OBJECT rdbmsSrvLimitedResourceLimit
|
|
Packit |
022b05 |
MIN-ACCESS read-only
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"A compliant system need not allow write-access to this
|
|
Packit |
022b05 |
object."
|
|
Packit |
022b05 |
OBJECT rdbmsSrvLimitedResourceDescription
|
|
Packit |
022b05 |
MIN-ACCESS read-only
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"A compliant system need not allow write-access to this
|
|
Packit |
022b05 |
object."
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
::= { rdbmsCompliances 1 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
-- units of conformance
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
-- rdbmsStateChange and rdbmsOutOfSpace traps are omitted
|
|
Packit |
022b05 |
-- intentionally. They are not required or part of any
|
|
Packit |
022b05 |
-- conformance group.
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsGroup OBJECT-GROUP
|
|
Packit |
022b05 |
OBJECTS {
|
|
Packit |
022b05 |
rdbmsDbPrivateMibOID, rdbmsDbVendorName,
|
|
Packit |
022b05 |
rdbmsDbName, rdbmsDbContact,
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbInfoProductName, rdbmsDbInfoVersion,
|
|
Packit |
022b05 |
rdbmsDbInfoSizeUnits, rdbmsDbInfoSizeAllocated,
|
|
Packit |
022b05 |
rdbmsDbInfoSizeUsed, rdbmsDbInfoLastBackup,
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbParamCurrValue, rdbmsDbParamComment,
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsDbLimitedResourceLimit,
|
|
Packit |
022b05 |
rdbmsDbLimitedResourceCurrent,
|
|
Packit |
022b05 |
rdbmsDbLimitedResourceHighwater,
|
|
Packit |
022b05 |
rdbmsDbLimitedResourceFailures,
|
|
Packit |
022b05 |
rdbmsDbLimitedResourceDescription,
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvPrivateMibOID, rdbmsSrvVendorName,
|
|
Packit |
022b05 |
rdbmsSrvProductName, rdbmsSrvContact,
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvInfoStartupTime,
|
|
Packit |
022b05 |
rdbmsSrvInfoFinishedTransactions,
|
|
Packit |
022b05 |
rdbmsSrvInfoDiskReads, rdbmsSrvInfoDiskWrites,
|
|
Packit |
022b05 |
rdbmsSrvInfoLogicalReads, rdbmsSrvInfoLogicalWrites,
|
|
Packit |
022b05 |
rdbmsSrvInfoPageReads, rdbmsSrvInfoPageWrites,
|
|
Packit |
022b05 |
rdbmsSrvInfoHandledRequests,
|
|
Packit |
022b05 |
rdbmsSrvInfoRequestRecvs, rdbmsSrvInfoRequestSends,
|
|
Packit |
022b05 |
rdbmsSrvInfoHighwaterInboundAssociations,
|
|
Packit |
022b05 |
rdbmsSrvInfoMaxInboundAssociations,
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvParamCurrValue, rdbmsSrvParamComment,
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsSrvLimitedResourceLimit,
|
|
Packit |
022b05 |
rdbmsSrvLimitedResourceCurrent,
|
|
Packit |
022b05 |
rdbmsSrvLimitedResourceHighwater,
|
|
Packit |
022b05 |
rdbmsSrvLimitedResourceFailures,
|
|
Packit |
022b05 |
rdbmsSrvLimitedResourceDescription,
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
rdbmsRelState, rdbmsRelActiveTime }
|
|
Packit |
022b05 |
STATUS current
|
|
Packit |
022b05 |
DESCRIPTION
|
|
Packit |
022b05 |
"A collection of objects providing basic instrumentation of an
|
|
Packit |
022b05 |
RDBMS entity."
|
|
Packit |
022b05 |
::= { rdbmsGroups 1 }
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
----------------------------------------------------------------
|
|
Packit |
022b05 |
|
|
Packit |
022b05 |
END
|