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 | 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 | OID of Adaptive Server Any- |
|
|
| where MIB 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
3The 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- | BytesReceivedUncomp |
|
| comp |
|
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