Chapter 1. The Adaptive Server AnywhereSNMP Extension Agent
startingat 1. Skippingnumbers is not allowed. This field is optional.
Disabled Ifset to 1, this database entry is skipped by the Adaptive Server
AnywhereSNMP Extension Agent. Thisis useful for temporarily removing
onedatabase from the list of databases managed by the Adaptive Server
AnywhereSNMP Extension Agent, without renumbering the rest. Thisfield
isoptional.
☞Forinformation about creating traps, see “Creating dynamic traps” on
page19.
Sampleasasnmp.ini file Thefollowing is a sample
asasnmp.ini
filefor the Adaptive Server
AnywhereSNMP Extension Agent.
[ASAAgent]
[DB1]
ConnStr=UID=DBA;PWD=SQL;ENG=server1;DBN=sales;DBF=sales.db
Trap1=1.1.5 > 50000
UtilDbPwd=test
[DB2]
ConnStr=UID=DBA;PWD=SQL;ENG=server1;DBN=field;DBF=field.db
UtilDbPwd=test
Disabled=1
[DB3]
ConnStr=UID=DBA;PWD=SQL;LINKS=tcpip;ENG=server2;DBN=hq;DBF=hq.db
UtilDbPwd=test
Becausethere are no parameters specified in the ASAAgent section, the
AdaptiveServer Anywhere SNMP Extension Agent will poll values every 5
seconds.
TheAdaptive Server Anywhere SNMP Extension Agent is monitoring 3
differentdatabases running on two different servers. Database 3 is running
ona different machine, so the LINKS connection parameter is required to
specifythe protocol. Atrap is specified for DB1, which fires when the
numberof bytes sent by the database server is greater than 50 000.
Obtaining values using the Adaptive Server Anywhere SNMP Extension
Agent
Usingthe Adaptive Server Anywhere SNMP Extension Agent, you can
retrievethe values of all the following:
♦Databaseserver properties
☞Fora list of the database server property OIDs, see “Server
properties”on page 29.
♦Databaseserver statistics
15