Using the SQL Anywhere SNMP Extension Agent, you can retrieve the values of all the following:
Database server properties. See SQL Anywhere MIB server properties.
Database server statistics. See SQL Anywhere MIB server statistics.
Database options. See SQL Anywhere MIB database options.
Database properties. See SQL Anywhere MIB database properties.
Database statistics. See SQL Anywhere MIB database statistics.
The way you retrieve these values depends on your SNMP management software.
The table below provides a description and sample value that could be returned for the following OIDs.
| OID | Explanation | Sample value |
|---|---|---|
| 1.3.6.1.4.1.897.2.1.1.1.1 | Server statistic ActiveReq on database 1 | 1 |
| 1.3.6.1.4.1.897.2.2.1.4.1 | Database statistic CacheRead on database 1 | 11397 |
| 1.3.6.1.4.1.897.2.3.1 | Agent version | 11.0.1(2459) |
| 1.3.6.1.4.1.897.2.3.2.1 | Connection string for database 1 | UID=DBA;PWD=sql; ENG=server1; DBN=sales; DBF=sales.db |
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |