Sybase Network Card Adaptive Server Anywhere SNMP Extension Agent User Manual

Adaptive Server® Anywhere  
SNMP Extension Agent  
User’s Guide  
Part number: DC00192-01-0902-01  
Last modified: December 2004  
 
Contents  
About This Manual  
v
SQL Anywhere Studio documentation . . . . . . . . . . . . . vi  
Documentation conventions . . . . . . . . . . . . . . . . . . . ix  
The Adaptive Server Anywhere sample database . . . . . . . xi  
Finding out more and providing feedback . . . . . . . . . . . xii  
I Using the Adaptive Server Anywhere SNMP Ex-  
tension Agent  
1
1
The Adaptive Server Anywhere SNMP Extension Agent  
Introduction to the Adaptive Server Anywhere SNMP Exten-  
sion Agent . . . . . . . . . . . . . . . . . . . . . . . . . .  
Understanding SNMP . . . . . . . . . . . . . . . . . . . . . .  
3
4
6
Using the Adaptive Server Anywhere SNMP Extension Agent 10  
II Adaptive Server Anywhere SNMP Extension  
Agent Reference  
21  
2
Adaptive Server Anywhere MIB Reference  
23  
The Adaptive Server Anywhere MIB . . . . . . . . . . . . . . 24  
3
RDBMS MIB Reference  
41  
The RDBMS MIB . . . . . . . . . . . . . . . . . . . . . . . . . 42  
Index  
49  
iii  
 
iv  
 
About This Manual  
Subject  
This book covers material related to running and configuring the Adaptive  
Server Anywhere SNMP Extension Agent.  
Audience  
This manual is for Adaptive Server Anywhere users who wish to use the  
Adaptive Server Anywhere SNMP Extension Agent on Windows 2000,  
Windows XP, or Windows Server 2003 (32-bit versions). It is to be used in  
conjunction with other manuals in the documentation set.  
v
 
SQL Anywhere Studio documentation  
This book is part of the SQL Anywhere documentation set. This section  
describes the books in the documentation set and how you can use them.  
The SQL Anywhere  
Studio documentation  
The SQL Anywhere Studio documentation is available in a variety of forms:  
in an online form that combines all books in one large help file; as separate  
PDF files for each book; and as printed books that you can purchase. The  
documentation consists of the following books:  
Introducing SQL Anywhere Studio This book provides an overview of  
the SQL Anywhere Studio database management and synchronization  
technologies. It includes tutorials to introduce you to each of the pieces  
that make up SQL Anywhere Studio.  
What’s New in SQL Anywhere Studio This book is for users of  
previous versions of the software. It lists new features in this and  
previous releases of the product and describes upgrade procedures.  
Adaptive Server Anywhere Database Administration Guide This  
book covers material related to running, managing, and configuring  
databases and database servers.  
Adaptive Server Anywhere SQL User’s Guide This book describes  
how to design and create databases; how to import, export, and modify  
data; how to retrieve data; and how to build stored procedures and  
triggers.  
Adaptive Server Anywhere SQL Reference Manual This book  
provides a complete reference for the SQL language used by Adaptive  
Server Anywhere. It also describes the Adaptive Server Anywhere  
system tables and procedures.  
Adaptive Server Anywhere Programming Guide This book describes  
how to build and deploy database applications using the C, C++, and Java  
programming languages. Users of tools such as Visual Basic and  
PowerBuilder can use the programming interfaces provided by those  
tools. It also describes the Adaptive Server Anywhere ADO.NET data  
provider.  
Adaptive Server Anywhere SNMP Extension Agent User’s Guide  
This book describes how to configure the Adaptive Server Anywhere  
SNMP Extension Agent for use with SNMP management applications to  
manage Adaptive Server Anywhere databases.  
Adaptive Server Anywhere Error Messages This book provides a  
complete listing of Adaptive Server Anywhere error messages together  
with diagnostic information.  
vi  
 
SQL Anywhere Studio Security Guide This book provides  
information about security features in Adaptive Server Anywhere  
databases. Adaptive Server Anywhere 7.0 was awarded a TCSEC  
(Trusted Computer System Evaluation Criteria) C2 security rating from  
the U.S. Government. This book may be of interest to those who wish to  
run the current version of Adaptive Server Anywhere in a manner  
equivalent to the C2-certified environment.  
MobiLink Administration Guide This book describes how to use the  
MobiLink data synchronization system for mobile computing, which  
enables sharing of data between a single Oracle, Sybase, Microsoft or  
IBM database and many Adaptive Server Anywhere or UltraLite  
databases.  
MobiLink Clients This book describes how to set up and synchronize  
Adaptive Server Anywhere and UltraLite remote databases.  
MobiLink Server-Initiated Synchronization User’s Guide This book  
describes MobiLink server-initiated synchronization, a feature of  
MobiLink that allows you to initiate synchronization from the  
consolidated database.  
MobiLink Tutorials This book provides several tutorials that walk you  
through how to set up and run MobiLink applications.  
QAnywhere User’s Guide This manual describes MobiLink  
QAnywhere, a messaging platform that enables the development and  
deployment of messaging applications for mobile and wireless clients, as  
well as traditional desktop and laptop clients.  
iAnywhere Solutions ODBC Drivers This book describes how to set  
up ODBC drivers to access consolidated databases other than Adaptive  
Server Anywhere from the MobiLink synchronization server and from  
Adaptive Server Anywhere remote data access.  
SQL Remote User’s Guide This book describes all aspects of the  
SQL Remote data replication system for mobile computing, which  
enables sharing of data between a single Adaptive Server Anywhere or  
Adaptive Server Enterprise database and many Adaptive Server  
Anywhere databases using an indirect link such as e-mail or file transfer.  
SQL Anywhere Studio Help This book includes the context-sensitive  
help for Sybase Central, Interactive SQL, and other graphical tools. It is  
not included in the printed documentation set.  
UltraLite Database User’s Guide This book is intended for all  
UltraLite developers. It introduces the UltraLite database system and  
provides information common to all UltraLite programming interfaces.  
vii  
 
UltraLite Interface Guides A separate book is provided for each  
UltraLite programming interface. Some of these interfaces are provided  
as UltraLite components for rapid application development, and others  
are provided as static interfaces for C, C++, and Java development.  
In addition to this documentation set, PowerDesigner and InfoMaker include  
their own online documentation.  
Documentation formats  
SQL Anywhere Studio provides documentation in the following formats:  
Online documentation The online documentation contains the  
complete SQL Anywhere Studio documentation, including both the  
books and the context-sensitive help for SQL Anywhere tools. The online  
documentation is updated with each maintenance release of the product,  
and is the most complete and up-to-date source of documentation.  
To access the online documentation on Windows operating systems,  
choose Start Programs SQL Anywhere 9 Online Books. You can  
navigate the online documentation using the HTML Help table of  
contents, index, and search facility in the left pane, as well as using the  
links and menus in the right pane.  
To access the online documentation on UNIX operating systems, see the  
HTML documentation under your SQL Anywhere installation.  
PDF books The SQL Anywhere books are provided as a set of PDF  
files, viewable with Adobe Acrobat Reader.  
The PDF books are accessible from the online books, or from the  
Windows Start menu.  
Printed books The complete set of books is available from Sybase  
sales or from eShop, the Sybase online store at  
viii  
 
Documentation conventions  
This section lists the typographic and graphical conventions used in this  
documentation.  
Syntax conventions  
The following conventions are used in the SQL syntax descriptions:  
Keywords All SQL keywords appear in upper case, like the words  
ALTER TABLE in the following example:  
ALTER TABLE [ owner.]table-name  
Placeholders Items that must be replaced with appropriate identifiers  
or expressions are shown like the words owner and table-name in the  
following example:  
ALTER TABLE [ owner.]table-name  
Repeating items Lists of repeating items are shown with an element of  
the list followed by an ellipsis (three dots), like column-constraint in the  
following example:  
ADD column-definition [ column-constraint, . . . ]  
One or more list elements are allowed. In this example, if more than one  
is specified, they must be separated by commas.  
Optional portions Optional portions of a statement are enclosed by  
square brackets.  
RELEASE SAVEPOINT [ savepoint-name ]  
These square brackets indicate that the savepoint-name is optional. The  
square brackets should not be typed.  
Options When none or only one of a list of items can be chosen,  
vertical bars separate the items and the list is enclosed in square brackets.  
[ ASC | DESC ]  
For example, you can choose one of ASC, DESC, or neither. The square  
brackets should not be typed.  
Alternatives When precisely one of the options must be chosen, the  
alternatives are enclosed in curly braces and a bar is used to separate the  
options.  
[ QUOTES { ON | OFF } ]  
If the QUOTES option is used, one of ON or OFF must be provided. The  
brackets and braces should not be typed.  
ix  
 
Graphic icons  
The following icons are used in this documentation.  
A client application.  
A database server, such as Sybase Adaptive Server Anywhere.  
A database. In some high-level diagrams, the icon may be used to  
represent both the database and the database server that manages it.  
Replication or synchronization middleware. These assist in sharing data  
among databases. Examples are the MobiLink Synchronization Server  
and the SQL Remote Message Agent.  
A programming interface.  
API  
x
 
The Adaptive Server Anywhere sample database  
Many of the examples throughout the documentation use the Adaptive  
Server Anywhere sample database.  
The sample database is held in a file named asademo.db, and is located in  
your SQL Anywhere directory.  
The sample database represents a small company. It contains internal  
information about the company (employees, departments, and finances) as  
well as product information and sales information (sales orders, customers,  
and contacts). All information in the database is fictional.  
The following figure shows the tables in the sample database and how they  
relate to each other.  
asademo.db  
sales_order_items  
product  
Employee  
id  
integer <pk,fk>  
smallint <pk>  
id  
name  
description  
size  
color  
integer  
char(15)  
char(30)  
char(18)  
char(6)  
integer  
<pk>  
emp_id  
integer  
integer  
char(20)  
char(20)  
integer  
char(40)  
char(20)  
char(4)  
char(9)  
char(10)  
char(1)  
char(11)  
numeric(20,3)  
date  
date  
date  
char(1)  
char(1)  
char(1)  
char(1)  
<pk>  
<fk>  
line_id  
prod_id  
quantity  
ship_date  
manager_id  
emp_fname  
emp_lname  
dept_id  
street  
city  
state  
zip_code  
phone  
status  
ss_number  
salary  
start_date  
termination_date  
birth_date  
bene_health_ins  
bene_life_ins  
bene_day_care  
sex  
integer  
integer  
date  
<fk>  
id = prod_id  
quantity  
unit_price  
numeric (15,2)  
emp_id = sales_rep  
id = id  
sales_order  
customer  
id  
cust_id  
order_date date  
fin_code_id char(2) <fk>  
region  
sales_rep  
integer <pk>  
integer <fk>  
id  
integer  
<pk>  
fname  
lname  
address  
city  
state  
zip  
phone  
char(15)  
char(20)  
char(35)  
char(20)  
char(2)  
char(7)  
integer  
id = cust_id  
<fk>  
char(10)  
char(20)  
code = fin_code_id  
fin_code  
company_name char(35)  
dept_id = dept_id  
contact  
code  
type  
description char(50)  
char(2)  
char(10)  
<pk>  
emp_id = dept_head_id  
id  
integer  
char(15)  
char(15)  
char(2)  
char(30)  
char(20)  
char(2)  
char(5)  
char(10)  
char(10)  
<pk>  
last_name  
first_name  
title  
street  
city  
state  
zip  
phone  
fax  
code = code  
fin_data  
department  
dept_id  
integer  
char(40)  
dept_head_id integer  
<pk>  
<fk>  
dept_name  
year  
quarter char(2)  
code char(2)  
amount numeric(9)  
char(4)  
<pk>  
<pk>  
<pk,fk>  
xi  
 
Finding out more and providing feedback  
We would like to receive your opinions, suggestions, and feedback on this  
documentation.  
You can provide feedback on this documentation and on the software  
through newsgroups set up to discuss SQL Anywhere technologies. These  
newsgroups can be found on the forums.sybase.com news server.  
The newsgroups include the following:  
Newsgroup disclaimer  
iAnywhere Solutions has no obligation to provide solutions, information  
or ideas on its newsgroups, nor is iAnywhere Solutions obliged to provide  
anything other than a systems operator to monitor the service and insure its  
operation and availability.  
iAnywhere Solutions Technical Advisors as well as other staff assist on the  
newsgroup service when they have time available. They offer their help  
on a volunteer basis and may not be available on a regular basis to provide  
solutions and information. Their ability to help is based on their workload.  
You can e-mail comments and suggestions to the SQL Anywhere  
documentation team at [email protected]. Although we do not  
undertake to reply to e-mails at that address, you can be sure we will read  
your suggestions with interest.  
xii  
 
PART I  
USING THE ADAPTIVE  
SERVER ANYWHERE  
SNMP EXTENSION AGENT  
This part describes how to set up and configure the Adaptive Server  
Anywhere SNMP Extension Agent.  
 
 
CHAPTER 1  
The Adaptive Server Anywhere SNMP  
Extension Agent  
About this chapter  
Contents  
This chapter introduces you to the Adaptive Server Anywhere SNMP  
Extension Agent.  
Topic:  
page  
3
 
Introduction to the Adaptive Server Anywhere  
SNMP Extension Agent  
If you are running Adaptive Server Anywhere on Windows 2000, Windows  
XP, or Windows Server 2003 (32-bit versions), you can use the Adaptive  
Server Anywhere SNMP Extension Agent in conjunction with SNMP  
management applications to manage your Adaptive Server Anywhere  
databases. One agent can be used to monitor several different databases  
running on different database servers running on different machines.  
Using the Adaptive Server Anywhere SNMP Extension Agent, you can do  
the following:  
retrieve the value of all server and database statistics  
retrieve the value of all server and database properties  
retrieve the value of all PUBLIC database options  
set the value for any PUBLIC database option  
execute stored procedures  
generate traps based on property or statistic values  
Supplied files  
The following files for the Adaptive Server Anywhere SNMP Extension  
Agent are included in your SQL Anywhere Studio installation:  
dbsnmp9.dll The Adaptive Server Anywhere SNMP Extension Agent.  
This file is located in C:\Program Files\Sybase\SQL Anywhere 9\win32.  
iAnywhere.mib The Adaptive Server Anywhere MIB contains all the  
OIDs for database server and database properties, statistics, and options  
that can be accessed using the Adaptive Server Anywhere SNMP  
Extension Agent.  
RDBMS-MIB.mib The is a generic MIB for relational database  
management systems and contains OIDs that can be accessed using the  
Adaptive Server Anywhere SNMP Extension Agent.  
SNMPv2-SMI.mib This MIB is referenced by the Adaptive Server  
Anywhere and RDBMS MIBs.  
SNMPv2-TC.mib This MIB is referenced by the Adaptive Server  
Anywhere and RDBMS MIBs.  
SYBASE-MIB.mib The Sybase MIB. This MIB is referenced by the  
Adaptive Server Anywhere MIB.  
4
 
 
Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent  
asasnmp.ini This file lists the databases that the Adaptive Server  
Anywhere SNMP Extension Agent monitors. By default, this file is  
located in C:\Program Files\Sybase\SQL Anywhere 9\win32.  
5
 
