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

Page 36

The Adaptive Server Anywhere MIB

The following sections list the OIDs of the statistics, properties, and options that can be retrieved and set using the Adaptive Server Anywhere SNMP Extension Agent. By default,

Agent

The Agent table lists information about the Adaptive Server Anywhere

SNMP Extension Agent.

Writable properties are marked with an asterisk (*). The value n is the database number in the asasnmp.ini file.

OID

Type

Name

Value returned

 

 

 

 

1.3.6.1.4.1.897.2.3.1

String

asaVersion

Agent version

1.3.6.1.4.1.897.2.3.2.n

String

asaDBConnStr

Connection string

1.3.6.1.4.1.897.2.3.3.n

Integer32

asaConnected*

1 if the agent is connected, 0 otherwise

1.3.6.1.4.1.897.2.3.4.n

Integer32

asaStarted*

1 if the database is started, 0 otherwise

1.3.6.1.4.1.897.2.3.5.n

String

asaProc*

” “

1.3.6.1.4.1.897.2.3.6

String

asaRestart*

0

 

 

 

 

asaMetaData tables

The following metadata tables are included in the Adaptive Server

Anywhere MIB:

asaSrvMetaData.asaSrvStatMetaDataTable

asaSrvMetaData.asaSrvPropMetaDataTable

asaSrvMetaData.asaDbStatMetaDataTable

asaSrvMetaData.asaDbPropMetaDataTable

asaSrvMetaData.asaDbOptMetaDataTable

asaSrvMetaData.asaSrvStatMetaDataTable

This table contains metadata about the database server statistics.

The value db is the database number in the asasnmp.ini file.

24

Image 36
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 Adaptive Server Anywhere MIB AgentAsaMetaData 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 Rdbms MIB RdbmsDbTableRdbmsDbInfoTable 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