Sybase Adaptive Server Anywhere SNMP Extension Agent User Manual

Page 25

Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent

❖

To restart the Adaptive Server Anywhere SNMP Extension Agent

1. Using your SNMP management tool, change the value of the

asaAgent.asaRestart property,

1.3.6.1.4.1.897.2.3.6

, to 1.

You can obfuscate the contents of the

asasnmp.ini

file with simple

encryption using the File Hiding utility (dbfhide).

☞

For more information, see

“Hiding the contents of .ini files”

[ASA

Database Administration Guide, page 524]

The ASAAgent section

The ASAAgent section of the

asasnmp.ini

file contains a TrapPollTime field

with information about the Adaptive Server Anywhere Extension Agent. If
the TrapPollTime field is not required, you can omit the entire section.

TrapPollTime

This value specifies the poll frequency for dynamic traps if

they are specified. The Adaptive Server Anywhere SNMP Extension Agent
polls the values every 5 seconds by default. Setting this value to 0 disables
dynamic traps. This field is optional.

The DBn section

Each DB

section of the

asasnmp.ini

file describes a database, how to

connect to it, and any dynamic traps that exist for the database. The fields in
this section are case sensitive.

The value for

is a number that identifies the database. The numbers must

start with 1, and numbers cannot be skipped. For example, if the

asasnmp.ini

file contained entries for [DB1], [DB2], and [DB4], the [DB4] entry would
be ignored because the file is missing the entry for [DB3].

ConnStr

The connection string used to connect to the database. You must

supply enough information to be able to connect to the database. This field is
required.

♦

If you want to use an ODBC data source to connect to the database, it
must be a

system

data source, not a

user

data source.

♦

If you want to use an integrated login, you must map to the SYSTEM
account because the SNMP Agent runs as a service. However, this means
that anything that runs as a service can then connect to the database
without a password. Alternatively, you can change the account that the
service runs under and then create an integrated login for that account.

♦

The string

ASTART=NO;IDLE=0;CON=SNMP;ASTOP=NO

is prepended to

the connection string. This string does the following:

•

prevents the Adaptive Server Anywhere SNMP Extension Agent from
trying to autostart a database server

•

disables idle timeout since it is likely that the Adaptive Server
Anywhere SNMP Extension Agent will sit idle for some time