Chapter 2. Adaptive Server AnywhereMIB Reference
asaDbMetaData.asaDbOptMetaDataTable
Thistable contains metadata about the database options.
Thevalue
db
isthe database number in the
asasnmp.ini
file.
OID Type Name Valuereturned
1.3.6.1.4.1.897.2.4.2.1.1.1.
db
Integer32 asaDbOptIndex
db
1.3.6.1.4.1.897.2.4.2.1.1.2.
db
Integer32 asaDbOptObjType 21
1.3.6.1.4.1.897.2.4.2.1.1.3.
db
Integer32 asaDbOptType 32
1.3.6.1.4.1.897.2.4.2.1.1.4.
db
OID asaDbOptOID OIDof Adaptive Server Any-
whereMIB entry3
1.3.6.1.4.1.897.2.4.2.1.1.5.
db
String asaDbOptName Option name
1Values:1=Server, 2=Database
2Values:1=Statistic, 2=Property, 3=Option
3TheOID returned does not include the database number. Youmust append
thedatabase number to the OID before it can be used in a query.
Server statistics
Thistable lists the OIDs and names of the database server statistics that can
beretrieved using the Adaptive Server Anywhere SNMP Extension Agent.
Thevalue
n
isthe database number in the
asasnmp.ini
file.
OID Type Name Statistic
1.3.6.1.4.1.897.2.1.1.1.
n
Integer32 srvStatActiveReq ActiveReq
1.3.6.1.4.1.897.2.1.1.2.
n
Integer32 srvStatAvailIO AvailIO
1.3.6.1.4.1.897.2.1.1.3.
n
Counter64 srvStatBytesReceived BytesReceived
1.3.6.1.4.1.897.2.1.1.4.
n
Counter64 srvStatBytesReceivedUn-
comp
BytesReceivedUncomp
1.3.6.1.4.1.897.2.1.1.5.
n
Counter64 srvStatBytesSent BytesSent
1.3.6.1.4.1.897.2.1.1.6.
n
Counter64 srvStatBytesSentUncomp BytesSentUncomp
1.3.6.1.4.1.897.2.1.1.7.
n
Counter64 srvStatCacheHitsEng CacheHitsEng
1.3.6.1.4.1.897.2.1.1.8.
n
Integer32 srvStatCachePinned CachePinned
27