Sybase Network Card Adaptive Server Anywhere SNMP Extension Agent User Manual

Adaptive Server^®Anywhere

SNMP Extension Agent

User’s Guide

Part number: DC00192-01-0902-01

Last modiﬁed: December 2004

Download from Www.Somanuals.com. All Manuals Search And Download.

Contents

About This Manual

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

The Adaptive Server Anywhere SNMP Extension Agent

Introduction to the Adaptive Server Anywhere SNMP Exten-

sion Agent . . . . . . . . . . . . . . . . . . . . . . . . . .

Understanding SNMP . . . . . . . . . . . . . . . . . . . . . .

Using the Adaptive Server Anywhere SNMP Extension Agent 10

II Adaptive Server Anywhere SNMP Extension

Agent Reference

Adaptive Server Anywhere MIB Reference

The Adaptive Server Anywhere MIB . . . . . . . . . . . . . . 24

RDBMS MIB Reference

The RDBMS MIB . . . . . . . . . . . . . . . . . . . . . . . . . 42

Index

iii

Download from Www.Somanuals.com. All Manuals Search And Download.

About This Manual

Subject

This book covers material related to running and conﬁguring 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.

Download from Www.Somanuals.com. All Manuals Search And Download.

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 ﬁle; as separate

PDF ﬁles 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 conﬁguring

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 conﬁgure 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.

Download from Www.Somanuals.com. All Manuals Search And Download.

♦ 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-certiﬁed 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 ﬁle 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

Download from Www.Somanuals.com. All Manuals Search And Download.

♦ 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

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

http://eshop.sybase.com/eshop/documentation.

viii

Download from Www.Somanuals.com. All Manuals Search And Download.

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 identiﬁers

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-deﬁnition [ column-constraint, . . . ]

One or more list elements are allowed. In this example, if more than one

is speciﬁed, 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.

Download from Www.Somanuals.com. All Manuals Search And Download.

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

Download from Www.Somanuals.com. All Manuals Search And Download.

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 ﬁle 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 ﬁnances) as

well as product information and sales information (sales orders, customers,

and contacts). All information in the database is ﬁctional.

The following ﬁgure shows the tables in the sample database and how they

relate to each other.

asademo.db

sales_order_items

product

Employee

integer <pk,fk>

smallint <pk>

name

description

size

color

integer

char(15)

char(30)

char(18)

char(6)

integer

<pk>

emp_id

integer

char(20)

integer

char(40)

char(20)

char(4)

char(9)

char(10)

char(1)

char(11)

numeric(20,3)

date

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

date

<fk>

id = prod_id

quantity

unit_price

numeric (15,2)

emp_id = sales_rep

id = id

sales_order

customer

cust_id

order_date date

fin_code_id char(2) <fk>

region

sales_rep

integer <pk>

integer <fk>

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

integer

char(15)

char(2)

char(30)

char(20)

char(2)

char(5)

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

Download from Www.Somanuals.com. All Manuals Search And Download.

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:

♦ sybase.public.sqlanywhere.general

♦ sybase.public.sqlanywhere.linux

♦ sybase.public.sqlanywhere.mobilink

♦ sybase.public.sqlanywhere.product_futures_discussion

♦ sybase.public.sqlanywhere.replication

♦ sybase.public.sqlanywhere.ultralite

♦ sybase.public.sqlanywhere.qanywhere

Newsgroup disclaimer

iAnywhere Solutions has no obligation to provide solutions, information

or ideas on its newsgroups, nor is iAnywhere Solutions obliged to provide

anything other than a systems operator to monitor the service and insure its

operation and availability.

iAnywhere Solutions Technical Advisors as well as other staff assist on the

newsgroup service when they have time available. They offer their help

on a volunteer basis and may not be available on a regular basis to provide

solutions and information. Their ability to help is based on their workload.

You can e-mail comments and suggestions to the SQL Anywhere

documentation team at [email protected]. Although we do not

undertake to reply to e-mails at that address, you can be sure we will read

your suggestions with interest.

xii

Download from Www.Somanuals.com. All Manuals Search And Download.

PART I

USING THE ADAPTIVE

SERVER ANYWHERE

SNMP EXTENSION AGENT

This part describes how to set up and conﬁgure the Adaptive Server

Anywhere SNMP Extension Agent.

