Using SNMP and MIBs

I l @ ve RuBoard

Simple Network Management Protocol (SNMP) is a standard protocol used for communication between a system being managed and a management application. SNMP, introduced in the 1980s, is now the de facto standard for the communication of management information. Although initially SNMP was used only to manage network components , such as routers, bridges, and hubs, it is now used for systems, software applications, and middleware products as well.

SNMP subagents are the processes responsible for the management of different system components. SNMP communication from a management station is forwarded to the appropriate subagent by a master agent process on the system being managed. SNMP communication is sent over the User Datagram Protocol (UDP). The master agent listens for requests on a well-known UDP port (161), decodes the requests, and forwards them to the appropriate subagent. Each subagent registers with the master agent at startup and indicates the requests that should be forwarded to it. The master agent also sends traps on behalf of a subagent. Figure A-1 shows all SNMP traffic going through the master agent, to or from the subagents on the system. On HP-UX, the master agent is provided through EMANATE technology, licensed from SNMP Research International, Inc. More information about EMANATE can be found at http://www.snmp.com.

Figure A-1. SNMP architecture.

SNMP subagents represent the management information that they supply in the form of a hierarchical structure called a Management Information Base (MIB). Figure A-2 shows how the individual MIBs, MIB-II and RDBMS MIB, fit into the overall MIB hierarchy. MIB Browsers are often included with enterprise management frameworks, such as HP OpenView Network Node Manager. These graphical tools can allow operators to navigate the MIB tree structure, to look for specific management information. In addition to showing the MIB Object Identifier (OID), the MIB Browser typically also shows the value of the MIB object. The MIB Browser uses SNMP requests to query the subagent for the MIB values on the managed system.

Figure A-2. MIB hierarchy.

Names , as well as numeric values, are assigned with each component of the MIB OIDs. For example, the MIB-II is a standard MIB for system information with a root OID of 1.3.6.1.2.1. This corresponds to the mnemonic OID iso.org.dod.internet.mgmt.mib_2. Note that although some SNMP tools expect an OID to be preceded by a dot ("."), it is omitted from this appendix, for readability.

SNMP Research International provides an EMANATE Subagent Development Kit (SADK) to allow additional subagents to be written. Another way to configure new SNMP objects to be monitored is through the HP OpenView Extensible SNMP Agent product. The agent can be extended through configuration files that describe new managed objects and actions to be taken. The MIB value can be the output from a command, or the contents of a user-specified file. The Extensible SNMP Agent can generate user-defined SNMP traps based on configured conditions. When it is used with HP OpenView Network Node Manager (NNM) or IT/Operations (IT/O), automated actions can also be taken when the trap is received.

MIBs often originate as Internet draft documents. These draft specifications can be created by anyone , but before becoming standards, they are reviewed by the Internet Engineering Task Force (IETF). After review, these documents are published as Requests For Comments (RFCs). RFC specifications can be found on the Web at http://www.ietf.org, along with other IETF documents.

In addition to the standard MIBs, many vendors provide unique MIBs for their own hardware or software products. Hewlett-Packard, for example, provides an MIB for its MC/ServiceGuard product. Oracle provides its own proprietary MIB specifications under the private branch. These private documents are subject only to the reviews appropriate to the issuing organization.

A management application can receive the MIB information by making an SNMP Get request, which can be a blocking or nonblocking call. The reply from the subagent includes the OID, variable type, and value. SNMP also supports SNMP Set requests, but this capability often isn't implemented by the subagents.

In addition to responding to SNMP requests for information, a subagent can initiate notification of an event through the SNMP trap mechanism. SNMP traps are an important tool for integrating with other management frameworks, because a process is typically provided on the management station that listens for these traps. Subagents can forward key event information to different management applications by using this one mechanism.

SNMP trap configuration information is stored in the configuration file /etc/SnmpAgent.d /snmpd.conf, which is where you specify SNMP community names. If configured, the SNMP agent allows only those requests with the specified community name. You can specify a different community name configuration for SNMP Set and Get requests. The destination addresses where traps should be sent are also specified in this configuration file. You should be sure to list the IP address of your management station.

The Event Monitoring Service (EMS) uses SNMP traps as one method of forwarding resource events to target applications. EMS has a MIB defined, which includes the various traps that can be sent. The enterprise OID for EMS traps is 1.3.6.1.4.1.11.2.3.1.7. Using the SNMP trap notification provided by EMS, monitors can generate events via SNMP traps to multiple applications and platforms without having to make SNMP function calls directly

Like most enterprise management platforms, Hewlett-Packard's OpenView IT/O and NNM provide event handlers that listen for SNMP traps and can display events, log events, and generate automatic actions when they are received. Templates are provided to define the handling of specific SNMP traps. The templates define the event message to be displayed, the sever ity of the event, the name of the system sending the event, the message group or category for the event, and the automatic or operator-initiated action for the event. New trap definitions can easily be added to a template so that the event will be recognized and properly formatted.

Each trap is identified by its OID as well as generic and specific trap numbers . The trap includes the address of the agent sending the event and a list of variables. Using the template, the event handler assigns the event to a category and then assigns the severity configured in the template. The message is formatted based on the format string in the template. The variables contained in the trap message can be used in the formatted event message that is displayed in the Message Browser.

Management platforms, such as OpenView NNM, provide several tools for accessing the MIB information. An MIB Browser is useful for exploring MIBs and querying for the MIB values. Figure A-3 shows the result of querying for the operational status of the LAN interface cards from the MIB-II.

Figure A-3. The NNM MIB Browser.

NNM not only provides a simple MIB Browser, it also provides a Data Collector tool that collects the MIB data for historical trending and problem monitoring. You can define thresholds to generate an event when specified thresholds are exceeded. The NNM Application Builder MIB tool enables you to quickly develop an application to monitor the MIB variables. The Application Builder enables you to report the MIB data in the form of a table, form, or graph. IT/O also includes the MIB monitor templates, which enable you to set up monitoring for any MIB variable. Monitor templates provide tight integration with the IT/O Message Browser and provide the ability to specify automatic actions based on events.

A summary of SNMP and the latest revisions to SNMP version 2 can be found in Marshall T. Rose's The Simple Book: An Introduction to Internet Management (Prentice Hall, 1994). More information about SNMP can also be found in RFCs 1441 and 1442, available on the Web at http://www.ietf.org.

The following sections describe some important MIB specifications that take advantage of the SNMP standard. These documents include information about your system, peripherals, and database, as well as other software applications. This information can be invaluable in providing the appropriate level of monitoring for your Unix system. Note that in the following the MIB specifications, an asterisk (*) suffix indicates that the variable serves as an index for a table entry.

MIB-II

The MIB-II is often referred to as the System MIB. It is a standard repository for information about a computer system that is supported on a variety of platforms, including Unix and Windows NT. The MIB-II contains information about a computer system, such as its name, system contact, and the length of time it has been running. It also contains statistics from the key networking protocols, such as TCP, UDP, and IP. Statistics include packet transmission counts and error counts.

MIB Definition

Listing A-1 shows the complete definition for the MIB-II, as defined in RFCs 1213 and 1214.

Listing A-1 MIB-II specification.

 mgmt   [1 ] mib_2     [1 ] system       [1 ] sysDescr       [2 ] sysObjectID       [3 ] sysUpTime       [4 ] sysContact       [5 ] sysName       [6 ] sysLocation       [7 ] sysServices     [2 ] interfaces       [1 ] ifNumber       [2 ] ifTable         [1 ] ifEntry           [1 ] ifIndex*           [2 ] ifDescr           [3 ] ifType           [4 ] ifMtu           [5 ] ifSpeed           [6 ] ifPhysAddress           [7 ] ifAdminStatus           [8 ] ifOperStatus           [9 ] ifLastChange           [10] ifInOctets           [11] ifInUcastPkts           [12] ifInNUcastPkts           [13] ifInDiscards           [14] ifInErrors           [15] ifInUnknownProtos           [16] ifOutOctets           [17] ifOutUcastPkts           [18] ifOutNUcastPkts           [19] ifOutDiscards           [20] ifOutErrors           [21] ifOutQLen           [22] ifSpecific     [3 ] at       [1 ] atTable         [1 ] atEntry           [1 ] atIfIndex*           [2 ] atPhysAddress           [3 ] atNetAddress*     [4 ] ip       [1 ] ipForwarding       [2 ] ipDefaultTTL       [3 ] ipInReceives       [4 ] ipInHdrErrors       [5 ] ipInAddrErrors       [6 ] ipForwDatagrams       [7 ] ipInUnknownProtos       [8 ] ipInDiscards       [9 ] ipInDelivers       [10] ipOutRequests       [11] ipOutDiscards       [12] ipOutNoRoutes       [13] ipReasmTimeout       [14] ipReasmReqds       [15] ipReasmOKs       [16] ipReasmFails       [17] ipFragOKs       [18] ipFragFails       [19] ipFragCreates       [20] ipAddrTable         [1 ] ipAddrEntry           [1 ] ipAdEntAddr*           [2 ] ipAdEntIfIndex           [3 ] ipAdEntNetMask           [4 ] ipAdEntBcastAddr           [5 ] ipAdEntReasmMaxSize       [21] ipRouteTable         [1 ] ipRouteEntry           [1 ] ipRouteDest*           [2 ] ipRouteIfIndex           [3 ] ipRouteMetric1           [4 ] ipRouteMetric2           [5 ] ipRouteMetric3           [6 ] ipRouteMetric4           [7 ] ipRouteNextHop           [8 ] ipRouteType           [9 ] ipRouteProto           [10] ipRouteAge           [11] ipRouteMask           [12] ipRouteMetric5           [13] ipRouteInfo       [22] ipNetToMediaTable         [1 ] ipNetToMediaEntry           [1 ] ipNetToMediaIfIndex*           [2 ] ipNetToMediaPhysAddress           [3 ] ipNetToMediaNetAddress*           [4 ] ipNetToMediaType       [23] ipRoutingDiscards     [5 ] icmp       [1 ] icmpInMsgs       [2 ] icmpInErrors       [3 ] icmpInDestUnreachs       [4 ] icmpInTimeExcds       [5 ] icmpInParmProbs       [6 ] icmpInSrcQuenchs       [7 ] icmpInRedirects       [8 ] icmpInEchos       [9 ] icmpInEchoReps       [10] icmpInTimestamps       [11] icmpInTimestampReps       [12] icmpInAddrMasks       [13] icmpInAddrMaskReps       [14] icmpOutMsgs       [15] icmpOutErrors       [16] icmpOutDestUnreachs       [17] icmpOutTimeExcds       [18] icmpOutParmProbs       [19] icmpOutSrcQuenchs       [20] icmpOutRedirects       [21] icmpOutEchos       [22] icmpOutEchoReps       [23] icmpOutTimestamps       [24] icmpOutTimestampReps       [25] icmpOutAddrMasks       [26] icmpOutAddrMaskReps     [6 ] tcp       [1 ] tcpRtoAlgorithm       [2 ] tcpRtoMin       [3 ] tcpRtoMax       [4 ] tcpMaxConn       [5 ] tcpActiveOpens       [6 ] tcpPassiveOpens       [7 ] tcpAttemptFails       [8 ] tcpEstabResets       [9 ] tcpCurrEstab       [10] tcpInSegs       [11] tcpOutSegs       [12] tcpRetransSegs       [13] tcpConnTable         [1 ] tcpConnEntry           [1 ] tcpConnState           [2 ] tcpConnLocalAddress*           [3 ] tcpConnLocalPort*           [4 ] tcpConnRemAddress           [5 ] tcpConnRemPort       [14] tcpInErrs       [15] tcpOutRsts     [7 ] udp       [1 ] udpInDatagrams       [2 ] udpNoPorts       [3 ] udpInErrors       [4 ] udpOutDatagrams       [5 ] udpTable         [1 ] udpEntry           [1 ] udpLocalAddress*           [2 ] udpLocalPort*     [8 ] egp       [1 ] egpInMsgs       [2 ] egpInErrors       [3 ] egpOutMsgs       [4 ] egpOutErrors       [5 ] egpNeighTable         [1 ] egpNeighEntry           [1 ] egpNeighState           [2 ] egpNeighAddr*           [3 ] egpNeighAs           [4 ] egpNeighInMsgs           [5 ] egpNeighInErrs           [6 ] egpNeighOutMsgs           [7 ] egpNeighOutErrs           [8 ] egpNeighInErrMsgs           [9 ] egpNeighOutErrMsgs           [10] egpNeighStateUps           [11] egpNeighStateDowns           [12] egpNeighIntervalHello           [13] egpNeighIntervalPoll           [14] egpNeighMode           [15] egpNeighEventTrigger       [6 ] egpAs     [10] transmission     [11] snmp       [1 ] snmpInPkts       [2 ] snmpOutPkts       [3 ] snmpInBadVersions       [4 ] snmpInBadCommunityNames       [5 ] snmpInBadCommunityUses       [6 ] snmpInASNParseErrs       [8 ] snmpInTooBigs       [9 ] snmpInNoSuchNames       [10] snmpInBadValues       [11] snmpInReadOnlys       [12] snmpInGenErrs       [13] snmpInTotalReqVars       [14] snmpInTotalSetVars       [15] snmpInGetRequests       [16] snmpInGetNexts       [17] snmpInSetRequests       [18] snmpInGetResponses       [19] snmpInTraps       [20] snmpOutTooBigs       [21] snmpOutNoSuchNames       [22] snmpOutBadValues       [24] snmpOutGenErrs       [25] snmpOutGetRequests       [26] snmpOutGetNexts       [27] snmpOutSetRequests       [28] snmpOutGetResponses       [29] snmpOutTraps       [30] snmpEnableAuthenTraps 

