Sybase Adaptive Server Anywhere SNMP Extension Agent manual Software

Page 28

For a list of the database server statistic OIDs, see “Server statistics” on page 27.

♦ Database options

For a list of the database option OIDs, see “Database options” on page 36.

♦ Database properties

For a list of the database property OIDs, see “Database properties” on page 33.

 

♦ Database statistics

 

 

 

 

For a list of the database statistic OIDs, see “Database statistics” on

 

page 31.

 

 

 

 

The way you retrieve these values will depend on your SNMP management

 

software.

 

 

 

Examples

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

 

1

 

 

 

database 1

 

 

 

1.3.6.1.4.1.897.2.1.2.1.3

 

Server property C2 on database 3

 

NO

1.3.6.1.4.1.897.2.2.1.4.1

 

Database statistic CacheRead on

 

11397

 

 

 

database 1

 

 

 

1.3.6.1.4.1.897.2.2.2.7.4

 

Database property CaseSensi-

 

OFF

 

 

tivePasswords on database 4

 

 

 

1.3.6.1.4.1.897.2.2.3.5.2

 

Database option ANSI_-

 

OFF

 

 

INTEGER_OVERFLOW on

 

 

 

 

 

database 2

 

 

 

1.3.6.1.4.1.897.2.3.1

 

Agent version

 

9.0.1(1841)

 

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

 

 

 

 

 

 

16

Image 28
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