Sybase Adaptive Server Anywhere SNMP Extension Agent manual Mib

Page 20

OID

Name

Description

 

 

 

1.3.6.1.4.897.2.3.3.db

asaAgent.asaConnected

Returns whether the Adaptive

 

 

Server Anywhere Extension Agent

 

 

is connected to database db. Setting

 

 

this value to 0 causes the Adaptive

 

 

Server Anywhere Extension Agent

 

 

to shut down the database1, while

 

 

setting this value to 1 causes the

 

 

Adaptive Server Anywhere Exten-

 

 

sion Agent to attempt to start the

 

 

database2.

1.3.6.1.4.897.2.3.4.db

asaAgent.asaStarted

Returns whether database db is run-

 

 

ning. Setting this value to 0 causes

 

 

the Adaptive Server Anywhere Ex-

 

 

tension Agent to shut down the

 

 

database, while setting this value to

 

 

1 attempts to start the database.

1.3.6.1.4.897.2.3.5.db

asaAgent.asaProc

Setting this value to a string proc_-

 

 

name causes the Adaptive Server

 

 

Anywhere Extension Agent to exe-

 

 

cuted the procedure proc_name in

 

 

the database.

 

 

Arguments can be supplied (for

 

 

example, proc_name(‘string’, 4));

 

 

if no arguments are supplied, paren-

 

 

theses () are appended to the name.

 

 

Getting the value returns "".

1.3.6.1.4.897.2.4

asaMetaData

Several virtual tables; each row

 

 

represents a variable supported

 

 

by the Adaptive Server Anywhere

 

 

MIB.

 

 

 

1Note that when stopping a database by setting this variable, the stop is unconditional, meaning that the database will be stopped even if it has active connections.

2In order to be able to start a database by setting this variable, the DBF parameter must be specified in the connection string (along with DBN if desired and DBKEY if required), and either (a) the UtilDbPwd field must be set in the asasnmp.ini file, or (b) the start database permission on the server (specified with the -gd server option) must be set to all.

8

Image 20
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 AsaMetaData tables Adaptive Server Anywhere MIBAgent 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 RdbmsDbInfoTable Rdbms MIBRdbmsDbTable 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