Monitoring Notes

When navigating the MIB hierarchy using a tool such as the HP OpenView MIB Browser, you see the mnemonic names for the MIB variables. The mnemonic for the MIB-II is iso.org.dod.internet.mgmt.mib-2. However, if you intend to write your own SNMP application, you need to know the numeric root OID of the MIB-II, which is 1.3.6.1.2.1. An operator can query this information and correlate it to track error rates.

This MIB contains some fault information. For example, Hewlett-Packard's EMS HA Monitors product uses this MIB to monitor the status of each network interface.

The MIB-II also contains network performance information, including the amount of data sent and received per protocol. However, data is not correlated or converted to rates. Consequently, to get an accurate picture of your network performance, you must collect this data over a period of time and then note the changes yourself.

RMON MIB

The RMON MIB is meant to provide a standard method for collecting network performance data. Monitors, or probes, are placed on specific LAN segments and then collect data on those segments. Network packet statistics and a history of network performance can be stored in the MIB. RMON also provides lists of the top network users, such as the systems that are sending the most packets with errors.

MIB Definition

Listing A-2 shows the complete RMON specification, as defined in RFC 1757.

Listing A-2 RMON MIB specification.

 mib_2   [16] rmon     [1 ] statistics       [1 ] etherStatsTable         [1 ] etherStatsEntry           [1 ] etherStatsIndex*           [2 ] etherStatsDataSource           [3 ] etherStatsDropEvents           [4 ] etherStatsOctets           [5 ] etherStatsPkts           [6 ] etherStatsBroadcastPkts           [7 ] etherStatsMulticastPkts           [8 ] etherStatsCRCAlignErrors           [9 ] etherStatsUndersizePkts           [10] etherStatsOversizePkts           [11] etherStatsFragments           [12] etherStatsJabbers           [13] etherStatsCollisions           [14] etherStatsPkts64Octets           [15] etherStatsPkts65to127Octets           [16] etherStatsPkts128to255Octets           [17] etherStatsPkts256to511Octets           [18] etherStatsPkts512to1023Octets           [19] etherStatsPkts1024to1518Octets           [20] etherStatsOwner           [21] etherStatsStatus     [2 ] history       [1 ] historyControlTable         [1 ] historyControlEntry           [1 ] historyControlIndex*           [2 ] historyControlDataSource           [3 ] historyControlBucketsRequested           [4 ] historyControlBucketsGranted           [5 ] historyControlInterval           [6 ] historyControlOwner           [7 ] historyControlStatus       [2 ] etherHistoryTable         [1 ] etherHistoryEntry           [1 ] etherHistoryIndex*           [2 ] etherHistorySampleIndex*           [3 ] etherHistoryIntervalStart           [4 ] etherHistoryDropEvents           [5 ] etherHistoryOctets           [6 ] etherHistoryPkts           [7 ] etherHistoryBroadcastPkts           [8 ] etherHistoryMulticastPkts           [9 ] etherHistoryCRCAlignErrors           [10] etherHistoryUndersizePkts           [11] etherHistoryOversizePkts           [12] etherHistoryFragments           [13] etherHistoryJabbers           [14] etherHistoryCollisions           [15] etherHistoryUtilization     [3 ] alarm       [1 ] alarmTable         [1 ] alarmEntry           [1 ] alarmIndex*           [2 ] alarmInterval           [3 ] alarmVariable           [4 ] alarmSampleType           [5 ] alarmValue           [6 ] alarmStartupAlarm           [7 ] alarmRisingThreshold           [8 ] alarmFallingThreshold           [9 ] alarmRisingEventIndex           [10] alarmFallingEventIndex           [11] alarmOwner           [12] alarmStatus     [4 ] hosts       [1 ] hostControlTable         [1 ] hostControlEntry           [1 ] hostControlIndex*           [2 ] hostControlDataSource           [3 ] hostControlTableSize           [4 ] hostControlLastDeleteTime           [5 ] hostControlOwner           [6 ] hostControlStatus       [2 ] hostTable         [1 ] hostEntry           [1 ] hostAddress*           [2 ] hostCreationOrder           [3 ] hostIndex*           [4 ] hostInPkts           [5 ] hostOutPkts           [6 ] hostInOctets           [7 ] hostOutOctets           [8 ] hostOutErrors           [9 ] hostOutBroadcastPkts           [10] hostOutMulticastPkts       [3 ] hostTimeTable         [1 ] hostTimeEntry           [1 ] hostTimeAddress           [2 ] hostTimeCreationOrder*           [3 ] hostTimeIndex*           [4 ] hostTimeInPkts           [5 ] hostTimeOutPkts           [6 ] hostTimeInOctets           [7 ] hostTimeOutOctets           [8 ] hostTimeOutErrors           [9 ] hostTimeOutBroadcastPkts           [10] hostTimeOutMulticastPkts     [5 ] hostTopN       [1 ] hostTopNControlTable         [1 ] hostTopNControlEntry           [1 ] hostTopNControlIndex*           [2 ] hostTopNHostIndex           [3 ] hostTopNRateBase           [4 ] hostTopNTimeRemaining           [5 ] hostTopNDuration           [6 ] hostTopNRequestedSize           [7 ] hostTopNGrantedSize           [8 ] hostTopNStartTime           [9 ] hostTopNOwner           [10] hostTopNStatus       [2 ] hostTopNTable         [1 ] hostTopNEntry           [1 ] hostTopNReport*           [2 ] hostTopNIndex*           [3 ] hostTopNAddress           [4 ] hostTopNRate     [6 ] matrix       [1 ] matrixControlTable         [1 ] matrixControlEntry           [1 ] matrixControlIndex*           [2 ] matrixControlDataSource           [3 ] matrixControlTableSize           [4 ] matrixControlLastDeleteTime           [5 ] matrixControlOwner           [6 ] matrixControlStatus       [2 ] matrixSDTable         [1 ] matrixSDEntry           [1 ] matrixSDSourceAddress*           [2 ] matrixSDDestAddress           [3 ] matrixSDIndex*           [4 ] matrixSDPkts           [5 ] matrixSDOctets           [6 ] matrixSDErrors       [3 ] matrixDSTable         [1 ] matrixDSEntry           [1 ] matrixDSSourceAddress           [2 ] matrixDSDestAddress*           [3 ] matrixDSIndex*           [4 ] matrixDSPkts           [5 ] matrixDSOctets           [6 ] matrixDSErrors     [7 ] filter       [1 ] filterTable         [1 ] filterEntry           [1 ] filterIndex*           [2 ] filterChannelIndex           [3 ] filterPktDataOffset           [4 ] filterPktData           [5 ] filterPktDataMask           [6 ] filterPktDataNotMask           [7 ] filterPktStatus           [8 ] filterPktStatusMask           [9 ] filterPktStatusNotMask           [10] filterOwner           [11] filterStatus       [2 ] channelTable         [1 ] channelEntry           [1 ] channelIndex*           [2 ] channelIfIndex           [3 ] channelAcceptType           [4 ] channelDataControl           [5 ] channelTurnOnEventIndex           [6 ] channelTurnOffEventIndex           [7 ] channelEventIndex           [8 ] channelEventStatus           [9 ] channelMatches           [10] channelDescription           [11] channelOwner           [12] channelStatus     [8 ] capture       [1 ] bufferControlTable         [1 ] bufferControlEntry           [1 ] bufferControlIndex*           [2 ] bufferControlChannelIndex           [3 ] bufferControlFullStatus           [4 ] bufferControlFullAction           [5 ] bufferControlCaptureSliceSize           [6 ] bufferControlDownloadSliceSize           [7 ] bufferControlDownloadOffset           [8 ] bufferControlMaxOctetsRequested           [9 ] bufferControlMaxOctetsGranted           [10] bufferControlCapturedPackets           [11] bufferControlTurnOnTime           [12] bufferControlOwner           [13] bufferControlStatus       [2 ] captureBufferTable         [1 ] captureBufferEntry           [1 ] captureBufferControlIndex*           [2 ] captureBufferIndex*           [3 ] captureBufferPacketID           [4 ] captureBufferPacketDataz           [5 ] captureBufferPacketLength           [6 ] captureBufferPacketTime           [7 ] captureBufferPacketStatus     [9 ] event       [1 ] eventTable         [1 ] eventEntry           [1 ] eventIndex*           [2 ] eventDescription           [3 ] eventType           [4 ] eventCommunity           [5 ] eventLastTimeSent           [6 ] eventOwner           [7 ] eventStatus       [2 ] logTable         [1 ] logEntry           [1 ] logEventIndex*           [2 ] logIndex*           [3 ] logTime           [4 ] logDescription 

Monitoring Notes

If you intend to write your own SNMP application, the numeric root OID of the RMON MIB is 1.3.6.1.2.1.16.

The RMON MIB is divided into the following sections: statistics, history, alarm, hosts, hostsTopN, matrix, filter, capture, and event.

The statistics section provides information regarding the amount of data being sent on a particular Ethernet interface, including the number of broadcasts, errors, and collisions. You can also see the distribution of packets of different sizes.

The history group enables you to sample statistics at a specified polling interval and sum them over time.

The alarm and event groups are used to report when configured thresholds are crossed. Statistics are periodically checked to see whether a threshold has been crossed. After an event is sent, no additional events are sent until the opposite threshold has been crossed.

RMON probes can discover new systems, or hosts, by watching the source and destination station addresses in packets passing on a LAN segment. The hosts group stores each address seen on the interface. A variety of important statistics are kept about each system, such as the number of packets sent and received, error packets sent, and broadcasts sent. This can be invaluable information for catching a misbehaving system that is dominating the network bandwidth on a LAN segment.

The hostsTopN group keeps track of the top systems on a segment for a specific statistic, such as the number of packets received, error packets sent, or broadcast packets sent. The number of systems in the list is configurable.

The matrix group can be used to determine traffic problems. Statistics are kept on the network conversations between two addresses. Information collected includes the number of packets sent in either direction and the number of error packets.

The filter and capture groups work together to capture packets sent on a segment. A management station can then download the packets.

Note that this MIB also supports two traps that can be sent when an alarm entry either rises above or falls below a threshold.

RMON II MIB

RMON II extends the RMON specification to include additional network performance information for the transport-, session-, presentation-, and application-layer protocols. These network layers are defined in Chapter 6.

MIB Definition

Listing A-3 shows the complete specification for RMON II, as defined in RFC 2021.