Download from Www.Somanuals.com. All Manuals Search And Download.

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

Introduction to the Adaptive Server Anywhere SNMP Extension

Agent

Understanding SNMP

Using the Adaptive Server Anywhere SNMP Extension Agent

Download from Www.Somanuals.com. All Manuals Search And Download.

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 ﬁles

The following ﬁles 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 ﬁle 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.

Download from Www.Somanuals.com. All Manuals Search And Download.

Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent

♦ asasnmp.ini This ﬁle lists the databases that the Adaptive Server

Anywhere SNMP Extension Agent monitors. By default, this ﬁle is

located in C:\Program Files\Sybase\SQL Anywhere 9\win32.

Download from Www.Somanuals.com. All Manuals Search And Download.

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

speciﬁc events occur using notiﬁcations 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 Identiﬁer (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 ﬁle 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 speciﬁcally 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

“The Adaptive Server Anywhere MIB” on page 7 .

♦ RDBMS MIB a generic, vendor-independent MIB for relational

databases. This MIB contains information about the database servers and

databases in your system.

☞ For more information about the RDBMS MIB, see “The RDBMS

MIB” on page 9.

Download from Www.Somanuals.com. All Manuals Search And Download.

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,

see “Adaptive Server Anywhere MIB Reference” on page 23.

☞ For information about setting values in the Adaptive Server Anywhere

MIB, see “Setting values using the Adaptive Server Anywhere SNMP

Extension Agent” on page 17 .

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.

Download from Www.Somanuals.com. All Manuals Search And Download.

OID

Name

Description

1.3.6.1.4.897.2.3.3.db

asaAgent.asaConnected

Returns whether the Adaptive

Server Anywhere Extension Agent

is connected to database db. Setting

this value to 0 causes the Adaptive

Server Anywhere Extension Agent

to shut down the database¹, while

setting this value to 1 causes the

Adaptive Server Anywhere Exten-

sion Agent to attempt to start the

database².

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.

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.

In order to be able to start a database by setting this variable, the DBF

parameter must be speciﬁed in the connection string (along with DBN if

desired and DBKEY if required), and either (a) the UtilDbPwd ﬁeld must be

set in the asasnmp.ini ﬁle, or (b) the start database permission on the server

(speciﬁed with the -gd server option) must be set to all.

Download from Www.Somanuals.com. All Manuals Search And Download.

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 ﬁnd 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

page 24.

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,

see “RDBMS MIB Reference” on page 41.

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 ﬁxed 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.

Download from Www.Somanuals.com. All Manuals Search And Download.

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 ﬁle 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 ﬁrst 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.

Download from Www.Somanuals.com. All Manuals Search And Download.

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.

Download from Www.Somanuals.com. All Manuals Search And Download.

Conﬁguring 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 ﬁle

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

ﬁle in the C:\Program Files\Sybase\SQL Anywhere 9\win32 directory.

Once you edit this ﬁle, 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.

Download from Www.Somanuals.com. All Manuals Search And Download.

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 ﬁle with simple

encryption using the File Hiding utility (dbfhide).

☞ For more information, see “Hiding the contents of .ini ﬁles” [ASA

Database Administration Guide, page 524].

The ASAAgent section

The ASAAgent section of the asasnmp.ini ﬁle contains a TrapPollTime ﬁeld

with information about the Adaptive Server Anywhere Extension Agent. If

the TrapPollTime ﬁeld is not required, you can omit the entire section.

TrapPollTime This value speciﬁes the poll frequency for dynamic traps if

they are speciﬁed. The Adaptive Server Anywhere SNMP Extension Agent

polls the values every 5 seconds by default. Setting this value to 0 disables

dynamic traps. This ﬁeld is optional.

The DBn section

Each DBn section of the asasnmp.ini ﬁle describes a database, how to

connect to it, and any dynamic traps that exist for the database. The ﬁelds in

this section are case sensitive.

The value for n is a number that identiﬁes the database. The numbers must

start with 1, and numbers cannot be skipped. For example, if the asasnmp.ini

ﬁle contained entries for [DB1], [DB2], and [DB4], the [DB4] entry would

be ignored because the ﬁle 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 ﬁeld 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

Download from Www.Somanuals.com. All Manuals Search And Download.

• names the connection so it can be identiﬁed

• 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 ﬁle, the values in the asasnmp.ini ﬁle 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 ﬁnd the database ﬁle. 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 ﬁle) in the asasnmp.ini ﬁle, 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 ﬁeld 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 ﬁeld 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 ﬁeld 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 ﬁeld can be used to change the cache time