Understanding SNMP  
Simple Network Management Protocol (SNMP) is a standard protocol used  
for network management. SNMP allows managers and agents to  
communicate: managers send requests to agents, and agents respond to  
queries from managers. Additionally, agents can notify managers when  
specific events occur using notifications called traps.  
SNMP agents handle requests to get and set the values of variables for  
managed objects. Each variable has a single value, and values are generally  
strings or integers, although they may also be other types.  
Variables are kept in a global hierarchy, and each variable has a unique  
number under its parent. The full name of a variable (including all its  
parents) is called the Object Identifier (OID). All OIDs that are owned by  
Sybase begin with 1.3.6.1.4.1.897.  
The list of OIDs that an agent supports, including their names, types, and  
other information are stored in a file called a Management Information  
Base (MIB).  
A MIB is a database that stores network management information about  
managed objects. The MIB is separate from the Adaptive Server Anywhere  
database you are monitoring using the Adaptive Server Anywhere SNMP  
Extension Agent. The values of MIB objects can be changed or retrieved  
using SNMP. MIB objects are organized in a hierarchy with the most general  
information about the network located at the top level of the hierarchy. The  
Adaptive Server Anywhere SNMP Extension Agent supports the following  
MIBs:  
Adaptive Server Anywhere MIB a MIB created specifically for the  
Adaptive Server Anywhere SNMP Extension Agent. All the OIDs in the  
Adaptive Server Anywhere MIB begin with 1.3.6.1.4.1.897.2. The  
Adaptive Server Anywhere MIB lists the OIDs for the statistics,  
properties, and option values that can be retrieved, and in some cases set,  
using the Adaptive Server Anywhere SNMP Extension Agent.  
For more information about the Adaptive Server Anywhere MIB, see  
RDBMS MIB a generic, vendor-independent MIB for relational  
databases. This MIB contains information about the database servers and  
databases in your system.  
For more information about the RDBMS MIB, see “The RDBMS  
6
 
 
Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent  
The Adaptive Server Anywhere MIB  
The Adaptive Server Anywhere MIB was created for the Adaptive Server  
Anywhere SNMP Extension Agent. It includes all database server statistics  
and properties, as well as all database statistics, properties, and options. The  
statistics and properties are all read-only (with a few exceptions), and the  
database options are all read-write.  
By default, the Adaptive Server Anywhere MIB is located in C:\Program  
Files\Sybase\SQL Anywhere 9\snmp\iAnywhere.mib.  
For information about the tables in the Adaptive Server Anywhere MIB,  
For information about setting values in the Adaptive Server Anywhere  
The following hierarchy describes the Adaptive Server Anywhere MIB:  
OID  
Name  
Description  
1.3.6.1.4.897.2.1.1.n.db  
asaServer.asaSrvStat  
Returns the value of server statistic  
n on database db.  
1.3.6.1.4.897.2.1.2.n.db  
1.3.6.1.4.897.2.2.1.n.db  
1.3.6.1.4.897.2.2.2.n.db  
1.3.6.1.4.897.2.2.3.n.db  
1.3.6.1.4.897.2.3.1  
asaServer.asaSrvProp  
asaDb.asaDbStat  
Returns the value of server property  
n on database db.  
Returns the value of database statis-  
tic n on database db.  
asaDb.asaDbProp  
Returns the value of database prop-  
erty n on database db.  
asaDb.asaDbOpt  
Returns the value of database option  
n on database db.  
asaAgent.asaVersion  
asaAgent.asaDbConnStr  
Returns the version of the Adaptive  
Server Anywhere Extension Agent.  
1.3.6.1.4.897.2.3.2.db  
Returns the connection string for  
database db.  
7
 
 
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 database1, while  
setting this value to 1 causes the  
Adaptive Server Anywhere Exten-  
sion Agent to attempt to start the  
database2.  
1.3.6.1.4.897.2.3.4.db  
asaAgent.asaStarted  
asaAgent.asaProc  
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  
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
 
Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent  
asaMetaData tables  
The Adaptive Server Anywhere MIB includes metadata tables that provide a  
way to query the Adaptive Server Anywhere Extension Agent to find out  
which variables are supported.  
asaSrvMetaData.asaSrvStatMetaDataTable lists the database server  
statistics (variables under asa.asaServer.asaSrvStat.)  
asaSrvMetaData.asaSrvpropMetaDataTable lists the database server  
properties (variables under asa.asaServer.asaSrv.Prop.)  
asaDbMetaData.asaDbStatMetaDataTable lists the database statistics  
(variables under asa.asaDb.asaDbStat.)  
asaDbMetaData.asaDbpropMetaDataTable lists the database  
properties (variables under asa.asaDb.asaDbProp.)  
asaDbMetaData.asaDbOptMetaDataTable lists the database options  
(variables under asa.asaDb.asaDbOpt.)  
For more information about the information stored in the Adaptive  
Server Anywhere MIB metadata tables, see “asaMetaData tables” on  
The RDBMS MIB  
The RDBMS MIB is a generic and vendor-independent MIB (RFC 1697) for  
relational database-management system products. The RDBMS MIB uses  
virtual tables to return information on the servers and databases. The base  
OID is 1.3.6.1.2.1.39, and there are 9 virtual tables in this MIB. The  
Adaptive Server Anywhere SNMP Extension Agent supports 8 of these  
virtual tables.  
For descriptions of the supported tables contained in the RDBMS MIB,  
The Adaptive Server Anywhere Extension Agent provides read-only access  
to all of the supported variables in the RDBMS MIB. None of the variables  
in the RDBMS MIB are writable through the Adaptive Server Anywhere  
Extension Agent.  
A virtual table contains a fixed number of attributes and any number for  
rows. Elements in the table are retrieved using GET requests by appending  
the column number and row number to the OID of the table. A 1 must be  
appended to the table OID, so the OID looks as follows:  
table.1.colnum.rownum  
By default, the RDBMS MIB is located in C:\Program Files\Sybase\SQL  
Anywhere 9\snmp\RDBMS-MIB.mib.  
9
 
 
Using the Adaptive Server Anywhere SNMP  
Extension Agent  
In order to use the Adaptive Server Anywhere SNMP Extension Agent, you  
must have SNMP installed on your machine and you must create an  
asasnmp.ini file that contains information about the databases that are  
monitored by the Adaptive Server Anywhere SNMP Extension Agent.  
Installing SNMP  
Before you can use the Adaptive Server Anywhere Extension Agent, you  
must install SNMP on your machine. By default, SNMP is not installed on  
Windows 2000 or Windows XP.  
To install SNMP  
1. Open the Control Panel.  
On Windows 2000, from the Start menu choose Settings Control  
Panel.  
On Windows XP, from the Start menu choose Control Panel.  
2. Double-click Add/Remove Programs.  
The Add/Remove Programs dialog appears.  
3. In the left pane of the Add/Remove Programs dialog, click Add/Remove  
Windows Components.  
The Windows Components wizard appears.  
4. On the first page of the Windows Components wizard, double-click  
Management and Monitoring Tools.  
The Management and Monitoring Tools dialog appears.  
5. Select the Simple Network Management Protocol option and then click  
OK.  
6. Click Next.  
7. Click Finished when the installation completes.  
8. If you are prompted, reboot your computer.  
Once you have installed SNMP on your machine, two services should be  
running on your machine: SNMP Service and SNMP Trap Service.  
10  
 
 
Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent  
To check that the SNMP services are installed on your computer  
1. Open the Control Panel.  
On Windows 2000, from the Start menu choose Settings Control  
Panel.  
On Windows XP, from the Start menu choose Control Panel.  
2. In the Control Panel, double-click Administrative Tools.  
3. Double-click Services.  
The services SNMP Service and SNMP Trap Service appear in the list of  
local services.  
If you installed SNMP before you installed SQL Anywhere Studio, you need  
to stop and restart the SNMP service so it will detect the Adaptive Server  
Anywhere SNMP Extension Agent. If you installed SQL Anywhere Studio  
and then installed SNMP, the SNMP service will detect the Adaptive Server  
Anywhere SNMP Extension Agent automatically.  
To restart the SNMP service (Control Panel)  
1. Open the Control Panel.  
On Windows 2000, from the Start menu choose Settings Control  
Panel.  
On Windows XP, from the Start menu choose Control Panel.  
2. In the Control Panel, double-click Administrative Tools.  
3. Double-click Services.  
4. Right-click SNMP Service and choose Restart from the popup menu.  
This stops and restarts the SNMP service.  
To restart the SNMP service (Command line)  
1. Open a command prompt and execute the following command:  
net stop snmp  
This stops the SNMP service.  
2. Execute the following command:  
net start snmp  
This starts the SNMP service.  
11  
 
Configuring the Adaptive Server Anywhere SNMP Extension Agent  
The Adaptive Server Anywhere Extension Agent can monitor one or more  
databases. The databases to be monitored are stored in the asasnmp.ini file  
with the following format:  
[ASAAgent]  
TrapPollTime=time in seconds  
[DBn]  
ConnStr=connection string  
UtilDbPwd=utility database password  
CacheTime=time in seconds  
Trapt=trap information  
Disabled=1 or 0  
By default, your SQL Anywhere Studio installation places the asasnmp.ini  
file in the C:\Program Files\Sybase\SQL Anywhere 9\win32 directory.  
Once you edit this file, you must restart the SNMP service or reset the  
Adaptive Server Anywhere SNMP Extension Agent so that the new settings  
are used by the Agent.  
To restart the SNMP service (Control Panel)  
1. Open the Control Panel.  
On Windows 2000, from the Start menu choose Settings Control  
Panel.  
On Windows XP, from the Start menu choose Control Panel.  
2. In the Control Panel, double-click Administrative Tools.  
3. Double-click Services.  
4. Right-click SNMP Service and choose Restart from the popup menu.  
This stops and restarts the SNMP service.  
To restart the SNMP service (Command line)  
1. Open a command prompt and execute the following command:  
net stop snmp  
This stops the SNMP service.  
2. Execute the following command:  
net start snmp  
This starts the SNMP service.  
12  
 
Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent  
To restart the Adaptive Server Anywhere SNMP Extension Agent  
1. Using your SNMP management tool, change the value of the  
asaAgent.asaRestart property, 1.3.6.1.4.1.897.2.3.6, to 1.  
You can obfuscate the contents of the asasnmp.ini file with simple  
encryption using the File Hiding utility (dbfhide).  
For more information, see “Hiding the contents of .ini files” [ASA  
Database Administration Guide, page 524].  
The ASAAgent section  
The ASAAgent section of the asasnmp.ini file contains a TrapPollTime field  
with information about the Adaptive Server Anywhere Extension Agent. If  
the TrapPollTime field is not required, you can omit the entire section.  
TrapPollTime This value specifies the poll frequency for dynamic traps if  
they are specified. The Adaptive Server Anywhere SNMP Extension Agent  
polls the values every 5 seconds by default. Setting this value to 0 disables  
dynamic traps. This field is optional.  
The DBn section  
Each DBn section of the asasnmp.ini file describes a database, how to  
connect to it, and any dynamic traps that exist for the database. The fields in  
this section are case sensitive.  
The value for n is a number that identifies the database. The numbers must  
start with 1, and numbers cannot be skipped. For example, if the asasnmp.ini  
file contained entries for [DB1], [DB2], and [DB4], the [DB4] entry would  
be ignored because the file is missing the entry for [DB3].  
ConnStr The connection string used to connect to the database. You must  
supply enough information to be able to connect to the database. This field is  
required.  
If you want to use an ODBC data source to connect to the database, it  
must be a system data source, not a user data source.  
If you want to use an integrated login, you must map to the SYSTEM  
account because the SNMP Agent runs as a service. However, this means  
that anything that runs as a service can then connect to the database  
without a password. Alternatively, you can change the account that the  
service runs under and then create an integrated login for that account.  
The string ASTART=NO;IDLE=0;CON=SNMP;ASTOP=NO is prepended to  
the connection string. This string does the following:  
prevents the Adaptive Server Anywhere SNMP Extension Agent from  
trying to autostart a database server  
disables idle timeout since it is likely that the Adaptive Server  
Anywhere SNMP Extension Agent will sit idle for some time  
13  
 
names the connection so it can be identified  
prevents the database from being shut down when the Adaptive Server  
Anywhere SNMP Extension Agent disconnects  
If you specify any of these values in the connection string in the  
asasnmp.ini file, the values in the asasnmp.ini file will override the  
default settings.  
UtilDbPwd When setting asa.agent.asaStarted to start a database,  
the Adaptive Server Anywhere SNMP Extension Agent attempts to connect  
to the database with the DBF parameter, which tells the database server  
where to find the database file. However, if the permission required to start  
the database is DBA (the default for the network server, which can also be  
set using the -gd dba option for both the personal and network servers), then  
the server will not allow the connection.  
To start a database on such a server, the Adaptive Server Anywhere SNMP  
Extension Agent must connect as a user with DBA authority to a database  
already running on the same server. This can be done by connecting to the  
utility database. If you specify the utility database password (contained in  
the server’s util_db.ini file) in the asasnmp.ini file, then to start a database,  
the Adaptive Server Anywhere Extension Agent connects to the utility  
database on the same server, executes the START DATABASE statement,  
and then disconnects. This field is optional.  
CacheTime When data is retrieved from the database, it can be cached  
inside the Adaptive Server Anywhere SNMP Extension Agent, so that  
subsequent retrievals of the same type of data (for example, server properties  
or database statistics) do not require communication with the database.  
While caching the data means that you can obtain the data more quickly on  
subsequent retrievals, the data may be out of date. The CacheTime field can  
be used to change the cache time, or disable the cache by setting the value to  
0. By default, the cache time is 30 seconds. When the CacheTime parameter  
is set to 0, the data retrieved is always be up-to-date because data is retrieved  
from the database for every request. This field is optional.  
DBSpaceCacheTime The rdbmsDbLimitedResourceTable in the RDBMS  
MIB contains information about dbspaces. When this information is  
retrieved from the database, it can also be cached inside the Adaptive Server  
Anywhere Extension Agent. The default cache time for dbspace information  
is 600 seconds (10 minutes). This field can be used to change the cache time  
(or disable the cache by setting the value to 0). This field is optional.  
For more information about the rdbmsDbLimitedResourceTable table,  
Trapt Creates a dynamic trap. The value t must be a positive integer  
14  
 
Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent  
starting at 1. Skipping numbers is not allowed. This field is optional.  
Disabled If set to 1, this database entry is skipped by the Adaptive Server  
Anywhere SNMP Extension Agent. This is useful for temporarily removing  
one database from the list of databases managed by the Adaptive Server  
Anywhere SNMP Extension Agent, without renumbering the rest. This field  
is optional.  
For information about creating traps, see “Creating dynamic traps” on  
Sample asasnmp.ini file The following is a sample asasnmp.ini file for the Adaptive Server  
Anywhere SNMP Extension Agent.  
[ASAAgent]  
[DB1]  
ConnStr=UID=DBA;PWD=SQL;ENG=server1;DBN=sales;DBF=sales.db  
Trap1=1.1.5 > 50000  
UtilDbPwd=test  
[DB2]  
ConnStr=UID=DBA;PWD=SQL;ENG=server1;DBN=field;DBF=field.db  
UtilDbPwd=test  
Disabled=1  
[DB3]  
ConnStr=UID=DBA;PWD=SQL;LINKS=tcpip;ENG=server2;DBN=hq;DBF=hq.db  
UtilDbPwd=test  
Because there are no parameters specified in the ASAAgent section, the  
Adaptive Server Anywhere SNMP Extension Agent will poll values every 5  
seconds.  
The Adaptive Server Anywhere SNMP Extension Agent is monitoring 3  
different databases running on two different servers. Database 3 is running  
on a different machine, so the LINKS connection parameter is required to  
specify the protocol. A trap is specified for DB1, which fires when the  
number of bytes sent by the database server is greater than 50 000.  
Obtaining values using the Adaptive Server Anywhere SNMP Extension  
Agent  
Using the Adaptive Server Anywhere SNMP Extension Agent, you can  
retrieve the values of all the following:  
Database server properties  
For a list of the database server property OIDs, see “Server  
Database server statistics  
15  
 