Listing A-3 RMON II MIB specification.

 mib_2   [16] rmon     [11] protocolDir       [1 ] protocolDirLastChange       [2 ] protocolDirTable         [1 ] protocolDirEntry           [1 ] protocolDirID*           [2 ] protocolDirParameters*           [3 ] protocolDirLocalIndex*           [4 ] protocolDirDescr           [5 ] protocolDirType           [6 ] protocolDirAddressMapConfig           [7 ] protocolDirHostConfig           [8 ] protocolDirMatrixConfig           [9 ] protocolDirOwner           [10] protocolDirStatus     [12] protocolDist       [1 ] protocolDistControlTable         [1 ] protocolDistControlEntry           [1 ] protocolDistControlIndex*           [2 ] protocolDistControlDataSource           [3 ] protocolDistControlDroppedFrames           [4 ] protocolDistControlCreateTime           [5 ] protocolDistControlOwner           [6 ] protocolDistControlStatus       [2 ] protocolDistStatsTable         [1 ] protocolDistStatsEntry           [1 ] protocolDistStatsPkts           [2 ] protocolDistStatsOctets     [13] addressMap       [1 ] addressMapInserts       [2 ] addressMapDeletes       [3 ] addressMapMaxDesiredEntries       [4 ] addressMapControlTable         [1 ] addressMapControlEntry           [1 ] addressMapControlIndex*           [2 ] addressMapControlDataSource           [3 ] addressMapControlDroppedFrames           [4 ] addressMapControlOwner           [5 ] addressMapControlStatus       [5 ] addressMapTable         [1 ] addressMapEntry           [1 ] addressMapTimeMark*           [2 ] addressMapNetworkAddress           [3 ] addressMapSource           [4 ] addressMapPhysicalAddress           [5 ] addressMapLastChange     [14] nlHost       [1 ] hlHostControlTable         [1 ] hlHostControlEntry           [1 ] hlHostControlIndex*           [2 ] hlHostControlDataSource           [3 ] hlHostControlNlDroppedFrames           [4 ] hlHostControlNlInserts           [5 ] hlHostControlNlDeletes           [6 ] hlHostControlNlMaxDesiredEntries           [7 ] hlHostControlAlDroppedFrames           [8 ] hlHostControlAlInserts           [9 ] hlHostControlAlDeletes           [10] hlHostControlAlMaxDesiredEntries           [11] hlHostControlOwner           [12] hlHostControlStatus       [2 ] nlHostTable         [1 ] nlHostEntry           [1 ] nlHostTimeMark*           [2 ] nlHostAddress           [3 ] nlHostInPkts           [4 ] nlHostOutPkts           [5 ] nlHostInOctets           [6 ] nlHostOutOctets           [7 ] nlHostOutMacNonUnicastPkts           [8 ] nlHostCreateTime     [15] nlMatrix       [1 ] hlMatrixControlTable         [1 ] hlMatrixControlEntry           [1 ] hlMatrixControlIndex*           [2 ] hlMatrixControlDataSource           [3 ] hlMatrixControlNlDroppedFrames           [4 ] hlMatrixControlNlInserts           [5 ] hlMatrixControlNlDeletes           [6 ] hlMatrixControlNlMaxDesiredEntries           [7 ] hlMatrixControlAlDroppedFrames           [8 ] hlMatrixControlAlInserts           [9 ] hlMatrixControlAlDeletes           [10] hlMatrixControlAlMaxDesiredEntries           [11] hlMatrixControlOwner           [12] hlMatrixControlStatus       [2 ] nlMatrixSDTable         [1 ] nlMatrixSDEntry           [1 ] nlMatrixSDTimeMark*           [2 ] nlMatrixSDSourceAddress           [3 ] nlMatrixSDDestAddress           [4 ] nlMatrixSDPkts           [5 ] nlMatrixSDOctets           [6 ] nlMatrixSDCreateTime       [3 ] nlMatrixDSTable         [1 ] nlMatrixDSEntry           [1 ] nlMatrixDSTimeMark*           [2 ] nlMatrixDSSourceAddress           [3 ] nlMatrixDSDestAddress           [4 ] nlMatrixDSPkts           [5 ] nlMatrixDSOctets           [6 ] nlMatrixDSCreateTime       [4 ] nlMatrixTopNControlTable         [1 ] nlMatrixTopNControlEntry           [1 ] nlMatrixTopNControlIndex*           [2 ] nlMatrixTopNControlMatrixIndex           [3 ] nlMatrixTopNControlRateBase           [4 ] nlMatrixTopNControlTimeRemaining           [5 ] nlMatrixTopNControlGeneratedReports           [6 ] nlMatrixTopNControlDuration           [7 ] nlMatrixTopNControlRequestedSize           [8 ] nlMatrixTopNControlGrantedSize           [9 ] nlMatrixTopNControlStartTime           [10] nlMatrixTopNControlOwner           [11] nlMatrixTopNControlStatus       [5 ] nlMatrixTopNTable         [1 ] nlMatrixTopNEntry           [1 ] nlMatrixTopNIndex*           [2 ] nlMatrixTopNProtocolDirLocalIndex           [3 ] nlMatrixTopNSourceAddress           [4 ] nlMatrixTopNDestAddress           [5 ] nlMatrixTopNPktRate           [6 ] nlMatrixTopNReversePktRate           [7 ] nlMatrixTopNOctetRate           [8 ] nlMatrixTopNReverseOctetRate     [16] alHost       [1 ] alHostTable         [1 ] alHostEntry           [1 ] alHostTimeMark*           [2 ] alHostInPkts           [3 ] alHostOutPkts           [4 ] alHostInOctets           [5 ] alHostOutOctets           [6 ] alHostCreateTime     [17] alMatrix       [1 ] alMatrixSDTable         [1 ] alMatrixSDEntry           [1 ] alMatrixSDTimeMark*           [2 ] alMatrixSDPkts           [3 ] alMatrixSDOctets           [4 ] alMatrixSDCreateTime       [2 ] alMatrixDSTable         [1 ] alMatrixDSEntry           [1 ] alMatrixDSTimeMark*           [2 ] alMatrixDSPkts           [3 ] alMatrixDSOctets           [4 ] alMatrixDSCreateTime       [3 ] alMatrixTopNControlTable         [1 ] alMatrixTopNControlEntry           [1 ] alMatrixTopNControlIndex*           [2 ] alMatrixTopNControlMatrixIndex           [3 ] alMatrixTopNControlRateBase           [4 ] alMatrixTopNControlTimeRemaining           [5 ] alMatrixTopNControlGeneratedReports           [6 ] alMatrixTopNControlDuration           [7 ] alMatrixTopNControlRequestedSize           [8 ] alMatrixTopNControlGrantedSize           [9 ] alMatrixTopNControlStartTime           [10] alMatrixTopNControlOwner           [11] alMatrixTopNControlStatus       [4 ] alMatrixTopNTable         [1 ] alMatrixTopNEntry           [1 ] alMatrixTopNIndex*           [2 ] alMatrixTopNProtocolDirLocalIndex           [3 ] alMatrixTopNSourceAddress           [4 ] alMatrixTopNDestAddress           [5 ] alMatrixTopNAppProtocolDirLocalIndex           [6 ] alMatrixTopNPktRate           [7 ] alMatrixTopNReversePktRate           [8 ] alMatrixTopNOctetRate           [9 ] alMatrixTopNReverseOctetRate     [18] usrHistory       [1 ] usrHistoryControlTable         [1 ] usrHistoryControlEntry           [1 ] usrHistoryControlIndex*           [2 ] usrHistoryControlObjects           [3 ] usrHistoryControlBucketsRequested           [4 ] usrHistoryControlBucketsGranted           [5 ] usrHistoryControlInterval           [6 ] usrHistoryControlOwner           [7 ] usrHistoryControlStatus       [2 ] usrHistoryObjectTable         [1 ] usrHistoryObjectEntry           [1 ] usrHistoryObjectIndex*           [2 ] usrHistoryObjectVariable           [3 ] usrHistoryObjectSampleType       [3 ] usrHistoryTable         [1 ] usrHistoryEntry           [1 ] usrHistorySampleIndex*           [2 ] usrHistoryIntervalStart           [3 ] usrHistoryIntervalEnd           [4 ] usrHistoryAbsValue           [5 ] usrHistoryValStatus     [19] probeConfig       [1 ] probeCapabilities       [2 ] probeSoftwareRev       [3 ] probeHardwareRev       [4 ] probeDateTime       [5 ] probeResetControl       [6 ] probeDownloadFile       [7 ] probeDownloadTFTPServer       [8 ] probeDownloadAction       [9 ] probeDownloadStatus       [10] serialConfigTable         [1 ] serialConfigEntry           [1 ] serialMode           [2 ] serialProtocol           [3 ] serialTimeout           [4 ] serialModemInitString           [5 ] serialModemHangUpString           [6 ] serialModemConnectResp           [7 ] serialModemNoConnectResp           [8 ] serialDialoutTimeout           [9 ] serialStatus       [11] netConfigTable         [1 ] netConfigEntry           [1 ] netConfigIPAddress           [2 ] netConfigSubnetMask           [3 ] netConfigStatus       [12] netDefaultGateway       [13] trapDestTable         [1 ] trapDestEntry           [1 ] trapDestIndex*           [2 ] trapDestCommunity           [3 ] trapDestProtocol           [4 ] trapDestAddress           [5 ] trapDestOwner           [6 ] trapDestStatus       [14] serialConnectionTable         [1 ] serialConnectionEntry           [1 ] serialConnectIndex*           [2 ] serialConnectDestIpAddress           [3 ] serialConnectType           [4 ] serialConnectDialString           [5 ] serialConnectSwitchConnectSeq           [6 ] serialConnectSwitchDisconnectSeq           [7 ] serialConnectSwitchResetSeq           [8 ] serialConnectOwner           [9 ] serialConnectStatus     [20] rmonConformance       [1 ] rmon2MIBCompliances         [1 ] rmon2MIBCompliance         [2 ] rmon2MIBApplicationLayerCompliance       [2 ] rmon2MIBGroups         [1 ] protocolDirectoryGroup         [2 ] protocolDistributionGroup         [3 ] addressMapGroup         [4 ] nlHostGroup         [5 ] nlMatrixGroup         [6 ] alHostGroup         [7 ] alMatrixGroup         [8 ] usrHistoryGroup         [9 ] probeInformationGroup         [10] probeConfigurationGroup         [11] rmon1EnhancementGroup         [12] rmon1EthernetEnhancementGroup         [13] rmon1TokenRingEnhancementGroup 

Monitoring Notes

If you intend to write your own SNMP application, the numeric root OID of the RMON MIB is 1.3.6.1.2.1.16. RMON II is an extension of this MIB.

The protocol directory lists all the protocols that the monitor supports. A monitor can add more protocols, but the extensibility is limited.

The protocol distribution group shows per-protocol statistics for the amount of data and packets being sent on a LAN segment. From this information, you can calculate the bandwidth utilization per protocol and, hopefully, isolate a troublesome application.

The address mappings group is used to map a network address to the station address to which it is bound. The network layer host group then shows the amount of traffic for each network address. The network layer matrix group shows network traffic statistics between pairs of network addresses. You can also see the top traffic producers .

The application layer host shows network traffic statistics for a particular network address, broken down by protocol. Similarly, the application layer matrix shows this information for traffic between a pair of network addresses.

Host Resources MIB

The Host Resources MIB is a proposed IETF standard for representing host information. This MIB requires the implementation of portions of the MIB-II. The Host Resources MIB includes information such as the current and maximum number of processes on a system and the system uptime. This MIB may be used to represent information about a computer system or about a device, such as a network printer.

MIB Definition

Listing A-4 shows the complete specification for the Host Resources MIB, as defined in RFC 1514.

Listing A-4 Host Resources MIB specification.

 mib_2   [25] host     [1 ] hrSystem       [1 ] hrSystemUptime       [2 ] hrSystemDate       [3 ] hrSystemInitialLoadDevice       [4 ] hrSystemInitialLoadParameters       [5 ] hrSystemNumUsers       [6 ] hrSystemProcesses       [7 ] hrSystemMaxProcesses     [2 ] hrStorage       [1 ] hrStorageTypes         [1 ] hrStorageOther         [2 ] hrStorageRam         [3 ] hrStorageVirtualMemory         [4 ] hrStorageFixedDisk         [5 ] hrStorageRemovableDisk         [6 ] hrStorageFloppyDisk         [7 ] hrStorageCompactDisc         [8 ] hrStorageRamDisk       [2 ] hrMemorySize       [3 ] hrStorageTable         [1 ] hrStorageEntry           [1 ] hrStorageIndex*           [2 ] hrStorageType           [3 ] hrStorageDescr           [4 ] hrStorageAllocationUnits           [5 ] hrStorageSize           [6 ] hrStorageUsed           [7 ] hrStorageAllocationFailures     [3 ] hrDevice       [1 ] hrDeviceTypes         [1 ] hrDeviceOther         [2 ] hrDeviceUnknown         [3 ] hrDeviceProcessor         [4 ] hrDeviceNetwork         [5 ] hrDevicePrinter         [6 ] hrDeviceDiskStorage         [10] hrDeviceVideo         [11] hrDeviceAudio         [12] hrDeviceCoprocessor         [13] hrDeviceKeyboard         [14] hrDeviceModem         [15] hrDeviceParallelPort         [16] hrDevicePointing         [17] hrDeviceSerialPort         [18] hrDeviceTape         [19] hrDeviceClock         [20] hrDeviceVolatileMemory         [21] hrDeviceNonVolatileMemory       [9 ] hrFSTypes         [1 ] hrFSOther         [2 ] hrFSUnknown         [3 ] hrFSBerkeleyFFS         [4 ] hrFSSys5FS         [5 ] hrFSFat         [6 ] hrFSHPFS         [7 ] hrFSHFS         [8 ] hrFSMFS         [9 ] hrFSNTFS         [10] hrFSVNode         [11] hrFSJournaled         [12] hrFSiso9660         [13] hrFSRockRidge         [14] hrFSNFS         [15] hrFSNetware         [16] hrFSAFS         [17] hrFSDFS         [18] hrFSAppleshare         [19] hrFSRFS         [20] hrFSDGCFS         [21] hrFSBFS       [2 ] hrDeviceTable         [1 ] hrDeviceEntry           [1 ] hrDeviceIndex*           [2 ] hrDeviceType           [3 ] hrDeviceDescr           [4 ] hrDeviceID           [5 ] hrDeviceStatus           [6 ] hrDeviceErrors       [3 ] hrProcessorTable         [1 ] hrProcessorEntry           [1 ] hrProcessorFrwID           [2 ] hrProcessorLoad       [4 ] hrNetworkTable         [1 ] hrNetworkEntry           [1 ] hrNetworkIfIndex       [5 ] hrPrinterTable         [1 ] hrPrinterEntry           [1 ] hrPrinterStatus           [2 ] hrPrinterDetectedErrorState       [6 ] hrDiskStorageTable         [1 ] hrDiskStorageEntry           [1 ] hrDiskStorageAccess           [2 ] hrDiskStorageMedia           [3 ] hrDiskStorageRemoveble           [4 ] hrDiskStorageCapacity       [7 ] hrPartitionTable         [1 ] hrPartitionEntry           [1 ] hrPartitionIndex*           [2 ] hrPartitionLabel           [3 ] hrPartitionID           [4 ] hrPartitionSize           [5 ] hrPartitionFSIndex       [8 ] hrFSTable         [1 ] hrFSEntry           [1 ] hrFSIndex*           [2 ] hrFSMountPoint           [3 ] hrFSRemoteMountPoint           [4 ] hrFSType           [5 ] hrFSAccess           [6 ] hrFSBootable           [7 ] hrFSStorageIndex           [8 ] hrFSLastFullBackupDate           [9 ] hrFSLastPartialBackupDate     [4 ] hrSWRun       [1 ] hrSWOSIndex       [2 ] hrSWRunTable         [1 ] hrSWRunEntry           [1 ] hrSWRunIndex*           [2 ] hrSWRunName           [3 ] hrSWRunID           [4 ] hrSWRunPath           [5 ] hrSWRunParameters           [6 ] hrSWRunType           [7 ] hrSWRunStatus     [5 ] hrSWRunPerf       [1 ] hrSWRunPerfTable         [1 ] hrSWRunPerfEntry           [1 ] hrSWRunPerfCPU           [2 ] hrSWRunPerfMem     [6 ] hrSWInstalled       [1 ] hrSWInstalledLastChange       [2 ] hrSWInstalledLastUpdateTime       [3 ] hrSWInstalledTable         [1 ] hrSWInstalledEntry           [1 ] hrSWInstalledIndex*           [2 ] hrSWInstalledName           [3 ] hrSWInstalledID           [4 ] hrSWInstalledType           [5 ] hrSWInstalledDate 

