of servers that may be accessing it."
INDEX { rdbmsDbIndex, applIndex }
::= { rdbmsRelTable 1 }
RdbmsRelEntry ::=
SEQUENCE {
rdbmsRelState INTEGER,
rdbmsRelActiveTime DateAndTime
}
rdbmsRelState OBJECT-TYPE
SYNTAX INTEGER{
other(1),
active(2),
available(3),
restricted(4),
unavailable(5)
}
MAX-ACCESS read-only
STATUS current
DESCRIPTION
"The state of this server's access to this database.
Active(2) means the server is actively using the database.
Available(3) means the server could use the database if
necessary. Restricted(4) means the database is in some
administratively determined state of less-than-complete
availability. Unavailable(5) means the database is not
available through this server. Other(1) means the
database/server is in some other condition, possibly
described in the vendor private MIB."
::= { rdbmsRelEntry 1 }
rdbmsRelActiveTime OBJECT-TYPE
SYNTAX DateAndTime
MAX-ACCESS read-only
STATUS current
DESCRIPTION
"The time the database was made active by the server. If an
instance of rdbmsRelState is not active(1), then attempts to
access the corresponding instance of this object may result
in either noSuchName (SNMPv1) or noSuchInstance (SNMPv2)
being returned by the agent."
::= { rdbmsRelEntry 2 }
----------------------------------------------------------------
-- Well known resources for which limits, high water marks,
-- access or allocation failures, and current levels of use
-- are possibly available in either the rdbmsDbLimitedResources
-- or the rdbmsSrvLimitedResources tables.
rdbmsWellKnownLimitedResources OBJECT IDENTIFIER
::= { rdbmsObjects 10 }
rdbmsLogSpace OBJECT-IDENTITY
STATUS current
DESCRIPTION
"Storage allocated for redo and undo logs."
::= { rdbmsWellKnownLimitedResources 1}
----------------------------------------------------------------
rdbmsTraps OBJECT IDENTIFIER ::= { rdbmsMIB 2 }
rdbmsStateChange NOTIFICATION-TYPE
OBJECTS { rdbmsRelState }
STATUS current
DESCRIPTION
"An rdbmsStateChange trap signifies that one of the database
server/databases managed by this agent has changed its
rdbmsRelState in a way that makes it less accessible for use.
For these purposes, both active(2) and available(3) are
considered fully accessible. The state sent with the trap is
the new, less accessible state."
::= { rdbmsTraps 1 }
rdbmsOutOfSpace NOTIFICATION-TYPE
OBJECTS { rdbmsSrvInfoDiskOutOfSpaces }
STATUS current
DESCRIPTION
"An rdbmsOutOfSpace trap signifies that one of the database
servers managed by this agent has been unable to allocate
space for one of the databases managed by this agent. Care
should be taken to avoid flooding the network with these
traps."
::= { rdbmsTraps 2 }
----------------------------------------------------------------
-- compliance information
rdbmsConformance OBJECT IDENTIFIER ::= { rdbmsMIB 3 }
rdbmsCompliances OBJECT IDENTIFIER ::= { rdbmsConformance 1 }
rdbmsGroups OBJECT IDENTIFIER ::= { rdbmsConformance 2 }
-- compliance statements
rdbmsCompliance MODULE-COMPLIANCE
STATUS current
DESCRIPTION
"The compliance statement for SNMP entities which
implement the RDBMS MIB"
MODULE HOST-RESOURCES-MIB
MANDATORY-GROUPS { hrSystem }
MODULE APPLICATION-MIB
MANDATORY-GROUPS { applGroup }
MODULE RDBMS-MIB
MANDATORY-GROUPS { rdbmsGroup }
GROUP rdbmsGroup
DESCRIPTION
"The rdbmsGroup is mandatory, but no write access
to objects is required for compliance."
OBJECT rdbmsDbContact
MIN-ACCESS read-only
DESCRIPTION
"A compliant system need not allow write-access to this
object."
OBJECT rdbmsDbParamCurrValue
MIN-ACCESS read-only
DESCRIPTION
"A compliant system need not allow write-access to this
object."
OBJECT rdbmsDbParamComment
MIN-ACCESS read-only
DESCRIPTION
"A compliant system need not allow write-access to this
object."
OBJECT rdbmsDbLimitedResourceLimit
MIN-ACCESS read-only
DESCRIPTION
"A compliant system need not allow write-access to this
object."
OBJECT rdbmsDbLimitedResourceDescription
MIN-ACCESS read-only
DESCRIPTION
"A compliant system need not allow write-access to this
object."
OBJECT rdbmsSrvContact
MIN-ACCESS read-only
DESCRIPTION
"A compliant system need not allow write-access to this
object."
OBJECT rdbmsSrvInfoMaxInboundAssociations
MIN-ACCESS read-only
DESCRIPTION
"A compliant system need not allow write-access to this
object."
OBJECT rdbmsSrvParamCurrValue
MIN-ACCESS read-only
DESCRIPTION
"A compliant system need not allow write-access to this
object."
OBJECT rdbmsSrvParamComment
MIN-ACCESS read-only
DESCRIPTION
"A compliant system need not allow write-access to this
object."
OBJECT rdbmsSrvLimitedResourceLimit
MIN-ACCESS read-only
DESCRIPTION
"A compliant system need not allow write-access to this
object."
OBJECT rdbmsSrvLimitedResourceDescription
MIN-ACCESS read-only
DESCRIPTION
"A compliant system need not allow write-access to this
object."
::= { rdbmsCompliances 1 }
-- units of conformance
-- rdbmsStateChange and rdbmsOutOfSpace traps are omitted
-- intentionally. They are not required or part of any
-- conformance group.
rdbmsGroup OBJECT-GROUP
OBJECTS {
rdbmsDbPrivateMibOID, rdbmsDbVendorName,
rdbmsDbName, rdbmsDbContact,
rdbmsDbInfoProductName, rdbmsDbInfoVersion,
rdbmsDbInfoSizeUnits, rdbmsDbInfoSizeAllocated,
rdbmsDbInfoSizeUsed, rdbmsDbInfoLastBackup,
rdbmsDbParamCurrValue, rdbmsDbParamComment,
rdbmsDbLimitedResourceLimit,
rdbmsDbLimitedResourceCurrent,
rdbmsDbLimitedResourceHighwater,
rdbmsDbLimitedResourceFailures,
rdbmsDbLimitedResourceDescription,
rdbmsSrvPrivateMibOID, rdbmsSrvVendorName,
rdbmsSrvProductName, rdbmsSrvContact,
rdbmsSrvInfoStartupTime,
rdbmsSrvInfoFinishedTransactions,
rdbmsSrvInfoDiskReads, rdbmsSrvInfoDiskWrites,
rdbmsSrvInfoLogicalReads, rdbmsSrvInfoLogicalWrites,
rdbmsSrvInfoPageReads, rdbmsSrvInfoPageWrites,
rdbmsSrvInfoHandledRequests,
rdbmsSrvInfoRequestRecvs, rdbmsSrvInfoRequestSends,
rdbmsSrvInfoHighwaterInboundAssociations,
rdbmsSrvInfoMaxInboundAssociations,
rdbmsSrvParamCurrValue, rdbmsSrvParamComment,
rdbmsSrvLimitedResourceLimit,
rdbmsSrvLimitedResourceCurrent,
rdbmsSrvLimitedResourceHighwater,
rdbmsSrvLimitedResourceFailures,
rdbmsSrvLimitedResourceDescription,
rdbmsRelState, rdbmsRelActiveTime }
STATUS current
DESCRIPTION
"A collection of objects providing basic instrumentation of an
RDBMS entity."
::= { rdbmsGroups 1 }
----------------------------------------------------------------
END
5. Acknowledgements
This document was produced by the IETF RDBMSMIB working group:
Mark Allyn, Boeing
Virinder Batra, IBM
Jonathan Bauer DEC
Janice Befu, Network General
Gerard Berthet, Independence Technologies
Dave Brower, Ingres
Barry Bruins, Network General
David Campbell, Digital Equipment Corporation
Stephen Campbell, European Database Consulting
Jeff Case SNMP Research
Dave Crocker Silicon Graphics
Tony Daniel, Informix
Craig DeNoce, Sybase
Howard Dernehl, Ingres/Data General
Mike Hartstein, Oracle
Vijay Iyer, Independence Technologies
Britt Johnston, Progress
Bill Kehoe, Sybase
Deirdre Kostick, Bellcore
Cheryl Krupczak, Empire Technologies
Damien Lindauer, Microsoft
Ivan Lui, Informix
John McCormack, Tandem Computers Inc.
David Meldrum, Sybase
David Morandi, Red Brick Systems
Bob Natale, American Computer
Diana Parr, Gupta
David Perkins, Synoptics
Randy Presuhn, Peer Networks
Brian Promes, Novell
Bob Purvy, Oracle
Roger Reinsch, IBM
Marshall T. Rose, Dover Beach Consulting
Jon Saperia, DEC
Marc Sinykin, Oracle
Jay Smith, Oracle
Mike Sorsen, Edward D. Jones & Co.
Bob Taylor, Tandem
Maria Valls, IBM
Bert Wijnen, IBM
Stan Wong, IBM
6. References
[1] Case, J., McCloghrie, K., Rose, M., and S. Waldbusser, "Structure
of Management Information for version 2 of the Simple Network
Management Protocol (SNMPv2)", RFC1442, SNMP Research, Inc.,
Hughes LAN Systems, Dover Beach Consulting, Inc., Carnegie Mellon
University, April 1993.
[2] McCloghrie, K., and M. Rose, "Management Information Base for
Network Management of TCP/IP-based internets - MIB-II", STD 17,
RFC1213, Hughes LAN Systems, Performance Systems International,
March 1991.
[3] Galvin, J., and K. McCloghrie, "Administrative Model for version
2 of the Simple Network Management Protocol (SNMPv2)", RFC1445,
Trusted Information Systems, Hughes LAN Systems, April 1993.
[4] Case, J., McCloghrie, K., Rose, M., and S. Waldbusser, "Protocol
Operations for version 2 of the Simple Network Management
Protocol (SNMPv2)", RFC1448, SNMP Research, Inc., Hughes LAN
Systems, Dover Beach Consulting, Inc., Carnegie Mellon
University, April 1993.
[5] Case, J., McCloghrie, K., Rose, M., and S. Waldbusser, "Textual
Conventions for version 2 of the Simple Network Management
Protocol (SNMPv2)", RFC1443, SNMP Research, Inc., Hughes LAN
Systems, Dover Beach Consulting, Inc., Carnegie Mellon
University, April 1993.
[6] Kille, S., WG Chair, and N. Freed, Editor, "The Network Services
Monitoring MIB", RFC1565, ISODE Consortium, Innosoft, January
1994.
7. Security Considerations
Security issues are not discussed in this memo.
8. Authors' Addresses
David Brower
The ASK Group, INGRES DBMS Development
1080 Marina Village Parkway
Alameda, CA, 94501
US
Phone: +1 510 748 3418
EMail: daveb@ingres.com
Bob Purvy
Oracle Corporation
500 Oracle Parkway
Redwood Shores, CA 94065
US
Phone: +1 415 506 2972
EMail: bpurvy@us.oracle.com
Anthony Daniel
Informix Software, Inc.
921 S.W. Washington Street
Portland, OR 97205
US
Phone: +1 503 221 2638
EMail: anthony@informix.com
Marc Sinykin
Oracle Corporation
400 Oracle Parkway
Redwood Shores, CA 94065
US
Phone: +1 415 506 2477
EMail: msinykin@us.oracle.com
Jay Smith
Oracle Corporation
400 Oracle Parkway
Redwood Shores, CA 94065
US
Phone: +1 415 506 6239