(or disable the cache by setting the value to 0). This ﬁeld is optional.

☞ For more information about the rdbmsDbLimitedResourceTable table,

see “rdbmsDbLimitedResourceTable” on page 44 .

Trapt Creates a dynamic trap. The value t must be a positive integer

Download from Www.Somanuals.com. All Manuals Search And Download.

Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent

starting at 1. Skipping numbers is not allowed. This ﬁeld 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 ﬁeld

is optional.

☞ For information about creating traps, see “Creating dynamic traps” on

page 19.

Sample asasnmp.ini ﬁle The following is a sample asasnmp.ini ﬁle 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 speciﬁed 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 speciﬁed for DB1, which ﬁres when the

number of bytes sent by the database server is greater than 50 000.

Obtaining values using the Adaptive Server Anywhere SNMP Extension

Agent

Using the Adaptive Server Anywhere SNMP Extension Agent, you can

retrieve the values of all the following:

♦ Database server properties

☞ For a list of the database server property OIDs, see “Server

properties” on page 29.

♦ Database server statistics

Download from Www.Somanuals.com. All Manuals Search And Download.

☞ For a list of the database server statistic OIDs, see “Server statistics”

on page 27 .

♦ Database options

☞ For a list of the database option OIDs, see “Database options” on

page 36 .

♦ Database properties

☞ For a list of the database property OIDs, see “Database properties”

on page 33 .

♦ Database statistics

☞ For a list of the database statistic OIDs, see “Database statistics” on

page 31 .

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

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

Download from Www.Somanuals.com. All Manuals Search And Download.

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

“The Adaptive Server Anywhere MIB” on page 24.

Executing stored procedures using the Adaptive Server Anywhere SNMP

Extension Agent

The Adaptive Server Anywhere MIB includes an OID that allows you to

execute a stored procedure using the Adaptive Server Anywhere SNMP

Extension Agent. In order to execute the stored procedure, the user that the

Adaptive Server Anywhere SNMP Extension Agent uses to connect must

have one of the following:

♦ execute permission on the procedure

♦ be the owner of the procedure

♦ have DBA authority

Any result sets or return values generated by the procedure are ignored.

To execute a stored procedure using the Adaptive Server Anywhere SNMP

Extension Agent, set the value of asaAgent.asaProc (OID

1.3.6.1.4.1.897.2.3.5.db, where db is the database number in the asasnmp.ini

ﬁle) 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.

Download from Www.Somanuals.com. All Manuals Search And Download.

For example, setting the value of asaAgent.asaProc to the string

“pchin.updatesales( ’param1’, 2)” calls the updatesales stored

procedure owned by user pchin.

The way you set the value of this OID to the procedure name will depend on

your SNMP management software.

☞ For more information, see “The Adaptive Server Anywhere MIB” on

page 7 .

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 conﬁgure 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 conﬁgure your

SNMP Service to send traps to your current machine.

❖ To conﬁgure 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 Conﬁguration dialog appears.

7. In the SNMP Service Conﬁguration dialog, type localhost in the text box

and then click Add.

8. Click OK to close the Service property sheet.

Download from Www.Somanuals.com. All Manuals Search And Download.

Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent

Adaptive Server

Anywhere SNMP

Extension Agent traps

The Adaptive Server Anywhere SNMP Extension Agent sends a trap

whenever a connection is dropped by the database server. The OID of this

trap is 1.3.6.1.2.1.39.2.1.

The only other traps sent by the Adaptive Server Anywhere agent are

dynamic traps.

☞ For more information about dynamic traps, see “Creating dynamic

traps” on page 19 .

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 ﬁle. The format of the trap information in the asasnmp.ini

ﬁle 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 preﬁx (1.3.6.1.4.1.897.2.) is prepended.

☞ For a list of OIDs in the Adaptive Server Anywhere MIB, see “Adaptive

Server Anywhere MIB Reference” on page 23 .

☞ For a list of OIDs in the RDBMS MIB, see “RDBMS MIB Reference”