Monitoring Notes

If you intend to write your own SNMP application, the numeric root OID of the Host Resources MIB is 1.3.6.1.2.1.25.

The valid states for the hrDeviceStatus field in the hrDeviceTable are unknown, running, warning, testing, and down. When used for printers, this status can be combined with printer status fields to determine a more specific status of a printer device, such as active, busy, or unavailable.

Printer MIB

The Printer MIB is the proposed IETF standard for defining a printer's attributes and current status. The MIB focuses on management of the printer itself, not the queuing or scheduling of print jobs. The Printer MIB can report critical alerts such as "Out of Paper". Several printer vendors have already adopted this MIB. For example, Hewlett-Packard uses this MIB to record information about its LaserJet 5Si and many other printer models.

MIB Definition

Listing A-5 shows the complete specification for the Printer MIB, as defined in RFC 1759.

Listing A-5 Printer MIB specification.

 mib_2   [43] printmib     [5 ] prtGeneral       [1 ] prtGeneralTable         [1 ] prtGeneralEntry           [1 ] prtGeneralConfigChanges           [2 ] prtGeneralCurrentLocalization           [3 ] prtGeneralReset           [4 ] prtGeneralCurrentOperator           [5 ] prtGeneralServicePerson           [6 ] prtInputDefaultIndex           [7 ] prtOutputDefaultIndex           [8 ] prtMarkerDefaultIndex           [9 ] prtMediaPathDefaultIndex           [10] prtConsoleLocalization           [11] prtConsoleNumberOfDisplayLines           [12] prtConsoleNumberOfDisplayChars           [13] prtConsoleDisable       [2 ] prtStorageRefTable         [1 ] prtStorageRefEntry           [1 ] prtStorageRefSeqNumber*           [2 ] prtStorageRefIndex       [3 ] prtDeviceRefTable         [1 ] prtDeviceRefEntry           [1 ] prtDeviceRefSeqNumber*           [2 ] prtDeviceRefIndex     [6 ] prtCover       [1 ] prtCoverTable         [1 ] prtCoverEntry           [1 ] prtCoverIndex*           [2 ] prtCoverDescription           [3 ] prtCoverStatus     [7 ] prtLocalization       [1 ] prtLocalizationTable         [1 ] prtLocalizationEntry           [1 ] prtLocalizationIndex*           [2 ] prtLocalizationLanguage           [3 ] prtLocalizationCountry           [4 ] prtLocalizationCharacterSet     [8 ] prtInput       [2 ] prtInputTable         [1 ] prtInputEntry           [1 ] prtInputIndex*           [2 ] prtInputType           [3 ] prtInputDimUnit           [4 ] prtInputMediaDimFeedDirDeclared           [5 ] prtInputMediaDimXFeedDirDeclared           [6 ] prtInputMediaDimFeedDirChosen           [7 ] prtInputMediaDimXFeedDirChosen           [8 ] prtInputCapacityUnit           [9 ] prtInputMaxCapacity           [10] prtInputCurrentLevel           [11] prtInputStatus           [12] prtInputMediaName           [13] prtInputName           [14] prtInputVendorName           [15] prtInputModel           [16] prtInputVersion           [17] prtInputSerialNumber           [18] prtInputDescription           [19] prtInputSecurity           [20] prtInputMediaWeight           [21] prtInputMediaType           [22] prtInputMediaColor           [23] prtInputMediaFormParts     [9 ] prtOutput       [2 ] prtOutputTable         [1 ] prtOutputEntry           [1 ] prtOutputIndex*           [2 ] prtOutputType           [3 ] prtOutputCapacityUnit           [4 ] prtOutputMaxCapacity           [5 ] prtOutputRemainingCapacity           [6 ] prtOutputStatus           [7 ] prtOutputName           [8 ] prtOutputVendorName           [9 ] prtOutputModel           [10] prtOutputVersion           [11] prtOutputSerialNumber           [12] prtOutputDescription           [13] prtOutputSecurity           [14] prtOutputDimUnit           [15] prtOutputMaxDimFeedDir           [16] prtOutputMaxDimXFeedDir           [17] prtOutputMinDimFeedDir           [18] prtOutputMinDimXFeedDir           [19] prtOutputStackingOrder           [20] prtOutputPageDeliveryOrientation           [21] prtOutputBursting           [22] prtOutputDecollating           [23] prtOutputPageCollated           [24] prtOutputOffsetStacking     [10] prtMarker       [2 ] prtMarkerTable         [1 ] prtMarkerEntry           [1 ] prtMarkerIndex*           [2 ] prtMarkerMarkTech           [3 ] prtMarkerCounterUnit           [4 ] prtMarkerLifeCount           [5 ] prtMarkerPowerOnCount           [6 ] prtMarkerProcessColorants           [7 ] prtMarkerSpotColorants           [8 ] prtMarkerAddressabilityUnit           [9 ] prtMarkerAddressabilityFeedDir           [10] prtMarkerAddressabilityXFeedDir           [11] prtMarkerNorthMargin           [12] prtMarkerSouthMargin           [13] prtMarkerWestMargin           [14] prtMarkerEastMargin           [15] prtMarkerStatus     [11] prtMarkerSupplies       [1 ] prtMarkerSuppliesTable         [1 ] prtMarkerSuppliesEntry           [1 ] prtMarkerSuppliesIndex*           [2 ] prtMarkerSuppliesMarkerIndex           [3 ] prtMarkerSuppliesColorantIndex           [4 ] prtMarkerSuppliesClass           [5 ] prtMarkerSuppliesType           [6 ] prtMarkerSuppliesDescription           [7 ] prtMarkerSuppliesSupplyUnit           [8 ] prtMarkerSuppliesMaxCapacity           [9 ] prtMarkerSuppliesLevel     [12] prtMarkerColorant       [1 ] prtMarkerColorantTable         [1 ] prtMarkerColorantEntry           [1 ] prtMarkerColorantIndex*           [2 ] prtMarkerColorantMarkerIndex           [3 ] prtMarkerColorantRole           [4 ] prtMarkerColorantValue           [5 ] prtMarkerColorantTonality     [13] prtMediaPath       [4 ] prtMediaPathTable         [1 ] prtMediaPathEntry           [1 ] prtMediaPathIndex*           [2 ] prtMediaPathMaxSpeedPrintUnit           [3 ] prtMediaPathMediaSizeUnit           [4 ] prtMediaPathMaxSpeed           [5 ] prtMediaPathMaxMediaFeedDir           [6 ] prtMediaPathMaxMediaXFeedDir           [7 ] prtMediaPathMinMediaFeedDir           [8 ] prtMediaPathMinMediaXFeedDir           [9 ] prtMediaPathType           [10] prtMediaPathDescription           [11] prtMediaPathStatus     [14] prtChannel       [1 ] prtChannelTable         [1 ] prtChannelEntry           [1 ] prtChannelIndex*           [2 ] prtChannelType           [3 ] prtChannelProtocolVersion           [4 ] prtChannelCurrentJobCntlLangIndex           [5 ] prtChannelDefaultPageDescLangIndex           [6 ] prtChannelState           [7 ] prtChannelIfIndex           [8 ] prtChannelStatus     [15] prtInterpreter       [1 ] prtInterpreterTable         [1 ] prtInterpreterEntry           [1 ] prtInterpreterIndex*           [2 ] prtInterpreterLangFamily           [3 ] prtInterpreterLangLevel           [4 ] prtInterpreterLangVersion           [5 ] prtInterpreterDescription           [6 ] prtInterpreterVersion           [7 ] prtInterpreterDefaultOrientation           [8 ] prtInterpreterFeedAddressability           [9 ] prtInterpreterXFeedAddressability           [10] prtInterpreterDefaultCharSetIn           [11] prtInterpreterDefaultCharSetOut           [12] prtInterpreterTwoWay     [16] prtConsoleDisplayBuffer       [5 ] prtConsoleDisplayBufferTable         [1 ] prtConsoleDisplayBufferEntry           [1 ] prtConsoleDisplayBufferIndex*           [2 ] prtConsoleDisplayBufferText     [17] prtConsoleLights       [6 ] prtConsoleLightTable         [1 ] prtConsoleLightEntry           [1 ] prtConsoleLightIndex*           [2 ] prtConsoleOnTime           [3 ] prtConsoleOffTime           [4 ] prtConsoleColor           [5 ] prtConsoleDescription     [18] prtAlert       [2 ] printerV1Alert         [0 ] printerV2AlertPrefix           [1 ] printerV2Alert       [1 ] prtAlertTable         [1 ] prtAlertEntry           [1 ] prtAlertIndex*           [2 ] prtAlertSeverityLevel           [3 ] prtAlertTrainingLevel           [4 ] prtAlertGroup           [5 ] prtAlertGroupIndex           [6 ] prtAlertLocation           [7 ] prtAlertCode           [8 ] prtAlertDescription           [9 ] prtAlertTime     [2 ] prtMIBConformance       [2 ] prtMIBGroups         [1 ] prtGeneralGroup         [2 ] prtResponsiblePartyGroup         [3 ] prtInputGroup         [4 ] prtExtendedInputGroup         [5 ] prtInputMediaGroup         [6 ] prtOutputGroup         [7 ] prtExtendedOutputGroup         [8 ] prtOutputDimensionsGroup         [9 ] prtOutputFeaturesGroup         [10] prtMarkerGroup         [11] prtMarkerSuppliesGroup         [12] prtMarkerColorantGroup         [13] prtMediaPathGroup         [14] prtChannelGroup         [15] prtInterpreterGroup         [16] prtConsoleGroup         [17] prtAlertTableGroup         [18] prtAlertTimeGroup       [1 ] prtMIBCompliance 

Monitoring Notes

If you intend to write your own SNMP application, the numeric root OID of the Printer MIB is 1.3.6.1.2.1.43.

The Printer MIB requires portions of the MIB-II and the Host Resources MIB to be implemented. Many of the tables in the Printer MIB are indexed by hrDeviceIndex, from the Host Resources MIB.

The hrDeviceStatus field in the hrDeviceTable is combined with the hrPrinterStatus and hrPrinterDetectedErrorState fields in the hrPrinterTable to determine the specific status of a printer device. For example, if the hrPrinterStatus indicates an idle status and the hrDeviceStatus indicates a running status, then the corresponding printer is functioning normally. However, if the hrPrinterStatus is idle and the hrDeviceStatus indicates a warning status, then the printer has a status of noncritical alert active.

The prtAlertTable can record the list of alerts occurring for a printer device. The prtAlertCode indicates the specific printer problem, such as a paper jam, a paper tray missing, or low toner.

The HP-UNIX MIB

The HP-UNIX MIB is a private MIB provided by Hewlett-Packard. It is meant to be an extension to the MIB-II. The HP-UNIX MIB contains important information about the users, jobs, filesystems, memory, and processes of a system. The number of users logged in to the system and the number of jobs running are both indications of how busy the system is. The amount of free swap space or filesystem space can be a warning of potential problems. The process status can be checked to see whether a particular application is still running normally on the target system.

MIB Definition

Listing A-6 shows the complete specification for the HP-UNIX MIB, as defined by Hewlett-Packard.

Listing A-6 HP-UNIX MIB specification.

 enterprises   [11] hp     [2 ] nm       [3 ] system         [1 ] general           [1 ] computerSystem             [1 ] computerSystemUpTime             [2 ] computerSystemUsers             [3 ] computerSystemAvgJobs1             [4 ] computerSystemAvgJobs5             [5 ] computerSystemAvgJobs15             [6 ] computerSystemMaxProc             [7 ] computerSystemFreeMemory             [8 ] computerSystemPhysMemory             [9 ] computerSystemMaxUserMem             [10] computerSystemSwapConfig             [11] computerSystemEnabledSwap             [12] computerSystemFreeSwap             [13] computerSystemUserCPU             [14] computerSystemSysCPU             [15] computerSystemIdleCPU             [16] computerSystemNiceCPU           [2 ] fileSystem             [1 ] fileSystemMounted             [2 ] fileSystemTable               [1 ] fileSystemEntry                 [1 ] fileSystemID1*                 [2 ] fileSystemID2*                 [3 ] fileSystemName                 [4 ] fileSystemBlock                 [5 ] fileSystemBfree                 [6 ] fileSystemBavail                 [7 ] fileSystemBsize                 [8 ] fileSystemFiles                 [9 ] fileSystemFfree                 [10] fileSystemDir           [4 ] processes             [1 ] processNum             [2 ] processTable               [1 ] processEntry                 [1 ] processPID*                 [2 ] processIdx                 [3 ] processUID                 [4 ] processPPID                 [5 ] processDsize                 [6 ] processTsize                 [7 ] processSsize                 [8 ] processNice                 [9 ] processMajor                 [10] processMinor                 [11] processPgrp                 [12] processPrio                 [13] processAddr                 [14] processCPU                 [15] processUtime                 [16] processStime                 [17] processStart                 [18] processFlags                 [19] processStatus                 [20] processWchan                 [21] processProcNum                 [22] processCmd                 [23] processTime                 [24] processCPUticks                 [25] processCPUticksTotal                 [26] processFss                 [27] processPctCPU                 [28] processRssize                 [29] processSUID                 [30] processUname                 [31] processTTY           [5 ] cluster             [1 ] isClustered             [2 ] clusterTable               [1 ] clusterEntry                 [1 ] clusterID*                 [2 ] clusterMachineID                 [3 ] clusterType                 [4 ] clusterCnodeName                 [5 ] clusterSwapServingCnode                 [6 ] clusterKcsp                 [7 ] clusterCnodeAddress             [3 ] clusterCnodeID         [2 ] hpux           [2 ] hp9000s300           [3 ] hp9000s800           [5 ] hp9000s700         [10] hpsun           [1 ] sparc             [1 ] sun4             [2 ] sun5         [8 ] hp386       [4 ] interface         [1 ] ieee8023Mac           [1 ] ieee8023MacTable             [1 ] ieee8023MacEntry               [1 ] ieee8023MacIndex*               [2 ] ieee8023MacTransmitted               [3 ] ieee8023MacNotTransmitted               [4 ] ieee8023MacDeferred               [5 ] ieee8023MacCollisions               [6 ] ieee8023MacSingleCollisions               [7 ] ieee8023MacMultipleCollisions               [8 ] ieee8023MacExcessCollisions               [9 ] ieee8023MacLateCollisions               [10] ieee8023MacCarrierLostErrors               [11] ieee8023MacNoHeartBeatErrors               [12] ieee8023MacFramesReceived               [13] ieee8023MacUndeliverableFramesReceived               [14] ieee8023MacCRCErrors               [15] ieee8023MacAlignmentErrors               [16] ieee8023MacResourceErrors               [17] ieee8023MacControlFieldErrors               [18] ieee8023MacUnknownProtocolErrors               [19] ieee8023MacMulticastsAccepted       [7 ] icmp         [1 ] icmpEchoReq       [13] snmp         [1 ] trap           [1 ] trapDestinationNum           [2 ] trapDestinationTable             [1 ] trapDestinationEntry               [1 ] trapDestination*         [2 ] snmpdConf           [1 ] snmpdConfRespond           [2 ] snmpdReConfigure           [3 ] snmpdFlag           [4 ] snmpdLogMask           [5 ] snmpdVersion           [6 ] snmpdStatus           [7 ] snmpdSize           [9 ] snmpdWhatString         [4 ] authfail           [1 ] authFailTable             [1 ] authFailEntry               [1 ] authIpAddress*               [2 ] authTime               [3 ] authCommunityName       [17] openView         [2 ] openViewTrapVars           [1 ] openViewSourceId           [2 ] openViewSourceName           [3 ] openViewObjectId           [4 ] openViewData           [5 ] openViewSeverity           [6 ] openViewCategory           [7 ] openViewFilter           [8 ] openViewEntity           [9 ] openViewAddress           [10] openViewPid         [1 ] hpOpenView 

Monitoring Notes

The mnemonic root OID for the HP-UNIX MIB is iso.org.dod.internet.private.enterprises.hp.nm. If you intend to write your own SNMP application, you need to know the numeric root OID of the HP-UNIX MIB is 1.3.6.1.4.1.11.2.

HP's EMS HA Monitors product uses this MIB to monitor the current number of users and jobs on a system and the amount of free filesystem space.

This MIB can be a useful place to find information about the specific processes running on a system, such as their CPU utilization, priority, and resident set size . However, you may have a difficult time using a MIB Browser to wade through the numerous process table entries; this information is best queried from a customized SNMP application.

Note that this MIB contains information on NFS diskless clusters, but not on HP's high availability or EPS clusters. Information on these clusters is provided in the following sections.

HP Cluster MIB

The HP Cluster MIB is a private MIB provided by Hewlett-Packard. It defines cluster membership information for the high availability and EPS clusters.

MIB Definition

Listing A-7 shows the complete specification for the HP Cluster MIB, as defined by Hewlett-Packard.

Listing A-7 HP Cluster specification.

 enterprises   [11] hp     [2 ] nm       [3 ] system         [1 ] general           [6 ] hpmcCluster             [1 ] hpmcClusterObjects               [1 ] hpmcGenInfo                 [1 ] hpmcNumClusters                 [2 ] hpmcClusterTable                   [1 ] hpmcClusterEntry                     [1 ] hpmcClusterIndex*                     [2 ] hpmcClusterName                     [3 ] hpmcClusterType                     [4 ] hpmcClusterDescr                     [5 ] hpmcClusterSWVersion                     [6 ] hpmcClusterState                     [7 ] hpmcClusterLastStateChange                     [8 ] hpmcClusterLastReconfig                     [9 ] hpmcClusterPrimaryNode                     [10] hpmcNodeStatus                     [11] hpmcNodeLastEvent                     [12] hpmcNodeLastEventTime                     [13] hpmcClusterUpTime               [2 ] hpmcMemberInfo                 [1 ] hpmcCNodeTable                   [1 ] hpmcCNodeEntry                     [1 ] hpmcNodeID*                     [2 ] hpmcNodeName                     [3 ] hpmcNodeRole             [2 ] hpmcClusterTypes               [1 ] hpmcServiceGuard               [2 ] hpmcNFSDiskless               [3 ] hpmcMCSE               [4 ] hpmcLockManager             [3 ] hpmcTypeSpecific 

Monitoring Notes

If you intend to write your own SNMP application, the root OID of the HP Cluster MIB is 1.3.6.1.4.1.11.2.3.1.6.

You can use this MIB to find out which systems are part of a cluster and how long the cluster software has been running.

Additional fields specific to MC/ServiceGuard and MC/LockManager clusters are described in the following section. EPS clusters don't have any unique MIB variables. Note that this MIB does not include information on NFS or "diskless" clusters.

HP MC/ServiceGuard MIB

The HP MC/ServiceGuard MIB is an extension of the HP Cluster MIB, providing additional MIB variables specific to the MC/ServiceGuard high availability product. A better name might have been the HP HA MIB, because it also supports the HP MC/LockManager high availability product.

MIB Definition

Listing A-8 shows the complete specification for the HP MC/ServiceGuard MIB, as defined by Hewlett-Packard.

Listing A-8 HP MC/ServiceGuard specification.

 enterprises   [11] hp     [2 ] nm       [3 ] system         [1 ] general           [6 ] hpmcCluster             [3 ] hpmcTypeSpecific               [1 ] hpmcSGCluster                 [0 ] hpmcSGTraps                   [1 ] hpmcSGSubagentUp                   [2 ] hpmcSGReconfig                   [3 ] hpmcSGClusterUp                   [4 ] hpmcSGClusterDown                   [5 ] hpmcSGConfigChange                   [6 ] hpmcSGPkgStart                   [7 ] hpmcSGPkgUp                   [8 ] hpmcSGPkgHalt                   [9 ] hpmcSGPkgDown                   [10] hpmcSGSvcDown                   [11] hpmcSGPkgFlags                   [12] hpmcSGIPAddrUp                   [13] hpmcSGIPAddrDown                   [14] hpmcSGLocalSwitch                   [15] hpmcSGSubnetUp                   [16] hpmcSGSubnetDown                   [17] hpmcSGNodeUp                   [18] hpmcSGNodeHalted                   [19] hpmcSGNodeFailed                 [1 ] hpmcSGObjects                   [1 ] hpmcSGGenInfo                     [1 ] hpmcSGClusterIndex                     [2 ] hpmcSGClusterID                     [3 ] hpmcSGHeartbeatInterval                     [4 ] hpmcSGNodeTimeout                     [5 ] hpmcSGAutoStartTimeout                     [6 ] hpmcSGNetworkPollingInterval                   [2 ] hpmcSGLockInfo                     [1 ] hpmcSGLockTable                       [1 ] hpmcSGLockEntry                         [1 ] hpmcSGVolumeIndex*                         [2 ] hpmcSGPhysicalVolume                   [3 ] hpmcSGIfInfo                     [1 ] hpmcSGNetTable                       [1 ] hpmcSGNetEntry                         [1 ] hpmcSGNetIfIndex*                         [2 ] hpmcSGNetIfName                         [3 ] hpmcSGNetBridgedNet                         [4 ] hpmcSGNetIfFlags                         [5 ] hpmcSGNetLastEvent                         [6 ] hpmcSGNetLastEventTime                         [7 ] hpmcSGNetIfHwPath                   [4 ] hpmcSGPkgInfo                     [1 ] hpmcSGPkgTable                       [1 ] hpmcSGPkgEntry                         [1 ] hpmcSGPkgIndex*                         [2 ] hpmcSGPkgName                         [3 ] hpmcSGPkgDescr                         [4 ] hpmcSGPkgStatus                         [5 ] hpmcSGPkgCurrNode                         [6 ] hpmcSGPkgLastEvent                         [7 ] hpmcSGPkgLastEventTime                         [8 ] hpmcSGPkgRunScriptPath                         [9 ] hpmcSGPkgHaltScriptPath                         [10] hpmcSGPkgRunScriptTimeout                         [11] hpmcSGPkgHaltScriptTimeout                     [2 ] hpmcSGPkgSubnetTable                       [1 ] hpmcSGPkgSubnetEntry                         [1 ] hpmcSGPkgSubnet*                         [2 ] hpmcSGPkgSubnetStatus                         [3 ] hpmcSGPkgOverrideMACAddr                     [3 ] hpmcSGPkgAddrTable                       [1 ] hpmcSGPkgAddrEntry                         [1 ] hpmcSGPkgAddr*                         [2 ] hpmcSGPkgID                     [4 ] hpmcSGPkgSvcTable                       [1 ] hpmcSGPkgSvcEntry                         [1 ] hpmcSGPkgSvcIndex*                         [2 ] hpmcSGPkgSvcName                         [3 ] hpmcSGPkgSvcStatus                         [4 ] hpmcSGPkgSvcFlags                         [5 ] hpmcSGPkgSvcHaltTimeout                         [6 ] hpmcSGPkgSvcMaxRestarts                         [7 ] hpmcSGPkgSvcRestartCount                     [5 ] hpmcSGPkgNodeTable                       [1 ] hpmcSGPkgNodeEntry                         [1 ] hpmcSGPkgNodeRank*                         [2 ] hpmcSGPkgNode                         [3 ] hpmcSGPkgLocalSwitchEnable 

Monitoring Notes

If you intend to write your own SNMP application, the root OID of the HP Cluster MIB is 1.3.6.1.4.1.11.2.3.1.6. The cluster type, hpmcClusterTypes, should indicate MC/ServiceGuard or MC/LockManager, with the additional MIB variables referring to a high availability cluster.

You can check this MIB to ensure that high availability configuration parameters are set correctly, such as the heartbeat interval. You can also use this MIB to determine the critical applications running in the cluster and their status. Note, however, that the package status is accurate only on the cluster's coordinator node.

HP's EMS HA Monitors product uses this MIB to monitor MC/ServiceGuard and MC/LockManager cluster, node, package, and service status.

Network Services MIB

The Network Services MIB contains information that is meant to be generic for all network server applications. Database vendors use this MIB to store database server data. For example, Oracle takes advantage of this MIB to store information for the Oracle7 Server, the Oracle MultiProtocol Interchange, and the Oracle Names products.

MIB Definition

Listing A-9 shows the complete specification for the Network Services MIB, as defined in RFC 2248.

