Sybase Adaptive Server Anywhere SNMP Extension Agent manual

Page 16

Introduction to the Adaptive Server Anywhere SNMP Extension Agent

If you are running Adaptive Server Anywhere on Windows 2000, Windows XP, or Windows Server 2003 (32-bit versions), you can use the Adaptive Server Anywhere SNMP Extension Agent in conjunction with SNMP management applications to manage your Adaptive Server Anywhere databases. One agent can be used to monitor several different databases running on different database servers running on different machines.

Using the Adaptive Server Anywhere SNMP Extension Agent, you can do the following:

♦ retrieve the value of all server and database statistics

 

♦ retrieve the value of all server and database properties

 

♦ retrieve the value of all PUBLIC database options

 

♦ set the value for any PUBLIC database option

 

♦ execute stored procedures

 

♦ generate traps based on property or statistic values

Supplied files

The following files for the Adaptive Server Anywhere SNMP Extension

 

Agent are included in your SQL Anywhere Studio installation:

 

dbsnmp9.dll The Adaptive Server Anywhere SNMP Extension Agent.

 

This file is located in C:\Program Files\Sybase\SQL Anywhere 9\win32.

 

iAnywhere.mib

The Adaptive Server Anywhere MIB contains all the

 

OIDs for database server and database properties, statistics, and options

 

that can be accessed using the Adaptive Server Anywhere SNMP

 

Extension Agent.

 

 

RDBMS-MIB.mib

The is a generic MIB for relational database

 

management systems and contains OIDs that can be accessed using the

 

Adaptive Server Anywhere SNMP Extension Agent.

 

SNMPv2-SMI.mib

This MIB is referenced by the Adaptive Server

 

Anywhere and RDBMS MIBs.

 

SNMPv2-TC.mib

This MIB is referenced by the Adaptive Server

 

Anywhere and RDBMS MIBs.

 

SYBASE-MIB.mib

The Sybase MIB. This MIB is referenced by the

 

Adaptive Server Anywhere MIB.

4

Image 16
Contents Adaptive Server Anywhere Snmp Extension Agent User’s Guide Page Contents Page About This Manual SQL Anywhere Studio documentation Page Page Documentation conventions Following icons are used in this documentation Adaptive Server Anywhere sample database Asademo.dbFinding out more and providing feedback Using the Adaptive Server Anywhere Snmp Extension Agent Page Adaptive Server Anywhere Snmp Extension Agent Agent are included in your SQL Anywhere Studio installation Adaptive Server Anywhere Snmp Extension Agent Understanding Snmp Adaptive Server Anywhere MIB Files\Sybase\SQL Anywhere 9\snmp\iAnywhere.mibMIB Rdbms MIB Using the Adaptive Server Anywhere Snmp Extension Agent Installing SnmpTo restart the Snmp service Control Panel Configuring the Adaptive Server Anywhere Snmp Extension Agent To restart the Adaptive Server Anywhere Snmp Extension Agent Page ASAAgent DB1 Software SET Option PUBLIC.opt = ’value’ Using traps To configure the Snmp serviceCreating dynamic traps Trap examples Adaptive Server Anywhere Snmp Extension Agent Reference Page Adaptive Server Anywhere MIB Reference Agent Adaptive Server Anywhere MIBAsaMetaData tables AsaSrvMetaData.asaSrvPropMetaDataTable AsaDbMetaData.asaDbPropMetaDataTable Server statistics AsaDbMetaData.asaDbOptMetaDataTableOID Server properties OID Database statistics OID Database properties OID Adaptive Server Anywhere MIB Reference Database options Adaptive Server Anywhere MIB Reference OID Adaptive Server Anywhere MIB Reference OID Rdbms MIB Reference RdbmsDbTable Rdbms MIBRdbmsDbInfoTable RdbmsDbParamTable Rdbms MIB ReferenceRdbmsDbLimitedResourceTable Write FileRdbmsSrvTable RdbmsSrvInfoTableRdbmsSrvParamTable RdbmsSrvLimitedResourceTableIf this is 0, then it returns prop Page Index Index Cooperativecommittimeout option Index Index Odbcdescribebinaryasvarbinary Pinnedcursorpercentofcache ReadOnly property Truncatetimestampvalues option Installing Snmp Windows XP