on page 41 .

dbnum is the database number. This ﬁeld is optional, but if speciﬁed, it

must match the database number of the [DBn] section of the asasnmp.ini

ﬁle.

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)

Download from Www.Somanuals.com. All Manuals Search And Download.

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 ﬁelds as you wish in the asasnmp.ini ﬁle. 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 ﬁelds as you wish in the asasnmp.ini ﬁle. 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 ﬁrst dynamic trap sent by the Adaptive

Server Anywhere SNMP agent)

♦ the database index

♦ the database name trap index (from the asasnmp.ini ﬁle)

♦ 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 notiﬁed 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 ﬁle is

larger than 10 MB

Download from Www.Somanuals.com. All Manuals Search And Download.

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.

Download from Www.Somanuals.com. All Manuals Search And Download.

CHAPTER 2

Adaptive Server Anywhere MIB Reference

About this chapter

Contents

This chapter contains descriptions of the tables in the Adaptive Server

Anywhere MIB.

Topic:

page

The Adaptive Server Anywhere MIB

Download from Www.Somanuals.com. All Manuals Search And Download.

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 ﬁle.

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

String

1 if the agent is connected, 0 otherwise

1 if the database is started, 0 otherwise

” “

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 ﬁle.

Download from Www.Somanuals.com. All Manuals Search And Download.

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

OID

asaSrvStatIndex

asaSrvStatObjType

asaSrvStatType

asaSrvStatOID

1¹

1²

OID of Adaptive Server Any-

where MIB entry³

1.3.6.1.4.1.897.2.4.1.1.1.5.db

String

asaSrvStatName

Statistic name

¹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.

asaSrvMetaData.asaSrvPropMetaDataTable

This table contains metadata about the database server properties.

The value db is the database number in the asasnmp.ini ﬁle.

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

OID

asaSrvPropIndex

asaSrvPropObjType

asaSrvPropType

asaSrvPropOID

1¹

2²

OID of Adaptive

Server Anywhere MIB

entry³

1.3.6.1.4.1.897.2.4.1.2.1.5.db

String

asaSrvPropName

Property name

¹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.asaDbStatMetaDataTable

This table contains metadata about the database statistics.

Download from Www.Somanuals.com. All Manuals Search And Download.

The value db is the database number in the asasnmp.ini ﬁle.

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

OID

asaDbStatIndex

asaDbStatObjType

asaDbStatType

asaDbStatOID

2¹

1²

OID of Adaptive Server

Anywhere MIB entry³

1.3.6.1.4.1.897.2.4.2.1.1.5.db

String

asaDbStatName

Statistic name

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 ﬁle.

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

OID

asaDbPropIndex

asaDbPropObjType

asaDbPropType

asaDbPropOID

2¹

2²

OID of Adaptive Server

Anywhere MIB entry³

1.3.6.1.4.1.897.2.4.2.2.1.5.db

String

asaDbPropName

Property name

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.

Download from Www.Somanuals.com. All Manuals Search And Download.

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 ﬁle.

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

OID

asaDbOptIndex

asaDbOptObjType

asaDbOptType

asaDbOptOID

2¹

3²

OID of Adaptive Server Any-

where MIB entry³

1.3.6.1.4.1.897.2.4.2.1.1.5.db

String

asaDbOptName

Option name

¹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.

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 ﬁle.

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

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

Integer32

srvStatBytesSent

BytesSent

srvStatBytesSentUncomp

srvStatCacheHitsEng

srvStatCachePinned

BytesSentUncomp

CacheHitsEng

CachePinned

Download from Www.Somanuals.com. All Manuals Search And Download.

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

Integer32

Counter64

Integer32

Counter64

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

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

Integer32

Counter64

Integer32

srvStatPacketsSent

srvStatPacketsSentUncomp

srvStatPeakCacheSize

srvStatRemoteputWait

srvStatReq

PacketsSent

PacketsSentUncomp

PeakCacheSize

RemoteputWait

Req

srvStatSendFail

SendFail

srvStatTotalBuffers

srvStatUnschReq

TotalBuffers

UnschReq

Download from Www.Somanuals.com. All Manuals Search And Download.

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 ﬁle.

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

srvPropC2

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

Download from Www.Somanuals.com. All Manuals Search And Download.

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

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

srvPropNumProcessorsAvail