Listing A-9 Network Services MIB specification.

 mib_2   [27] application     [3 ] applConformance       [1 ] applGroups         [1 ] applGroup         [2 ] assocGroup       [2 ] applCompliances         [1 ] applCompliance         [2 ] assocCompliance     [4 ] applTCPProtoID     [5 ] applUDPProtoID     [1 ] applTable       [1 ] applEntry         [1 ] applIndex*         [2 ] applName         [3 ] applDirectoryName         [4 ] applVersion         [5 ] applUptime         [6 ] applOperStatus         [7 ] applLastChange         [8 ] applInboundAssociations         [9 ] applOutboundAssociations         [10] applAccumulatedInboundAssociations         [11] applAccumulatedOutboundAssociations         [12] applLastInboundActivity         [13] applLastOutboundActivity         [14] applRejectedInboundAssociations         [15] applFailedOutboundAssociations         [16] applDescription         [17] applURL     [2 ] assocTable       [1 ] assocEntry         [1 ] assocIndex*         [2 ] assocRemoteApplication         [3 ] assocApplicationProtocol         [4 ] assocApplicationType         [5 ] assocDuration 

Monitoring Notes

If you intend to write your own SNMP application, the root OID of the Network Services MIB is 1.3.6.1.2.1.27.

Important fields in this MIB include the application's name, uptime, version, and current status. You can also use this MIB to determine the current number of connections to an application.

Both Informix and Oracle support this MIB, but don't support all the MIB variables. The following fields in the applTable are supported by both vendors:

• applName

• applVersion

• applUptime

• applOperStatus

• applLastChange

• applInboundAssociations

Note that although Oracle and other database vendors use this MIB, it is not being used for more traditional network services, such as telnet.

RDBMS MIB

The Relational Database Management System (RDBMS) MIB contains information that is meant to be generic for all RDBMS systems. This MIB is supported by all the major database vendors. It provides availability information, such as database status and server uptime, and performance information, such as the number of logical database reads.

MIB Definition

Listing A-10 shows the complete specification for the RDBMS MIB, as defined in RFC 1697.

Listing A-10 RDBMS MIB specification.

 mib_2   [39] rdbmsMIB     [1 ] rdbmsObjects       [10] rdbmsWellKnownLimitedResources         [1 ] rdbmsLogSpace       [1 ] rdbmsDbTable         [1 ] rdbmsDbEntry           [1 ] rdbmsDbIndex*           [2 ] rdbmsDbPrivateMibOID           [3 ] rdbmsDbVendorName           [4 ] rdbmsDbName           [5 ] rdbmsDbContact       [2 ] rdbmsDbInfoTable         [1 ] rdbmsDbInfoEntry           [1 ] rdbmsDbInfoProductName           [2 ] rdbmsDbInfoVersion           [3 ] rdbmsDbInfoSizeUnits           [4 ] rdbmsDbInfoSizeAllocated           [5 ] rdbmsDbInfoSizeUsed           [6 ] rdbmsDbInfoLastBackup       [3 ] rdbmsDbParamTable         [1 ] rdbmsDbParamEntry           [1 ] rdbmsDbParamName*           [2 ] rdbmsDbParamSubIndex           [3 ] rdbmsDbParamID           [4 ] rdbmsDbParamCurrValue           [5 ] rdbmsDbParamComment       [4 ] rdbmsDbLimitedResourceTable         [1 ] rdbmsDbLimitedResourceEntry           [1 ] rdbmsDbLimitedResourceName*           [2 ] rdbmsDbLimitedResourceID           [3 ] rdbmsDbLimitedResourceLimit           [4 ] rdbmsDbLimitedResourceCurrent           [5 ] rdbmsDbLimitedResourceHighwater           [6 ] rdbmsDbLimitedResourceFailures           [7 ] rdbmsDbLimitedResourceDescription       [5 ] rdbmsSrvTable         [1 ] rdbmsSrvEntry           [1 ] rdbmsSrvPrivateMibOID           [2 ] rdbmsSrvVendorName           [3 ] rdbmsSrvProductName           [4 ] rdbmsSrvContact       [6 ] rdbmsSrvInfoTable         [1 ] rdbmsSrvInfoEntry           [1 ] rdbmsSrvInfoStartupTime           [2 ] rdbmsSrvInfoFinishedTransactions           [3 ] rdbmsSrvInfoDiskReads           [4 ] rdbmsSrvInfoLogicalReads           [5 ] rdbmsSrvInfoDiskWrites           [6 ] rdbmsSrvInfoLogicalWrites           [7 ] rdbmsSrvInfoPageReads           [8 ] rdbmsSrvInfoPageWrites           [9 ] rdbmsSrvInfoDiskOutOfSpaces           [10] rdbmsSrvInfoHandledRequests           [11] rdbmsSrvInfoRequestRecvs           [12] rdbmsSrvInfoRequestSends           [13] rdbmsSrvInfoHighwaterInboundAssociations           [14] rdbmsSrvInfoMaxInboundAssociations       [7 ] rdbmsSrvParamTable         [1 ] rdbmsSrvParamEntry           [1 ] rdbmsSrvParamName*           [2 ] rdbmsSrvParamSubIndex           [3 ] rdbmsSrvParamID           [4 ] rdbmsSrvParamCurrValue           [5 ] rdbmsSrvParamComment       [8 ] rdbmsSrvLimitedResourceTable         [1 ] rdbmsSrvLimitedResourceEntry           [1 ] rdbmsSrvLimitedResourceName*           [2 ] rdbmsSrvLimitedResourceID           [3 ] rdbmsSrvLimitedResourceLimit           [4 ] rdbmsSrvLimitedResourceCurrent           [5 ] rdbmsSrvLimitedResourceHighwater           [6 ] rdbmsSrvLimitedResourceFailures           [7 ] rdbmsSrvLimitedResourceDescription       [9 ] rdbmsRelTable         [1 ] rdbmsRelEntry           [1 ] rdbmsRelState           [2 ] rdbmsRelActiveTime     [2 ] rdbmsTraps       [1 ] rdbmsStateChange       [2 ] rdbmsOutOfSpace     [3 ] rdbmsConformance       [1 ] rdbmsCompliances         [1 ] rdbmsCompliance       [2 ] rdbmsGroups         [1 ] rdbmsGroup 

Monitoring Notes

If you intend to write your own SNMP application, the root OID of the RDBMS MIB is 1.3.6.1.2.1.39.

The RDBMS MIB contains both fault and performance information. The MIB contains the state of each database. The status of a database instance is obtained by cross-referencing the server tables with the application entries in the Network Services MIB. In this way, you can see the process status ( applOperStatus ). To verify that the server is responding, you can check applAccumulatedInboundAssociations to see whether the number of connections is still increasing. This field is supported by Informix, but not Oracle.

Performance information includes the number of committed database transactions and database I/O and cache hit rates.

You can also use this MIB to determine whether database tables are reaching their configured limits.

Database vendors don't implement all components of this MIB. Oracle and Informix, for example, don't implement the following tables of the RDBMS MIB:

• rdbmsDbParamTable

• rdbmsDbLimitedResourceTable

In addition, Oracle doesn't implement the rdbmsSrvLimitedResourceTable in the RDBMS MIB.

Oracle Private Database MIB

Oracle's Private Database MIB contains additional RDBMS statistics specific to the Oracle7 architecture. It is meant to be used as a supplement to the RDBMS MIB. The majority of the information in this MIB is performance- related .

MIB Definition

Listing A-11 shows the complete specification for Oracle's Private Database MIB, as defined by Oracle.

Listing A-11 Oracle Private Database MIB specification.

 enterprises   [111] oracle     [4 ] oraDbMIB       [1 ] oraDbObjects         [1 ] oraDbSysTable           [1 ] oraDbSysEntry             [1 ] oraDbSysConsistentChanges             [2 ] oraDbSysConsistentGets             [3 ] oraDbSysDbBlockChanges             [4 ] oraDbSysDbBlockGets             [5 ] oraDbSysFreeBufferInspected             [6 ] oraDbSysFreeBufferRequested             [7 ] oraDbSysParseCount             [8 ] oraDbSysPhysReads             [9 ] oraDbSysPhysWrites             [10] oraDbSysRedoEntries             [11] oraDbSysRedoLogSpaceRequests             [12] oraDbSysRedoSyncWrites             [13] oraDbSysSortsDisk             [14] oraDbSysSortsMemory             [15] oraDbSysSortsRows             [16] oraDbSysTableFetchRowid             [17] oraDbSysTableFetchContinuedRow             [18] oraDbSysTableScanBlocks             [19] oraDbSysTableScanRows             [20] oraDbSysTableScansLong             [21] oraDbSysTableScansShort             [22] oraDbSysUserCalls             [23] oraDbSysUserCommits             [24] oraDbSysUserRollbacks             [25] oraDbSysWriteRequests         [2 ] oraDbTablespaceTable           [1 ] oraDbTablespaceEntry             [1 ] oraDbTablespaceIndex*             [2 ] oraDbTablespaceName             [3 ] oraDbTablespaceSizeAllocated             [4 ] oraDbTablespaceSizeUsed             [5 ] oraDbTablespaceState             [6 ] oraDbTablespaceLargestAvailableChunk         [3 ] oraDbDataFileTable           [1 ] oraDbDataFileEntry             [1 ] oraDbDataFileIndex*             [2 ] oraDbDataFileName             [3 ] oraDbDataFileSizeAllocated             [4 ] oraDbDataFileDiskReads             [5 ] oraDbDataFileDiskWrites             [6 ] oraDbDataFileDiskReadBlocks             [7 ] oraDbDataFileDiskWrittenBlocks             [8 ] oraDbDataFileDiskReadTimeTicks             [9 ] oraDbDataFileDiskWriteTimeTicks         [4 ] oraDbLibraryCacheTable           [1 ] oraDbLibraryCacheEntry             [1 ] oraDbLibraryCacheIndex*             [2 ] oraDbLibraryCacheNameSpace             [3 ] oraDbLibraryCacheGets             [4 ] oraDbLibraryCacheGetHits             [5 ] oraDbLibraryCachePins             [6 ] oraDbLibraryCachePinHits             [7 ] oraDbLibraryCacheReloads             [8 ] oraDbLibraryCacheInvalidations         [5 ] oraDbLibraryCacheSumTable           [1 ] oraDbLibraryCacheSumEntry             [1 ] oraDbLibraryCacheSumGets             [2 ] oraDbLibraryCacheSumGetHits             [3 ] oraDbLibraryCacheSumPins             [4 ] oraDbLibraryCacheSumPinHits             [5 ] oraDbLibraryCacheSumReloads             [6 ] oraDbLibraryCacheSumInvalidations         [6 ] oraDbSGATable           [1 ] oraDbSGAEntry             [1 ] oraDbSGAFixedSize             [2 ] oraDbSGAVariableSize             [3 ] oraDbSGADatabaseBuffers             [4 ] oraDbSGARedoBuffers         [7 ] oraDbConfigTable           [1 ] oraDbConfigEntry             [1 ] oraDbConfigDbBlockBuffers             [2 ] oraDbConfigDbBlockCkptBatch             [3 ] oraDbConfigDbBlockSize             [4 ] oraDbConfigDbFileSimWrites             [5 ] oraDbConfigDbMultiBlockReadCount             [6 ] oraDbConfigDistLockTimeout             [7 ] oraDbConfigDistRecoveryConnectHold             [8 ] oraDbConfigDistTransactions             [9 ] oraDbConfigLogArchiveBufferSize             [10] oraDbConfigLogArchiveBuffers             [11] oraDbConfigLogBuffer             [12] oraDbConfigLogCheckpointInterval             [13] oraDbConfigLogCheckpointTimeout             [14] oraDbConfigLogFiles             [15] oraDbConfigMaxRollbackSegments             [16] oraDbConfigMTSMaxDispatchers             [17] oraDbConfigMTSMaxServers             [18] oraDbConfigMTSServers             [19] oraDbConfigOpenCursors             [20] oraDbConfigOpenLinks             [21] oraDbConfigOptimizerMode             [22] oraDbConfigProcesses             [23] oraDbConfigSerializable             [24] oraDbConfigSessions             [25] oraDbConfigSharedPool             [26] oraDbConfigSortAreaSize             [27] oraDbConfigSortAreaRetainedSize             [28] oraDbConfigTransactions             [29] oraDbConfigTransactionsPerRollback 

Monitoring Notes

The mnemonic root OID for Oracle's Private Database MIB is iso.org.dod.internet.private.enterprises.oracle.oraDbMIB. If you intend to write your own SNMP application, the numeric root OID of Oracle's Private Database MIB is 1.3.6.1.4.1.111.4.

Many of the table entries in this MIB are indexed by using applIndex from the Network Services MIB.

This MIB contains several fields that are useful for performance monitoring. They supply statistics such as the number of block changes, user calls, consistent Gets, block Gets, physical reads, recursive calls, user commits, and consistent changes. This data needs to be queried at regular intervals to establish baselines and to be able to determine whether a persistent performance problem exists.

Each entry in the oraDbSysTable corresponds to a current database instance on the system. The table is indexed by rdbmsDbIndex, from the RDBMS MIB.

Each entry in the oraDbTablespaceTable represents a given tablespace within a current database instance. The table is indexed by rdbmsDbIndex, from the RDBMS MIB, and by oraDbTablespaceIndex.

One rdbmsDbTable entry is likely to correspond to multiple tablespace table entries. For example, addition to indicating the amount of space allocated and in use, the state variable oraDbTablespaceState indicates whether the tablespace is offline or accessible.

