Sybase Adaptive Server Anywhere SNMP Extension Agent manual Database properties

Page 45

Chapter 2. Adaptive Server Anywhere MIB Reference

OID

Type

Name

Property

 

 

 

 

1.3.6.1.4.1.897.2.2.1.36.n

Integer32

dbStatIdleWrite

IdleWrite

1.3.6.1.4.1.897.2.2.1.37.n

Integer32

dbStatIndAdd

IndAdd

1.3.6.1.4.1.897.2.2.1.38.n

Integer32

dbStatIndLookup

IndLookup

1.3.6.1.4.1.897.2.2.1.39.n

Integer32

dbStatIOToRecover

IOToRecover

1.3.6.1.4.1.897.2.2.1.40.n

Integer32

dbStatJavaHeapSize

JavaHeapSize

1.3.6.1.4.1.897.2.2.1.41.n

Integer32

dbStatJavaNSSize

JavaNSSize

1.3.6.1.4.1.897.2.2.1.42.n

Integer32

dbStatLockTablePages

LockTablePages

1.3.6.1.4.1.897.2.2.1.43.n

Integer32

dbStatMapPages

MapPages

1.3.6.1.4.1.897.2.2.1.44.n

Integer32

dbStatMaxIO

MaxIO

1.3.6.1.4.1.897.2.2.1.45.n

Counter64

dbStatMaxRead

MaxRead

1.3.6.1.4.1.897.2.2.1.46.n

Integer32

dbStatMaxWrite

MaxWrite

1.3.6.1.4.1.897.2.2.1.47.n

Integer32

dbStatPageRelocations

PageRelocations

1.3.6.1.4.1.897.2.2.1.48.n

Integer32

dbStatProcedurePages

ProcedurePages

1.3.6.1.4.1.897.2.2.1.49.n

Integer32

dbStatQueryCachePages

QueryCachePages

1.3.6.1.4.1.897.2.2.1.50.n

Integer32

dbStatQueryLowMemoryStrat-

QueryLowMemoryStrat-

 

 

egy

egy

1.3.6.1.4.1.897.2.2.1.51.n

Counter64

dbStatQueryRowsMaterialized

QueryRowsMaterialized

1.3.6.1.4.1.897.2.2.1.52.n

Integer32

dbStatRecoveryUrgency

RecoveryUrgency

1.3.6.1.4.1.897.2.2.1.53.n

Integer32

dbStatLogFreeCommit

LogFreeCommit

1.3.6.1.4.1.897.2.2.1.54.n

Integer32

dbStatLogWrite

LogWrite

1.3.6.1.4.1.897.2.2.1.55.n

Integer32

dbStatRelocatableHeapPages

RelocatableHeapPages

1.3.6.1.4.1.897.2.2.1.56.n

Integer32

dbStatRollbackLogPages

RollbackLogPages

1.3.6.1.4.1.897.2.2.1.57.n

Integer32

dbStatTempTablePages

TempTablePages

1.3.6.1.4.1.897.2.2.1.58.n

Integer32

dbStatTriggerPages

TriggerPages

1.3.6.1.4.1.897.2.2.1.59.n

Integer32

dbStatViewPages

ViewPages

 

 

 

 

Database properties

The following table lists the OIDs and names of the database properties that

33

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