For a list of the database server statistic OIDs, see “Server statistics”  
Database options  
For a list of the database option OIDs, see “Database options” on  
Database properties  
For a list of the database property OIDs, see “Database properties”  
Database statistics  
For a list of the database statistic OIDs, see “Database statistics” on  
The way you retrieve these values will depend on your SNMP management  
software.  
Examples  
The table below provides a description and sample value that could be  
returned for the following OIDs.  
OID  
Explanation  
Sample value  
1.3.6.1.4.1.897.2.1.1.1.1  
Server statistic ActiveReq on  
database 1  
1
1.3.6.1.4.1.897.2.1.2.1.3  
1.3.6.1.4.1.897.2.2.1.4.1  
Server property C2 on database 3 NO  
Database statistic CacheRead on  
database 1  
11397  
1.3.6.1.4.1.897.2.2.2.7.4  
1.3.6.1.4.1.897.2.2.3.5.2  
Database property CaseSensi-  
tivePasswords on database 4  
OFF  
OFF  
Database option ANSI_-  
INTEGER_OVERFLOW on  
database 2  
1.3.6.1.4.1.897.2.3.1  
1.3.6.1.4.1.897.2.3.2.1  
Agent version  
9.0.1(1841)  
Connection string for database 1  
UID=DBA;PWD=SQL;  
ENG=server1; DBN=sales;  
DBF=sales.db  
16  
 
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  
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  
 
 
For example, setting the value of asaAgent.asaProc to the string  
pchin.updatesales( ’param1’, 2)” calls the updatesales stored  
procedure owned by user pchin.  
The way you set the value of this OID to the procedure name will depend on  
your SNMP management software.  
For more information, see “The Adaptive Server Anywhere MIB” on  
Using traps  
A trap is an OID that is sent by an SNMP agent when a particular event  
occurs. Traps are initiated by the SNMP agent and can be detected by  
SNMP management software, which can then either deal with the event  
directly or query the SNMP agent for more information.  
In order to receive traps, you must configure the SNMP service. The SNMP  
service will receive the trap information and then forward it on somewhere;  
however, by default, this is nowhere, so any trap listeners you have running  
will not detect anything. The following steps show how to configure your  
SNMP Service to send traps to your current machine.  
To configure the SNMP service  
1. Right-click My Computer and choose Manage from the popup menu.  
The Computer Management dialog appears.  
2. In the left pane, double-click Services and Applications.  
3. In the left pane, double-click Services.  
4. Locate SNMP Service in the list of services in the right pane, right-click  
it and choose Properties from the popup menu.  
The SNMP Service property sheet appears.  
5. Click the Traps tab.  
6. On the Traps tab, click Add.  
The SNMP Service Configuration dialog appears.  
7. In the SNMP Service Configuration dialog, type localhost in the text box  
and then click Add.  
8. Click OK to close the Service property sheet.  
18  
 
Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent  
Adaptive Server  
Anywhere SNMP  
Extension Agent traps  
The Adaptive Server Anywhere SNMP Extension Agent sends a trap  
whenever a connection is dropped by the database server. The OID of this  
trap is 1.3.6.1.2.1.39.2.1.  
The only other traps sent by the Adaptive Server Anywhere agent are  
dynamic traps.  
For more information about dynamic traps, see “Creating dynamic  
Creating dynamic traps  
A dynamic trap is a trap that is sent by the Adaptive Server Anywhere  
Extension Agent when a simple expression involving the value of a  
particular property, statistic, or option is true. Dynamic traps are created in  
the asasnmp.ini file. The format of the trap information in the asasnmp.ini  
file entry is as follows:  
Trap<trapnum>=[1.3.6.1.4.1.897.2.]<oid>[.<dbnum>] <op> <value>  
trapnum is the dynamic trap number. It must start at 1 and be sequential.  
oid is the OID of the property, statistic, or option. OIDs in either the  
Adaptive Server Anywhere MIB or the RDBMS MIB are supported. If the  
OID given is an invalid Adaptive Server Anywhere or RDBMS OID, the  
Adaptive Server Anywhere MIB prefix (1.3.6.1.4.1.897.2.) is prepended.  
For a list of OIDs in the Adaptive Server Anywhere MIB, see “Adaptive  
For a list of OIDs in the RDBMS MIB, see “RDBMS MIB Reference”  
dbnum is the database number. This field is optional, but if specified, it  
must match the database number of the [DBn] section of the asasnmp.ini  
file.  
op must have one of the following values:  
= or == (equality)  
!=,  
, or  
(inequality)  
= or = (less than or equal)  
= or = (greater than or equal)  
(less than)  
(greater than)  
19  
 
 
Note  
Only equality or inequality are supported for string values.  
value is the value to use in the expression. String values may be enclosed  
in single or double quotes; these quotes will not be included in the value. If  
you want the beginning or closing quotation marks to be included in the  
string, you must double them. Note that single quotes occurring within the  
string should not be doubled.  
You can specify as many trap fields as you wish in the asasnmp.ini file. The  
OID used for the trap will be 1.3.6.1.4.1.897.2.4.1, and the data sent  
with the trap will indicate the trap number of the trap that was sent.  
You can specify as many Trap fields as you wish in the asasnmp.ini file. The  
OID used for the trap will be 1.3.6.1.4.1.897.2.4.1, and the data sent  
with the trap includes the following:  
the trap number (starts at 1 for the first dynamic trap sent by the Adaptive  
Server Anywhere SNMP agent)  
the database index  
the database name trap index (from the asasnmp.ini file)  
the variable name  
the variable value (this is the current value of the variable, not necessarily  
the threshold value)  
Dynamic trap behavior  
Once a dynamic trap is triggered, the trap is not be sent again until the  
condition that caused it to be triggered changes to FALSE and then back to  
TRUE again.  
For example, if you have a dynamic trap set using 1.1.11.1 = 5120,  
then the trap is triggered when the server’s cache size reaches 5 MB (= 5120  
KB) and the dynamic trap is disabled, so no more traps are sent. The only  
way the trap is re-enabled is if the cache size later drops below 5 MB. You  
would then be notified if the cache size grew to 5 MB again.  
Trap examples  
Trap information  
Description  
Trap1=1.1.5 10000  
Trap sent when the number of bytes sent from the  
server is greater than 10 000  
Trap2=1.3.6.1.2.1.39.1.4.1.4.14.1 = 10485760  
Trap sent if the size of the transaction log file is  
larger than 10 MB  
20  
 
PART II  
ADAPTIVE SERVER  
ANYWHERE SNMP  
EXTENSION AGENT  
REFERENCE  
This section lists the OIDs supported by the Adaptive Server Anywhere  
SNMP Extension Agent. It lists the contents of the tables in the Adaptive  
Server Anywhere MIB and the RDBMS MIB.  
 
 
CHAPTER 2  
Adaptive Server Anywhere MIB Reference  
About this chapter  
Contents  
This chapter contains descriptions of the tables in the Adaptive Server  
Anywhere MIB.  
Topic:  
page  
23  
 
 
The Adaptive Server Anywhere MIB  
The following sections list the OIDs of the statistics, properties, and options  
that can be retrieved and set using the Adaptive Server Anywhere SNMP  
Extension Agent. By default,  
Agent  
The Agent table lists information about the Adaptive Server Anywhere  
SNMP Extension Agent.  
Writable properties are marked with an asterisk (*). The value n is the  
database number in the asasnmp.ini file.  
OID  
Type  
Name  
Value returned  
1.3.6.1.4.1.897.2.3.1  
1.3.6.1.4.1.897.2.3.2.n  
1.3.6.1.4.1.897.2.3.3.n  
1.3.6.1.4.1.897.2.3.4.n  
1.3.6.1.4.1.897.2.3.5.n  
1.3.6.1.4.1.897.2.3.6  
String  
asaVersion  
asaDBConnStr  
asaConnected*  
asaStarted*  
asaProc*  
Agent version  
String  
Connection string  
Integer32  
Integer32  
String  
1 if the agent is connected, 0 otherwise  
1 if the database is started, 0 otherwise  
” “  
0
String  
asaRestart*  
asaMetaData tables  
The following metadata tables are included in the Adaptive Server  
Anywhere MIB:  
asaSrvMetaData.asaSrvStatMetaDataTable  
asaSrvMetaData.asaSrvPropMetaDataTable  
asaSrvMetaData.asaDbStatMetaDataTable  
asaSrvMetaData.asaDbPropMetaDataTable  
asaSrvMetaData.asaDbOptMetaDataTable  
asaSrvMetaData.asaSrvStatMetaDataTable  
This table contains metadata about the database server statistics.  
The value db is the database number in the asasnmp.ini file.  
24  
 
   
Chapter 2. Adaptive Server Anywhere MIB Reference  
OID  
Type  
Name  
Value returned  
1.3.6.1.4.1.897.2.4.1.1.1.1.db  
1.3.6.1.4.1.897.2.4.1.1.1.2.db  
1.3.6.1.4.1.897.2.4.1.1.1.3.db  
1.3.6.1.4.1.897.2.4.1.1.1.4.db  
Integer32  
Integer32  
Integer32  
OID  
asaSrvStatIndex  
asaSrvStatObjType  
asaSrvStatType  
asaSrvStatOID  
db  
11  
12  
OID of Adaptive Server Any-  
where MIB entry3  
1.3.6.1.4.1.897.2.4.1.1.1.5.db  
String  
asaSrvStatName  
Statistic name  
1 Values: 1=Server, 2=Database  
2 Values: 1=Statistic, 2=Property, 3=Option  
3 The OID returned does not include the database number. You must append  
the database number to the OID before it can be used in a query.  
asaSrvMetaData.asaSrvPropMetaDataTable  
This table contains metadata about the database server properties.  
The value db is the database number in the asasnmp.ini file.  
OID  
Type  
Name  
Value returned  
1.3.6.1.4.1.897.2.4.1.2.1.1.db  
1.3.6.1.4.1.897.2.4.1.2.1.2.db  
1.3.6.1.4.1.897.2.4.1.2.1.3.db  
1.3.6.1.4.1.897.2.4.1.2.1.4.db  
Integer32  
Integer32  
Integer32  
OID  
asaSrvPropIndex  
asaSrvPropObjType  
asaSrvPropType  
asaSrvPropOID  
db  
11  
22  
OID of Adaptive  
Server Anywhere MIB  
entry3  
1.3.6.1.4.1.897.2.4.1.2.1.5.db  
String  
asaSrvPropName  
Property name  
1 Values: 1=Server, 2=Database  
2 Values: 1=Statistic, 2=Property, 3=Option  
3 The OID returned does not include the database number. You must append  
the database number to the OID before it can be used in a query.  
asaDbMetaData.asaDbStatMetaDataTable  
This table contains metadata about the database statistics.  
25  
 
The value db is the database number in the asasnmp.ini file.  
OID  
Type  
Name  
Value returned  
1.3.6.1.4.1.897.2.4.2.1.1.1.db  
1.3.6.1.4.1.897.2.4.2.1.1.2.db  
1.3.6.1.4.1.897.2.4.2.1.1.3.db  
1.3.6.1.4.1.897.2.4.2.1.1.4.db  
Integer32  
Integer32  
Integer32  
OID  
asaDbStatIndex  
asaDbStatObjType  
asaDbStatType  
asaDbStatOID  
db  
21  
12  
OID of Adaptive Server  
Anywhere MIB entry3  
1.3.6.1.4.1.897.2.4.2.1.1.5.db  
String  
asaDbStatName  
Statistic name  
1
2
3
Values: 1=Server, 2=Database  
Values: 1=Statistic, 2=Property, 3=Option  
The OID returned does not include the database number. You must append  
the database number to the OID before it can be used in a query.  
asaDbMetaData.asaDbPropMetaDataTable  
This table contains metadata about the database properties.  
The value db is the database number in the asasnmp.ini file.  
OID  
Type  
Name  
Value returned  
1.3.6.1.4.1.897.2.4.2.2.1.1.db  
1.3.6.1.4.1.897.2.4.2.2.1.2.db  
1.3.6.1.4.1.897.2.4.2.2.1.3.db  
1.3.6.1.4.1.897.2.4.2.2.1.4.db  
Integer32  
Integer32  
Integer32  
OID  
asaDbPropIndex  
asaDbPropObjType  
asaDbPropType  
asaDbPropOID  
db  
21  
22  
OID of Adaptive Server  
Anywhere MIB entry3  
1.3.6.1.4.1.897.2.4.2.2.1.5.db  
String  
asaDbPropName  
Property name  
1
2
3
Values: 1=Server, 2=Database  
Values: 1=Statistic, 2=Property, 3=Option  
The OID returned does not include the database number. You must append  
the database number to the OID before it can be used in a query.  
26  
 
Chapter 2. Adaptive Server Anywhere MIB Reference  
asaDbMetaData.asaDbOptMetaDataTable  
This table contains metadata about the database options.  
The value db is the database number in the asasnmp.ini file.  
OID  
Type  
Name  
Value returned  
1.3.6.1.4.1.897.2.4.2.1.1.1.db  
1.3.6.1.4.1.897.2.4.2.1.1.2.db  
1.3.6.1.4.1.897.2.4.2.1.1.3.db  
1.3.6.1.4.1.897.2.4.2.1.1.4.db  
Integer32  
Integer32  
Integer32  
OID  
asaDbOptIndex  
asaDbOptObjType  
asaDbOptType  
asaDbOptOID  
db  
21  
32  
OID of Adaptive Server Any-  
where MIB entry3  
1.3.6.1.4.1.897.2.4.2.1.1.5.db  
String  
asaDbOptName  
Option name  
1 Values: 1=Server, 2=Database  
2 Values: 1=Statistic, 2=Property, 3=Option  
3 The OID returned does not include the database number. You must append  
the database number to the OID before it can be used in a query.  
Server statistics  
This table lists the OIDs and names of the database server statistics that can  
be retrieved using the Adaptive Server Anywhere SNMP Extension Agent.  
The value n is the database number in the asasnmp.ini file.  
OID  
Type  
Name  
Statistic  
1.3.6.1.4.1.897.2.1.1.1.n  
1.3.6.1.4.1.897.2.1.1.2.n  
1.3.6.1.4.1.897.2.1.1.3.n  
1.3.6.1.4.1.897.2.1.1.4.n  
Integer32  
Integer32  
Counter64  
Counter64  
srvStatActiveReq  
srvStatAvailIO  
srvStatBytesReceived  
ActiveReq  
AvailIO  
BytesReceived  
BytesReceivedUncomp  
srvStatBytesReceivedUn-  
comp  
1.3.6.1.4.1.897.2.1.1.5.n  
1.3.6.1.4.1.897.2.1.1.6.n  
1.3.6.1.4.1.897.2.1.1.7.n  
1.3.6.1.4.1.897.2.1.1.8.n  
Counter64  
Counter64  
Counter64  
Integer32  
srvStatBytesSent  
BytesSent  
srvStatBytesSentUncomp  
srvStatCacheHitsEng  
srvStatCachePinned  
BytesSentUncomp  
CacheHitsEng  
CachePinned  
27  
 
 
OID  
Type  
Name  
Statistic  
1.3.6.1.4.1.897.2.1.1.9.n  
1.3.6.1.4.1.897.2.1.1.10.n  
1.3.6.1.4.1.897.2.1.1.11.n  
1.3.6.1.4.1.897.2.1.1.12.n  
1.3.6.1.4.1.897.2.1.1.13.n  
1.3.6.1.4.1.897.2.1.1.14.n  
1.3.6.1.4.1.897.2.1.1.15.n  
1.3.6.1.4.1.897.2.1.1.16.n  
1.3.6.1.4.1.897.2.1.1.17.n  
1.3.6.1.4.1.897.2.1.1.18.n  
1.3.6.1.4.1.897.2.1.1.19.n  
Counter64  
Counter64  
Integer32  
Counter64  
Integer32  
Integer32  
Integer32  
Integer32  
Counter64  
Integer32  
Integer32  
srvStatCacheReadEng  
srvStatCacheReplacements  
srvStatCurrentCacheSize  
srvStatDiskReadEng  
srvStatFreeBuffers  
CacheReadEng  
CacheReplacements  
CurrentCacheSize  
DiskReadEng  
FreeBuffers  
srvStatJavaGlobFix  
srvStatLicensesInUse  
srvStatLockedHeapPages  
srvStatMainHeapBytes  
srvStatMainHeapPages  
JavaGlobFix  
LicensesInUse  
LockedHeapPages  
MainHeapBytes  
MainHeapPages  
MapPhysicalMemoryEng  
srvStatMapPhysicalMemo-  
ryEng  
1.3.6.1.4.1.897.2.1.1.20.n  
1.3.6.1.4.1.897.2.1.1.21.n  
1.3.6.1.4.1.897.2.1.1.22.n  
1.3.6.1.4.1.897.2.1.1.23.n  
1.3.6.1.4.1.897.2.1.1.24.n  
1.3.6.1.4.1.897.2.1.1.25.n  
Integer32  
Integer32  
Counter64  
Counter64  
Counter64  
Counter64  
srvStatMaxCacheSize  
srvStatMinCacheSize  
MaxCacheSize  
MinCacheSize  
srvStatMultiPacketsReceived  
srvStatMultiPacketsSent  
srvStatPacketsReceived  
MultiPacketsReceived  
MultiPacketsSent  
PacketsReceived  
srvStatPacketsReceivedUn-  
comp  
PacketsReceivedUncomp  
1.3.6.1.4.1.897.2.1.1.26.n  
1.3.6.1.4.1.897.2.1.1.27.n  
1.3.6.1.4.1.897.2.1.1.28.n  
1.3.6.1.4.1.897.2.1.1.29.n  
1.3.6.1.4.1.897.2.1.1.30.n  
1.3.6.1.4.1.897.2.1.1.31.n  
1.3.6.1.4.1.897.2.1.1.32.n  
1.3.6.1.4.1.897.2.1.1.33.n  
Counter64  
Counter64  
Integer32  
Integer32  
Integer32  
Counter64  
Integer32  
Integer32  
srvStatPacketsSent  
srvStatPacketsSentUncomp  
srvStatPeakCacheSize  
srvStatRemoteputWait  
srvStatReq  
PacketsSent  
PacketsSentUncomp  
PeakCacheSize  
RemoteputWait  
Req  
srvStatSendFail  
SendFail  
srvStatTotalBuffers  
srvStatUnschReq  
TotalBuffers  
UnschReq  
28  
 
