Asadbmetadata.asadboptmetadatatable, Server statistics – Sybase Adaptive Server Anywhere SNMP Extension Agent User Manual

Page 39

Advertising
background image

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

Advertising