Asadbmetadata.asadboptmetadatatable, Server statistics – Sybase Adaptive Server Anywhere SNMP Extension Agent User Manual
Page 39
Chapter 2. Adaptive Server Anywhere MIB Reference
asaDbMetaData.asaDbOptMetaDataTable
This table contains metadata about the database options.
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
asaDbOptIndex
db
1.3.6.1.4.1.897.2.4.2.1.1.2.
db
Integer32
asaDbOptObjType
2
1
1.3.6.1.4.1.897.2.4.2.1.1.3.
db
Integer32
asaDbOptType
3
2
1.3.6.1.4.1.897.2.4.2.1.1.4.
db
OID
asaDbOptOID
OID of Adaptive Server Any-
where MIB entry
3
1.3.6.1.4.1.897.2.4.2.1.1.5.
db
String
asaDbOptName
Option name
1
Values: 1=Server, 2=Database
2
Values: 1=Statistic, 2=Property, 3=Option
3
The 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.
Server statistics
This table lists the OIDs and names of the database server 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
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