Chapter 2. Adaptive Server Anywhere MIB Reference  
Server properties  
The following table lists OIDs and names of the database server properties  
that can be retrieved using the Adaptive Server Anywhere SNMP Extension  
Agent.  
Writable properties are marked with an asterisk (*). The value n is the  
database number in the asasnmp.ini file.  
OID  
Type  
Name  
Property  
1.3.6.1.4.1.897.2.1.2.1.n  
1.3.6.1.4.1.897.2.1.2.2.n  
1.3.6.1.4.1.897.2.1.2.3.n  
1.3.6.1.4.1.897.2.1.2.4.n  
1.3.6.1.4.1.897.2.1.2.5.n  
1.3.6.1.4.1.897.2.1.2.6.n  
1.3.6.1.4.1.897.2.1.2.7.n  
1.3.6.1.4.1.897.2.1.2.8.n  
1.3.6.1.4.1.897.2.1.2.9.n  
1.3.6.1.4.1.897.2.1.2.10.n  
1.3.6.1.4.1.897.2.1.2.11.n  
1.3.6.1.4.1.897.2.1.2.12.n  
1.3.6.1.4.1.897.2.1.2.13.n  
1.3.6.1.4.1.897.2.1.2.14.n  
1.3.6.1.4.1.897.2.1.2.15.n  
1.3.6.1.4.1.897.2.1.2.16.n  
1.3.6.1.4.1.897.2.1.2.17.n  
1.3.6.1.4.1.897.2.1.2.18.n  
1.3.6.1.4.1.897.2.1.2.19.n  
1.3.6.1.4.1.897.2.1.2.20.n  
1.3.6.1.4.1.897.2.1.2.21.n  
1.3.6.1.4.1.897.2.1.2.22.n  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
srvPropC2  
C2  
srvPropCharSet  
CharSet  
srvPropCommandLine  
srvPropCompactPlatformVer  
srvPropCompanyName  
srvPropConnsDisabled*  
srvPropConsoleLogFile  
srvPropDefaultCollation  
srvPropIdleTimeout  
srvPropIsIQ  
CommandLine  
CompactPlatformVer  
CompanyName  
ConnsDisabled  
ConsoleLogFile  
DefaultCollation  
IdleTimeout  
IsIQ  
srvPropIsJavaAvailable  
srvPropIsNetworkServer  
srvPropIsRuntimeServer  
srvPropJavaObjectsEnabled  
srvPropLanguage  
IsJavaAvailable  
IsNetworkServer  
IsRuntimeServer  
JavaObjectsEnabled  
Language  
srvPropLegalCopyright  
srvPropLegalTrademarks  
srvPropLicenseCount  
srvPropLicensedCompany  
srvPropLicensedUser  
srvPropLicenseType  
srvPropLivenessTimeout*  
LegalCopyright  
LegalTrademarks  
LicenseCount  
LicensedCompany  
LicensedUser  
LicenseType  
LivenessTimeout  
29  
 
 
OID  
Type  
Name  
Property  
1.3.6.1.4.1.897.2.1.2.23.n  
1.3.6.1.4.1.897.2.1.2.24.n  
1.3.6.1.4.1.897.2.1.2.25.n  
1.3.6.1.4.1.897.2.1.2.26.n  
1.3.6.1.4.1.897.2.1.2.27.n  
String  
String  
String  
String  
String  
srvPropMachineName  
srvPropMaxMessage  
srvPropMessageWindowSize  
srvPropName  
MachineName  
MaxMessage  
MessageWindowSize  
Name  
srvPropNativeProcessorArchi-  
tecture  
NativeProcessorArchitecture  
1.3.6.1.4.1.897.2.1.2.28.n  
1.3.6.1.4.1.897.2.1.2.29.n  
1.3.6.1.4.1.897.2.1.2.30.n  
1.3.6.1.4.1.897.2.1.2.31.n  
1.3.6.1.4.1.897.2.1.2.32.n  
1.3.6.1.4.1.897.2.1.2.33.n  
1.3.6.1.4.1.897.2.1.2.34.n  
1.3.6.1.4.1.897.2.1.2.35.n  
1.3.6.1.4.1.897.2.1.2.36.n  
1.3.6.1.4.1.897.2.1.2.37.n  
1.3.6.1.4.1.897.2.1.2.38.n  
1.3.6.1.4.1.897.2.1.2.39.n  
1.3.6.1.4.1.897.2.1.2.40.n  
1.3.6.1.4.1.897.2.1.2.41.n  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
srvPropNumProcessorsAvail  
srvPropNumProcessorsMax  
srvPropOmniIdentifier  
srvPropPageSize  
NumProcessorsAvail  
NumProcessorsMax  
OmniIdentifier  
PageSize  
srvPropPlatform  
Platform  
srvPropPlatformVer  
PlatformVer  
srvPropProcessCPU  
ProcessCPU  
srvPropProcessCPUSystem  
srvPropProcessCPUUser  
srvPropProcessorArchitecture  
srvPropProductName  
srvPropProductVersion  
srvPropQuittingTime*  
ProcessCPUSystem  
ProcessCPUUser  
ProcessorArchitecture  
ProductName  
ProductVersion  
QuittingTime  
srvPropRememberLastState-  
ment*  
RememberLastStatement  
1.3.6.1.4.1.897.2.1.2.42.n  
1.3.6.1.4.1.897.2.1.2.43.n  
1.3.6.1.4.1.897.2.1.2.44.n  
1.3.6.1.4.1.897.2.1.2.45.n  
1.3.6.1.4.1.897.2.1.2.46.n  
1.3.6.1.4.1.897.2.1.2.47.n  
1.3.6.1.4.1.897.2.1.2.48.n  
String  
String  
String  
String  
String  
String  
String  
srvPropRequestFilterConn  
srvPropRequestFilterDB  
srvPropRequestLogFile*  
srvPropRequestLogging*  
srvPropRequestLogMaxSize  
srvPropStartTime  
RequestFilterConn  
RequestFilterDB  
RequestLogFile  
RequestLogging  
RequestLogMaxSize  
StartTime  
srvPropTempDir  
TempDir  
30  
 
Chapter 2. Adaptive Server Anywhere MIB Reference  
OID  
Type  
Name  
Property  
1.3.6.1.4.1.897.2.1.2.49.n  
1.3.6.1.4.1.897.2.1.2.50.n  
1.3.6.1.4.1.897.2.1.2.51.n  
1.3.6.1.4.1.897.2.1.2.52.n  
1.3.6.1.4.1.897.2.1.2.53.n  
1.3.6.1.4.1.897.2.1.2.54.n  
1.3.6.1.4.1.897.2.1.2.55.n  
1.3.6.1.4.1.897.2.1.2.56.n  
1.3.6.1.4.1.897.2.1.2.57.n  
String  
String  
String  
String  
String  
String  
String  
String  
String  
srvPropThreads  
Threads  
srvPropTimeZoneAdjustment  
srvPropHttpPorts  
TimeZoneAdjustment  
HttpPorts  
srvPropHttpsPorts  
HttpsPorts  
srvPropProfileFilterConn  
srvPropProfileFilterUser  
srvPropRequestLogNumFiles  
srvPropIsFipsAvailable  
srvPropFipsMode  
ProfileFilterConn  
ProfileFilterUser  
RequestLogNumFIles  
IsFipsAvailable  
FipsMode  
Database statistics  
The following table lists the OIDs and names the database statistics that can  
be retrieved using the Adaptive Server Anywhere SNMP Extension Agent.  
The value n is the database number in the asasnmp.ini file.  
OID  
Type  
Name  
Property  
1.3.6.1.4.1.897.2.2.1.1.n  
1.3.6.1.4.1.897.2.2.1.2.n  
1.3.6.1.4.1.897.2.2.1.3.n  
1.3.6.1.4.1.897.2.2.1.4.n  
1.3.6.1.4.1.897.2.2.1.5.n  
1.3.6.1.4.1.897.2.2.1.6.n  
1.3.6.1.4.1.897.2.2.1.7.n  
1.3.6.1.4.1.897.2.2.1.8.n  
1.3.6.1.4.1.897.2.2.1.9.n  
1.3.6.1.4.1.897.2.2.1.10.n  
Counter64  
Integer32  
Integer32  
Counter64  
Integer32  
Integer32  
Integer32  
Integer32  
Integer32  
Integer32  
dbStatCacheHits  
CacheHits  
dbStatCacheReadIndInt  
dbStatCacheReadIndLeaf  
dbStatCacheRead  
dbStatCacheReadTable  
dbStatChkpt  
CacheReadIndInt  
CacheReadIndLeaf  
CacheRead  
CacheReadTable  
Chkpt  
dbStatChkptFlush  
dbStatChkptPage  
dbStatCheckpointUrgency  
ChkptFlush  
ChkptPage  
CheckpointUrgency  
dbStatCheckpointLogBitmap-  
Size  
CheckpointLogBitmap-  
Size  
1.3.6.1.4.1.897.2.2.1.11.n  
Integer32  
dbStatCheckpointLogBitmap-  
PagesWritten  
CheckpointLogBitmap-  
PagesWritten  
31  
 
 
OID  
Type  
Name  
Property  
1.3.6.1.4.1.897.2.2.1.12.n  
Integer32  
dbStatCheckpointLogCommit-  
ToDisk  
CheckpointLogCommit-  
ToDisk  
1.3.6.1.4.1.897.2.2.1.13.n  
1.3.6.1.4.1.897.2.2.1.14.n  
1.3.6.1.4.1.897.2.2.1.15.n  
Integer32  
Integer32  
Integer32  
dbStatCheckpointLogPageI-  
nUse  
CheckpointLogPageInUse  
dbStatCheckpointLogPagesRe-  
located  
CheckpointLogPagesRelo-  
cated  
dbStatCheckpoint-  
LogSavePreimage  
Checkpoint-  
LogSavePreimage  
1.3.6.1.4.1.897.2.2.1.16.n  
1.3.6.1.4.1.897.2.2.1.17.n  
1.3.6.1.4.1.897.2.2.1.18.n  
Integer32  
Integer32  
Integer32  
dbStatCheckpointLogSize  
dbStatCheckpointLogWrites  
CheckpointLogSize  
CheckpointLogWrites  
dbStatCheckpointLog-  
PagesWritten  
CheckpointLogPagesWrit-  
ten  
1.3.6.1.4.1.897.2.2.1.19.n  
1.3.6.1.4.1.897.2.2.1.20.n  
1.3.6.1.4.1.897.2.2.1.21.n  
1.3.6.1.4.1.897.2.2.1.22.n  
1.3.6.1.4.1.897.2.2.1.23.n  
1.3.6.1.4.1.897.2.2.1.24.n  
1.3.6.1.4.1.897.2.2.1.25.n  
1.3.6.1.4.1.897.2.2.1.26.n  
1.3.6.1.4.1.897.2.2.1.27.n  
1.3.6.1.4.1.897.2.2.1.28.n  
1.3.6.1.4.1.897.2.2.1.29.n  
1.3.6.1.4.1.897.2.2.1.30.n  
1.3.6.1.4.1.897.2.2.1.31.n  
1.3.6.1.4.1.897.2.2.1.32.n  
1.3.6.1.4.1.897.2.2.1.33.n  
1.3.6.1.4.1.897.2.2.1.34.n  
1.3.6.1.4.1.897.2.2.1.35.n  
Integer32  
Integer32  
Integer32  
Integer32  
Integer32  
Integer32  
Integer32  
Counter64  
Integer32  
Counter64  
Integer32  
Integer32  
Integer32  
Integer32  
Integer32  
Integer32  
Integer32  
dbStatCommitFile  
dbStatConnCount  
dbStatCurrIO  
CommitFile  
ConnCount  
CurrIO  
dbStatCurrRead  
CurrRead  
dbStatCurrWrite  
CurrWrite  
dbStatDiskReadIndInt  
dbStatDiskReadIndLeaf  
dbStatDiskRead  
DiskReadIndInt  
DiskReadIndLeaf  
DiskRead  
dbStatDiskReadTable  
dbStatDiskWrite  
dbStatExtendDB  
dbStatExtendTempWrite  
dbStatFullCompare  
dbStatGetData  
DiskReadTable  
DiskWrite  
ExtendDB  
ExtendTempWrite  
FullCompare  
GetData  
dbStatIdleCheck  
IdleCheck  
dbStatIdleChkpt  
IdleChkpt  
dbStatIdleChkTime  
IdleChkTime  
32  
 
