Sybase Adaptive Server Anywhere SNMP Extension Agent - Manual (Page 20)

OID Name Description
1.3.6.1.4.897.2.3.3. db asaAgent.asaConnected Returns whether the Adaptive
Server Anywhere Extension Agent
is connected to database
db . Setting
this value to 0 causes the Adaptive
Server Anywhere Extension Agent
to shut down the database
1
, while
setting this value to 1 causes the
Adaptive Server Anywhere Exten-
sion Agent to attempt to start the
database
2
.
1.3.6.1.4.897.2.3.4. db asaAgent.asaStarted Returns whether database db is run-
ning. Setting this value to 0 causes
the Adaptive Server Anywhere Ex-
tension Agent to shut down the
database, while setting this value to
1 attempts to start the database.
1.3.6.1.4.897.2.3.5. db asaAgent.asaProc Setting this value to a string proc_-
name causes the Adaptive Server
Anywhere Extension Agent to exe-
cuted the procedure
proc_name in
the database.
Arguments can be supplied (for
example, proc_name(‘string’, 4));
if no arguments are supplied, paren-
theses () are appended to the name.
Getting the value returns
"" .
1.3.6.1.4.897.2.4 asaMetaData Several virtual tables; each row
represents a variable supported
by the Adaptive Server Anywhere
MIB.
1
Note that when stopping a database by setting this variable, the stop is
unconditional, meaning that the database will be stopped even if it has active
connections.
2
In order to be able to start a database by setting this variable, the DBF
parameter must be specified in the connection string (along with DBN if
desired and DBKEY if required), and either (a) the UtilDbPwd field must be
set in the
asasnmp.ini file, or (b) the start database permission on the server
(specified with the -gd server option) must be set to all.
8