srvPropNumProcessorsMax

srvPropOmniIdentiﬁer

srvPropPageSize

NumProcessorsAvail

NumProcessorsMax

OmniIdentiﬁer

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

srvPropRequestFilterConn

srvPropRequestFilterDB

srvPropRequestLogFile*

srvPropRequestLogging*

srvPropRequestLogMaxSize

srvPropStartTime

RequestFilterConn

RequestFilterDB

RequestLogFile

RequestLogging

RequestLogMaxSize

StartTime

srvPropTempDir

TempDir

Download from Www.Somanuals.com. All Manuals Search And Download.

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

srvPropThreads

Threads

srvPropTimeZoneAdjustment

srvPropHttpPorts

TimeZoneAdjustment

HttpPorts

srvPropHttpsPorts

HttpsPorts

srvPropProﬁleFilterConn

srvPropProﬁleFilterUser

srvPropRequestLogNumFiles

srvPropIsFipsAvailable

srvPropFipsMode

ProﬁleFilterConn

ProﬁleFilterUser

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 ﬁle.

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

Counter64

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

Download from Www.Somanuals.com. All Manuals Search And Download.

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

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

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

Counter64

Integer32

Counter64

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

Download from Www.Somanuals.com. All Manuals Search And Download.

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

Counter64

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

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

Download from Www.Somanuals.com. All Manuals Search And Download.

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 ﬁle.

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

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

Download from Www.Somanuals.com. All Manuals Search And Download.

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

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

dbPropProcedureProﬁling*

dbPropReadOnly

PreserveSource

ProcedureProﬁling

ReadOnly

dbPropRemoteTrunc

dbPropSeparateCheckpointLog

dbPropSeparateForeignKeys

dbPropStringHistogramsFix

dbPropSyncTrunc

RemoteTrunc

SeparateCheckpointLog

SeparateForeignKeys

StringHistogramsFix

SyncTrunc

dbPropTableBitMaps

dbPropTablesQualTriggers

dbPropTempFileName

dbPropTransactionsSpanLogs

dbPropVariableHashSize

TableBitMaps

TablesQualTriggers

TempFileName

TransactionsSpanLogs

VariableHashSize

Download from Www.Somanuals.com. All Manuals Search And Download.

OID

Type

Name

Property

1.3.6.1.4.1.897.2.2.2.53.n

String

dbPropUniqueIdentiﬁer

UniqueIdentiﬁer

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 ﬁle.

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

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

dbOptAnsiIntegerOverﬂow*

dbOptAnsiPermissions*

Ansi_integer_overﬂow

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

Integer32

String

dbOptBlockingTimeout*

dbOptChained*

Blocking_timeout

Chained

Integer32

String

dbOptCheckpointTime*

dbOptCisOption*

Checkpoint_time

Cis_option

dbOptCisRowsetSize*

dbOptCloseOnEndtrans*

Cis_rowset_size

Close_on_endtrans

Download from Www.Somanuals.com. All Manuals Search And Download.

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

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

Download from Www.Somanuals.com. All Manuals Search And Download.

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

String

dbOptLoginProcedure*

dbOptLogDetailedPlans*

dbOptLogMaxRequests*

dbOptMaxCursorCount*

dbOptMaxHashSize*

dbOptMaxPlansCached*

Login_procedure

Log_detailed_plans

Log_max_requests

Max_cursor_count

Max_hash_size

String

Integer32

Max_plans_cached

Max_recursive_iterations

dbOptMaxRecursiveItera-

tions*

1.3.6.1.4.1.897.2.2.3.56.n

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

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

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

Download from Www.Somanuals.com. All Manuals Search And Download.

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

Integer32

String

dbOptQueryPlanOnOpen*

dbOptQuotedIdentiﬁer*

dbOptReadPastDeleted*

dbOptRecoveryTime*

dbOptReplicateAll*

Query_plan_on_open

Quoted_identiﬁer

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

Integer32

String

dbOptReturnJavaAsString*

dbOptRITriggerTime*

dbOptRowCounts*

dbOptScale*

Return_java_as_string

RI_trigger_time

Row_counts

Scale

dbOptSortCollation*

Sort_collation

dbOptSQLFlaggerError-

Level*

SQL_ﬂagger_error_level

