Chapter 1. The Adaptive Server AnywhereSNMP Extension Agent
Setting values using the Adaptive Server Anywhere SNMP Extension
Agent
TheAdaptive Server Anywhere SNMP Extension Agent responds to SNMP
get,get-next, and set queries.
Youcan set any database option, some server properties, and one database
propertyusing the AdaptiveServer Anywhere SNMP agent.
Whensetting database options, the Adaptive Server Anywhere SNMP agent
executesthe statement:
SET OPTION PUBLIC.opt = ’value’
Whensetting database and server properties, the sa_server_option system
procedureis used.
Theway you set these values depends on your SNMP management software.
☞Forthe OIDs and information about the options and properties that can
beset with the Adaptive Server Anywhere SNMP Extension Agent, see
“TheAdaptive Server Anywhere MIB” on page 24.
Executing stored procedures using the Adaptive Server Anywhere SNMPExtension Agent
TheAdaptive Server Anywhere MIB includes an OID that allows you to
executea stored procedure using the Adaptive Server Anywhere SNMP
ExtensionAgent. Inorder to execute the stored procedure, the user that the
AdaptiveServer Anywhere SNMP Extension Agent uses to connect must
haveone of the following:
♦executepermission on the procedure
♦bethe owner of the procedure
♦haveDBA authority
Anyresult sets or return values generated by the procedure are ignored.
Toexecute a stored procedure using the Adaptive Server Anywhere SNMP
ExtensionAgent, set the value of asaAgent.asaProc (OID
1.3.6.1.4.1.897.2.3.5.
db
,where
db
isthe database number in the
asasnmp.ini
file)to a string that is the name of a stored procedure. Optionally,you can
supplyarguments to the procedure; if no arguments are supplied,
parentheses( ) areappended to the procedure name.
17