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 SQL Anywhere SNMP Extension Agent supports eight of these virtual tables.

For more information about the tables contained in the RDBMS MIB, see RDBMS MIB reference.

The SQL Anywhere Extension Agent provides read-only access to all the supported variables in the RDBMS MIB. None of the variables in the RDBMS MIB are writable through the SQL 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.column.rownum

By default, the RDBMS MIB is located in %SQLANY12%\snmp\RDBMS-MIB.mib.