The oraDbDataFileTable keeps track of the number of disk reads and writes being made to a data file. The oraDbConfigTable stores important database configuration parameters, such as DB_BLOCK_BUFFERS, which is used to determine the buffer cache size.

The oraDbLibraryCacheTable keeps track of performance data about the library cache. Variables in this table, such as oraDbLibraryCachePins and oraDbLibraryCacheReloads, can be used to calculate the library cache miss rate. Each table entry represents a given library cache within a current database instance on the system. The oraDbLibraryCacheSumTable provides summary information for all the library caches in a database instance.

Oracle Network Listener MIB

The Oracle Network Listener MIB is a protocol-independent application that receives connection requests from remote database users. Oracle provides a private Network Listener MIB that includes additional information about the current status of the listener process.

MIB Definition

Listing A-12 shows the complete specification for Oracle's private Network Listener MIB, as defined by Oracle.

Listing A-12 Oracle Network Listener MIB specification.

 enterprises   [111] oracle     [5 ] oraListenerMIB       [1 ] oraListenerObjects         [1 ] oraListenerTable           [1 ] oraListenerEntry             [1 ] oraListenerIndex*             [2 ] oraListenerName             [3 ] oraListenerVersion             [4 ] oraListenerStartDate             [5 ] oraListenerUptime             [6 ] oraListenerTraceLevel             [7 ] oraListenerSecurityLevel             [8 ] oraListenerParameterFile             [9 ] oraListenerLogFile             [10] oraListenerTraceFile             [11] oraListenerState             [12] oraListenerNumberOfServices             [13] oraListenerContact         [5 ] oraSIDTable           [1 ] oraSIDEntry             [1 ] oraSIDListenerIndex*             [2 ] oraSIDName*             [3 ] oraSIDCurrentConnectedClients             [4 ] oraSIDReservedConnections         [2 ] oraDedicatedSrvTable           [1 ] oraDedicatedSrvEntry             [1 ] oraDedicatedSrvIndex*             [2 ] oraDedicatedSrvEstablishedConnections             [3 ] oraDedicatedSrvRejectedConnections         [3 ] oraDispatcherTable           [1 ] oraDispatcherEntry             [1 ] oraDispatcherIndex*             [2 ] oraDispatcherEstablishedConnections             [3 ] oraDispatcherRejectedConnections             [4 ] oraDispatcherCurrentConnections             [5 ] oraDispatcherMaximumConnections             [6 ] oraDispatcherState             [7 ] oraDispatcherProtocolInfo         [4 ] oraPrespawnedSrvTable           [1 ] oraPrespawnedSrvEntry             [1 ] oraPrespawnedSrvIndex*             [2 ] oraPrespawnedSrvEstablishedConnections             [3 ] oraPrespawnedSrvRejectedConnections             [4 ] oraPrespawnedSrvCurrentConnections             [5 ] oraPrespawnedSrvMaximumConnections             [6 ] oraPrespawnedSrvState             [7 ] oraPrespawnedSrvProtocolInfo             [8 ] oraPrespawnedSrvProcessorID         [6 ] oraListenAddressTable           [1 ] oraListenAddressEntry             [1 ] oraListenAddressIndex*             [2 ] oraListenAddress       [2 ] oraListenerTraps         [1 ] oraListenerStateChange 

Monitoring Notes

If you intend to write your own SNMP application, the root OID of Oracle's Network Listener MIB is 1.3.6.1.4.1.111.5.

Each entry in the oraListenerTable represents the network listener for a current database instance on the system. You should monitor the state of the listener, oraListenerState, to ensure that the process is still running. If the listener isn't running, then no new client connection requests can be processed . You can monitor this by having your management station listen for an oraListenerStateChange trap, indicating that the listener has changed state. This is the only trap currently provided by the MIB. Note that Oracle's OEM MIB also includes a trap that is sent when the OEM agent detects that the listener has gone down.

One oraSIDEntry exists for each database instance for which the listener listens. You should compare the current number of connected clients with the maximum reserved, to see whether you are nearing the limit. When the limit is reached, new requests are redirected to dedicated servers, which require more system resources.

Dispatchers and prespawned servers are optional processes to help clients connect to the database. Again, to check whether a problem is imminent, check whether the current number of connections is approaching the maximum number of connections allowed.

Oracle Names MIB

The Oracle Names product provides an enterprise directory service for database information. More information about Oracle Names can be found in Oracle Names Administrator's Guide from Oracle. This private Oracle MIB provides additional information about the current status of the Oracle Names product.

MIB Definition

Listing A-13 shows the complete specification for Oracle's Names MIB, as defined by Oracle.

Listing A-13 Oracle Names MIB specification.

 enterprises   [111] oracle     [6 ] oraNamesMIB       [1 ] oraNamesObjects         [1 ] oraNamesTNSTable           [1 ] oraNamesTNSEntry             [1 ] oraNamesTNSstartDate             [2 ] oraNamesTNStraceLevel             [3 ] oraNamesTNSsecurityLevel             [4 ] oraNamesTNSparameterFile             [5 ] oraNamesTNSlogFile             [6 ] oraNamesTNStraceFile             [7 ] oraNamesTNSstate             [8 ] oraNamesTNScontact             [9 ] oraNamesTNSlistenAddresses             [10] oraNamesTNSfailedListenAddresses             [11] oraNamesTNSreload             [12] oraNamesTNSrunningTime         [2 ] oraNamesConfigTable           [1 ] oraNamesConfigEntry             [1 ] oraNamesConfigAdminRegion             [2 ] oraNamesConfigAuthorityRequired             [3 ] oraNamesConfigAutoRefreshExpire             [4 ] oraNamesConfigAutoRefreshRetry             [5 ] oraNamesConfigCacheCheckpointFile             [6 ] oraNamesConfigCacheCheckpointInterval             [7 ] oraNamesConfigConfigCheckpointFile             [8 ] oraNamesConfigDefaultForwarders             [9 ] oraNamesConfigDefaultForwardersOnly             [10] oraNamesConfigDomainCheckpointFile             [11] oraNamesConfigDomainHints             [12] oraNamesConfigDomains             [13] oraNamesConfigForwardingAvailable             [14] oraNamesConfigForwardingDesired             [15] oraNamesConfigLogDirectory             [16] oraNamesConfigLogStatsInterval             [17] oraNamesConfigLogUnique             [18] oraNamesConfigMaxOpenConnections             [19] oraNamesConfigMaxReforwards             [20] oraNamesConfigMessagePoolStartSize             [21] oraNamesConfigNoModifyRequests             [22] oraNamesConfigNoRegionDatabase             [23] oraNamesConfigResetStatsInterval             [24] oraNamesConfigServerName             [25] oraNamesConfigTopologyCheckpointFile             [26] oraNamesConfigTraceDirectory             [27] oraNamesConfigTraceFunc             [28] oraNamesConfigTraceMask             [29] oraNamesConfigTraceUnique         [3 ] oraNamesServerTable           [1 ] oraNamesServerEntry             [1 ] oraNamesServerQueriesReceived             [2 ] oraNamesServerLastNnamesNotFound             [3 ] oraNamesServerQueriesTotalTime             [4 ] oraNamesServerDeletesReceived             [5 ] oraNamesServerDeletesRefused             [6 ] oraNamesServerDeletesTotalTime             [7 ] oraNamesServerRenamesReceived             [8 ] oraNamesServerRenamesRefused             [9 ] oraNamesServerRenamesTotalTime             [10] oraNamesServerUpdatesReceived             [11] oraNamesServerUpdatesRefused             [12] oraNamesServerUpdatesTotalTime             [13] oraNamesServerCorruptMessagesReceived             [14] oraNamesServerResponsesSent             [15] oraNamesServerErrorResponsesSent             [16] oraNamesServerAliasLoopsDetected             [17] oraNamesServerLookupsAttempted             [18] oraNamesServerCreatedOnLookup             [19] oraNamesServerLookupFailures             [20] oraNamesServerExactMatches             [21] oraNamesServerForwardFailures             [22] oraNamesServerForwardTimeouts             [23] oraNamesServerResponsesReceived             [24] oraNamesServerErrorResponsesReceived             [25] oraNamesServerRequestsForwarded             [26] oraNamesServerLastReload             [27] oraNamesServerReloadCheckFailures             [28] oraNamesServerLastCheckpoint             [29] oraNamesServerName             [30] oraNamesServerAdminRegion 

Monitoring Notes

If you intend to write your own SNMP application, the root OID of the Oracle Names MIB is 1.3.6.1.4.1.111.6.

The table entries in this MIB are indexed using applIndex from the Network Services MIB.

Running time in the oraNamesTNSTable table can be used to get an idea of how long the server has been running. Several fields in this table are not supported for Oracle Names, including the start date, security level, state, listen addresses, and failed listen addresses.

The oraNamesConfigTable includes important configuration information, such as the server name and administrative region name. Several fields in the table aren't supported for Oracle Names, including the configuration's checkpoint file, the default forwarders, fields related to domains, the configuration log file directory, the configuration unique log flag, the maximum number of open connections, the message pool start size, the region database flag, the topology checkpoint file, and the fields related to tracing.

The oraNamesServerTable includes important performance information, such as the number of queries received and responses sent, and the time spent processing the queries. Several fields aren't supported: last few names not found; information on deletes, renames, and updates; statistics on error responses; the last reload time; and the last checkpoint time.

Oracle Enterprise Manager MIB

Oracle Enterprise Manager (OEM) provides database management and monitoring. OEM supports the private Oracle Enterprise Manager MIB, which includes information about database events discovered by the OEM agent.

MIB Definition

Listing A-14 shows the complete specification for the Oracle Enterprise Manager MIB, as defined by Oracle.

Listing A-14 Oracle Enterprise Manager MIB specification.

 enterprises   [111] oracle     [12] oraAgent       [1 ] oraAgentObjects         [1 ] oraAgentEventTable           [1 ] oraAgentEventEntry             [1 ] oraAgentEventIndex*             [2 ] oraAgentEventName             [3 ] oraAgentEventID             [4 ] oraAgentEventService             [5 ] oraAgentEventTime             [6 ] oraAgentEventSeverity             [7 ] oraAgentEventUser             [8 ] oraAgentEventAppID             [9 ] oraAgentEventMessage             [10] oraAgentEventArguments             [11] oraAgentEventResults       [2 ] oraAgentTraps         [1 ] oraAgentEventOcc         [2 ] oraAgentEventDbUpdown         [3 ] oraAgentEventDbAlert         [4 ] oraAgentEventDbProbe         [5 ] oraAgentEventDbUserBlock         [6 ] oraAgentEventDbArchFull         [7 ] oraAgentEventDbDumpFull         [8 ] oraAgentEventDbMaxExtent         [9 ] oraAgentEventDbChunkSmall         [10] oraAgentEventDbDatafileLimit         [11] oraAgentEventDbLockLimit         [12] oraAgentEventDbProcessLimit         [13] oraAgentEventDbSessionLimit         [14] oraAgentEventDbUserLimit         [15] oraAgentEventDbBufferCache         [16] oraAgentEventDbChainRow         [17] oraAgentEventDbDataDictionaryCache         [18] oraAgentEventDbDiskIORate         [19] oraAgentEventDbLibraryCache         [20] oraAgentEventDbNetIORate         [21] oraAgentEventDbResponseTime         [22] oraAgentEventDbSysStat         [23] oraAgentEventDbSysStatDelta         [24] oraAgentEventSQLNetUpDown         [25] oraAgentEventHostCPULoad         [26] oraAgentEventHostCPUUtil         [27] oraAgentEventHostPaging         [28] oraAgentEventHostSwapFull         [29] oraAgentEventHostDiskFull 

Monitoring Notes

If you intend to write your own SNMP application, the root OID of the Oracle Enterprise Manager MIB is 1.3.6.1.4.1.111.12.

All events discovered by the OEM agent can also be sent as SNMP traps. Possible traps include reaching the limits on available file space or concurrent locks and sessions, falling below configured limits for cache hit ratios, and reaching system performance thresholds, such as CPU utilization.

Oracle MultiProtocol Interchange MIB

Oracle MultiProtocol Interchange is a product that is used to provide application connectivity by translating between different network transport stacks. It supports the private Oracle MultiProtocol Interchange MIB, which includes information about the current status of the MultiProtocol Interchange (MPI) and its components.

MIB Definition

Listing A-15 shows the complete specification for Oracle's private MultiProtocol Interchange MIB, as defined by Oracle.