1.3.6.1.4.1.897.2.2.3.87.n

String

dbOptSQLFlaggerWarn-

ingLevel*

SQL_ﬂagger_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

dbOptStringRtruncation*

dbOptSubsumeRowLocks*

String_rtruncation

Subsume_row_locks

Suppress_TDS_debugging

dbOptSuppressTDSDebug-

ging*

Download from Www.Somanuals.com. All Manuals Search And Download.

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

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

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

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

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

dbOptRollbackOnDeadlock

dbOptIntegratedServerName*

dbOptLogDeadlocks*

Rollback_on_deadlock

Integrated_server_name

Log_deadlocks

Download from Www.Somanuals.com. All Manuals Search And Download.

CHAPTER 3

RDBMS MIB Reference

About this chapter

Contents

This chapter contains descriptions of each of the tables in the RDBMS MIB.

Topic:

page

The RDBMS MIB

Download from Www.Somanuals.com. All Manuals Search And Download.

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 ﬁle.

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

rdbmsDbPrivateMibOID

rdbmsDbVendorName

rdbmsDbName

rdbmsDbContact

1.3.6.1.4.1.897.2

property(‘CompanyName’)

db_property(‘name’)

property(‘LicensedUser’)

String

rdbmsDbInfoTable

This table provides additional information about the databases on the system.

The value db is the database number in the asasnmp.ini ﬁle.

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’)

Download from Www.Somanuals.com. All Manuals Search And Download.

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

rdbmsDbInfoSizeAllo-

cated

db_property(‘pagesize’) * db_-

property(‘ﬁlesize’)

1.3.6.1.2.1.39.1.2.1.5.db

rdbmsDbInfoSizeUsed

db_property(‘pagesize’) * (db_-

property(‘ﬁlesize’) - db_-

property(‘freepages’) )

1.3.6.1.2.1.39.1.2.1.6.db

String

rdbmsDbInfoLast-

Backup

NULL¹

¹This OID is not currently supported by the Adaptive Server Anywhere

SNMP Extension Agent.

rdbmsDbParamTable

This table lists the conﬁguration parameters for the databases on the system.

The value db is the database number in the asasnmp.ini ﬁle, while n is the

index of the option in the asa.2.3 subtree.

OID

Type

Name

Value returned

Option name

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

rdbmsDbParamCurrValue

rdbmsDbParamComment

Option value

NULL¹

1.3.6.1.2.1.39.1.3.1.5.db

Download from Www.Somanuals.com. All Manuals Search And Download.

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 ﬁle

♦ 15 is the transaction log mirror ﬁle

♦ 16 is the temporary ﬁle

♦ 17 is the write ﬁle

The value db is the database number in the asasnmp.ini ﬁle.

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 ﬁle 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

String

rdbmsDbLimitedResourceCur- Current ﬁle size

rent

rdbmsDbLimitedResource-

Highwater

Current size

rdbmsDbLimitedResource-

Failure

0¹

rdbmsDbLimite-

”Bytes”

dResourceDescription

This OID is not currently supported by the Adaptive Server Anywhere

SNMP Extenstion Agent.

Download from Www.Somanuals.com. All Manuals Search And Download.

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 ﬁle.

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

rdbmsSrvInfoTable

This table lists additional information about the database servers in your

system.

The value db is the database number in the asasnmp.ini ﬁle.

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

rdbmsSrvInfoStartupTime

rdbmsSrvInfoFinishedTransactions

rdbmsSrvInfoDiskReads

rdbmsSrvInfoLogicalReads

rdbmsSrvInfoDiskWrites

property(‘StartTime’)

0¹

property(‘DiskReadEng’)

0¹

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

rdbmsSrvInfoLogicalWrites

rdbmsSrvInfoPageReads

0¹

rdbmsSrvInfoPageDiskOutOfWrites

rdbmsSrvInfoSpaces

0¹

rdbmsSrvInfoHandledRequests

rdbmsSrvInfoRequestRecvs

property(‘Req’)

prop-

erty(‘PacketsReceivedUncomp’)

1.3.6.1.2.1.39.1.6.1.12.db

Integer

rdbmsSrvInfoRequestSends

prop-

erty(‘PacketsSentUncomp’)

Download from Www.Somanuals.com. All Manuals Search And Download.

OID

Type

Name

Value returned

