Database statistics, Database statistics” on – Sybase Adaptive Server Anywhere SNMP Extension Agent User Manual
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-
Size
CheckpointLogBitmap-
Size
1.3.6.1.4.1.897.2.2.1.11.
n
Integer32
dbStatCheckpointLogBitmap-
PagesWritten
CheckpointLogBitmap-
PagesWritten
31