Listing A-15 Oracle MultiProtocol Interchange MIB specification.

 enterprises   [111] oracle     [7 ] oraInterchangeMIB       [1 ] oraInterchangeObjects         [1 ] oraInterchgTable           [1 ] oraInterchgEntry             [1 ] oraInterchgConfigDirectory             [2 ] oraInterchgContactInfo         [2 ] oraNavigatorTable           [1 ] oraNavigatorEntry             [1 ] oraNavigatorRunningTime             [2 ] oraNavigatorLogging             [3 ] oraNavigatorLoggingLevel             [4 ] oraNavigatorLogFile             [5 ] oraNavigatorTraceLevel             [6 ] oraNavigatorTraceFile             [7 ] oraNavigatorStoppable             [8 ] oraNavigatorAccumulatedSuccessfulRequests             [9 ] oraNavigatorAccumulatedFailedRequests             [10] oraNavigatorState             [11] oraNavigatorErrors             [12] oraNavigatorErrorMessage         [3 ] oraNavigatorListenAddressTable           [1 ] oraNavigatorListenAddressEntry             [1 ] oraNavigatorListenAddressIndex*             [2 ] oraNavigatorListenAddress         [4 ] oraNavigatorFailedAddressTable           [1 ] oraNavigatorFailedAddressEntry             [1 ] oraNavigatorFailedAddressIndex*             [2 ] oraNavigatorFailedAddress         [5 ] oraNavigatorRouteAddressTable           [1 ] oraNavigatorRouteAddressEntry             [1 ] oraNavigatorRouteAddressIndex*             [2 ] oraNavigatorRouteAddress         [6 ] oraCmanagerTable           [1 ] oraCmanagerEntry             [1 ] oraCmanagerStartTime             [2 ] oraCmanagerRunningTime             [3 ] oraCmanagerLogging             [4 ] oraCmanagerLogFile             [5 ] oraCmanagerTraceLevel             [6 ] oraCmanagerTraceFile             [7 ] oraCmanagerStoppable             [8 ] oraCmanagerMaximumPumps             [9 ] oraCmanagerMaximumConnectionsPerPump             [10] oraCmanagerPumpStrategy             [11] oraCmanagerActivePumps             [12] oraCmanagerMaximumConnections             [13] oraCmanagerCurrentConnectionsInUse             [14] oraCmanagerAccumulatedSuccessfulConnections             [15] oraCmanagerAccumulatedFailedConnections             [16] oraCmanagerImmediateAverageBytes             [17] oraCmanagerMaximumConnectTime             [18] oraCmanagerMinimumConnectTime             [19] oraCmanagerAverageConnectTime             [20] oraCmanagerMaximumConnectDuration             [21] oraCmanagerState             [22] oraCmanagerErrors             [23] oraCmanagerErrorMessage         [7 ] oraCmanagerListenAddressTable           [1 ] oraCmanagerListenAddressEntry             [1 ] oraCmanagerListenAddressIndex*             [2 ] oraCmanagerListenAddress         [8 ] oraCmanagerFailedAddressTable           [1 ] oraCmanagerFailedAddressEntry             [1 ] oraCmanagerFailedAddressIndex*             [2 ] oraCmanagerFailedAddress         [9 ] oraPumpTable           [1 ] oraPumpEntry             [1 ] oraPumpIndex*             [2 ] oraPumpActiveTime             [3 ] oraPumpTraceLevel             [4 ] oraPumpTraceFile             [5 ] oraPumpActiveConnections             [6 ] oraPumpSuccessfulConnections             [7 ] oraPumpFailedConnections             [8 ] oraPumpAccumulatedBytesSent             [9 ] oraPumpCurrentBytesPerSecond             [10] oraPumpMaximumAverageBytes             [11] oraPumpImmediateAverageBytes             [12] oraPumpMaximumConnectTime             [13] oraPumpMinimumConnectTime             [14] oraPumpAverageConnectTime             [15] oraPumpMaximumConnectDuration             [16] oraPumpMaximumBuffers             [17] oraPumpBufferUtilization             [18] oraPumpErrors             [19] oraPumpErrorMessage         [10] oraPumpListenAddressTable           [1 ] oraPumpListenAddressEntry             [1 ] oraPumpListenAddressIndex             [2 ] oraPumpListenAddress         [11] oraPumpFailedAddressTable           [1 ] oraPumpFailedAddressEntry             [1 ] oraPumpFailedAddressIndex             [2 ] oraPumpFailedAddress         [12] oraConnectionTable           [1 ] oraConnectionEntry             [1 ] oraConnectionIndex             [2 ] oraConnectionPumpID             [3 ] oraConnectionIdleTime             [4 ] oraConnectionDuration             [5 ] oraConnectionSourceAddress             [6 ] oraConnectionDestinationAddress       [2 ] oraInterchgTraps 

Monitoring Notes

If you intend to write your own SNMP application, the root OID of Oracle's MultiProtocol Interchange MIB is 1.3.6.1.4.1.111.7.

Many of the table entries in this MIB are indexed by using applIndex from the Network Services MIB.

This MIB includes information about several components of MPI, such as the Navigator and Connection Manager. The duration and idle time of each connection are also provided.

Informix Private Database MIB

The Informix-Online Dynamic Server has a private database MIB in addition to its support of the RDBMS MIB. Information available includes lock requests, checkpoint status, and the number of deadlocks.

MIB Definition

Listing A-16 shows the complete specification for the Informix-Online Private Database MIB, as defined by Informix.

Listing A-16 Informix-Online Private Database MIB specification.

 enterprises   [893] informix     [1 ] servers       [1 ] onlineMIB         [1 ] onlineObjects           [1 ] onServerTable             [1 ] onServerEntry               [1 ] onServerMode               [2 ] onServerCheckpointInProgress               [3 ] onServerPageSize               [4 ] onServerThreads               [5 ] onServerVPs               [6 ] onServerVirtualMemory               [7 ] onServerResidentMemory               [8 ] onServerMessageMemory               [9 ] onServerIsamCalls               [10] onServerLatchWaits               [11] onServerLockRequests               [12] onServerLockWaits               [13] onServerBufferWaits               [14] onServerCheckpoints               [15] onServerCheckpointWaits               [16] onServerDeadLocks               [17] onServerLockTimeouts               [18] onServerLogicalLogRecords               [19] onServerLogicalLogPageWrites               [20] onServerLogicalLogWrites               [21] onServerBufferFlushes               [22] onServerForegroundWrites               [23] onServerLRUWrites               [24] onServerChunkWrites               [25] onServerReadAheadPages               [26] onServerReadAheadPagesUsed               [27] onServerSequentialScans               [28] onServerMemorySorts               [29] onServerDiskSorts               [30] onServerMaxSortSpace               [31] onServerNetworkReads               [32] onServerNetworkWrites               [33] onServerPDQCalls           [2 ] onDatabaseTable             [1 ] onDatabaseEntry               [1 ] onDatabaseDbspace               [2 ] onDatabaseCreated               [3 ] onDatabaseLogging               [4 ] onDatabaseOpenStatus               [5 ] onDatabaseUsers           [3 ] onTableTable             [1 ] onTableEntry               [1 ] onTableIndex               [2 ] onTableName               [3 ] onTableOwner               [4 ] onTableType               [5 ] onTableLockLevel               [6 ] onTableCreated               [7 ] onTableFirstDbspace               [8 ] onTableRowSize               [9 ] onTableRows               [10] onTableColumns               [11] onTableIndices               [12] onTableExtents               [13] onTablePagesAllocated               [14] onTablePagesUsed               [15] onTableFragments               [16] onTableFragmentStrategy               [17] onTableActiveFragments           [4 ] onActiveTableTable             [1 ] onActiveTableEntry               [1 ] onActiveTableStatus               [2 ] onActiveTableIsBeingAltered               [3 ] onActiveTableUsers               [4 ] onActiveTableLockRequests               [5 ] onActiveTableLockWaits               [6 ] onActiveTableLockTimeouts               [7 ] onActiveTableIsamReads               [8 ] onActiveTableIsamWrites               [9 ] onActiveTableBufferReads               [10] onActiveTableBufferWrites           [5 ] onFragmentTable             [1 ] onFragmentEntry               [1 ] onFragmentIndex               [2 ] onFragmentType               [3 ] onFragmentDbspace               [4 ] onFragmentExpression               [5 ] onFragmentIndexName               [6 ] onFragmentExtents               [7 ] onFragmentPagesAllocated               [8 ] onFragmentPagesUsed               [9 ] onFragmentIsamReads               [10] onFragmentIsamWrites           [6 ] onDbspaceTable             [1 ] onDbspaceEntry               [1 ] onDbspaceIndex*               [2 ] onDbspaceName               [3 ] onDbspaceOwner               [4 ] onDbspaceCreated               [5 ] onDbspaceChunks               [6 ] onDbspaceType               [7 ] onDbspaceMirrorStatus               [8 ] onDbspaceRecoveryStatus               [9 ] onDbspaceBackupStatus               [10] onDbspaceMiscStatus               [11] onDbspacePagesAllocated               [12] onDbspacePagesUsed               [13] onDbspaceBackupDate           [7 ] onChunkTable             [1 ] onChunkEntry               [1 ] onChunkIndex               [2 ] onChunkFileName               [3 ] onChunkFileOffset               [4 ] onChunkPagesAllocated               [5 ] onChunkPagesUsed               [6 ] onChunkType               [7 ] onChunkStatus               [8 ] onChunkMirroring               [9 ] onChunkReads               [10] onChunkPageReads               [11] onChunkWrites               [12] onChunkPageWrites               [13] onChunkMirrorFileName               [14] onChunkMirrorFileOffset               [15] onChunkMirrorStatus           [8 ] onLogicalLogTable             [1 ] onLogicalLogEntry               [1 ] onLogicalLogIndex*               [2 ] onLogicalLogID               [3 ] onLogicalLogDbspace               [4 ] onLogicalLogStatus               [5 ] onLogicalLogContainsLastCheckpoint               [6 ] onLogicalLogIsTemporary               [7 ] onLogicalLogPagesAllocated               [8 ] onLogicalLogPagesUsed               [9 ] onLogicalLogFillTime           [9 ] onPhysicalLogTable             [1 ] onPhysicalLogEntry               [1 ] onPhysicalLogDbspace               [2 ] onPhysicalLogBufferSize               [3 ] onPhysicalLogBufferUsed               [4 ] onPhysicalLogPageWrites               [5 ] onPhysicalLogWrites               [6 ] onPhysicalLogPagesAllocated               [7 ] onPhysicalLogPagesUsed           [10] onSessionTable             [1 ] onSessionEntry               [1 ] onSessionIndex*               [2 ] onSessionUserName               [3 ] onSessionUserProgramVersion               [4 ] onSessionUserProcessId               [5 ] onSessionUserTime               [6 ] onSessionState               [7 ] onSessionDatabase               [8 ] onSessionCurrentMemory               [9 ] onSessionThreads               [10] onSessionLockRequests               [11] onSessionLocksHeld               [12] onSessionLockWaits               [13] onSessionLockTimeouts               [14] onSessionLogRecords               [15] onSessionIsamReads               [16] onSessionIsamWrites               [17] onSessionPageReads               [18] onSessionPageWrites               [19] onSessionLongTxs               [20] onSessionLogSpace               [21] onSessionHighwaterLogSpace               [22] onSessionSqlStatement               [23] onSessionSqlIsolation               [24] onSessionSqlLockWaitMode               [25] onSessionSqlEstimatedCost               [26] onSessionSqlEstimatedRows               [27] onSessionSqlError               [28] onSessionSqlIsamError               [29] onSessionTransactionStatus               [30] onSessionTransactionBeginLog               [31] onSessionTransactionLastLog           [11] onLockTable             [1 ] onLockEntry               [1 ] onLockIndex               [2 ] onLockDatabaseName               [3 ] onLockTableName               [4 ] onLockType               [5 ] onLockGranularity               [6 ] onLockRowId               [7 ] onLockWaiters               [8 ] onLockGrantTime           [12] onBarTable             [1 ] onBarEntry               [1 ] onBarActivityIndex*               [2 ] onBarObjectIndex               [3 ] onBarObjectName               [4 ] onBarObjectType               [5 ] onBarBackupLevel               [6 ] onBarActionStatus               [7 ] onBarTimeStamp           [13] onSqlHostTable             [1 ] onSqlHostEntry               [1 ] onSqlHostIndex*               [2 ] onSqlHostName               [3 ] onSqlHostNetType               [4 ] onSqlHostServerName               [5 ] onSqlHostServiceName           [14] onSnmpTable             [1 ] onSnmpEntry               [1 ] onSnmpIndex*               [2 ] onSnmpName               [3 ] onSnmpOID               [4 ] onSnmpRefreshType               [5 ] onSnmpRefreshInterval               [6 ] onSnmpNextRefresh               [7 ] onSnmpRefreshes               [8 ] onSnmpHoldInterval               [9 ] onSnmpRows               [10] onSnmpColumns               [11] onSnmpRetries               [12] onSnmpFailures 

Monitoring Notes

If you intend to write your own SNMP application, the root OID of the Informix-Online Private Database MIB is 1.3.6.1.4.1.893.1.1.

Many of the table entries in this MIB are indexed by using applIndex from the Network Services MIB and rdbmsDbIndex from the RDBMS MIB.

You can use the server mode, onServerMode, to determine whether the server is online, shutting down, or backing up. The MIB variable onServerCheckpointInProgress can give additional information about the server's activities. The Informix MIB also provides status information on all open tables, the database recovery process, and log files.

A variety of performance and resource management information is included in this MIB. For example, to determine whether your sort area is too small, you can check onServerDiskSorts to see how many sorts are requiring disk space.

I l @ ve RuBoard