Chapter 2. Adaptive Server Anywhere MIB Reference  
OID  
Type  
Name  
Property  
1.3.6.1.4.1.897.2.2.1.36.n  
1.3.6.1.4.1.897.2.2.1.37.n  
1.3.6.1.4.1.897.2.2.1.38.n  
1.3.6.1.4.1.897.2.2.1.39.n  
1.3.6.1.4.1.897.2.2.1.40.n  
1.3.6.1.4.1.897.2.2.1.41.n  
1.3.6.1.4.1.897.2.2.1.42.n  
1.3.6.1.4.1.897.2.2.1.43.n  
1.3.6.1.4.1.897.2.2.1.44.n  
1.3.6.1.4.1.897.2.2.1.45.n  
1.3.6.1.4.1.897.2.2.1.46.n  
1.3.6.1.4.1.897.2.2.1.47.n  
1.3.6.1.4.1.897.2.2.1.48.n  
1.3.6.1.4.1.897.2.2.1.49.n  
1.3.6.1.4.1.897.2.2.1.50.n  
Integer32  
Integer32  
Integer32  
Integer32  
Integer32  
Integer32  
Integer32  
Integer32  
Integer32  
Counter64  
Integer32  
Integer32  
Integer32  
Integer32  
Integer32  
dbStatIdleWrite  
IdleWrite  
dbStatIndAdd  
IndAdd  
dbStatIndLookup  
dbStatIOToRecover  
dbStatJavaHeapSize  
dbStatJavaNSSize  
dbStatLockTablePages  
dbStatMapPages  
dbStatMaxIO  
IndLookup  
IOToRecover  
JavaHeapSize  
JavaNSSize  
LockTablePages  
MapPages  
MaxIO  
dbStatMaxRead  
MaxRead  
dbStatMaxWrite  
dbStatPageRelocations  
dbStatProcedurePages  
dbStatQueryCachePages  
MaxWrite  
PageRelocations  
ProcedurePages  
QueryCachePages  
dbStatQueryLowMemoryStrat-  
egy  
QueryLowMemoryStrat-  
egy  
1.3.6.1.4.1.897.2.2.1.51.n  
1.3.6.1.4.1.897.2.2.1.52.n  
1.3.6.1.4.1.897.2.2.1.53.n  
1.3.6.1.4.1.897.2.2.1.54.n  
1.3.6.1.4.1.897.2.2.1.55.n  
1.3.6.1.4.1.897.2.2.1.56.n  
1.3.6.1.4.1.897.2.2.1.57.n  
1.3.6.1.4.1.897.2.2.1.58.n  
1.3.6.1.4.1.897.2.2.1.59.n  
Counter64  
Integer32  
Integer32  
Integer32  
Integer32  
Integer32  
Integer32  
Integer32  
Integer32  
dbStatQueryRowsMaterialized  
dbStatRecoveryUrgency  
dbStatLogFreeCommit  
dbStatLogWrite  
QueryRowsMaterialized  
RecoveryUrgency  
LogFreeCommit  
LogWrite  
dbStatRelocatableHeapPages  
dbStatRollbackLogPages  
dbStatTempTablePages  
dbStatTriggerPages  
RelocatableHeapPages  
RollbackLogPages  
TempTablePages  
TriggerPages  
dbStatViewPages  
ViewPages  
Database properties  
The following table lists the OIDs and names of the database properties that  
33  
 
 
can be retrieved using the Adaptive Server Anywhere SNMP Extension  
Agent.  
Writable properties are marked with an asterisk (*). The value n is the  
database number in the asasnmp.ini file.  
OID  
Type  
Name  
Property  
1.3.6.1.4.1.897.2.2.2.1.n  
1.3.6.1.4.1.897.2.2.2.2.n  
1.3.6.1.4.1.897.2.2.2.3.n  
1.3.6.1.4.1.897.2.2.2.4.n  
1.3.6.1.4.1.897.2.2.2.5.n  
1.3.6.1.4.1.897.2.2.2.6.n  
1.3.6.1.4.1.897.2.2.2.7.n  
1.3.6.1.4.1.897.2.2.2.8.n  
1.3.6.1.4.1.897.2.2.2.9.n  
1.3.6.1.4.1.897.2.2.2.10.n  
1.3.6.1.4.1.897.2.2.2.11.n  
1.3.6.1.4.1.897.2.2.2.12.n  
1.3.6.1.4.1.897.2.2.2.13.n  
1.3.6.1.4.1.897.2.2.2.14.n  
1.3.6.1.4.1.897.2.2.2.15.n  
1.3.6.1.4.1.897.2.2.2.16.n  
1.3.6.1.4.1.897.2.2.2.17.n  
1.3.6.1.4.1.897.2.2.2.18.n  
1.3.6.1.4.1.897.2.2.2.19.n  
1.3.6.1.4.1.897.2.2.2.20.n  
1.3.6.1.4.1.897.2.2.2.21.n  
1.3.6.1.4.1.897.2.2.2.22.n  
1.3.6.1.4.1.897.2.2.2.23.n  
1.3.6.1.4.1.897.2.2.2.24.n  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
dbPropAlias  
Alias  
dbPropAuditingTypes  
dbPropBlankPadding  
dbPropBlobArenas  
dbPropCapabilities  
dbPropCaseSensitive  
dbPropCaseSensitivePasswords  
dbPropCharSet  
AuditingTypes  
BlankPadding  
BlobArenas  
Capabilities  
CaseSensitive  
CaseSensitivePasswords  
CharSet  
dbPropChecksum  
Checksum  
dbPropClusteredIndexes  
dbPropCollation  
ClusteredIndexes  
Collation  
dbPropCompressedBTrees  
dbPropCompression  
dbPropCurrentRedoPos  
dbPropDBFileFragments  
dbPropDriveType  
CompressedBTrees  
Compression  
CurrentRedoPos  
DBFileFragments  
DriveType  
dbPropEncryption  
dbPropFile  
Encryption  
File  
dbPropFileSize  
FileSize  
dbPropFileVersion  
dbPropFreePageBitMaps  
dbPropFreePages  
FileVersion  
FreePageBitMaps  
FreePages  
dbPropGlobalDBId  
dbPropHistogramHashFix  
GlobalDBId  
HistogramHashFix  
34  
 
Chapter 2. Adaptive Server Anywhere MIB Reference  
OID  
Type  
Name  
Property  
1.3.6.1.4.1.897.2.2.2.25.n  
1.3.6.1.4.1.897.2.2.2.26.n  
1.3.6.1.4.1.897.2.2.2.27.n  
1.3.6.1.4.1.897.2.2.2.28.n  
1.3.6.1.4.1.897.2.2.2.29.n  
1.3.6.1.4.1.897.2.2.2.30.n  
1.3.6.1.4.1.897.2.2.2.31.n  
1.3.6.1.4.1.897.2.2.2.32.n  
1.3.6.1.4.1.897.2.2.2.33.n  
1.3.6.1.4.1.897.2.2.2.34.n  
1.3.6.1.4.1.897.2.2.2.35.n  
1.3.6.1.4.1.897.2.2.2.36.n  
1.3.6.1.4.1.897.2.2.2.37.n  
1.3.6.1.4.1.897.2.2.2.38.n  
1.3.6.1.4.1.897.2.2.2.39.n  
1.3.6.1.4.1.897.2.2.2.40.n  
1.3.6.1.4.1.897.2.2.2.41.n  
1.3.6.1.4.1.897.2.2.2.42.n  
1.3.6.1.4.1.897.2.2.2.43.n  
1.3.6.1.4.1.897.2.2.2.44.n  
1.3.6.1.4.1.897.2.2.2.45.n  
1.3.6.1.4.1.897.2.2.2.46.n  
1.3.6.1.4.1.897.2.2.2.47.n  
1.3.6.1.4.1.897.2.2.2.48.n  
1.3.6.1.4.1.897.2.2.2.49.n  
1.3.6.1.4.1.897.2.2.2.50.n  
1.3.6.1.4.1.897.2.2.2.51.n  
1.3.6.1.4.1.897.2.2.2.52.n  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
String  
dbPropHistograms  
Histograms  
dbPropIndexStatistics  
dbPropIQStore  
IndexStatistics  
IQStore  
dbPropJDKVersion  
JDKVersion  
dbPropLanguage  
Language  
dbPropLargeProcedureIDs  
dbPropLogFileFragments  
dbPropLogMirrorName  
dbPropLogName  
LargeProcedureIDs  
LogFileFragments  
LogMirrorName  
LogName  
dbPropLTMGeneration  
dbPropLTMTrunc  
LTMGeneration  
LTMTrunc  
dbPropMultiByteCharSet  
dbPropName  
MultiByteCharSet  
Name  
dbPropNamedConstraints  
dbPropPageSize  
NamedConstraints  
PageSize  
dbPropPreserveSource  
dbPropProcedureProfiling*  
dbPropReadOnly  
PreserveSource  
ProcedureProfiling  
ReadOnly  
dbPropRemoteTrunc  
dbPropSeparateCheckpointLog  
dbPropSeparateForeignKeys  
dbPropStringHistogramsFix  
dbPropSyncTrunc  
RemoteTrunc  
SeparateCheckpointLog  
SeparateForeignKeys  
StringHistogramsFix  
SyncTrunc  
dbPropTableBitMaps  
dbPropTablesQualTriggers  
dbPropTempFileName  
dbPropTransactionsSpanLogs  
dbPropVariableHashSize  
TableBitMaps  
TablesQualTriggers  
TempFileName  
TransactionsSpanLogs  
VariableHashSize  
35  
 
OID  
Type  
Name  
Property  
1.3.6.1.4.1.897.2.2.2.53.n  
String  
dbPropUniqueIdentifier  
UniqueIdentifier  
Database options  
The following table lists the OIDs and names of the database options that can  
be retrieved using the Adaptive Server Anywhere SNMP Extension Agent.  
Writable options are marked with an asterisk (*). The value n is the database  
number in the asasnmp.ini file.  
OID  
Type  
Name  
Option  
1.3.6.1.4.1.897.2.2.3.1.n  
1.3.6.1.4.1.897.2.2.3.2.n  
1.3.6.1.4.1.897.2.2.3.3.n  
1.3.6.1.4.1.897.2.2.3.4.n  
String  
String  
String  
String  
dbOptAllowNullsByDefault*  
dbOptAnsinull*  
dbOptAnsiBlanks*  
Allow_nulls_by_default  
Ansinull  
Ansi_blanks  
dbOptAnsiCloseCursorsOn-  
Rollback*  
Ansi_close_cursors_on_-  
rollback  
1.3.6.1.4.1.897.2.2.3.5.n  
1.3.6.1.4.1.897.2.2.3.6.n  
1.3.6.1.4.1.897.2.2.3.7.n  
String  
String  
String  
dbOptAnsiIntegerOverflow*  
dbOptAnsiPermissions*  
Ansi_integer_overflow  
Ansi_permissions  
dbOptAnsiUpdateCon-  
straints*  
Ansi_update_constraints  
1.3.6.1.4.1.897.2.2.3.8.n  
1.3.6.1.4.1.897.2.2.3.9.n  
1.3.6.1.4.1.897.2.2.3.10.n  
1.3.6.1.4.1.897.2.2.3.11.n  
1.3.6.1.4.1.897.2.2.3.12.n  
1.3.6.1.4.1.897.2.2.3.13.n  
1.3.6.1.4.1.897.2.2.3.14.n  
1.3.6.1.4.1.897.2.2.3.15.n  
1.3.6.1.4.1.897.2.2.3.16.n  
1.3.6.1.4.1.897.2.2.3.17.n  
1.3.6.1.4.1.897.2.2.3.18.n  
String  
dbOptAuditing*  
Auditing  
String  
dbOptAuditingOptions*  
dbOptAutomaticTimestamp*  
dbOptBackgroundPriority*  
dbOptBlocking*  
Auditing_options  
Automatic_timestamp  
Background_priority  
Blocking  
String  
String  
String  
Integer32  
String  
dbOptBlockingTimeout*  
dbOptChained*  
Blocking_timeout  
Chained  
Integer32  
Integer32  
Integer32  
String  
dbOptCheckpointTime*  
dbOptCisOption*  
Checkpoint_time  
Cis_option  
dbOptCisRowsetSize*  
dbOptCloseOnEndtrans*  
Cis_rowset_size  
Close_on_endtrans  
36  
 
 
Chapter 2. Adaptive Server Anywhere MIB Reference  
OID  
Type  
Name  
Option  
1.3.6.1.4.1.897.2.2.3.19.n  
String  
dbOptConnectionAuthentica-  
tion*  
Connection_authentication  
1.3.6.1.4.1.897.2.2.3.20.n  
String  
dbOptContinueAfterRaiseer-  
ror*  
Continue_after_raise_error  
1.3.6.1.4.1.897.2.2.3.21.n  
1.3.6.1.4.1.897.2.2.3.22.n  
1.3.6.1.4.1.897.2.2.3.23.n  
String  
dbOptConversionError*  
Conversion_error  
String  
dbOptCooperativeCommits*  
Cooperative_commits  
Integer32  
dbOptCooperativeCommit-  
Timeout*  
Cooperative_commit_-  
timeout  
1.3.6.1.4.1.897.2.2.3.24.n  
String  
dbOptDatabaseAuthentica-  
tion*  
Database_authentication  
1.3.6.1.4.1.897.2.2.3.25.n  
1.3.6.1.4.1.897.2.2.3.26.n  
1.3.6.1.4.1.897.2.2.3.27.n  
1.3.6.1.4.1.897.2.2.3.28.n  
1.3.6.1.4.1.897.2.2.3.29.n  
String  
dbOptDateFormat*  
dbOptDateOrder*  
Date_format  
String  
Date_order  
String  
dbOptDebugMessages*  
dbOptDedicatedTask*  
Debug_messages  
Dedicated_task  
String  
Integer32  
dbOptDefaultTimestampIn-  
crement*  
Default_timestamp_-  
increment  
1.3.6.1.4.1.897.2.2.3.30.n  
String  
dbOptDelayedCommits*  
Delayed_commits  
1.3.6.1.4.1.897.2.2.3.31.n  
Integer32  
dbOptDelayedCommitTime-  
out*  
Delayed_commit_timeout  
1.3.6.1.4.1.897.2.2.3.32.n  
1.3.6.1.4.1.897.2.2.3.33.n  
1.3.6.1.4.1.897.2.2.3.34.n  
1.3.6.1.4.1.897.2.2.3.35.n  
1.3.6.1.4.1.897.2.2.3.36.n  
1.3.6.1.4.1.897.2.2.3.37.n  
1.3.6.1.4.1.897.2.2.3.38.n  
1.3.6.1.4.1.897.2.2.3.39.n  
1.3.6.1.4.1.897.2.2.3.40.n  
1.3.6.1.4.1.897.2.2.3.41.n  
1.3.6.1.4.1.897.2.2.3.42.n  
String  
dbOptDivideByZeroError*  
dbOptEscapeCharacter*  
dbOptExcludeOperators*  
dbOptExtendedJoinSyntax*  
dbOptFireTriggers*  
Divide_by_zero_error  
Escape_character  
Exclude_operators  
Extended_join_syntax  
Fire_triggers  
String  
String  
String  
String  
Integer32  
String  
dbOptFirstDayOfWeek*  
dbOptFloatAsDouble*  
First_day_of_week  
Float_as_double  
String  
dbOptForceViewCreation*  
dbOptForXmlNullTreatment*  
dbOptGlobalDatabaseId*  
dbOptIsolationLevel*  
Force_view_creation  
For_xml_null_treatment  
Global_database_id  
Isolation_level  
String  
Integer32  
Integer32  
37  
 
OID  
Type  
Name  
Option  
1.3.6.1.4.1.897.2.2.3.43.n  
1.3.6.1.4.1.897.2.2.3.44.n  
1.3.6.1.4.1.897.2.2.3.45.n  
1.3.6.1.4.1.897.2.2.3.46.n  
1.3.6.1.4.1.897.2.2.3.47.n  
1.3.6.1.4.1.897.2.2.3.48.n  
1.3.6.1.4.1.897.2.2.3.49.n  
1.3.6.1.4.1.897.2.2.3.50.n  
1.3.6.1.4.1.897.2.2.3.51.n  
1.3.6.1.4.1.897.2.2.3.52.n  
1.3.6.1.4.1.897.2.2.3.53.n  
1.3.6.1.4.1.897.2.2.3.54.n  
1.3.6.1.4.1.897.2.2.3.55.n  
Integer32  
String  
dbOptJavaHeapSize*  
dbOptJavaInputOutput*  
dbOptJavaNamespaceSize*  
dbOptJavaPageBufferSize*  
dbOptLockRejectedRows*  
dbOptLoginMode*  
Java_heap_size  
Java_input_output  
Java_namespace_size  
Java_page_buffer_size  
Lock_rejected_rows  
Login_mode  
Integer32  
Integer32  
String  
String  
String  
dbOptLoginProcedure*  
dbOptLogDetailedPlans*  
dbOptLogMaxRequests*  
dbOptMaxCursorCount*  
dbOptMaxHashSize*  
dbOptMaxPlansCached*  
Login_procedure  
Log_detailed_plans  
Log_max_requests  
Max_cursor_count  
Max_hash_size  
String  
Integer32  
Integer32  
Integer32  
Integer32  
Integer32  
Max_plans_cached  
Max_recursive_iterations  
dbOptMaxRecursiveItera-  
tions*  
1.3.6.1.4.1.897.2.2.3.56.n  
Integer32  
Integer32  
dbOptMaxStatementCount*  
Max_statement_count  
1.3.6.1.4.1.897.2.2.3.57.n  
dbOptMaxWorkTableHash-  
Size*  
Max_work_table_hash_size  
1.3.6.1.4.1.897.2.2.3.58.n  
1.3.6.1.4.1.897.2.2.3.59.n  
1.3.6.1.4.1.897.2.2.3.60.n  
1.3.6.1.4.1.897.2.2.3.61.n  
1.3.6.1.4.1.897.2.2.3.62.n  
Integer32  
Integer32  
Integer32  
String  
dbOptMinPasswordLength*  
dbOptInternal  
Min_password_length  
Internal  
dbOptNearestCentury*  
dbOptNonKeywords*  
Nearest_century  
Non_keywords  
String  
dbOptODBCDistinguishCha-  
rAndVarchar*  
ODBC_distinguish_char_-  
and_varchar  
1.3.6.1.4.1.897.2.2.3.63.n  
String  
dbOptOnCharsetConversion-  
Failure*  
On_charset_conversion_-  
failure  
1.3.6.1.4.1.897.2.2.3.64.n  
String  
String  
dbOptOnTsqlError*  
On_tsql_error  
1.3.6.1.4.1.897.2.2.3.65.n  
dbOptOptimisticWaitFor-  
Commit*  
Optimistic_wait_for_commit  
1.3.6.1.4.1.897.2.2.3.66.n  
String  
dbOptOptimizationGoal*  
Optimization_goal  
38  
 
