Sybase Adaptive Server Anywhere SNMP Extension Agent manual Adaptive Server Anywhere MIB

Page 19

Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent

The Adaptive Server Anywhere MIB

The Adaptive Server Anywhere MIB was created for the Adaptive Server Anywhere SNMP Extension Agent. It includes all database server statistics and properties, as well as all database statistics, properties, and options. The statistics and properties are all read-only (with a few exceptions), and the database options are all read-write.

By default, the Adaptive Server Anywhere MIB is located in C:\Program

Files\Sybase\SQL Anywhere 9\snmp\iAnywhere.mib.

For information about the tables in the Adaptive Server Anywhere MIB, see “Adaptive Server Anywhere MIB Reference” on page 23 .

For information about setting values in the Adaptive Server Anywhere MIB, see “Setting values using the Adaptive Server Anywhere SNMP Extension Agent” on page 17 .

The following hierarchy describes the Adaptive Server Anywhere MIB:

OID

Name

Description

 

 

 

1.3.6.1.4.897.2.1.1.n.db

asaServer.asaSrvStat

Returns the value of server statistic

 

 

n on database db.

1.3.6.1.4.897.2.1.2.n.db

asaServer.asaSrvProp

Returns the value of server property

 

 

n on database db.

1.3.6.1.4.897.2.2.1.n.db

asaDb.asaDbStat

Returns the value of database statis-

 

 

tic n on database db.

1.3.6.1.4.897.2.2.2.n.db

asaDb.asaDbProp

Returns the value of database prop-

 

 

erty n on database db.

1.3.6.1.4.897.2.2.3.n.db

asaDb.asaDbOpt

Returns the value of database option

 

 

n on database db.

1.3.6.1.4.897.2.3.1

asaAgent.asaVersion

Returns the version of the Adaptive

 

 

Server Anywhere Extension Agent.

1.3.6.1.4.897.2.3.2.db

asaAgent.asaDbConnStr

Returns the connection string for

 

 

database db.

 

 

 

7

Image 19
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 Asademo.db Adaptive Server Anywhere sample databaseFinding 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 Files\Sybase\SQL Anywhere 9\snmp\iAnywhere.mib Adaptive Server Anywhere MIBMIB Rdbms MIB Installing Snmp Using the Adaptive Server Anywhere Snmp Extension AgentTo 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’ To configure the Snmp service Using trapsCreating 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 AsaDbMetaData.asaDbOptMetaDataTable Server statisticsOID 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 Rdbms MIB Reference RdbmsDbParamTableWrite File RdbmsDbLimitedResourceTableRdbmsSrvInfoTable RdbmsSrvTableRdbmsSrvLimitedResourceTable RdbmsSrvParamTableIf this is 0, then it returns prop Page Index Index Cooperativecommittimeout option Index Index Odbcdescribebinaryasvarbinary Pinnedcursorpercentofcache ReadOnly property Truncatetimestampvalues option Installing Snmp Windows XP