Sybase Adaptive Server Anywhere SNMP Extension Agent manual Rdbms MIB

Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent

asaMetaData tables The Adaptive Server Anywhere MIB includes metadata tables that provide a way to query the Adaptive Server Anywhere Extension Agent to find out which variables are supported.

♦ asaSrvMetaData.asaSrvStatMetaDataTable	lists the database server
statistics (variables under asa.asaServer.asaSrvStat.)
♦ asaSrvMetaData.asaSrvpropMetaDataTable	lists the database server
properties (variables under asa.asaServer.asaSrv.Prop.)
♦ asaDbMetaData.asaDbStatMetaDataTable	lists the database statistics
(variables under asa.asaDb.asaDbStat.)
♦ asaDbMetaData.asaDbpropMetaDataTable	lists the database
properties (variables under asa.asaDb.asaDbProp.)
♦ asaDbMetaData.asaDbOptMetaDataTable	lists the database options
(variables under asa.asaDb.asaDbOpt.)

☞For more information about the information stored in the Adaptive Server Anywhere MIB metadata tables, see “asaMetaData tables” on page 24.

The RDBMS MIB

The RDBMS MIB is a generic and vendor-independent MIB (RFC 1697) for relational database-management system products. The RDBMS MIB uses virtual tables to return information on the servers and databases. The base OID is 1.3.6.1.2.1.39, and there are 9 virtual tables in this MIB. The Adaptive Server Anywhere SNMP Extension Agent supports 8 of these virtual tables.

☞For descriptions of the supported tables contained in the RDBMS MIB, see “RDBMS MIB Reference” on page 41 .

The Adaptive Server Anywhere Extension Agent provides read-onlyaccess to all of the supported variables in the RDBMS MIB. None of the variables in the RDBMS MIB are writable through the Adaptive Server Anywhere Extension Agent.

A virtual table contains a fixed number of attributes and any number for rows. Elements in the table are retrieved using GET requests by appending the column number and row number to the OID of the table. A 1 must be appended to the table OID, so the OID looks as follows:

table.1.colnum.rownum

By default, the RDBMS MIB is located in C:\Program Files\Sybase\SQL

Anywhere 9\snmp\RDBMS-MIB.mib.

9