Chapter 2. Adaptive Server Anywhere MIB Reference  
OID  
Type  
Name  
Option  
1.3.6.1.4.1.897.2.2.3.67.n  
1.3.6.1.4.1.897.2.2.3.68.n  
1.3.6.1.4.1.897.2.2.3.69.n  
1.3.6.1.4.1.897.2.2.3.70.n  
Integer32  
String  
dbOptOptimizationLevel*  
dbOptOptimizationLogging*  
Optimization_level  
Optimization_logging  
String  
dbOptOptimizationWorkload* Optimization_workload  
Integer32  
dbOptPinnedCursorPer-  
centOfCache*  
Pinned_cursor_percent_of_-  
cache  
1.3.6.1.4.1.897.2.2.3.71.n  
1.3.6.1.4.1.897.2.2.3.72.n  
1.3.6.1.4.1.897.2.2.3.73.n  
1.3.6.1.4.1.897.2.2.3.74.n  
Integer32  
String  
dbOptPrecision*  
Precision  
dbOptPrefetch*  
Prefetch  
String  
dbOptPreserveSourceFormat*  
Preserve_source_format  
Prevent_article_pkey_update  
String  
dbOptPreventArticlePkeyUp-  
date*  
1.3.6.1.4.1.897.2.2.3.75.n  
1.3.6.1.4.1.897.2.2.3.76.n  
1.3.6.1.4.1.897.2.2.3.77.n  
1.3.6.1.4.1.897.2.2.3.78.n  
1.3.6.1.4.1.897.2.2.3.79.n  
1.3.6.1.4.1.897.2.2.3.80.n  
String  
String  
String  
Integer32  
String  
String  
dbOptQueryPlanOnOpen*  
dbOptQuotedIdentifier*  
dbOptReadPastDeleted*  
dbOptRecoveryTime*  
dbOptReplicateAll*  
Query_plan_on_open  
Quoted_identifier  
Read_past_deleted  
Recovery_time  
Replicate_all  
dbOptReturnDateTime-  
AsString*  
Return_date_time_as_string  
1.3.6.1.4.1.897.2.2.3.81.n  
1.3.6.1.4.1.897.2.2.3.82.n  
1.3.6.1.4.1.897.2.2.3.83.n  
1.3.6.1.4.1.897.2.2.3.84.n  
1.3.6.1.4.1.897.2.2.3.85.n  
1.3.6.1.4.1.897.2.2.3.86.n  
String  
String  
String  
Integer32  
String  
String  
dbOptReturnJavaAsString*  
dbOptRITriggerTime*  
dbOptRowCounts*  
dbOptScale*  
Return_java_as_string  
RI_trigger_time  
Row_counts  
Scale  
dbOptSortCollation*  
Sort_collation  
dbOptSQLFlaggerError-  
Level*  
SQL_flagger_error_level  
1.3.6.1.4.1.897.2.2.3.87.n  
String  
dbOptSQLFlaggerWarn-  
ingLevel*  
SQL_flagger_warning_level  
1.3.6.1.4.1.897.2.2.3.88.n  
1.3.6.1.4.1.897.2.2.3.89.n  
1.3.6.1.4.1.897.2.2.3.90.n  
String  
String  
String  
dbOptStringRtruncation*  
dbOptSubsumeRowLocks*  
String_rtruncation  
Subsume_row_locks  
Suppress_TDS_debugging  
dbOptSuppressTDSDebug-  
ging*  
39  
 
OID  
Type  
Name  
Option  
1.3.6.1.4.1.897.2.2.3.91.n  
String  
dbOptTDSEmptyStringIs-  
Null*  
TDS_empty_string_is_null  
1.3.6.1.4.1.897.2.2.3.92.n  
1.3.6.1.4.1.897.2.2.3.93.n  
1.3.6.1.4.1.897.2.2.3.94.n  
1.3.6.1.4.1.897.2.2.3.95.n  
1.3.6.1.4.1.897.2.2.3.96.n  
1.3.6.1.4.1.897.2.2.3.97.n  
1.3.6.1.4.1.897.2.2.3.98.n  
1.3.6.1.4.1.897.2.2.3.99.n  
Integer32  
Integer32  
Integer32  
String  
dbOptThreadCount*  
Thread_count  
dbOptThreadStack*  
Thread_stack  
dbOptThreadSwaps*  
Thread_swaps  
dbOptTimestampFormat*  
dbOptTimeFormat*  
Timestamp_format  
Time_format  
String  
Integer32  
String  
dbOptTimeZoneAdjustment*  
dbOptTruncateDateValues*  
Time_zone_adjustment  
Truncate_date_values  
String  
dbOptTruncateTimestampVal- Truncate_timestamp_values  
ues*  
1.3.6.1.4.1.897.2.2.3.100.n  
String  
dbOptTruncateWithAutocom-  
mit*  
Truncate_with_auto_commit  
1.3.6.1.4.1.897.2.2.3.101.n  
1.3.6.1.4.1.897.2.2.3.102.n  
1.3.6.1.4.1.897.2.2.3.103.n  
1.3.6.1.4.1.897.2.2.3.104.n  
String  
String  
String  
String  
dbOptTsqlHexConstant*  
dbOptTsqlVariables*  
dbOptUpdateStatistics*  
Tsql_hex_constant  
Tsql_variables  
Update_statistics  
dbOptUpgradeDatabaseCapa-  
bility*  
Upgrade_database_-  
capability  
1.3.6.1.4.1.897.2.2.3.105.n  
1.3.6.1.4.1.897.2.2.3.106.n  
1.3.6.1.4.1.897.2.2.3.107.n  
String  
String  
String  
dbOptUserEstimates*  
dbOptWaitForCommit*  
User_estimates  
Wait_for_commit  
dbOptTempSpaceLim-  
itCheck*  
Temp_space_limit_check  
1.3.6.1.4.1.897.2.2.3.108.n  
1.3.6.1.4.1.897.2.2.3.109.n  
1.3.6.1.4.1.897.2.2.3.110.n  
Integer32  
Integer32  
String  
dbOptRemoteIdleTimeout*  
dbOptInternal  
Remote_idle_timeout  
Internal  
dbOptODBCDescribeBina-  
ryAsVarbinary*  
ODBC_describe_binary_-  
as_varbinary  
1.3.6.1.4.1.897.2.2.3.111.n  
1.3.6.1.4.1.897.2.2.3.112.n  
1.3.6.1.4.1.897.2.2.3.113.n  
String  
String  
String  
dbOptRollbackOnDeadlock  
dbOptIntegratedServerName*  
dbOptLogDeadlocks*  
Rollback_on_deadlock  
Integrated_server_name  
Log_deadlocks  
40  
 
CHAPTER 3  
RDBMS MIB Reference  
About this chapter  
Contents  
This chapter contains descriptions of each of the tables in the RDBMS MIB.  
Topic:  
page  
41  
 
 
The RDBMS MIB  
The following sections list the OIDs of the values that can be retrieved using  
the Adaptive Server Anywhere SNMP Extension Agent. By default, the  
RDBMS MIB is located in C:\Program Files\Sybase\SQL Anywhere  
9\snmp\RDBMS-MIB.mib.  
rdbmsDbTable  
This table lists information about the databases installed on a system.  
The value db is the database number in the asasnmp.ini file.  
OID  
Type  
Name  
Value returned  
1.3.6.1.2.1.39.1.1.1.1.db  
1.3.6.1.2.1.39.1.1.1.2.db  
1.3.6.1.2.1.39.1.1.1.3.db  
1.3.6.1.2.1.39.1.1.1.4.db  
1.3.6.1.2.1.39.1.1.1.5.db  
Integer  
OID  
rdbmsDbIndex  
db  
rdbmsDbPrivateMibOID  
rdbmsDbVendorName  
rdbmsDbName  
rdbmsDbContact  
1.3.6.1.4.1.897.2  
property(‘CompanyName’)  
db_property(‘name’)  
property(‘LicensedUser’)  
String  
String  
String  
rdbmsDbInfoTable  
This table provides additional information about the databases on the system.  
The value db is the database number in the asasnmp.ini file.  
OID  
Type  
Name  
Value returned  
1.3.6.1.2.1.39.1.2.1.1.db  
String  
rdbmsDbInfoProduct-  
Name  
property(‘PropertyName’)  
1.3.6.1.2.1.39.1.2.1.2.db  
String  
rdbmsDbInfoVersion  
property(‘ProductVersion’)  
42  
 
 
Chapter 3. RDBMS MIB Reference  
OID  
Type  
Name  
Value returned  
1.3.6.1.2.1.39.1.2.1.3.db  
Integer  
rdbmsDbInfoSizeUnits  
Calculated based on dbInfoSizeAllo-  
cated and dbInfoSizeUsed.  
1=bytes  
2=KB  
3=MB  
4=GB  
5=TB  
(Each unit is 1024 times the previ-  
ous.)  
1.3.6.1.2.1.39.1.2.1.4.db  
Integer  
Integer  
rdbmsDbInfoSizeAllo-  
cated  
db_property(‘pagesize’) * db_-  
property(‘filesize’)  
1.3.6.1.2.1.39.1.2.1.5.db  
rdbmsDbInfoSizeUsed  
db_property(‘pagesize’) * (db_-  
property(‘filesize’) - db_-  
property(‘freepages’) )  
1.3.6.1.2.1.39.1.2.1.6.db  
String  
rdbmsDbInfoLast-  
Backup  
NULL1  
1 This OID is not currently supported by the Adaptive Server Anywhere  
SNMP Extension Agent.  
rdbmsDbParamTable  
This table lists the configuration parameters for the databases on the system.  
The value db is the database number in the asasnmp.ini file, while n is the  
index of the option in the asa.2.3 subtree.  
OID  
Type  
Name  
Value returned  
Option name  
n
1.3.6.1.2.1.39.1.3.1.1.db  
1.3.6.1.2.1.39.1.3.1.2.db  
1.3.6.1.2.1.39.1.3.1.3.db  
String  
Integer  
OID  
rdbmsDbParamName  
rdbmsDbParamSubIndex  
rdbmsDbParamID  
OID in Adaptive Server  
Anywhere MIB correspond-  
ing to this option  
1.3.6.1.2.1.39.1.3.1.4.db  
String  
String  
rdbmsDbParamCurrValue  
rdbmsDbParamComment  
Option value  
NULL1  
1.3.6.1.2.1.39.1.3.1.5.db  
43  
 
1
This OID is not currently supported by the Adaptive Server Anywhere  
SNMP Extenstion Agent.  
rdbmsDbLimitedResourceTable  
This table lists free space information on each dbspace. In this table, n  
represents each dbspace as follows:  
1-13 are for normal dbspaces (numbered 0-12 in the database)  
14 is the transaction log file  
15 is the transaction log mirror file  
16 is the temporary file  
17 is the write file  
The value db is the database number in the asasnmp.ini file.  
OID  
Type  
Name  
Value returned  
1.3.6.1.2.1.39.1.4.1.1.n.db  
String  
rdbmsDbLimitedResource-  
Name  
Name of dbspace, or Trans-  
action Log, Transaction Log  
Mirror, Temporary File, or  
Write File.  
1.3.6.1.2.1.39.1.4.1.2.n.db  
OID  
rdbmsDbLimitedResourceID  
1.3.6.1.4.1.897.2  
1.3.6.1.2.1.39.1.4.1.3.n.db  
Integer  
rdbmsDbLimitedResource-  
Limit  
Free space available on disk +  
current file size, in bytes  
1.3.6.1.2.1.39.1.4.1.4.n.db  
1.3.6.1.2.1.39.1.4.1.5.n.db  
1.3.6.1.2.1.39.1.4.1.6.n.db  
1.3.6.1.2.1.39.1.4.1.7n.db  
Integer  
Integer  
Integer  
String  
rdbmsDbLimitedResourceCur- Current file size  
rent  
rdbmsDbLimitedResource-  
Highwater  
Current size  
rdbmsDbLimitedResource-  
Failure  
01  
rdbmsDbLimite-  
”Bytes”  
dResourceDescription  
1
This OID is not currently supported by the Adaptive Server Anywhere  
SNMP Extenstion Agent.  
44  
 
 
Chapter 3. RDBMS MIB Reference  
rdbmsSrvTable  
This table lists the database servers running or installed on your system.  
The value db is the database number in the asasnmp.ini file.  
OID  
Type  
Name  
Value returned  
1.3.6.1.2.1.39.1.5.1.1.db  
1.3.6.1.2.1.39.1.5.1.2.db  
1.3.6.1.2.1.39.1.5.1.3.db  
1.3.6.1.2.1.39.1.5.1.4.db  
OID  
rdbmsSrvPrivateMibOID  
rdbmsSrvVendorName  
rdbmsSrvProductName  
rdbmsSrvContact  
1.3.6.1.4.1.897.2  
property(‘CompanyName’)  
property(‘ProductName’)  
property(‘LicencedCompany’)  
String  
String  
String  
rdbmsSrvInfoTable  
This table lists additional information about the database servers in your  
system.  
The value db is the database number in the asasnmp.ini file.  
OID  
Type  
Name  
Value returned  
1.3.6.1.2.1.39.1.6.1.1.db  
1.3.6.1.2.1.39.1.6.1.2.db  
1.3.6.1.2.1.39.1.6.1.3.db  
1.3.6.1.2.1.39.1.6.1.4.db  
1.3.6.1.2.1.39.1.6.1.5.db  
Integer  
Integer  
Integer  
Integer  
Integer  
rdbmsSrvInfoStartupTime  
rdbmsSrvInfoFinishedTransactions  
rdbmsSrvInfoDiskReads  
rdbmsSrvInfoLogicalReads  
rdbmsSrvInfoDiskWrites  
property(‘StartTime’)  
01  
property(‘DiskReadEng’)  
01  
prop-  
erty(‘DiskWriteEng’)  
1.3.6.1.2.1.39.1.6.1.6.db  
1.3.6.1.2.1.39.1.6.1.7.db  
1.3.6.1.2.1.39.1.6.1.8.db  
1.3.6.1.2.1.39.1.6.1.9.db  
1.3.6.1.2.1.39.1.6.1.10.db  
1.3.6.1.2.1.39.1.6.1.11.db  
Integer  
Integer  
Integer  
Integer  
Integer  
Integer  
rdbmsSrvInfoLogicalWrites  
rdbmsSrvInfoPageReads  
01  
01  
rdbmsSrvInfoPageDiskOutOfWrites  
rdbmsSrvInfoSpaces  
01  
01  
rdbmsSrvInfoHandledRequests  
rdbmsSrvInfoRequestRecvs  
property(‘Req’)  
prop-  
erty(‘PacketsReceivedUncomp’)  
1.3.6.1.2.1.39.1.6.1.12.db  
Integer  
rdbmsSrvInfoRequestSends  
prop-  
erty(‘PacketsSentUncomp’)  
45  
 
OID  
Type  
Name  
Value returned  
1.3.6.1.2.1.39.1.6.1.13.db  
Integer  
rdbmsSrvInfoHighwaterInboundAs-  
sociations  
01  
1.3.6.1.2.1.39.1.6.1.14.db  
Integer  
rdbmsSrvInfoMaxInboundAssocia-  
tions  
01  
1
This OID is not currently supported by the Adaptive Server Anywhere  
SNMP Extenstion Agent.  
rdbmsSrvParamTable  
This table lists the server options that can be set by the Adaptive Server  
Anywhere SNMP Extension Agent through the Adaptive Server Anywhere  
MIB. n is the index, as follows:  
n
1
2
3
4
5
6
Server option  
ConnsDisabled  
LivenessTimeout (default)  
QuittingTime  
RememberLastStatement  
RequestLogFile  
RequestLogging  
The value db is the database number in the asasnmp.ini file.  
OID  
Type  
Name  
Value returned  
Name of option n  
n
1.3.6.1.2.1.39.1.7.1.1.n.db  
1.3.6.1.2.1.39.1.7.1.2.n.db  
1.3.6.1.2.1.39.1.7.1.3.n.db  
1.3.6.1.2.1.39.1.7.1.4.n.db  
1.3.6.1.2.1.39.1.7.1.5.n.db  
String  
Integer  
OID  
rdbmsDbSrvParamName  
rdbmsDbSrvParamSubIndex  
rdbmsDbSrvParamID  
1.3.6.1.4.1.897.2  
String  
String  
rdbmsDbSrvParamCurrValue Current value of option n  
rdbmsDbSrvParamComment Full name of option n  
rdbmsSrvLimitedResourceTable  
This table contains information about server configuration parameters.  
46  
 