1.3.6.1.2.1.39.1.6.1.13.db

Integer

rdbmsSrvInfoHighwaterInboundAs-

sociations

0¹

1.3.6.1.2.1.39.1.6.1.14.db

Integer

rdbmsSrvInfoMaxInboundAssocia-

tions

0¹

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:

Server option

ConnsDisabled

LivenessTimeout (default)

QuittingTime

RememberLastStatement

RequestLogFile

RequestLogging

The value db is the database number in the asasnmp.ini ﬁle.

OID

Type

Name

Value returned

Name of option 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

rdbmsDbSrvParamCurrValue Current value of option n

rdbmsDbSrvParamComment Full name of option n

rdbmsSrvLimitedResourceTable

This table contains information about server conﬁguration parameters.

Download from Www.Somanuals.com. All Manuals Search And Download.

Chapter 3. RDBMS MIB Reference

The value db is the database number in the asasnmp.ini ﬁle, while n is the

index of the resource as follows:

Name

Resource

Resource limit

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

String

rdbmsSrvLimitedResource-

Limit

Upper limit of resource n

Current value of resource n

0¹

rdbmsSrvLimitedResource-

Current

rdbmsSrvLimitedResource-

Highwater

rdbmsSrvLimitedResource-

Failures

rdbmsSrvLimite-

Name of resource n

dResourceDescription

¹This OID is not currently supported by the Adaptive Server Anywhere

SNMP Extenstion Agent.

Download from Www.Somanuals.com. All Manuals Search And Download.

Index

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 ﬁle

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

ActiveReq property

ASA SNMP Extension Agent OID

Adaptive Server Anywhere MIB

about

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 ﬁle

conﬁguring

dynamic traps

executing functions

executing stored procedures

restarting

supported MIBs

supported platforms

Agent table

ASA SNMP Extension Agent OID

Adaptive Server Anywhere MIB

agents

about

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

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

ASA SNMP Extension Agent OID

Download from Www.Somanuals.com. All Manuals Search And Download.

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

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

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

ASA SNMP Extension Agent OID

Download from Www.Somanuals.com. All Manuals Search And Download.

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

viii

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

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

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

setting with the ASA SNMP Extension Agent 17

database properties

OIDs for ASA SNMP Extension Agent

retrieving with the ASA SNMP Extension Agent

viii

about

setting with the ASA SNMP Extension Agent 17

database statistics

Adaptive Server Anywhere MIB

OIDs for ASA SNMP Extension Agent

retrieving with the ASA SNMP Extension Agent

DATABASE_AUTHENTICATION option

ASA SNMP Extension Agent OID

DATE_FORMAT option

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

ASA SNMP Extension Agent OID

Download from Www.Somanuals.com. All Manuals Search And Download.

Index

EXTENDED_JOIN_SYNTAX option

ASA SNMP Extension Agent OID

ExtendTempWrite property

HistogramHashFix property

ASA SNMP Extension Agent OID

Histograms property

ASA SNMP Extension Agent OID

HttpPorts property

ASA SNMP Extension Agent OID

feedback

documentation

providing

ASA SNMP Extension Agent OID

HttpsPorts property

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

iAnywhere.mib ﬁle

about

location

icons

used in manuals

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

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

GLOBAL_DATABASE_ID option

ASA SNMP Extension Agent OID

GlobalDBId property

ASA SNMP Extension Agent OID

Download from Www.Somanuals.com. All Manuals Search And Download.

Index

IsRuntimeServer property

ASA SNMP Extension Agent OID

LockTablePages property

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

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

ASA SNMP Extension Agent OID

JavaObjectsEnabled property

ASA SNMP Extension Agent OID

JDKVersion property

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

MachineName property

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

Download from Www.Somanuals.com. All Manuals Search And Download.

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

ASA SNMP Extension Agent OID

NumProcessorsAvail property

ASA SNMP Extension Agent OID

NumProcessorsMax property

ASA SNMP Extension Agent OID

object identiﬁers

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 identiﬁers

about

Adaptive Server Anywhere MIB

database options

database properties

database statistics

deﬁned

RDBMS MIB

server properties

server statistics

OmniIdentiﬁer property

ASA SNMP Extension Agent OID

see OIDs

Adaptive Server Anywhere MIB

MIBs

deﬁned