Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent
starting at 1. Skipping numbers is not allowed. This field is optional.
Disabled If set to 1, this database entry is skipped by the Adaptive Server Anywhere SNMP Extension Agent. This is useful for temporarily removing one database from the list of databases managed by the Adaptive Server Anywhere SNMP Extension Agent, without renumbering the rest. This field is optional.
☞For information about creating traps, see “Creating dynamic traps” on page 19.
Sample asasnmp.ini file The following is a sample asasnmp.ini file for the Adaptive Server Anywhere SNMP 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
Because there are no parameters specified in the ASAAgent section, the Adaptive Server Anywhere SNMP Extension Agent will poll values every 5 seconds.
The Adaptive Server Anywhere SNMP Extension Agent is monitoring 3 different databases running on two different servers. Database 3 is running on a different machine, so the LINKS connection parameter is required to specify the protocol. A trap is specified for DB1, which fires when the number of bytes sent by the database server is greater than 50 000.
Obtaining values using the Adaptive Server Anywhere SNMP Extension Agent
Using the Adaptive Server Anywhere SNMP Extension Agent, you can retrieve the values of all the following:
♦Database server properties
☞ For a list of the database server property OIDs, see “Server properties” on page 29 .
♦Database server statistics
15