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,
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