Chapter 3. RDBMS MIB Reference  
The value db is the database number in the asasnmp.ini file, while n is the  
index of the resource as follows:  
Name  
Resource  
Resource limit  
n
1
2
Connec-  
tions  
prop-  
property(‘LicenseCount’)  
property(‘NumProcessorsMax’)  
erty(‘LicensesInUse’)  
Processors  
prop-  
erty(‘NumProcessorsAvail’)  
If this is 0, then it returns prop-  
erty(‘NumProcessorsAvail’))  
OID  
Type  
Name  
Value returned  
1.3.6.1.2.1.39.1.8.1.1.db  
String  
rdbmsSrvLimitedResource-  
Name  
Name of resource n  
1.3.6.1.2.1.39.1.8.1.2.db  
1.3.6.1.2.1.39.1.8.1.3.db  
1.3.6.1.2.1.39.1.8.1.4.db  
1.3.6.1.2.1.39.1.8.1.5.db  
1.3.6.1.2.1.39.1.8.1.6.db  
1.3.6.1.2.1.39.1.8.1.7.db  
OID  
rdbmsSrvLimitedResour-  
ceID  
OID in Adaptive Server Anywhere  
MIB corresponding to this option  
Integer  
Integer  
Integer  
Integer  
String  
rdbmsSrvLimitedResource-  
Limit  
Upper limit of resource n  
Current value of resource n  
Current value of resource n  
01  
rdbmsSrvLimitedResource-  
Current  
rdbmsSrvLimitedResource-  
Highwater  
rdbmsSrvLimitedResource-  
Failures  
rdbmsSrvLimite-  
Name of resource n  
dResourceDescription  
1 This OID is not currently supported by the Adaptive Server Anywhere  
SNMP Extenstion Agent.  
47  
 
48  
 
Index  
A
ANSI_INTEGER_OVERFLOW option  
ASA SNMP Extension Agent OID  
ANSI_PERMISSIONS option  
ASA SNMP Extension Agent OID  
ANSI_UPDATE_CONSTRAINTS option  
ASA SNMP Extension Agent OID  
ANSINULL option  
ASA SNMP Extension Agent OID  
asaDbOptMetaDataTable  
Adaptive Server Anywhere MIB  
asaDbPropMetaDataTable  
Adaptive Server Anywhere MIB  
asaDbStatMetaDataTable  
Adaptive Server Anywhere MIB  
asasnmp.ini file  
required for ASA SNMP Extension Agent  
asaSrvPropMetaDataTable  
Adaptive Server Anywhere MIB  
asaSrvStatMetaDataTable  
Adaptive Server Anywhere MIB  
AUDITING option  
ASA SNMP Extension Agent OID  
AUDITING_OPTIONS option  
ASA SNMP Extension Agent OID  
AuditingTypes property  
ASA SNMP Extension Agent OID  
AUTOMATIC_TIMESTAMP option  
ASA SNMP Extension Agent OID  
AvailIO property  
36  
36  
36  
36  
27  
26  
26  
12  
25  
24  
36  
36  
34  
36  
27  
ActiveReq property  
ASA SNMP Extension Agent OID  
Adaptive Server Anywhere MIB  
about  
27  
7
24  
27  
26  
26  
24  
25  
24  
36  
33  
31  
24  
29  
27  
23  
Agent table  
asaDbOptMetaDataTable  
asaDbPropMetaDataTable  
asaDbStatMetaDataTable  
asaMetaData tables  
asaSrvPropMetaDataTable  
asaSrvStatMetaDataTable  
database options  
database properties  
database statistics  
list of tables  
server properties  
server statistics  
Adaptive Server Anywhere MIB reference  
Adaptive Server Anywhere SNMP Extension Agent  
about  
asasnmp.ini file  
configuring  
dynamic traps  
executing functions  
executing stored procedures  
restarting  
3
12  
10  
19  
17  
17  
12  
6
supported MIBs  
supported platforms  
Agent table  
4
ASA SNMP Extension Agent OID  
Adaptive Server Anywhere MIB  
agents  
about  
24  
6
B
BACKGROUND_PRIORITY option  
ASA SNMP Extension Agent OID  
BlankPadding property  
ASA SNMP Extension Agent OID  
BlobArenas property  
ASA SNMP Extension Agent OID  
BLOCKING option  
ASA SNMP Extension Agent OID  
BLOCKING_TIMEOUT option  
ASA SNMP Extension Agent OID  
36  
34  
34  
36  
36  
Alias property  
ASA SNMP Extension Agent OID  
ALLOW_NULLS_BY_DEFAULT option  
ASA SNMP Extension Agent OID  
ANSI_BLANKS option  
ASA SNMP Extension Agent OID  
ANSI_CLOSE_CURSORS_ON_ROLLBACK  
option  
34  
36  
36  
ASA SNMP Extension Agent OID  
36  
49  
 
Index  
BytesReceived property  
ASA SNMP Extension Agent OID  
CheckpointLogPageInUse property  
ASA SNMP Extension Agent OID  
CheckpointLogPagesRelocated property  
ASA SNMP Extension Agent OID  
CheckpointLogPagesWritten property  
ASA SNMP Extension Agent OID  
CheckpointLogSavePreimage property  
ASA SNMP Extension Agent OID  
CheckpointLogSize property  
ASA SNMP Extension Agent OID  
CheckpointLogWrites property  
ASA SNMP Extension Agent OID  
CheckpointUrgency property  
ASA SNMP Extension Agent OID  
Checksum property  
ASA SNMP Extension Agent OID  
Chkpt property  
ASA SNMP Extension Agent OID  
ChkptFlush property  
ASA SNMP Extension Agent OID  
ChkptPage property  
ASA SNMP Extension Agent OID  
CIS_OPTION option  
ASA SNMP Extension Agent OID  
CIS_ROWSET_SIZE option  
ASA SNMP Extension Agent OID  
CLOSE_ON_ENDTRANS option  
ASA SNMP Extension Agent OID  
ClusteredIndexes property  
ASA SNMP Extension Agent OID  
Collation property  
ASA SNMP Extension Agent OID  
CommandLine property  
ASA SNMP Extension Agent OID  
CommitFile property  
ASA SNMP Extension Agent OID  
CompactPlatformVer property  
ASA SNMP Extension Agent OID  
CompanyName property  
ASA SNMP Extension Agent OID  
CompressedBTrees property  
ASA SNMP Extension Agent OID  
Compression property  
ASA SNMP Extension Agent OID  
ConnCount property  
31  
31  
31  
31  
31  
31  
31  
31  
34  
31  
31  
31  
36  
36  
36  
34  
34  
29  
31  
29  
29  
34  
34  
31  
ASA SNMP Extension Agent OID  
BytesReceivedUncomp property  
ASA SNMP Extension Agent OID  
BytesSent property  
ASA SNMP Extension Agent OID  
BytesSentUncomp property  
ASA SNMP Extension Agent OID  
27  
27  
27  
27  
C
C2 property  
ASA SNMP Extension Agent OID  
CacheHits property  
ASA SNMP Extension Agent OID  
CacheHitsEng property  
ASA SNMP Extension Agent OID  
CachePinned property  
ASA SNMP Extension Agent OID  
CacheRead property  
ASA SNMP Extension Agent OID  
CacheReadEng property  
ASA SNMP Extension Agent OID  
CacheReadIndInt property  
ASA SNMP Extension Agent OID  
CacheReadIndLeaf property  
ASA SNMP Extension Agent OID  
CacheReadTable property  
ASA SNMP Extension Agent OID  
CacheReplacements property  
ASA SNMP Extension Agent OID  
Capabilities property  
ASA SNMP Extension Agent OID  
CaseSensitive property  
ASA SNMP Extension Agent OID  
CaseSensitivePasswords property  
ASA SNMP Extension Agent OID  
CHAINED option  
ASA SNMP Extension Agent OID  
CharSet property  
ASA SNMP Extension Agent OID  
CHECKPOINT_TIME option  
ASA SNMP Extension Agent OID  
CheckpointLogBitmapPagesWritten property  
ASA SNMP Extension Agent OID  
CheckpointLogBitmapSize property  
ASA SNMP Extension Agent OID  
CheckpointLogCommitToDisk property  
29  
31  
27  
27  
31  
27  
31  
31  
31  
27  
34  
34  
34  
36  
29, 34  
36  
31  
31  
ASA SNMP Extension Agent OID  
50  
 
Index  
CONNECTION_AUTHENTICATION option  
ASA SNMP Extension Agent OID  
ConnsDisabled property  
ASA SNMP Extension Agent OID  
ConsoleLogFile property  
ASA SNMP Extension Agent OID  
CONTINUE_AFTER_RAISERROR option  
ASA SNMP Extension Agent OID  
conventions  
DATE_ORDER option  
ASA SNMP Extension Agent OID  
DBFileFragments property  
36  
29  
29  
36  
viii  
36  
36  
36  
27  
34  
31  
31  
31  
36  
34  
36  
36  
ASA SNMP Extension Agent OID  
DEBUG_MESSAGES option  
ASA SNMP Extension Agent OID  
DEDICATED_TASK option  
ASA SNMP Extension Agent OID  
DEFAULT_TIMESTAMP_INCREMENT option  
ASA SNMP Extension Agent OID  
DefaultCollation property  
ASA SNMP Extension Agent OID  
DELAYED_COMMIT_TIMEOUT option  
ASA SNMP Extension Agent OID  
DELAYED_COMMITS option  
ASA SNMP Extension Agent OID  
DiskRead property  
ASA SNMP Extension Agent OID  
DiskReadEng property  
ASA SNMP Extension Agent OID  
DiskReadIndInt property  
ASA SNMP Extension Agent OID  
DiskReadIndLeaf property  
ASA SNMP Extension Agent OID  
DiskReadTable property  
ASA SNMP Extension Agent OID  
DiskWrite property  
documentation  
36  
29  
36  
36  
31  
27  
31  
31  
31  
31  
36  
CONVERSION_ERROR option  
ASA SNMP Extension Agent OID  
COOPERATIVE_COMMIT_TIMEOUT option  
ASA SNMP Extension Agent OID  
COOPERATIVE_COMMITS option  
ASA SNMP Extension Agent OID  
CurrentCacheSize property  
ASA SNMP Extension Agent OID  
CurrentRedoPos property  
ASA SNMP Extension Agent OID  
CurrIO property  
ASA SNMP Extension Agent OID  
CurrRead property  
ASA SNMP Extension Agent OID  
CurrWrite property  
ASA SNMP Extension Agent OID  
D
ASA SNMP Extension Agent OID  
DIVIDE_BY_ZERO_ERROR option  
ASA SNMP Extension Agent OID  
documentation  
conventions  
SQL Anywhere Studio  
DriveType property  
ASA SNMP Extension Agent OID  
dynamic traps  
database options  
OIDs for ASA SNMP Extension Agent  
retrieving with the ASA SNMP Extension Agent  
15  
setting with the ASA SNMP Extension Agent 17  
database properties  
OIDs for ASA SNMP Extension Agent  
retrieving with the ASA SNMP Extension Agent  
15  
36  
viii  
vi  
34  
19  
33  
about  
setting with the ASA SNMP Extension Agent 17  
database statistics  
E
Adaptive Server Anywhere MIB  
OIDs for ASA SNMP Extension Agent  
retrieving with the ASA SNMP Extension Agent  
15  
DATABASE_AUTHENTICATION option  
ASA SNMP Extension Agent OID  
DATE_FORMAT option  
31  
31  
Encryption property  
ASA SNMP Extension Agent OID  
ESCAPE_CHARACTER option  
ASA SNMP Extension Agent OID  
EXCLUDE_OPERATORS option  
ASA SNMP Extension Agent OID  
ExtendDB property  
34  
36  
36  
31  
36  
36  
ASA SNMP Extension Agent OID  
ASA SNMP Extension Agent OID  
51  
 
Index  
EXTENDED_JOIN_SYNTAX option  
ASA SNMP Extension Agent OID  
ExtendTempWrite property  
H
36  
31  
HistogramHashFix property  
ASA SNMP Extension Agent OID  
Histograms property  
ASA SNMP Extension Agent OID  
HttpPorts property  
34  
34  
29  
29  
ASA SNMP Extension Agent OID  
F
feedback  
documentation  
providing  
ASA SNMP Extension Agent OID  
HttpsPorts property  
xii  
xii  
ASA SNMP Extension Agent OID  
File property  
ASA SNMP Extension Agent OID  
FileSize property  
ASA SNMP Extension Agent OID  
FileVersion property  
ASA SNMP Extension Agent OID  
FipsMode property  
34  
34  
34  
29  
36  
36  
36  
36  
36  
27  
34  
34  
31  
I
iAnywhere.mib file  
about  
location  
7
24  
icons  
used in manuals  
x
31  
31  
29  
31  
31  
34  
31  
36  
31  
34  
29  
29  
29  
29  
36  
ASA SNMP Extension Agent OID  
FIRE_TRIGGERS option  
ASA SNMP Extension Agent OID  
FIRST_DAY_OF_WEEK option  
ASA SNMP Extension Agent OID  
FLOAT_AS_DOUBLE option  
ASA SNMP Extension Agent OID  
FOR_XML_NULL_TREATMENT option  
ASA SNMP Extension Agent OID  
FORCE_VIEW_CREATION option  
ASA SNMP Extension Agent OID  
FreeBuffers property  
ASA SNMP Extension Agent OID  
FreePageBitmaps property  
ASA SNMP Extension Agent OID  
FreePages property  
ASA SNMP Extension Agent OID  
FullCompare property  
IdleCheck property  
ASA SNMP Extension Agent OID  
IdleChkpt property  
ASA SNMP Extension Agent OID  
IdleTimeout property  
ASA SNMP Extension Agent OID  
IdleWrite property  
ASA SNMP Extension Agent OID  
IndAdd property  
ASA SNMP Extension Agent OID  
IndexStatistics property  
ASA SNMP Extension Agent OID  
IndLookup property  
ASA SNMP Extension Agent OID  
INTEGRATED_SERVER_NAME option  
ASA SNMP Extension Agent OID  
IOToRecover property  
ASA SNMP Extension Agent OID  
IQStore property  
ASA SNMP Extension Agent OID  
IsFipsAvailable property  
ASA SNMP Extension Agent OID  
IsIQ property  
ASA SNMP Extension Agent OID  
functions  
executing using ASA SNMP Extension Agent 17  
G
GetData property  
ASA SNMP Extension Agent OID  
IsJavaAvailable property  
ASA SNMP Extension Agent OID  
IsNetworkServer property  
ASA SNMP Extension Agent OID  
ISOLATION_LEVEL option  
ASA SNMP Extension Agent OID  
ASA SNMP Extension Agent OID  
GLOBAL_DATABASE_ID option  
ASA SNMP Extension Agent OID  
GlobalDBId property  
31  
36  
34  
ASA SNMP Extension Agent OID  
52  
 
