Sybase Adaptive Server Anywhere SNMP Extension Agent manual AsaDbMetaData.asaDbPropMetaDataTable

Page 38

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.2.1.1.1.db

Integer32

asaDbStatIndex

db

1.3.6.1.4.1.897.2.4.2.1.1.2.db

Integer32

asaDbStatObjType

21

1.3.6.1.4.1.897.2.4.2.1.1.3.db

Integer32

asaDbStatType

12

1.3.6.1.4.1.897.2.4.2.1.1.4.db

OID

asaDbStatOID

OID of Adaptive Server

 

 

 

Anywhere MIB entry3

1.3.6.1.4.1.897.2.4.2.1.1.5.db

String

asaDbStatName

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.

asaDbMetaData.asaDbPropMetaDataTable

This table contains metadata about the database 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.2.2.1.1.db

Integer32

asaDbPropIndex

db

1.3.6.1.4.1.897.2.4.2.2.1.2.db

Integer32

asaDbPropObjType

21

1.3.6.1.4.1.897.2.4.2.2.1.3.db

Integer32

asaDbPropType

22

1.3.6.1.4.1.897.2.4.2.2.1.4.db

OID

asaDbPropOID

OID of Adaptive Server

 

 

 

Anywhere MIB entry3

1.3.6.1.4.1.897.2.4.2.2.1.5.db

String

asaDbPropName

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.

26

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