Sybase Adaptive Server Anywhere SNMP Extension Agent manual Database statistics

Page 43

Chapter 2. Adaptive Server Anywhere MIB Reference

OID

Type

Name

Property

 

 

 

 

1.3.6.1.4.1.897.2.1.2.49.n

String

srvPropThreads

Threads

1.3.6.1.4.1.897.2.1.2.50.n

String

srvPropTimeZoneAdjustment

TimeZoneAdjustment

1.3.6.1.4.1.897.2.1.2.51.n

String

srvPropHttpPorts

HttpPorts

1.3.6.1.4.1.897.2.1.2.52.n

String

srvPropHttpsPorts

HttpsPorts

1.3.6.1.4.1.897.2.1.2.53.n

String

srvPropProfileFilterConn

ProfileFilterConn

1.3.6.1.4.1.897.2.1.2.54.n

String

srvPropProfileFilterUser

ProfileFilterUser

1.3.6.1.4.1.897.2.1.2.55.n

String

srvPropRequestLogNumFiles

RequestLogNumFIles

1.3.6.1.4.1.897.2.1.2.56.n

String

srvPropIsFipsAvailable

IsFipsAvailable

1.3.6.1.4.1.897.2.1.2.57.n

String

srvPropFipsMode

FipsMode

 

 

 

 

Database statistics

The following table lists the OIDs and names the database statistics that can be retrieved using the Adaptive Server Anywhere SNMP Extension Agent.

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

OID

Type

Name

Property

 

 

 

 

1.3.6.1.4.1.897.2.2.1.1.n

Counter64

dbStatCacheHits

CacheHits

1.3.6.1.4.1.897.2.2.1.2.n

Integer32

dbStatCacheReadIndInt

CacheReadIndInt

1.3.6.1.4.1.897.2.2.1.3.n

Integer32

dbStatCacheReadIndLeaf

CacheReadIndLeaf

1.3.6.1.4.1.897.2.2.1.4.n

Counter64

dbStatCacheRead

CacheRead

1.3.6.1.4.1.897.2.2.1.5.n

Integer32

dbStatCacheReadTable

CacheReadTable

1.3.6.1.4.1.897.2.2.1.6.n

Integer32

dbStatChkpt

Chkpt

1.3.6.1.4.1.897.2.2.1.7.n

Integer32

dbStatChkptFlush

ChkptFlush

1.3.6.1.4.1.897.2.2.1.8.n

Integer32

dbStatChkptPage

ChkptPage

1.3.6.1.4.1.897.2.2.1.9.n

Integer32

dbStatCheckpointUrgency

CheckpointUrgency

1.3.6.1.4.1.897.2.2.1.10.n

Integer32

dbStatCheckpointLogBitmap-

CheckpointLogBitmap-

 

 

Size

Size

1.3.6.1.4.1.897.2.2.1.11.n

Integer32

dbStatCheckpointLogBitmap-

CheckpointLogBitmap-

 

 

PagesWritten

PagesWritten

 

 

 

 

31

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