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
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.
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.
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
♦ Database server statistics
15
♦ Database options
♦ Database properties
♦ Database statistics
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.
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.
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.
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.
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
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
|