Sybase Adaptive Server Anywhere SNMP Extension Agent User Manual

Page 29

Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent

Setting values using the Adaptive Server Anywhere SNMP Extension
Agent

The Adaptive Server Anywhere SNMP Extension Agent responds to SNMP
get, get-next, and set queries.

You can set any database option, some server properties, and one database
property using the Adaptive Server Anywhere SNMP agent.

When setting database options, the Adaptive Server Anywhere SNMP agent
executes the statement:

SET OPTION PUBLIC.opt = ’value’

When setting database and server properties, the sa_server_option system
procedure is used.

The way you set these values depends on your SNMP management software.

☞

For the OIDs and information about the options and properties that can

be set with the Adaptive Server Anywhere SNMP Extension Agent, see

“The Adaptive Server Anywhere MIB” on page 24

Executing stored procedures using the Adaptive Server Anywhere SNMP
Extension Agent

The Adaptive Server Anywhere MIB includes an OID that allows you to
execute a stored procedure using the Adaptive Server Anywhere SNMP
Extension Agent. In order to execute the stored procedure, the user that the
Adaptive Server Anywhere SNMP Extension Agent uses to connect must
have one of the following:

♦

execute permission on the procedure

♦

be the owner of the procedure

♦

have DBA authority

Any result sets or return values generated by the procedure are ignored.

To execute a stored procedure using the Adaptive Server Anywhere SNMP
Extension Agent, set the value of

asaAgent.asaProc

(OID

1.3.6.1.4.1.897.2.3.5.

, where

is the database number in the

asasnmp.ini

file) to a string that is the name of a stored procedure. Optionally, you can
supply arguments to the procedure; if no arguments are supplied,
parentheses ( ) are appended to the procedure name.