beautypg.com

Sybase Adaptive Server Anywhere SNMP Extension Agent User Manual

Page 27

background image

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