Sybase Adaptive Server Anywhere SNMP Extension Agent - 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. db , where db 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.
17