Sybase Adaptive Server Anywhere SNMP Extension Agent, User Manual

Page: 21 / 70

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-only access
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