Sybase Adaptive Server Anywhere SNMP Extension Agent manual AsaSrvMetaData.asaSrvPropMetaDataTable

Page 37

Chapter 2. Adaptive Server Anywhere MIB Reference

OID

Type

Name

Value returned

 

 

 

 

1.3.6.1.4.1.897.2.4.1.1.1.1.db

Integer32

asaSrvStatIndex

db

1.3.6.1.4.1.897.2.4.1.1.1.2.db

Integer32

asaSrvStatObjType

11

1.3.6.1.4.1.897.2.4.1.1.1.3.db

Integer32

asaSrvStatType

12

1.3.6.1.4.1.897.2.4.1.1.1.4.db

OID

asaSrvStatOID

OID of Adaptive Server Any-

 

 

 

where MIB entry3

1.3.6.1.4.1.897.2.4.1.1.1.5.db

String

asaSrvStatName

Statistic name

 

 

 

 

1Values: 1=Server, 2=Database

2Values: 1=Statistic, 2=Property, 3=Option

3The OID returned does not include the database number. You must append the database number to the OID before it can be used in a query.

asaSrvMetaData.asaSrvPropMetaDataTable

This table contains metadata about the database server properties.

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

OID

Type

Name

Value returned

 

 

 

 

1.3.6.1.4.1.897.2.4.1.2.1.1.db

Integer32

asaSrvPropIndex

db

1.3.6.1.4.1.897.2.4.1.2.1.2.db

Integer32

asaSrvPropObjType

11

1.3.6.1.4.1.897.2.4.1.2.1.3.db

Integer32

asaSrvPropType

22

1.3.6.1.4.1.897.2.4.1.2.1.4.db

OID

asaSrvPropOID

OID of Adaptive

 

 

 

Server Anywhere MIB

 

 

 

entry3

1.3.6.1.4.1.897.2.4.1.2.1.5.db

String

asaSrvPropName

Property name

 

 

 

 

1Values: 1=Server, 2=Database

2Values: 1=Statistic, 2=Property, 3=Option

3The OID returned does not include the database number. You must append the database number to the OID before it can be used in a query.

asaDbMetaData.asaDbStatMetaDataTable

This table contains metadata about the database statistics.

25

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