Sybase Adaptive Server Anywhere SNMP Extension Agent User Manual

Page 26

Advertising
background image

names the connection so it can be identified

prevents the database from being shut down when the Adaptive Server
Anywhere SNMP Extension Agent disconnects

If you specify any of these values in the connection string in the

asasnmp.ini

file, the values in the

asasnmp.ini

file will override the

default settings.

UtilDbPwd

When setting

asa.agent.asaStarted

to start a database,

the Adaptive Server Anywhere SNMP Extension Agent attempts to connect
to the database with the DBF parameter, which tells the database server
where to find the database file. However, if the permission required to start
the database is DBA (the default for the network server, which can also be
set using the -gd dba option for both the personal and network servers), then
the server will not allow the connection.

To start a database on such a server, the Adaptive Server Anywhere SNMP
Extension Agent must connect as a user with DBA authority to a database
already running on the same server. This can be done by connecting to the
utility database. If you specify the utility database password (contained in
the server’s

util_db.ini

file) in the

asasnmp.ini

file, then to start a database,

the Adaptive Server Anywhere Extension Agent connects to the utility
database on the same server, executes the START DATABASE statement,
and then disconnects. This field is optional.

CacheTime

When data is retrieved from the database, it can be cached

inside the Adaptive Server Anywhere SNMP Extension Agent, so that
subsequent retrievals of the same type of data (for example, server properties
or database statistics) do not require communication with the database.
While caching the data means that you can obtain the data more quickly on
subsequent retrievals, the data may be out of date. The CacheTime field can
be used to change the cache time, or disable the cache by setting the value to
0. By default, the cache time is 30 seconds. When the CacheTime parameter
is set to 0, the data retrieved is always be up-to-date because data is retrieved
from the database for every request. This field is optional.

DBSpaceCacheTime

The rdbmsDbLimitedResourceTable in the RDBMS

MIB contains information about dbspaces. When this information is
retrieved from the database, it can also be cached inside the Adaptive Server
Anywhere Extension Agent. The default cache time for dbspace information
is 600 seconds (10 minutes). This field can be used to change the cache time
(or disable the cache by setting the value to 0). This field is optional.

For more information about the rdbmsDbLimitedResourceTable table,

see

“rdbmsDbLimitedResourceTable” on page 44

.

Trapt

Creates a dynamic trap. The value

t

must be a positive integer

14

Advertising