Index  
IsRuntimeServer property  
ASA SNMP Extension Agent OID  
ASA SNMP Extension Agent OID  
LockTablePages property  
27  
31  
36  
36  
36  
34  
31  
36  
36  
34  
34  
31  
34  
34  
29  
ASA SNMP Extension Agent OID  
LOG_DEADLOCKS option  
ASA SNMP Extension Agent OID  
LOG_DETAILED_PLANS option  
ASA SNMP Extension Agent OID  
LOG_MAX_REQUESTS option  
ASA SNMP Extension Agent OID  
LogFileFragments property  
ASA SNMP Extension Agent OID  
LogFreeCommit property  
ASA SNMP Extension Agent OID  
LOGIN_MODE option  
ASA SNMP Extension Agent OID  
LOGIN_PROCEDURE option  
ASA SNMP Extension Agent OID  
LogMirrorName property  
ASA SNMP Extension Agent OID  
LogName property  
ASA SNMP Extension Agent OID  
LogWrite property  
ASA SNMP Extension Agent OID  
LTMGeneration property  
J
JAVA_HEAP_SIZE option  
ASA SNMP Extension Agent OID  
JAVA_INPUT_OUTPUT option  
ASA SNMP Extension Agent OID  
JAVA_NAMESPACE_SIZE option  
ASA SNMP Extension Agent OID  
JAVA_PAGE_BUFFER_SIZE option  
ASA SNMP Extension Agent OID  
JavaGlobFix property  
ASA SNMP Extension Agent OID  
JavaHeapSize property  
ASA SNMP Extension Agent OID  
JavaNSSize property  
36  
36  
36  
36  
27  
31  
31  
29  
34  
ASA SNMP Extension Agent OID  
JavaObjectsEnabled property  
ASA SNMP Extension Agent OID  
JDKVersion property  
ASA SNMP Extension Agent OID  
L
ASA SNMP Extension Agent OID  
LTMTrunc property  
ASA SNMP Extension Agent OID  
Language property  
ASA SNMP Extension Agent OID  
LargeProcedureIDs property  
ASA SNMP Extension Agent OID  
LegalCopyright property  
ASA SNMP Extension Agent OID  
LegalTrademarks property  
ASA SNMP Extension Agent OID  
LicenseCount property  
ASA SNMP Extension Agent OID  
LicensedCompany property  
ASA SNMP Extension Agent OID  
LicensedUser property  
ASA SNMP Extension Agent OID  
LicensesInUse property  
ASA SNMP Extension Agent OID  
LicenseType property  
ASA SNMP Extension Agent OID  
LivenessTimeout property  
ASA SNMP Extension Agent OID  
LOCK_REJECTED_ROWS option  
ASA SNMP Extension Agent OID  
LockedHeapPages property  
29, 34  
34  
M
MachineName property  
29  
ASA SNMP Extension Agent OID  
MainHeapBytes property  
ASA SNMP Extension Agent OID  
MainHeapPages property  
ASA SNMP Extension Agent OID  
management information bases  
about  
managers  
about  
MapPages property  
ASA SNMP Extension Agent OID  
MapPhysicalMemoryEng property  
ASA SNMP Extension Agent OID  
MAX_CURSOR_COUNT option  
ASA SNMP Extension Agent OID  
MAX_HASH_SIZE option  
ASA SNMP Extension Agent OID  
29  
27  
27  
6
29  
29  
29  
29  
6
27  
31  
27  
36  
36  
29  
29  
36  
53  
 
Index  
MAX_PLANS_CACHED option  
ASA SNMP Extension Agent OID  
MAX_RECURSIVE_ITERATIONS option  
ASA SNMP Extension Agent OID  
MAX_STATEMENT_COUNT option  
ASA SNMP Extension Agent OID  
MAX_WORK_TABLE_HASH_SIZE option  
ASA SNMP Extension Agent OID  
MaxCacheSize property  
ASA SNMP Extension Agent OID  
MaxIO property  
ASA SNMP Extension Agent OID  
MaxMessage property  
ASA SNMP Extension Agent OID  
MaxRead property  
ASA SNMP Extension Agent OID  
MaxWrite property  
ASA SNMP Extension Agent OID  
MessageWindowSize property  
ASA SNMP Extension Agent OID  
metadata tables  
NON_KEYWORDS option  
36  
36  
36  
36  
27  
31  
29  
31  
31  
29  
24  
ASA SNMP Extension Agent OID  
NumProcessorsAvail property  
ASA SNMP Extension Agent OID  
NumProcessorsMax property  
ASA SNMP Extension Agent OID  
36  
29  
29  
O
object identifiers  
ODBC_DESCRIBE_BINARY_AS_VARBINARY  
option  
ASA SNMP Extension Agent OID  
ODBC_DISTINGUISH_CHAR_AND_VARCHAR  
option  
ASA SNMP Extension Agent OID  
OIDs see also object identifiers  
about  
Adaptive Server Anywhere MIB  
database options  
database properties  
database statistics  
defined  
RDBMS MIB  
server properties  
server statistics  
OmniIdentifier property  
ASA SNMP Extension Agent OID  
see OIDs  
36  
36  
6
23  
36  
33  
31  
6
42  
29  
27  
Adaptive Server Anywhere MIB  
MIBs  
defined  
see also management information bases  
6
6
supported by ASA SNMP Extension Agent  
MIN_PASSWORD_LENGTH option  
ASA SNMP Extension Agent OID  
MinCacheSize property  
ASA SNMP Extension Agent OID  
MultiByteCharSet property  
ASA SNMP Extension Agent OID  
MultiPacketsReceived property  
ASA SNMP Extension Agent OID  
MultiPacketsSent property  
36  
27  
34  
27  
27  
29  
ON_CHARSET_CONVERSION_FAILURE option  
ASA SNMP Extension Agent OID  
ON_TSQL_ERROR option  
36  
36  
36  
36  
36  
36  
36  
ASA SNMP Extension Agent OID  
OPTIMISTIC_WAIT_FOR_COMMIT option  
ASA SNMP Extension Agent OID  
OPTIMIZATION_GOAL option  
ASA SNMP Extension Agent OID  
OPTIMIZATION_LEVEL option  
ASA SNMP Extension Agent OID  
OPTIMIZATION_LOGGING option  
ASA SNMP Extension Agent OID  
OPTIMIZATION_WORKLOAD option  
ASA SNMP Extension Agent OID  
options  
ASA SNMP Extension Agent OID  
N
Name property  
ASA SNMP Extension Agent OID  
NamedConstraints property  
ASA SNMP Extension Agent OID  
NativeProcessorArchitecture property  
ASA SNMP Extension Agent OID  
NEAREST_CENTURY option  
ASA SNMP Extension Agent OID  
newsgroups  
29, 34  
34  
database options in Adaptive Server Anywhere  
MIB  
29  
36  
36  
P
technical support  
xii  
PacketsReceived property  
54  
 
Index  
ASA SNMP Extension Agent OID  
PacketsReceivedUncomp property  
ASA SNMP Extension Agent OID  
PacketsSent property  
27  
27  
ASA SNMP Extension Agent OID  
ProfileFilterUser property  
ASA SNMP Extension Agent OID  
properties  
29  
29  
ASA SNMP Extension Agent OID  
PacketsSentUncomp property  
ASA SNMP Extension Agent OID  
PageRelocations property  
27  
database properties in Adaptive Server Anywhere  
MIB  
33  
27  
server property OIDs in Adaptive Server  
Anywhere MIB  
29  
ASA SNMP Extension Agent OID  
PageSize property  
31  
Q
ASA SNMP Extension Agent OID  
PeakCacheSize property  
ASA SNMP Extension Agent OID  
PINNED_CURSOR_PERCENT_OF_CACHE  
option  
ASA SNMP Extension Agent OID  
Platform property  
ASA SNMP Extension Agent OID  
PlatformVer property  
ASA SNMP Extension Agent OID  
PRECISION option  
ASA SNMP Extension Agent OID  
PREFETCH option  
ASA SNMP Extension Agent OID  
PRESERVE_SOURCE_FORMAT option  
ASA SNMP Extension Agent OID  
PreserveSource property  
29, 34  
27  
QUERY_PLAN_ON_OPEN option  
ASA SNMP Extension Agent OID  
QueryCachePages property  
ASA SNMP Extension Agent OID  
QueryLowMemoryStrategy property  
ASA SNMP Extension Agent OID  
QueryRowsMaterialized property  
ASA SNMP Extension Agent OID  
QuittingTime property  
36  
31  
31  
31  
29  
36  
36  
29  
29  
36  
36  
36  
34  
ASA SNMP Extension Agent OID  
QUOTED_IDENTIFIER option  
ASA SNMP Extension Agent OID  
R
RDBMS MIB  
about  
list of tables  
rdbmsDbInfoTable  
description  
rdbmsDbLimitedResourceTable  
description  
rdbmsDbParamTable  
description  
rdbmsDbTable  
description  
RDBMS-MIB.mib file  
about  
location  
rdbmsSrvInfoTable  
description  
rdbmsSrvLimitedResourceTable  
description  
rdbmsSrvParamTable  
description  
rdbmsSrvTable  
description  
READ_PAST_DELETED option  
9
42  
ASA SNMP Extension Agent OID  
PREVENT_ARTICLE_PKEY_UPDATE option  
ASA SNMP Extension Agent OID  
ProcedurePages property  
ASA SNMP Extension Agent OID  
ProcedureProfiling property  
ASA SNMP Extension Agent OID  
ProcessCPU property  
ASA SNMP Extension Agent OID  
ProcessCPUSystem property  
ASA SNMP Extension Agent OID  
ProcessCPUUser property  
ASA SNMP Extension Agent OID  
ProcessorArchitecture property  
ASA SNMP Extension Agent OID  
ProductName property  
ASA SNMP Extension Agent OID  
ProductVersion property  
42  
44  
43  
42  
36  
31  
34  
29  
29  
29  
29  
29  
29  
9
42  
45  
47  
46  
45  
ASA SNMP Extension Agent OID  
ProfileFilterConn property  
55  
 
Index  
ASA SNMP Extension Agent OID  
ReadOnly property  
ASA SNMP Extension Agent OID  
RECOVERY_TIME option  
ASA SNMP Extension Agent OID  
RecoveryUrgency property  
ASA SNMP Extension Agent OID  
RelocatableHeapPages property  
ASA SNMP Extension Agent OID  
RememberLastStatement property  
ASA SNMP Extension Agent OID  
REMOTE_IDLE_TIMEOUT option  
ASA SNMP Extension Agent OID  
RemoteputWait property  
ASA SNMP Extension Agent OID  
RemoteTrunc property  
ASA SNMP Extension Agent OID  
REPLICATE_ALL option  
ASA SNMP Extension Agent OID  
Req property  
ASA SNMP Extension Agent OID  
RequestFilterConn property  
ASA SNMP Extension Agent OID  
RequestFilterDB property  
ASA SNMP Extension Agent OID  
RequestLogFile property  
36  
34  
36  
31  
31  
29  
36  
27  
34  
36  
27  
29  
29  
29  
29  
29  
29  
36  
36  
36  
36  
31  
36  
S
SCALE option  
ASA SNMP Extension Agent OID  
SendFail property  
ASA SNMP Extension Agent OID  
SeparateCheckpointLog property  
ASA SNMP Extension Agent OID  
SeparateForeignKeys property  
ASA SNMP Extension Agent OID  
server properties  
36  
27  
34  
34  
29  
OIDs for ASA SNMP Extension Agent  
retrieving with the ASA SNMP Extension Agent  
15  
setting with the ASA SNMP Extension Agent 17  
server statistics  
OIDs for ASA SNMP Extension Agent  
27  
retrieving with the ASA SNMP Extension Agent  
15  
simple network management protocol  
SNMP  
see SNMP  
about  
agents  
dynamic traps  
installing  
managers  
traps  
6
6
19  
10  
6
6
3
18  
ASA SNMP Extension Agent OID  
RequestLogging property  
using the ASA SNMP Extension Agent  
using traps  
ASA SNMP Extension Agent OID  
RequestLogMaxSize property  
ASA SNMP Extension Agent OID  
RequestLogNumFiles property  
ASA SNMP Extension Agent OID  
RETURN_DATE_TIME_AS_STRING option  
ASA SNMP Extension Agent OID  
RETURN_JAVA_AS_STRING option  
ASA SNMP Extension Agent OID  
RI_TRIGGER_TIME option  
ASA SNMP Extension Agent OID  
ROLLBACK_ON_DEADLOCK option  
ASA SNMP Extension Agent OID  
RollbackLogPages property  
ASA SNMP Extension Agent OID  
ROW_COUNTS option  
SNMP service  
restarting  
11  
36  
vi  
SORT_COLLATION option  
ASA SNMP Extension Agent OID  
SQL Anywhere Studio  
documentation  
SQL_FLAGGER_ERROR_LEVEL option  
ASA SNMP Extension Agent OID  
SQL_FLAGGER_WARNING_LEVEL option  
ASA SNMP Extension Agent OID  
StartTime property  
36  
36  
29  
ASA SNMP Extension Agent OID  
statistics  
database statistics in Adaptive Server Anywhere  
MIB  
31  
server statistics OIDs for ASA SNMP Extension  
ASA SNMP Extension Agent OID  
Agent  
27  
stored procedures  
executing using ASA SNMP Extension Agent 17  
56  
 
Index  
STRING_RTRUNCATION option  
ASA SNMP Extension Agent OID  
StringHistrogramsFix property  
ASA SNMP Extension Agent OID  
SUBSUME_ROW_LOCKS option  
ASA SNMP Extension Agent OID  
support  
newsgroups  
supported platforms  
ASA SNMP Extension Agent  
SUPPRESS_TDS_DEBUGGING option  
ASA SNMP Extension Agent OID  
SyncTrunc property  
ASA SNMP Extension Agent OID  
TotalBuffers property  
ASA SNMP Extension Agent OID  
TransactionsSpanLogs property  
ASA SNMP Extension Agent OID  
traps  
about  
dynamic traps  
using with ASA SNMP Extension Agent  
TriggerPages property  
ASA SNMP Extension Agent OID  
TRUNCATE_DATE_VALUES option  
ASA SNMP Extension Agent OID  
TRUNCATE_TIMESTAMP_VALUES option  
ASA SNMP Extension Agent OID  
29  
27  
34  
36  
34  
36  
xii  
4
6, 18  
19  
18  
31  
36  
36  
36  
34  
ASA SNMP Extension Agent OID  
T
TRUNCATE_WITH_AUTO_COMMIT option  
ASA SNMP Extension Agent OID  
TSQL_HEX_CONSTANT option  
ASA SNMP Extension Agent OID  
TSQL_VARIABLES option  
36  
36  
36  
TableBitMaps property  
ASA SNMP Extension Agent OID  
TablesQualTriggers property  
ASA SNMP Extension Agent OID  
TDS_EMPTY_STRING_IS_NULL option  
ASA SNMP Extension Agent OID  
technical support  
34  
34  
36  
xii  
36  
29  
34  
31  
36  
36  
36  
29  
36  
36  
36  
ASA SNMP Extension Agent OID  
U
newsgroups  
UniqueIdentifier property  
ASA SNMP Extension Agent OID  
UnschReq property  
ASA SNMP Extension Agent OID  
UPDATE_STATISTICS option  
ASA SNMP Extension Agent OID  
UPGRADE_DATABASE_CAPABILITY option  
ASA SNMP Extension Agent OID  
USER_ESTIMATES option  
TEMP_SPACE_LIMIT_CHECK option  
ASA SNMP Extension Agent OID  
TempDir property  
ASA SNMP Extension Agent OID  
TempFileName property  
ASA SNMP Extension Agent OID  
TempTablePages property  
ASA SNMP Extension Agent OID  
THREAD_COUNT option  
ASA SNMP Extension Agent OID  
THREAD_STACK option  
ASA SNMP Extension Agent OID  
THREAD_SWAPS option  
ASA SNMP Extension Agent OID  
Threads property  
ASA SNMP Extension Agent OID  
TIME_FORMAT option  
34  
27  
36  
36  
36  
ASA SNMP Extension Agent OID  
V
VariableHashSize property  
ASA SNMP Extension Agent OID  
ViewPages property  
34  
31  
ASA SNMP Extension Agent OID  
W
ASA SNMP Extension Agent OID  
TIME_ZONE_ADJUSTMENT option  
ASA SNMP Extension Agent OID  
TIMESTAMP_FORMAT option  
ASA SNMP Extension Agent OID  
TimeZoneAdjustment property  
WAIT_FOR_COMMIT option  
ASA SNMP Extension Agent OID  
Windows 2000  
installing SNMP  
Windows 2003  
36  
10  
57  
 
Index  
installing SNMP  
Windows XP  
installing SNMP  
10  
10  
58  
 

SIIG Computer Hardware 04 0327A User Manual
Sony Camera Lens ALCF49S User Manual
Sony Car Stereo System CDXGT130 User Manual
Sony DVD Player DVPSR510H User Manual
Sony DVD VCR Combo DIGITAL8 User Manual
Sony Security Camera CCU M5AP User Manual
Sony Speaker SA WD100 User Manual
Sony Tablet Accessory BSC10 User Manual
Sterling Plumbing Outdoor Shower 600C Series User Manual
Sylvania DVD Player SDVD9001 BLACK User Manual