Sybase Adaptive Server Anywhere SNMP Extension Agent User Manual

Download

Adaptive Server®Anywhere

SNMP Extension Agent

User’s Guide

Part number: DC00192-01-0902-01

Last modiﬁed: December 2004

Copyright ©1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved. No part of this publication may be reproduced, transmitted, or translated in any form or by any means, electronic, mechanical, manual, optical, or

otherwise, without the prior written permission of iAnywhere Solutions, Inc. iAnywhere Solutions, Inc. is a subsidiary of Sybase, Inc. Sybase, SYBASE (logo), AccelaTrade, ADA Workbench, Adaptable Windowing Environment, Adaptive Component Architecture, Adaptive Server,

Adaptive Server Anywhere, Adaptive Server Enterprise, Adaptive Server Enterprise Monitor, Adaptive Server Enterprise Replication, Adaptive Server Everywhere, Adaptive Server IQ, Adaptive Warehouse, AnswerBase, Anywhere Studio, Application Manager, AppModeler, APT Workbench, APT-Build, APT-Edit, APT-Execute, APT-Library, APT-Translator, ASEP, AvantGo, AvantGo Application Alerts, AvantGo Mobile Delivery,AvantGo Mobile Document Viewer, AvantGo Mobile Inspection, AvantGo Mobile Marketing Channel, AvantGo Mobile Pharma, AvantGo Mobile Sales, AvantGo Pylon, AvantGo Pylon Application Server, AvantGoPylon Conduit, AvantGo Pylon PIM Server, AvantGo Pylon Pro, Backup Server,BayCam, Bit-Wise, BizTracker, Certiﬁed PowerBuilder Developer, Certiﬁed SYBASE Professional, Certiﬁed SYBASE Professional Logo, ClearConnect, Client Services, Client-Library, CodeBank, Column Design, ComponentPack, Connection Manager, Convoy/DM, Copernicus, CSP,Data Pipeline, Data Workbench, DataArchitect, Database Analyzer, DataExpress, DataServer,DataWindow, DB-Library, dbQueue, Developers Workbench, Direct Connect Anywhere, DirectConnect, Distribution Director, Dynamic Mobility Model, Dynamo, e-ADK, E-Anywhere, e-Biz Integrator, EC Gateway, ECMAP, ECRTP, eFulﬁllment Accelerator, Electronic Case Management, Embedded SQL, EMS, Enterprise Application Studio, Enterprise Client/Server, Enterprise Connect, Enterprise Data Studio, Enterprise Manager, Enterprise Portal (logo), Enterprise SQL Server Manager, Enterprise WorkArchitecture, Enterprise WorkDesigner, Enterprise WorkModeler, eProcurement Accelerator, eremote, Everything Works Better When Everything Works Together, EWA, E-Whatever,Financial Fusion, Financial Fusion (and design), Financial Fusion Server, Formula One, Fusion Powered e-Finance, Fusion Powered Financial Destinations, Fusion Powered STP, Gateway Manager, GeoPoint, GlobalFIX, iAnywhere, iAnywhere Solutions, ImpactNow, Industry WarehouseStudio, InfoMaker, Information Anywhere, Information Everywhere, InformationConnect, InstaHelp, Intelligent Self-Care, InternetBuilder, iremote, iScript, Jaguar CTS, jConnect for JDBC, KnowledgeBase, Logical Memory Manager, Mail Anywhere Studio, MainframeConnect, Maintenance Express, Manage Anywhere Studio, MAP, M-Business Channel, M-Business Network, M-Business Server, MDI Access Server, MDI Database Gateway,media.splash, Message Anywhere Server, MetaWorks, MethodSet, ML Query,MobiCATS, My AvantGo,My AvantGo Media Channel, My AvantGo Mobile Marketing, MySupport, Net-Gateway, Net-Library,New Era of Networks, Next Generation Learning, Next Generation Learning Studio, O DEVICE, OASiS, OASiS logo, ObjectConnect, ObjectCycle, OmniConnect, OmniSQL Access Module, OmniSQL Toolkit,Open Biz, Open Business Interchange, Open Client, Open Client/Server, Open Client/Server Interfaces, Open ClientConnect, Open Gateway, Open Server, Open ServerConnect, Open Solutions, Optima++, Orchestration Studio, Partnerships that Work, PB-Gen, PC APT Execute, PC DB-Net, PC Net Library, PhysicalArchitect, Pocket PowerBuilder, PocketBuilder, Power Through Knowledge, power.stop,Power++, PowerAMC, PowerBuilder, PowerBuilder Foundation Class Library, PowerDesigner, PowerDimensions, PowerDynamo, Powering the New Economy, PowerJ, PowerScript, PowerSite, PowerSocket, Powersoft, Powersoft Portfolio, Powersoft Professional, PowerStage, PowerStudio, PowerTips, PowerWare Desktop, PowerWare Enterprise, ProcessAnalyst, QAnywhere, Rapport, Relational Beans, RepConnector, Replication Agent, Replication Driver, Replication Server, Replication Server Manager, Replication Toolkit, Report Workbench, Report-Execute, Resource Manager, RW-DisplayLib, RW-Library, S.W.I.F.T.Message Format Libraries, SAFE, SAFE/PRO, SDF, Secure SQL Server,Secure SQL Toolset, Security Guardian, SKILS, smart.partners, smart.parts, smart.script, SQL Advantage, SQL Anywhere, SQL Anywhere Studio, SQL Code Checker, SQL Debug, SQL Edit, SQL Edit/TPU, SQL Everywhere, SQL Modeler, SQL Remote, SQL Server, SQL Server Manager, SQL Server SNMP SubAgent, SQL Server/CFT, SQL Server/DBM, SQL SMART, SQL Station, SQL Toolset, SQLJ, Stage III Engineering, Startup.Com, STEP, SupportNow, Sybase Central, Sybase Client/Server Interfaces, Sybase Development Framework, Sybase Financial Server, Sybase Gateways, Sybase Learning Connection, Sybase MPP,Sybase SQL Desktop, Sybase SQL Lifecycle, Sybase SQL Workgroup, Sybase Synergy Program, Sybase User Workbench, Sybase Virtual Server Architecture, SybaseWare, Syber Financial, SyberAssist, SybMD, SyBooks, System 10, System 11, System XI (logo), SystemTools, Tabular Data Stream, The Enterprise Client/Server Company, The Extensible Software Platform, The Future Is Wide Open, The Learning Connection, The Model For Client/Server Solutions, The Online Information Center, The Power of One, TotalFix, TradeForce, Transact-SQL, Translation Toolkit,Turning Imagination Into Reality, UltraLite, UltraLite.NET,UNIBOM, Unilib, Uninull, Unisep, Unistring, URK Runtime Kit for UniCode, Versacore, Viewer, VisualWriter, VQL, Warehouse Control Center, Warehouse Studio, WarehouseWORKS, WarehouseArchitect, Watcom,Watcom SQL, Watcom SQL Server, Web Deployment Kit, Web.PB,Web.SQL,WebSights, WebViewer, WorkGroup SQL Server, XA-Library, XA-Server, and XP Server are trademarks of Sybase, Inc. or its subsidiaries.

All other trademarks are property of their respective owners.

About This Manual v

SQL Anywhere Studio documentation . . . . . . . . . . . . . vi

Documentation conventions . . . . . . . . . . . . . . . . . . . ix

The Adaptive Server Anywhere sample database . . . . . . . xi

Finding out more and providing feedback . . . . . . . . . . . xii

I Using the Adaptive Server Anywhere SNMP Extension Agent 1

1 The Adaptive Server Anywhere SNMP Extension Agent 3

Introduction to the Adaptive Server Anywhere SNMP Exten-

sion Agent . . . . . . . . . . . . . . . . . . . . . . . . . . 4

Understanding SNMP . . . . . . . . . . . . . . . . . . . . . . 6

Using the Adaptive Server Anywhere SNMP Extension Agent 10

II Adaptive Server Anywhere SNMP Extension Agent Reference 21

2 Adaptive Server Anywhere MIB Reference 23

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

3 RDBMS MIB Reference 41

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

Index 49

iii

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.

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.

♦ 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

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

viii

♦ 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

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

owner

and

column-constraint

table-name

in the

These square brackets indicate that 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.

savepoint-name

is optional. The

Graphic icons The following icons are used in this documentation.

API

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

The Adaptive Server Anywhere sample database

fin_code

code char(2) <pk> type char(10) description char(50)

product

id integer  <pk> name char(15) description  char(30) size char(18) color char(6) quantity integer unit_price numeric (15,2)

asademo.db

contact

id integer <pk> last_name char(15) first_name char(15) title char(2) street char(30) city char(20) state char(2) zip char(5) phone char(10) fax char(10)

customer

id integer  <pk> fname char(15) lname char(20) address char(35) city char(20) state char(2) zip char(10) phone char(20) company_name char(35)

fin_data

year char(4) <pk> quarter char(2) <pk> code char(2) <pk,fk> amount numeric(9)

sales_order

id  integer <pk> cust_id integer <fk> order_date date fin_code_id char(2) <fk> region char(7) sales_rep integer <fk>

sales_order_items

id integer <pk,fk> line_id smallint <pk> prod_id integer <fk> quantity integer ship_date date

department

dept_id integer <pk> dept_name char(40) dept_head_id integer <fk>

Employee

emp_id integer  <pk> manager_id integer emp_fname char(20) emp_lname char(20) dept_id integer <fk> street char(40) city char(20) state char(4) zip_code char(9) phone char(10) status char(1) ss_number char(11) salary numeric(20,3) start_date date termination_date date birth_date date bene_health_ins char(1) bene_life_ins char(1) bene_day_care char(1) sex char(1)

id = prod_id

id = cust_id

id = id

emp_id = sales_rep

emp_id = dept_head_id

code = fin_code_id

dept_id = dept_id

code = code

Many of the examples throughout the documentation use the Adaptive Server Anywhere sample database.

The sample database is held in a ﬁle named 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

, and is located in

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

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.

forums.sybase.com

news server.

xii

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 iasdoc@ianywhere.com. Although we do not undertake to reply to e-mails at that address, you can be sure we will read your suggestions with interest.

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.

CHAPTER 1

The Adaptive Server Anywhere SNMP Extension Agent

About this chapter This chapter introduces you to the Adaptive Server Anywhere SNMP

Extension Agent.

Contents

Topic: page

Introduction to the Adaptive Server Anywhere SNMP Extension Agent

Understanding SNMP 6 Using the Adaptive Server Anywhere SNMP Extension Agent 10

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

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

C:\Program Files\Sybase\SQL Anywhere 9\win32

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

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.

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

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.

1.3.6.1.4.897.2.1.2.n.

1.3.6.1.4.897.2.2.1.n.

1.3.6.1.4.897.2.2.2.n.

1.3.6.1.4.897.2.2.3.n.

asaServer.asaSrvStat Returns the value of server statistic

on databasedb.

asaServer.asaSrvProp Returns the value of server property

on databasedb.

asaDb.asaDbStat Returns the value of database statis-

ticnon databasedb.

asaDb.asaDbProp Returns the value of database prop-

ertynon databasedb.

asaDb.asaDbOpt Returns the value of database option

on databasedb.

C:\Program

1.3.6.1.4.897.2.3.1 asaAgent.asaVersion Returns the version of the Adaptive Server Anywhere Extension Agent.

1.3.6.1.4.897.2.3.2.

asaAgent.asaDbConnStr Returns the connection string for

databasedb.

OID Name Description

1.3.6.1.4.897.2.3.3.

1.3.6.1.4.897.2.3.4.

1.3.6.1.4.897.2.3.5.

asaAgent.asaConnected Returns whether the Adaptive

Server Anywhere Extension Agent is connected to databasedb. Setting this value to 0 causes the Adaptive Server Anywhere Extension Agent to shut down the database1, while setting this value to 1 causes the Adaptive Server Anywhere Extension Agent to attempt to start the database2.

asaAgent.asaStarted Returns whether databasedbis run-

ning. Setting this value to 0 causes the Adaptive Server Anywhere Extension Agent to shut down the database, while setting this value to 1 attempts to start the database.

asaAgent.asaProc Setting this value to a string

name

causes the Adaptive Server Anywhere Extension Agent to executed the procedure the database.

Arguments can be supplied (for example, proc_name(‘string’, 4)); if no arguments are supplied, parentheses () are appended to the name. Getting the value returns "".

proc_-

proc_name

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.

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

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

Anywhere 9\snmp\RDBMS-MIB.mib

C:\Program Files\Sybase\SQL

read-only

access

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

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

♦ On Windows XP, from the Start menu choose Control Panel.

2. Double-click Add/Remove Programs.

The Add/Remove Programs dialog appears.

ﬁle that contains information about the databases that are

Panel.

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.

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.

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

asasnmp.ini

ﬁle

By default, your SQL Anywhere Studio installation places the ﬁle in the

C:\Program Files\Sybase\SQL Anywhere 9\win32

asasnmp.ini

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.

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

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 DB

connect to it, and any dynamic traps that exist for the database. The ﬁelds in this section are case sensitive.

The value fornis a number that identiﬁes the database. The numbers must start with 1, and numbers cannot be skipped. For example, if the ﬁ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.

section of the

asasnmp.ini

ﬁle describes a database, how to

ﬁle with simple

ﬁle contains a TrapPollTime ﬁeld

asasnmp.ini

♦ 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

• 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

must be a positive integer

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

☞ 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 Server property C2 on database 3 NO

1.3.6.1.4.1.897.2.2.1.4.1 Database statistic CacheRead on database 1

1.3.6.1.4.1.897.2.2.2.7.4 Database property CaseSensitivePasswords on database 4

1.3.6.1.4.1.897.2.2.3.5.2 Database option ANSI_INTEGER_OVERFLOW on database 2

1.3.6.1.4.1.897.2.3.1 Agent version 9.0.1(1841)

1.3.6.1.4.1.897.2.3.2.1 Connection string for database 1 UID=DBA;PWD=SQL;

11397

OFF

ENG=server1; DBN=sales; DBF=sales.db

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, wheredbis the database number in the ﬁ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.

asasnmp.ini

Using traps

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.

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.

Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent

Adaptive Server Anywhere SNMP Extension Agent traps

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

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

asasnmp.ini

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

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.

ﬁle. The

Trap examples

Trapinformation 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

PART II

ADAPTIVE SERVER

ANYWHERE SNMP

EXTENSION AGENT

REFERENCE

This section lists the OIDs supported by the Adaptive Server Anywhere

SNMP Extension Agent. It lists the contents of the tables in the Adaptive

Server Anywhere MIB and the RDBMS MIB.

CHAPTER 2

Adaptive Server Anywhere MIB Reference

About this chapter This chapter contains descriptions of the tables in the Adaptive Server

Anywhere MIB.

Contents

Topic: page

The Adaptive Server Anywhere MIB 24

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 valuenis the database number in the

OID Type Name Value returned

1.3.6.1.4.1.897.2.3.1 String asaVersion Agent version

asasnmp.ini

ﬁle.

1.3.6.1.4.1.897.2.3.2.

1.3.6.1.4.1.897.2.3.3.

1.3.6.1.4.1.897.2.3.4.

1.3.6.1.4.1.897.2.3.5.

1.3.6.1.4.1.897.2.3.6 String asaRestart* 0

n n n n

String asaDBConnStr Connection string Integer32 asaConnected* 1if the agent is connected, 0 otherwise Integer32 asaStarted* 1 if the database is started, 0 otherwise String asaProc* ” “

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 valuedbis the database number in the

asasnmp.ini

ﬁle.

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.

1.3.6.1.4.1.897.2.4.1.1.1.2.

1.3.6.1.4.1.897.2.4.1.1.1.3.

1.3.6.1.4.1.897.2.4.1.1.1.4.

db db db db

Integer32 asaSrvStatIndex Integer32 asaSrvStatObjType 1 Integer32 asaSrvStatType 1

OID asaSrvStatOID OID of Adaptive Server Any-

where MIB entry

1.3.6.1.4.1.897.2.4.1.1.1.5.

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 valuedbis the database number in the

OID Type Name Value returned

1.3.6.1.4.1.897.2.4.1.2.1.1.

1.3.6.1.4.1.897.2.4.1.2.1.2.

1.3.6.1.4.1.897.2.4.1.2.1.3.

db db db

Integer32 asaSrvPropIndex Integer32 asaSrvPropObjType 1 Integer32 asaSrvPropType 2

asasnmp.ini

ﬁle.

1.3.6.1.4.1.897.2.4.1.2.1.4.

1.3.6.1.4.1.897.2.4.1.2.1.5.

OID asaSrvPropOID OID of Adaptive

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.

Server Anywhere MIB

entry

The valuedbis the database number in the

OID Type Name Value returned

asasnmp.ini

ﬁle.

1.3.6.1.4.1.897.2.4.2.1.1.1.

1.3.6.1.4.1.897.2.4.2.1.1.2.

1.3.6.1.4.1.897.2.4.2.1.1.3.

1.3.6.1.4.1.897.2.4.2.1.1.4.

db db db db

Integer32 asaDbStatIndex Integer32 asaDbStatObjType 2 Integer32 asaDbStatType 1

OID asaDbStatOID OID of Adaptive Server

Anywhere MIB entry

1.3.6.1.4.1.897.2.4.2.1.1.5.

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 valuedbis the database number in the

OID Type Name Value returned

1.3.6.1.4.1.897.2.4.2.2.1.1.

1.3.6.1.4.1.897.2.4.2.2.1.2.

1.3.6.1.4.1.897.2.4.2.2.1.3.

db db db

Integer32 asaDbPropIndex Integer32 asaDbPropObjType 2 Integer32 asaDbPropType 2

asasnmp.ini

ﬁle.

1.3.6.1.4.1.897.2.4.2.2.1.4.

1.3.6.1.4.1.897.2.4.2.2.1.5.

OID asaDbPropOID OID of Adaptive Server

Anywhere MIB entry

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.

Chapter 2. Adaptive Server Anywhere MIB Reference

asaDbMetaData.asaDbOptMetaDataTable

This table contains metadata about the database options. The valuedbis the database number in the

OID Type Name Value returned

1.3.6.1.4.1.897.2.4.2.1.1.1.

1.3.6.1.4.1.897.2.4.2.1.1.2.

1.3.6.1.4.1.897.2.4.2.1.1.3.

1.3.6.1.4.1.897.2.4.2.1.1.4.

1.3.6.1.4.1.897.2.4.2.1.1.5.

Integer32 asaDbOptIndex

Integer32 asaDbOptObjType 2

Integer32 asaDbOptType 3

OID asaDbOptOID OID of Adaptive Server Any-

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

asasnmp.ini

where MIB entry

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 valuenis the database number in the

asasnmp.ini

ﬁle.

OID Type Name Statistic

1.3.6.1.4.1.897.2.1.1.1.

1.3.6.1.4.1.897.2.1.1.2.

1.3.6.1.4.1.897.2.1.1.3.

1.3.6.1.4.1.897.2.1.1.4.

1.3.6.1.4.1.897.2.1.1.5.

1.3.6.1.4.1.897.2.1.1.6.

1.3.6.1.4.1.897.2.1.1.7.

1.3.6.1.4.1.897.2.1.1.8.

Integer32 srvStatActiveReq ActiveReq

Integer32 srvStatAvailIO AvailIO

Counter64 srvStatBytesReceived BytesReceived

Counter64 srvStatBytesReceivedUn-

comp

Counter64 srvStatBytesSent BytesSent

Counter64 srvStatBytesSentUncomp BytesSentUncomp

Counter64 srvStatCacheHitsEng CacheHitsEng

Integer32 srvStatCachePinned CachePinned

BytesReceivedUncomp

OID Type Name Statistic

1.3.6.1.4.1.897.2.1.1.9.

1.3.6.1.4.1.897.2.1.1.10.

1.3.6.1.4.1.897.2.1.1.11.

1.3.6.1.4.1.897.2.1.1.12.

1.3.6.1.4.1.897.2.1.1.13.

1.3.6.1.4.1.897.2.1.1.14.

1.3.6.1.4.1.897.2.1.1.15.

1.3.6.1.4.1.897.2.1.1.16.

1.3.6.1.4.1.897.2.1.1.17.

1.3.6.1.4.1.897.2.1.1.18.

1.3.6.1.4.1.897.2.1.1.19.

1.3.6.1.4.1.897.2.1.1.20.

1.3.6.1.4.1.897.2.1.1.21.

1.3.6.1.4.1.897.2.1.1.22.

1.3.6.1.4.1.897.2.1.1.23.

1.3.6.1.4.1.897.2.1.1.24.

Counter64 srvStatCacheReadEng CacheReadEng

Counter64 srvStatCacheReplacements CacheReplacements

Integer32 srvStatCurrentCacheSize CurrentCacheSize

Counter64 srvStatDiskReadEng DiskReadEng

Integer32 srvStatFreeBuffers FreeBuffers

Integer32 srvStatJavaGlobFix JavaGlobFix

Integer32 srvStatLicensesInUse LicensesInUse

Integer32 srvStatLockedHeapPages LockedHeapPages

Counter64 srvStatMainHeapBytes MainHeapBytes

Integer32 srvStatMainHeapPages MainHeapPages

Integer32 srvStatMapPhysicalMemo-

ryEng

Integer32 srvStatMaxCacheSize MaxCacheSize

Integer32 srvStatMinCacheSize MinCacheSize

Counter64 srvStatMultiPacketsReceived MultiPacketsReceived

Counter64 srvStatMultiPacketsSent MultiPacketsSent

Counter64 srvStatPacketsReceived PacketsReceived

MapPhysicalMemoryEng

1.3.6.1.4.1.897.2.1.1.25.

1.3.6.1.4.1.897.2.1.1.26.

1.3.6.1.4.1.897.2.1.1.27.

1.3.6.1.4.1.897.2.1.1.28.

1.3.6.1.4.1.897.2.1.1.29.

1.3.6.1.4.1.897.2.1.1.30.

1.3.6.1.4.1.897.2.1.1.31.

1.3.6.1.4.1.897.2.1.1.32.

1.3.6.1.4.1.897.2.1.1.33.

Counter64 srvStatPacketsReceivedUn-

comp

Counter64 srvStatPacketsSent PacketsSent

Counter64 srvStatPacketsSentUncomp PacketsSentUncomp

Integer32 srvStatPeakCacheSize PeakCacheSize

Integer32 srvStatRemoteputWait RemoteputWait

Integer32 srvStatReq Req

Counter64 srvStatSendFail SendFail

Integer32 srvStatTotalBuffers TotalBuffers

Integer32 srvStatUnschReq UnschReq

PacketsReceivedUncomp

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 valuenis the database number in the

OID Type Name Property

asasnmp.ini

ﬁle.

1.3.6.1.4.1.897.2.1.2.1.

1.3.6.1.4.1.897.2.1.2.2.

1.3.6.1.4.1.897.2.1.2.3.

1.3.6.1.4.1.897.2.1.2.4.

1.3.6.1.4.1.897.2.1.2.5.

1.3.6.1.4.1.897.2.1.2.6.

1.3.6.1.4.1.897.2.1.2.7.

1.3.6.1.4.1.897.2.1.2.8.

1.3.6.1.4.1.897.2.1.2.9.

1.3.6.1.4.1.897.2.1.2.10.

1.3.6.1.4.1.897.2.1.2.11.

1.3.6.1.4.1.897.2.1.2.12.

1.3.6.1.4.1.897.2.1.2.13.

1.3.6.1.4.1.897.2.1.2.14.

1.3.6.1.4.1.897.2.1.2.15.

1.3.6.1.4.1.897.2.1.2.16.

1.3.6.1.4.1.897.2.1.2.17.

String srvPropC2 C2

String srvPropCharSet CharSet

String srvPropCommandLine CommandLine

String srvPropCompactPlatformVer CompactPlatformVer

String srvPropCompanyName CompanyName

String srvPropConnsDisabled* ConnsDisabled

String srvPropConsoleLogFile ConsoleLogFile

String srvPropDefaultCollation DefaultCollation

String srvPropIdleTimeout IdleTimeout

String srvPropIsIQ IsIQ

String srvPropIsJavaAvailable IsJavaAvailable

String srvPropIsNetworkServer IsNetworkServer

String srvPropIsRuntimeServer IsRuntimeServer

String srvPropJavaObjectsEnabled JavaObjectsEnabled

String srvPropLanguage Language

String srvPropLegalCopyright LegalCopyright

String srvPropLegalTrademarks LegalTrademarks

1.3.6.1.4.1.897.2.1.2.18.

1.3.6.1.4.1.897.2.1.2.19.

1.3.6.1.4.1.897.2.1.2.20.

1.3.6.1.4.1.897.2.1.2.21.

1.3.6.1.4.1.897.2.1.2.22.

String srvPropLicenseCount LicenseCount

String srvPropLicensedCompany LicensedCompany

String srvPropLicensedUser LicensedUser

String srvPropLicenseType LicenseType

String srvPropLivenessTimeout* LivenessTimeout

OID Type Name Property

1.3.6.1.4.1.897.2.1.2.23.

1.3.6.1.4.1.897.2.1.2.24.

1.3.6.1.4.1.897.2.1.2.25.

1.3.6.1.4.1.897.2.1.2.26.

1.3.6.1.4.1.897.2.1.2.27.

1.3.6.1.4.1.897.2.1.2.28.

1.3.6.1.4.1.897.2.1.2.29.

1.3.6.1.4.1.897.2.1.2.30.

1.3.6.1.4.1.897.2.1.2.31.

1.3.6.1.4.1.897.2.1.2.32.

1.3.6.1.4.1.897.2.1.2.33.

1.3.6.1.4.1.897.2.1.2.34.

1.3.6.1.4.1.897.2.1.2.35.

1.3.6.1.4.1.897.2.1.2.36.

1.3.6.1.4.1.897.2.1.2.37.

1.3.6.1.4.1.897.2.1.2.38.

String srvPropMachineName MachineName

String srvPropMaxMessage MaxMessage

String srvPropMessageWindowSize MessageWindowSize

String srvPropName Name

String srvPropNativeProcessorArchi-

tecture

String srvPropNumProcessorsAvail NumProcessorsAvail

String srvPropNumProcessorsMax NumProcessorsMax

String srvPropOmniIdentiﬁer OmniIdentiﬁer

String srvPropPageSize PageSize

String srvPropPlatform Platform

String srvPropPlatformVer PlatformVer

String srvPropProcessCPU ProcessCPU

String srvPropProcessCPUSystem ProcessCPUSystem

String srvPropProcessCPUUser ProcessCPUUser

String srvPropProcessorArchitecture ProcessorArchitecture

String srvPropProductName ProductName

NativeProcessorArchitecture

1.3.6.1.4.1.897.2.1.2.39.

1.3.6.1.4.1.897.2.1.2.40.

1.3.6.1.4.1.897.2.1.2.41.

1.3.6.1.4.1.897.2.1.2.42.

1.3.6.1.4.1.897.2.1.2.43.

1.3.6.1.4.1.897.2.1.2.44.

1.3.6.1.4.1.897.2.1.2.45.

1.3.6.1.4.1.897.2.1.2.46.

1.3.6.1.4.1.897.2.1.2.47.

1.3.6.1.4.1.897.2.1.2.48.

String srvPropProductVersion ProductVersion

String srvPropQuittingTime* QuittingTime

String srvPropRememberLastState-

ment*

String srvPropRequestFilterConn RequestFilterConn

String srvPropRequestFilterDB RequestFilterDB

String srvPropRequestLogFile* RequestLogFile

String srvPropRequestLogging* RequestLogging

String srvPropRequestLogMaxSize RequestLogMaxSize

String srvPropStartTime StartTime

String srvPropTempDir TempDir

RememberLastStatement

Chapter 2. Adaptive Server Anywhere MIB Reference

OID Type Name Property

1.3.6.1.4.1.897.2.1.2.49.

1.3.6.1.4.1.897.2.1.2.50.

1.3.6.1.4.1.897.2.1.2.51.

1.3.6.1.4.1.897.2.1.2.52.

1.3.6.1.4.1.897.2.1.2.53.

1.3.6.1.4.1.897.2.1.2.54.

1.3.6.1.4.1.897.2.1.2.55.

1.3.6.1.4.1.897.2.1.2.56.

1.3.6.1.4.1.897.2.1.2.57.

String srvPropThreads Threads

String srvPropTimeZoneAdjustment TimeZoneAdjustment

String srvPropHttpPorts HttpPorts

String srvPropHttpsPorts HttpsPorts

String srvPropProﬁleFilterConn ProﬁleFilterConn

String srvPropProﬁleFilterUser ProﬁleFilterUser

String srvPropRequestLogNumFiles RequestLogNumFIles

String srvPropIsFipsAvailable IsFipsAvailable

String srvPropFipsMode 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 valuenis the database number in the

OID Type Name Property

1.3.6.1.4.1.897.2.2.1.1.

Counter64 dbStatCacheHits CacheHits

asasnmp.ini

ﬁle.

1.3.6.1.4.1.897.2.2.1.2.

1.3.6.1.4.1.897.2.2.1.3.

1.3.6.1.4.1.897.2.2.1.4.

1.3.6.1.4.1.897.2.2.1.5.

1.3.6.1.4.1.897.2.2.1.6.

1.3.6.1.4.1.897.2.2.1.7.

1.3.6.1.4.1.897.2.2.1.8.

1.3.6.1.4.1.897.2.2.1.9.

1.3.6.1.4.1.897.2.2.1.10.nInteger32 dbStatCheckpointLogBitmap-

1.3.6.1.4.1.897.2.2.1.11.nInteger32 dbStatCheckpointLogBitmap-

Integer32 dbStatCacheReadIndInt CacheReadIndInt

Integer32 dbStatCacheReadIndLeaf CacheReadIndLeaf

Counter64 dbStatCacheRead CacheRead

Integer32 dbStatCacheReadTable CacheReadTable

Integer32 dbStatChkpt Chkpt

Integer32 dbStatChkptFlush ChkptFlush

Integer32 dbStatChkptPage ChkptPage

Integer32 dbStatCheckpointUrgency CheckpointUrgency

Size

PagesWritten

CheckpointLogBitmapSize

CheckpointLogBitmapPagesWritten

OID Type Name Property

1.3.6.1.4.1.897.2.2.1.12.nInteger32 dbStatCheckpointLogCommitToDisk

1.3.6.1.4.1.897.2.2.1.13.nInteger32 dbStatCheckpointLogPageInUse

1.3.6.1.4.1.897.2.2.1.14.nInteger32 dbStatCheckpointLogPagesRelocated

1.3.6.1.4.1.897.2.2.1.15.nInteger32 dbStatCheckpointLogSavePreimage

1.3.6.1.4.1.897.2.2.1.16.nInteger32 dbStatCheckpointLogSize CheckpointLogSize

1.3.6.1.4.1.897.2.2.1.17.nInteger32 dbStatCheckpointLogWrites CheckpointLogWrites

1.3.6.1.4.1.897.2.2.1.18.nInteger32 dbStatCheckpointLogPagesWritten

1.3.6.1.4.1.897.2.2.1.19.nInteger32 dbStatCommitFile CommitFile

1.3.6.1.4.1.897.2.2.1.20.nInteger32 dbStatConnCount ConnCount

1.3.6.1.4.1.897.2.2.1.21.nInteger32 dbStatCurrIO CurrIO

1.3.6.1.4.1.897.2.2.1.22.nInteger32 dbStatCurrRead CurrRead

1.3.6.1.4.1.897.2.2.1.23.nInteger32 dbStatCurrWrite CurrWrite

1.3.6.1.4.1.897.2.2.1.24.nInteger32 dbStatDiskReadIndInt DiskReadIndInt

CheckpointLogCommitToDisk

CheckpointLogPageInUse

CheckpointLogPagesRelocated

CheckpointLogSavePreimage

CheckpointLogPagesWritten

1.3.6.1.4.1.897.2.2.1.25.nInteger32 dbStatDiskReadIndLeaf DiskReadIndLeaf

1.3.6.1.4.1.897.2.2.1.26.nCounter64 dbStatDiskRead DiskRead

1.3.6.1.4.1.897.2.2.1.27.nInteger32 dbStatDiskReadTable DiskReadTable

1.3.6.1.4.1.897.2.2.1.28.nCounter64 dbStatDiskWrite DiskWrite

1.3.6.1.4.1.897.2.2.1.29.nInteger32 dbStatExtendDB ExtendDB

1.3.6.1.4.1.897.2.2.1.30.nInteger32 dbStatExtendTempWrite ExtendTempWrite

1.3.6.1.4.1.897.2.2.1.31.nInteger32 dbStatFullCompare FullCompare

1.3.6.1.4.1.897.2.2.1.32.nInteger32 dbStatGetData GetData

1.3.6.1.4.1.897.2.2.1.33.nInteger32 dbStatIdleCheck IdleCheck

1.3.6.1.4.1.897.2.2.1.34.nInteger32 dbStatIdleChkpt IdleChkpt

1.3.6.1.4.1.897.2.2.1.35.nInteger32 dbStatIdleChkTime IdleChkTime

Chapter 2. Adaptive Server Anywhere MIB Reference

OID Type Name Property

1.3.6.1.4.1.897.2.2.1.36.nInteger32 dbStatIdleWrite IdleWrite

1.3.6.1.4.1.897.2.2.1.37.nInteger32 dbStatIndAdd IndAdd

1.3.6.1.4.1.897.2.2.1.38.nInteger32 dbStatIndLookup IndLookup

1.3.6.1.4.1.897.2.2.1.39.nInteger32 dbStatIOToRecover IOToRecover

1.3.6.1.4.1.897.2.2.1.40.nInteger32 dbStatJavaHeapSize JavaHeapSize

1.3.6.1.4.1.897.2.2.1.41.nInteger32 dbStatJavaNSSize JavaNSSize

1.3.6.1.4.1.897.2.2.1.42.nInteger32 dbStatLockTablePages LockTablePages

1.3.6.1.4.1.897.2.2.1.43.nInteger32 dbStatMapPages MapPages

1.3.6.1.4.1.897.2.2.1.44.nInteger32 dbStatMaxIO MaxIO

1.3.6.1.4.1.897.2.2.1.45.nCounter64 dbStatMaxRead MaxRead

1.3.6.1.4.1.897.2.2.1.46.nInteger32 dbStatMaxWrite MaxWrite

1.3.6.1.4.1.897.2.2.1.47.nInteger32 dbStatPageRelocations PageRelocations

1.3.6.1.4.1.897.2.2.1.48.nInteger32 dbStatProcedurePages ProcedurePages

1.3.6.1.4.1.897.2.2.1.49.nInteger32 dbStatQueryCachePages QueryCachePages

1.3.6.1.4.1.897.2.2.1.50.nInteger32 dbStatQueryLowMemoryStrategy

1.3.6.1.4.1.897.2.2.1.51.nCounter64 dbStatQueryRowsMaterialized QueryRowsMaterialized

1.3.6.1.4.1.897.2.2.1.52.nInteger32 dbStatRecoveryUrgency RecoveryUrgency

1.3.6.1.4.1.897.2.2.1.53.nInteger32 dbStatLogFreeCommit LogFreeCommit

1.3.6.1.4.1.897.2.2.1.54.nInteger32 dbStatLogWrite LogWrite

1.3.6.1.4.1.897.2.2.1.55.nInteger32 dbStatRelocatableHeapPages RelocatableHeapPages

1.3.6.1.4.1.897.2.2.1.56.nInteger32 dbStatRollbackLogPages RollbackLogPages

1.3.6.1.4.1.897.2.2.1.57.nInteger32 dbStatTempTablePages TempTablePages

1.3.6.1.4.1.897.2.2.1.58.nInteger32 dbStatTriggerPages TriggerPages

1.3.6.1.4.1.897.2.2.1.59.nInteger32 dbStatViewPages ViewPages

QueryLowMemoryStrategy

Database properties

The following table lists the OIDs and names of the database properties that

can be retrieved using the Adaptive Server Anywhere SNMP Extension Agent.

Writable properties are marked with an asterisk (*). The valuenis the database number in the

OID Type Name Property

asasnmp.ini

ﬁle.

1.3.6.1.4.1.897.2.2.2.1.

1.3.6.1.4.1.897.2.2.2.2.

1.3.6.1.4.1.897.2.2.2.3.

1.3.6.1.4.1.897.2.2.2.4.

1.3.6.1.4.1.897.2.2.2.5.

1.3.6.1.4.1.897.2.2.2.6.

1.3.6.1.4.1.897.2.2.2.7.

1.3.6.1.4.1.897.2.2.2.8.

1.3.6.1.4.1.897.2.2.2.9.

1.3.6.1.4.1.897.2.2.2.10.

1.3.6.1.4.1.897.2.2.2.11.

1.3.6.1.4.1.897.2.2.2.12.

1.3.6.1.4.1.897.2.2.2.13.

1.3.6.1.4.1.897.2.2.2.14.

1.3.6.1.4.1.897.2.2.2.15.

1.3.6.1.4.1.897.2.2.2.16.

1.3.6.1.4.1.897.2.2.2.17.

n n n n n n n n n

String dbPropAlias Alias String dbPropAuditingTypes AuditingTypes String dbPropBlankPadding BlankPadding String dbPropBlobArenas BlobArenas String dbPropCapabilities Capabilities String dbPropCaseSensitive CaseSensitive String dbPropCaseSensitivePasswords CaseSensitivePasswords String dbPropCharSet CharSet String dbPropChecksum Checksum

String dbPropClusteredIndexes ClusteredIndexes

String dbPropCollation Collation

String dbPropCompressedBTrees CompressedBTrees

String dbPropCompression Compression

String dbPropCurrentRedoPos CurrentRedoPos

String dbPropDBFileFragments DBFileFragments

String dbPropDriveType DriveType

String dbPropEncryption Encryption

1.3.6.1.4.1.897.2.2.2.18.

1.3.6.1.4.1.897.2.2.2.19.

1.3.6.1.4.1.897.2.2.2.20.

1.3.6.1.4.1.897.2.2.2.21.

1.3.6.1.4.1.897.2.2.2.22.

1.3.6.1.4.1.897.2.2.2.23.

1.3.6.1.4.1.897.2.2.2.24.

String dbPropFile File

String dbPropFileSize FileSize

String dbPropFileVersion FileVersion

String dbPropFreePageBitMaps FreePageBitMaps

String dbPropFreePages FreePages

String dbPropGlobalDBId GlobalDBId

String dbPropHistogramHashFix HistogramHashFix

Chapter 2. Adaptive Server Anywhere MIB Reference

OID Type Name Property

1.3.6.1.4.1.897.2.2.2.25.

1.3.6.1.4.1.897.2.2.2.26.

1.3.6.1.4.1.897.2.2.2.27.

1.3.6.1.4.1.897.2.2.2.28.

1.3.6.1.4.1.897.2.2.2.29.

1.3.6.1.4.1.897.2.2.2.30.

1.3.6.1.4.1.897.2.2.2.31.

1.3.6.1.4.1.897.2.2.2.32.

1.3.6.1.4.1.897.2.2.2.33.

1.3.6.1.4.1.897.2.2.2.34.

1.3.6.1.4.1.897.2.2.2.35.

1.3.6.1.4.1.897.2.2.2.36.

1.3.6.1.4.1.897.2.2.2.37.

1.3.6.1.4.1.897.2.2.2.38.

1.3.6.1.4.1.897.2.2.2.39.

1.3.6.1.4.1.897.2.2.2.40.

1.3.6.1.4.1.897.2.2.2.41.

String dbPropHistograms Histograms

String dbPropIndexStatistics IndexStatistics

String dbPropIQStore IQStore

String dbPropJDKVersion JDKVersion

String dbPropLanguage Language

String dbPropLargeProcedureIDs LargeProcedureIDs

String dbPropLogFileFragments LogFileFragments

String dbPropLogMirrorName LogMirrorName

String dbPropLogName LogName

String dbPropLTMGeneration LTMGeneration

String dbPropLTMTrunc LTMTrunc

String dbPropMultiByteCharSet MultiByteCharSet

String dbPropName Name

String dbPropNamedConstraints NamedConstraints

String dbPropPageSize PageSize

String dbPropPreserveSource PreserveSource

String dbPropProcedureProﬁling* ProcedureProﬁling

1.3.6.1.4.1.897.2.2.2.42.

1.3.6.1.4.1.897.2.2.2.43.

1.3.6.1.4.1.897.2.2.2.44.

1.3.6.1.4.1.897.2.2.2.45.

1.3.6.1.4.1.897.2.2.2.46.

1.3.6.1.4.1.897.2.2.2.47.

1.3.6.1.4.1.897.2.2.2.48.

1.3.6.1.4.1.897.2.2.2.49.

1.3.6.1.4.1.897.2.2.2.50.

1.3.6.1.4.1.897.2.2.2.51.

1.3.6.1.4.1.897.2.2.2.52.

String dbPropReadOnly ReadOnly

String dbPropRemoteTrunc RemoteTrunc

String dbPropSeparateCheckpointLog SeparateCheckpointLog

String dbPropSeparateForeignKeys SeparateForeignKeys

String dbPropStringHistogramsFix StringHistogramsFix

String dbPropSyncTrunc SyncTrunc

String dbPropTableBitMaps TableBitMaps

String dbPropTablesQualTriggers TablesQualTriggers

String dbPropTempFileName TempFileName

String dbPropTransactionsSpanLogs TransactionsSpanLogs

String dbPropVariableHashSize VariableHashSize

OID Type Name Property

1.3.6.1.4.1.897.2.2.2.53.

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 valuenis the database number in the

OID Type Name Option

1.3.6.1.4.1.897.2.2.3.1.

1.3.6.1.4.1.897.2.2.3.2.

1.3.6.1.4.1.897.2.2.3.3.

1.3.6.1.4.1.897.2.2.3.4.

1.3.6.1.4.1.897.2.2.3.5.

1.3.6.1.4.1.897.2.2.3.6.

1.3.6.1.4.1.897.2.2.3.7.

n n n n

n n n

String dbOptAllowNullsByDefault* Allow_nulls_by_default String dbOptAnsinull* Ansinull String dbOptAnsiBlanks* Ansi_blanks String dbOptAnsiCloseCursorsOn-

String dbOptAnsiIntegerOverﬂow* Ansi_integer_overﬂow String dbOptAnsiPermissions* Ansi_permissions String dbOptAnsiUpdateCon-

asasnmp.ini

Rollback*

straints*

ﬁle.

Ansi_close_cursors_on_rollback

Ansi_update_constraints

1.3.6.1.4.1.897.2.2.3.8.

1.3.6.1.4.1.897.2.2.3.9.

1.3.6.1.4.1.897.2.2.3.10.

1.3.6.1.4.1.897.2.2.3.11.

1.3.6.1.4.1.897.2.2.3.12.

1.3.6.1.4.1.897.2.2.3.13.

1.3.6.1.4.1.897.2.2.3.14.

1.3.6.1.4.1.897.2.2.3.15.

1.3.6.1.4.1.897.2.2.3.16.

1.3.6.1.4.1.897.2.2.3.17.

1.3.6.1.4.1.897.2.2.3.18.

n n

n n n n n n n n n

String dbOptAuditing* Auditing String dbOptAuditingOptions* Auditing_options String dbOptAutomaticTimestamp* Automatic_timestamp String dbOptBackgroundPriority* Background_priority String dbOptBlocking* Blocking Integer32 dbOptBlockingTimeout* Blocking_timeout String dbOptChained* Chained Integer32 dbOptCheckpointTime* Checkpoint_time Integer32 dbOptCisOption* Cis_option Integer32 dbOptCisRowsetSize* Cis_rowset_size String dbOptCloseOnEndtrans* Close_on_endtrans

Chapter 2. Adaptive Server Anywhere MIB Reference

OID Type Name Option

1.3.6.1.4.1.897.2.2.3.19.

1.3.6.1.4.1.897.2.2.3.20.

1.3.6.1.4.1.897.2.2.3.21.

1.3.6.1.4.1.897.2.2.3.22.

1.3.6.1.4.1.897.2.2.3.23.

1.3.6.1.4.1.897.2.2.3.24.

1.3.6.1.4.1.897.2.2.3.25.

1.3.6.1.4.1.897.2.2.3.26.

1.3.6.1.4.1.897.2.2.3.27.

1.3.6.1.4.1.897.2.2.3.28.

1.3.6.1.4.1.897.2.2.3.29.

1.3.6.1.4.1.897.2.2.3.30.

1.3.6.1.4.1.897.2.2.3.31.

n n n

n n n n n

n n

String dbOptConnectionAuthentica-

tion*

String dbOptContinueAfterRaiseer-

ror* String dbOptConversionError* Conversion_error String dbOptCooperativeCommits* Cooperative_commits Integer32 dbOptCooperativeCommit-

Timeout* String dbOptDatabaseAuthentica-

tion* String dbOptDateFormat* Date_format String dbOptDateOrder* Date_order String dbOptDebugMessages* Debug_messages String dbOptDedicatedTask* Dedicated_task Integer32 dbOptDefaultTimestampIn-

crement* String dbOptDelayedCommits* Delayed_commits Integer32 dbOptDelayedCommitTime-

out*

Connection_authentication

Continue_after_raise_error

Cooperative_commit_timeout

Database_authentication

Default_timestamp_increment

Delayed_commit_timeout

1.3.6.1.4.1.897.2.2.3.32.

1.3.6.1.4.1.897.2.2.3.33.

1.3.6.1.4.1.897.2.2.3.34.

1.3.6.1.4.1.897.2.2.3.35.

1.3.6.1.4.1.897.2.2.3.36.

1.3.6.1.4.1.897.2.2.3.37.

1.3.6.1.4.1.897.2.2.3.38.

1.3.6.1.4.1.897.2.2.3.39.

1.3.6.1.4.1.897.2.2.3.40.

1.3.6.1.4.1.897.2.2.3.41.

1.3.6.1.4.1.897.2.2.3.42.

n n n n n n n n n n n

String dbOptDivideByZeroError* Divide_by_zero_error String dbOptEscapeCharacter* Escape_character String dbOptExcludeOperators* Exclude_operators String dbOptExtendedJoinSyntax* Extended_join_syntax String dbOptFireTriggers* Fire_triggers Integer32 dbOptFirstDayOfWeek* First_day_of_week String dbOptFloatAsDouble* Float_as_double String dbOptForceViewCreation* Force_view_creation String dbOptForXmlNullTreatment* For_xml_null_treatment Integer32 dbOptGlobalDatabaseId* Global_database_id Integer32 dbOptIsolationLevel* Isolation_level

OID Type Name Option

1.3.6.1.4.1.897.2.2.3.43.

1.3.6.1.4.1.897.2.2.3.44.

1.3.6.1.4.1.897.2.2.3.45.

1.3.6.1.4.1.897.2.2.3.46.

1.3.6.1.4.1.897.2.2.3.47.

1.3.6.1.4.1.897.2.2.3.48.

1.3.6.1.4.1.897.2.2.3.49.

1.3.6.1.4.1.897.2.2.3.50.

1.3.6.1.4.1.897.2.2.3.51.

1.3.6.1.4.1.897.2.2.3.52.

1.3.6.1.4.1.897.2.2.3.53.

1.3.6.1.4.1.897.2.2.3.54.

1.3.6.1.4.1.897.2.2.3.55.

1.3.6.1.4.1.897.2.2.3.56.

1.3.6.1.4.1.897.2.2.3.57.

n n n n n n n n n n n n n

n n

Integer32 dbOptJavaHeapSize* Java_heap_size String dbOptJavaInputOutput* Java_input_output Integer32 dbOptJavaNamespaceSize* Java_namespace_size Integer32 dbOptJavaPageBufferSize* Java_page_buffer_size String dbOptLockRejectedRows* Lock_rejected_rows String dbOptLoginMode* Login_mode String dbOptLoginProcedure* Login_procedure String dbOptLogDetailedPlans* Log_detailed_plans Integer32 dbOptLogMaxRequests* Log_max_requests Integer32 dbOptMaxCursorCount* Max_cursor_count Integer32 dbOptMaxHashSize* Max_hash_size Integer32 dbOptMaxPlansCached* Max_plans_cached Integer32 dbOptMaxRecursiveItera-

tions* Integer32 dbOptMaxStatementCount* Max_statement_count Integer32 dbOptMaxWorkTableHash-

Size*

Max_recursive_iterations

Max_work_table_hash_size

1.3.6.1.4.1.897.2.2.3.58.

1.3.6.1.4.1.897.2.2.3.59.

1.3.6.1.4.1.897.2.2.3.60.

1.3.6.1.4.1.897.2.2.3.61.

1.3.6.1.4.1.897.2.2.3.62.

1.3.6.1.4.1.897.2.2.3.63.

1.3.6.1.4.1.897.2.2.3.64.

1.3.6.1.4.1.897.2.2.3.65.

1.3.6.1.4.1.897.2.2.3.66.

n n n n n

n n

Integer32 dbOptMinPasswordLength* Min_password_length Integer32 dbOptInternal Internal Integer32 dbOptNearestCentury* Nearest_century String dbOptNonKeywords* Non_keywords String dbOptODBCDistinguishCha-

rAndVarchar* String dbOptOnCharsetConversion-

Failure* String dbOptOnTsqlError* On_tsql_error String dbOptOptimisticWaitFor-

Commit* String dbOptOptimizationGoal* Optimization_goal

ODBC_distinguish_char_and_varchar

On_charset_conversion_failure

Optimistic_wait_for_commit

Chapter 2. Adaptive Server Anywhere MIB Reference

OID Type Name Option

1.3.6.1.4.1.897.2.2.3.67.

1.3.6.1.4.1.897.2.2.3.68.

1.3.6.1.4.1.897.2.2.3.69.

1.3.6.1.4.1.897.2.2.3.70.

1.3.6.1.4.1.897.2.2.3.71.

1.3.6.1.4.1.897.2.2.3.72.

1.3.6.1.4.1.897.2.2.3.73.

1.3.6.1.4.1.897.2.2.3.74.

1.3.6.1.4.1.897.2.2.3.75.

1.3.6.1.4.1.897.2.2.3.76.

1.3.6.1.4.1.897.2.2.3.77.

1.3.6.1.4.1.897.2.2.3.78.

1.3.6.1.4.1.897.2.2.3.79.

1.3.6.1.4.1.897.2.2.3.80.

1.3.6.1.4.1.897.2.2.3.81.

n n n n

n n n n n n

Integer32 dbOptOptimizationLevel* Optimization_level String dbOptOptimizationLogging* Optimization_logging String dbOptOptimizationWorkload* Optimization_workload Integer32 dbOptPinnedCursorPer-

centOfCache* Integer32 dbOptPrecision* Precision String dbOptPrefetch* Prefetch String dbOptPreserveSourceFormat* Preserve_source_format String dbOptPreventArticlePkeyUp-

date* String dbOptQueryPlanOnOpen* Query_plan_on_open String dbOptQuotedIdentiﬁer* Quoted_identiﬁer String dbOptReadPastDeleted* Read_past_deleted Integer32 dbOptRecoveryTime* Recovery_time String dbOptReplicateAll* Replicate_all String dbOptReturnDateTime-

AsString* String dbOptReturnJavaAsString* Return_java_as_string

Pinned_cursor_percent_of_cache

Prevent_article_pkey_update

Return_date_time_as_string

1.3.6.1.4.1.897.2.2.3.82.

1.3.6.1.4.1.897.2.2.3.83.

1.3.6.1.4.1.897.2.2.3.84.

1.3.6.1.4.1.897.2.2.3.85.

1.3.6.1.4.1.897.2.2.3.86.

1.3.6.1.4.1.897.2.2.3.87.

1.3.6.1.4.1.897.2.2.3.88.

1.3.6.1.4.1.897.2.2.3.89.

1.3.6.1.4.1.897.2.2.3.90.

n n n n n

n n n

String dbOptRITriggerTime* RI_trigger_time String dbOptRowCounts* Row_counts Integer32 dbOptScale* Scale String dbOptSortCollation* Sort_collation String dbOptSQLFlaggerError-

Level* String dbOptSQLFlaggerWarn-

ingLevel* String dbOptStringRtruncation* String_rtruncation String dbOptSubsumeRowLocks* Subsume_row_locks String dbOptSuppressTDSDebug-

ging*

SQL_ﬂagger_error_level

SQL_ﬂagger_warning_level

Suppress_TDS_debugging

OID Type Name Option

1.3.6.1.4.1.897.2.2.3.91.

1.3.6.1.4.1.897.2.2.3.92.

1.3.6.1.4.1.897.2.2.3.93.

1.3.6.1.4.1.897.2.2.3.94.

1.3.6.1.4.1.897.2.2.3.95.

1.3.6.1.4.1.897.2.2.3.96.

1.3.6.1.4.1.897.2.2.3.97.

1.3.6.1.4.1.897.2.2.3.98.

1.3.6.1.4.1.897.2.2.3.99.

1.3.6.1.4.1.897.2.2.3.100.

1.3.6.1.4.1.897.2.2.3.101.

1.3.6.1.4.1.897.2.2.3.102.

1.3.6.1.4.1.897.2.2.3.103.

1.3.6.1.4.1.897.2.2.3.104.

n n n n n n n n

String dbOptTDSEmptyStringIs-

Null* Integer32 dbOptThreadCount* Thread_count Integer32 dbOptThreadStack* Thread_stack Integer32 dbOptThreadSwaps* Thread_swaps String dbOptTimestampFormat* Timestamp_format String dbOptTimeFormat* Time_format Integer32 dbOptTimeZoneAdjustment* Time_zone_adjustment String dbOptTruncateDateValues* Truncate_date_values String dbOptTruncateTimestampVal-

ues*

String dbOptTruncateWithAutocom-

mit*

String dbOptTsqlHexConstant* Tsql_hex_constant

String dbOptTsqlVariables* Tsql_variables

String dbOptUpdateStatistics* Update_statistics

String dbOptUpgradeDatabaseCapa-

bility*

TDS_empty_string_is_null

Truncate_timestamp_values

Truncate_with_auto_commit

Upgrade_database_capability

1.3.6.1.4.1.897.2.2.3.105.

1.3.6.1.4.1.897.2.2.3.106.

1.3.6.1.4.1.897.2.2.3.107.

1.3.6.1.4.1.897.2.2.3.108.

1.3.6.1.4.1.897.2.2.3.109.

1.3.6.1.4.1.897.2.2.3.110.

1.3.6.1.4.1.897.2.2.3.111.

1.3.6.1.4.1.897.2.2.3.112.

1.3.6.1.4.1.897.2.2.3.113.

String dbOptUserEstimates* User_estimates

String dbOptWaitForCommit* Wait_for_commit

String dbOptTempSpaceLim-

itCheck*

Integer32 dbOptRemoteIdleTimeout* Remote_idle_timeout

Integer32 dbOptInternal Internal

String dbOptODBCDescribeBina-

ryAsVarbinary*

String dbOptRollbackOnDeadlock Rollback_on_deadlock

String dbOptIntegratedServerName* Integrated_server_name

String dbOptLogDeadlocks* Log_deadlocks

Temp_space_limit_check

ODBC_describe_binary_as_varbinary

CHAPTER 3

RDBMS MIB Reference

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

Topic: page

The RDBMS MIB 42

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

9\snmp\RDBMS-MIB.mib

rdbmsDbTable

This table lists information about the databases installed on a system.

C:\Program Files\Sybase\SQL Anywhere

The valuedbis the database number in the

OID Type Name Value returned

1.3.6.1.2.1.39.1.1.1.1.

1.3.6.1.2.1.39.1.1.1.2.

1.3.6.1.2.1.39.1.1.1.3.

1.3.6.1.2.1.39.1.1.1.4.

1.3.6.1.2.1.39.1.1.1.5.

Integer rdbmsDbIndex

OID rdbmsDbPrivateMibOID 1.3.6.1.4.1.897.2

String rdbmsDbVendorName property(‘CompanyName’)

String rdbmsDbName db_property(‘name’)

String rdbmsDbContact property(‘LicensedUser’)

asasnmp.ini

rdbmsDbInfoTable

This table provides additional information about the databases on the system. The valuedbis the database number in the

OID Type Name Value returned

1.3.6.1.2.1.39.1.2.1.1.

1.3.6.1.2.1.39.1.2.1.2.

String rdbmsDbInfoProduct-

Name

String rdbmsDbInfoVersion property(‘ProductVersion’)

asasnmp.ini

property(‘PropertyName’)

ﬁle.

Chapter 3. RDBMS MIB Reference

OID Type Name Value returned

1.3.6.1.2.1.39.1.2.1.3.

1.3.6.1.2.1.39.1.2.1.4.

1.3.6.1.2.1.39.1.2.1.5.

1.3.6.1.2.1.39.1.2.1.6.

Integer rdbmsDbInfoSizeUnits Calculated based on dbInfoSizeAllo-

Integer rdbmsDbInfoSizeAllo-

Integer rdbmsDbInfoSizeUsed db_property(‘pagesize’) * (db_-

String rdbmsDbInfoLast-

This OID is not currently supported by the Adaptive Server Anywhere

SNMP Extension Agent.

cated

Backup

cated and dbInfoSizeUsed.

♦ 1=bytes ♦ 2=KB ♦ 3=MB ♦ 4=GB ♦ 5=TB

(Each unit is 1024 times the previous.)

db_property(‘pagesize’) * db_property(‘ﬁlesize’)

property(‘ﬁlesize’) - db_property(‘freepages’) )

NULL

rdbmsDbParamTable

This table lists the conﬁguration parameters for the databases on the system. The valuedbis the database number in the

index of the option in the asa.2.3 subtree.

OID Type Name Value returned

1.3.6.1.2.1.39.1.3.1.1.

1.3.6.1.2.1.39.1.3.1.2.

1.3.6.1.2.1.39.1.3.1.3.

1.3.6.1.2.1.39.1.3.1.4.

1.3.6.1.2.1.39.1.3.1.5.

db db db

db db

String rdbmsDbParamName Option name Integer rdbmsDbParamSubIndex OID rdbmsDbParamID OID in Adaptive Server

String rdbmsDbParamCurrValue Option value String rdbmsDbParamComment NULL

asasnmp.ini

ﬁle, whilenis the

Anywhere MIB corresponding to this option

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, 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 valuedbis the database number in the

OID Type Name Value returned

1.3.6.1.2.1.39.1.4.1.1.n.

1.3.6.1.2.1.39.1.4.1.2.n.

1.3.6.1.2.1.39.1.4.1.3.n.

1.3.6.1.2.1.39.1.4.1.4.n.

String rdbmsDbLimitedResource-

Name

OID rdbmsDbLimitedResourceID 1.3.6.1.4.1.897.2

Integer rdbmsDbLimitedResource-

Limit

Integer rdbmsDbLimitedResourceCur-

rent

asasnmp.ini

Name of dbspace, or Transaction Log, Transaction Log Mirror, Temporary File, or Write File.

Free space available on disk + current ﬁle size, in bytes

Current ﬁle size

ﬁle.

1.3.6.1.2.1.39.1.4.1.5.n.

1.3.6.1.2.1.39.1.4.1.6.n.

1.3.6.1.2.1.39.1.4.1.7n.

Integer rdbmsDbLimitedResource-

Highwater

Integer rdbmsDbLimitedResource-

Failure

String rdbmsDbLimite-

dResourceDescription

This OID is not currently supported by the Adaptive Server Anywhere

Current size

”Bytes”

SNMP Extenstion Agent.

rdbmsSrvTable

Chapter 3. RDBMS MIB Reference

This table lists the database servers running or installed on your system. The valuedbis the database number in the

OID Type Name Value returned

1.3.6.1.2.1.39.1.5.1.1.

1.3.6.1.2.1.39.1.5.1.2.

1.3.6.1.2.1.39.1.5.1.3.

1.3.6.1.2.1.39.1.5.1.4.

OID rdbmsSrvPrivateMibOID 1.3.6.1.4.1.897.2

String rdbmsSrvVendorName property(‘CompanyName’)

String rdbmsSrvProductName property(‘ProductName’)

String rdbmsSrvContact property(‘LicencedCompany’)

asasnmp.ini

ﬁle.

rdbmsSrvInfoTable

This table lists additional information about the database servers in your system.

The valuedbis the database number in the

OID Type Name Value returned

1.3.6.1.2.1.39.1.6.1.1.

1.3.6.1.2.1.39.1.6.1.2.

1.3.6.1.2.1.39.1.6.1.3.

1.3.6.1.2.1.39.1.6.1.4.

db db db db

Integer rdbmsSrvInfoStartupTime property(‘StartTime’) Integer rdbmsSrvInfoFinishedTransactions 0 Integer rdbmsSrvInfoDiskReads property(‘DiskReadEng’) Integer rdbmsSrvInfoLogicalReads 0

asasnmp.ini

ﬁle.

1.3.6.1.2.1.39.1.6.1.5.

1.3.6.1.2.1.39.1.6.1.6.

1.3.6.1.2.1.39.1.6.1.7.

1.3.6.1.2.1.39.1.6.1.8.

1.3.6.1.2.1.39.1.6.1.9.

1.3.6.1.2.1.39.1.6.1.10.

1.3.6.1.2.1.39.1.6.1.11.

1.3.6.1.2.1.39.1.6.1.12.

db db db db

Integer rdbmsSrvInfoDiskWrites prop-

Integer rdbmsSrvInfoLogicalWrites 0 Integer rdbmsSrvInfoPageReads 0 Integer rdbmsSrvInfoPageDiskOutOfWrites 0 Integer rdbmsSrvInfoSpaces 0

Integer rdbmsSrvInfoHandledRequests property(‘Req’)

Integer rdbmsSrvInfoRequestRecvs prop-

Integer rdbmsSrvInfoRequestSends prop-

erty(‘DiskWriteEng’)

erty(‘PacketsReceivedUncomp’)

erty(‘PacketsSentUncomp’)

OID Type Name Value returned

1.3.6.1.2.1.39.1.6.1.13.

1.3.6.1.2.1.39.1.6.1.14.

Integer rdbmsSrvInfoHighwaterInboundAs-

sociations

Integer rdbmsSrvInfoMaxInboundAssocia-

tions

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.nis the index, as follows:

n Server option

1 ConnsDisabled 2 LivenessTimeout (default) 3 QuittingTime 4 RememberLastStatement 5 RequestLogFile 6 RequestLogging

The valuedbis the database number in the

OID Type Name Value returned

1.3.6.1.2.1.39.1.7.1.1.n.

1.3.6.1.2.1.39.1.7.1.2.n.

1.3.6.1.2.1.39.1.7.1.3.n.

1.3.6.1.2.1.39.1.7.1.4.n.

1.3.6.1.2.1.39.1.7.1.5.n.

String rdbmsDbSrvParamName Name of option

Integer rdbmsDbSrvParamSubIndex

OID rdbmsDbSrvParamID 1.3.6.1.4.1.897.2

String rdbmsDbSrvParamCurrValue Current value of option

String rdbmsDbSrvParamComment Full name of option

asasnmp.ini

rdbmsSrvLimitedResourceTable

This table contains information about server conﬁguration parameters.

ﬁle.

Chapter 3. RDBMS MIB Reference

The valuedbis the database number in the

asasnmp.ini

index of the resource as follows:

Name Resource Resource limit

Connec-

tions Processors prop-

OID Type Name Valuereturned

1.3.6.1.2.1.39.1.8.1.1.

1.3.6.1.2.1.39.1.8.1.2.

1.3.6.1.2.1.39.1.8.1.3.

1.3.6.1.2.1.39.1.8.1.4.

1.3.6.1.2.1.39.1.8.1.5.

1.3.6.1.2.1.39.1.8.1.6.

String rdbmsSrvLimitedResource-

OID rdbmsSrvLimitedResour-

Integer rdbmsSrvLimitedResource-

property(‘LicensesInUse’)

erty(‘NumProcessorsAvail’)

Name

ceID

Limit

Current

Highwater

Failures

property(‘LicenseCount’)

property(‘NumProcessorsMax’) If this is 0, then it returns prop-

erty(‘NumProcessorsAvail’))

Name of resource

OID in Adaptive Server Anywhere MIB corresponding to this option

Upper limit of resource

Current value of resource

ﬁle, whilenis the

1.3.6.1.2.1.39.1.8.1.7.

String rdbmsSrvLimite-

This OID is not currently supported by the Adaptive Server Anywhere

SNMP Extenstion Agent.

dResourceDescription

Name of resource

Index

ActiveReq property

ASA SNMP Extension Agent OID 27

Adaptive Server Anywhere MIB

about 7 Agent table 24 asaDbOptMetaDataTable 27 asaDbPropMetaDataTable 26 asaDbStatMetaDataTable 26 asaMetaData tables 24 asaSrvPropMetaDataTable 25 asaSrvStatMetaDataTable 24 database options 36 database properties 33 database statistics 31 list of tables 24 server properties 29

server statistics 27 Adaptive Server Anywhere MIB reference 23 Adaptive Server Anywhere SNMP Extension Agent

about 3

asasnmp.ini ﬁle 12

conﬁguring 10

dynamic traps 19

executing functions 17

executing stored procedures 17

restarting 12

supported MIBs 6

supported platforms 4 Agent table

Adaptive Server Anywhere MIB 24 agents

about 6 Alias property

ASA SNMP Extension Agent OID 34 ALLOW_NULLS_BY_DEFAULT option

ASA SNMP Extension Agent OID 36 ANSI_BLANKS option

ASA SNMP Extension Agent OID 36 ANSI_CLOSE_CURSORS_ON_ROLLBACK

option

ASA SNMP Extension Agent OID 36

ANSI_INTEGER_OVERFLOW option

ASA SNMP Extension Agent OID 36

ANSI_PERMISSIONS option

ASA SNMP Extension Agent OID 36

ANSI_UPDATE_CONSTRAINTS option

ASA SNMP Extension Agent OID 36

ANSINULL option

ASA SNMP Extension Agent OID 36

asaDbOptMetaDataTable

Adaptive Server Anywhere MIB 27

asaDbPropMetaDataTable

Adaptive Server Anywhere MIB 26

asaDbStatMetaDataTable

Adaptive Server Anywhere MIB 26

asasnmp.ini ﬁle

required for ASA SNMP Extension Agent 12

asaSrvPropMetaDataTable

Adaptive Server Anywhere MIB 25

asaSrvStatMetaDataTable

Adaptive Server Anywhere MIB 24

AUDITING option

ASA SNMP Extension Agent OID 36

AUDITING_OPTIONS option

ASA SNMP Extension Agent OID 36

AuditingTypes property

ASA SNMP Extension Agent OID 34

AUTOMATIC_TIMESTAMP option

ASA SNMP Extension Agent OID 36

AvailIO property

ASA SNMP Extension Agent OID 27

BACKGROUND_PRIORITY option

ASA SNMP Extension Agent OID 36

BlankPadding property

ASA SNMP Extension Agent OID 34

BlobArenas property

ASA SNMP Extension Agent OID 34

BLOCKING option

ASA SNMP Extension Agent OID 36

BLOCKING_TIMEOUT option

ASA SNMP Extension Agent OID 36

Index

BytesReceived property

ASA SNMP Extension Agent OID 27

BytesReceivedUncomp property

ASA SNMP Extension Agent OID 27

BytesSent property

ASA SNMP Extension Agent OID 27

BytesSentUncomp property

ASA SNMP Extension Agent OID 27

C2 property

ASA SNMP Extension Agent OID 29

CacheHits property

ASA SNMP Extension Agent OID 31

CacheHitsEng property

ASA SNMP Extension Agent OID 27

CachePinned property

ASA SNMP Extension Agent OID 27

CacheRead property

ASA SNMP Extension Agent OID 31

CacheReadEng property

ASA SNMP Extension Agent OID 27

CacheReadIndInt property

ASA SNMP Extension Agent OID 31

CacheReadIndLeaf property

ASA SNMP Extension Agent OID 31

CacheReadTable property

ASA SNMP Extension Agent OID 31

CacheReplacements property

ASA SNMP Extension Agent OID 27

Capabilities property

ASA SNMP Extension Agent OID 34

CaseSensitive property

ASA SNMP Extension Agent OID 34

CaseSensitivePasswords property

ASA SNMP Extension Agent OID 34

CHAINED option

ASA SNMP Extension Agent OID 36

CharSet property

ASA SNMP Extension Agent OID 29, 34

CHECKPOINT_TIME option

ASA SNMP Extension Agent OID 36

CheckpointLogBitmapPagesWritten property

ASA SNMP Extension Agent OID 31

CheckpointLogBitmapSize property

ASA SNMP Extension Agent OID 31

CheckpointLogCommitToDisk property

ASA SNMP Extension Agent OID 31

CheckpointLogPageInUse property

ASA SNMP Extension Agent OID 31

CheckpointLogPagesRelocated property

ASA SNMP Extension Agent OID 31

CheckpointLogPagesWritten property

ASA SNMP Extension Agent OID 31

CheckpointLogSavePreimage property

ASA SNMP Extension Agent OID 31

CheckpointLogSize property

ASA SNMP Extension Agent OID 31

CheckpointLogWrites property

ASA SNMP Extension Agent OID 31

CheckpointUrgency property

ASA SNMP Extension Agent OID 31

Checksum property

ASA SNMP Extension Agent OID 34

Chkpt property

ASA SNMP Extension Agent OID 31

ChkptFlush property

ASA SNMP Extension Agent OID 31

ChkptPage property

ASA SNMP Extension Agent OID 31

CIS_OPTION option

ASA SNMP Extension Agent OID 36

CIS_ROWSET_SIZEoption

ASA SNMP Extension Agent OID 36

CLOSE_ON_ENDTRANS option

ASA SNMP Extension Agent OID 36

ClusteredIndexes property

ASA SNMP Extension Agent OID 34

Collation property

ASA SNMP Extension Agent OID 34

CommandLine property

ASA SNMP Extension Agent OID 29

CommitFile property

ASA SNMP Extension Agent OID 31

CompactPlatformVer property

ASA SNMP Extension Agent OID 29

CompanyName property

ASA SNMP Extension Agent OID 29

CompressedBTrees property

ASA SNMP Extension Agent OID 34

Compression property

ASA SNMP Extension Agent OID 34

ConnCount property

ASA SNMP Extension Agent OID 31

Index

CONNECTION_AUTHENTICATION option

ASA SNMP Extension Agent OID 36 ConnsDisabled property

ASA SNMP Extension Agent OID 29 ConsoleLogFile property

ASA SNMP Extension Agent OID 29 CONTINUE_AFTER_RAISERROR option

ASA SNMP Extension Agent OID 36 conventions

documentation viii CONVERSION_ERROR option

ASA SNMP Extension Agent OID 36 COOPERATIVE_COMMIT_TIMEOUT option

ASA SNMP Extension Agent OID 36 COOPERATIVE_COMMITS option

ASA SNMP Extension Agent OID 36 CurrentCacheSize property

ASA SNMP Extension Agent OID 27 CurrentRedoPos property

ASA SNMP Extension Agent OID 34 CurrIO property

ASA SNMP Extension Agent OID 31 CurrRead property

ASA SNMP Extension Agent OID 31 CurrWrite property

ASA SNMP Extension Agent OID 31

database options

OIDs for ASA SNMP Extension Agent 36

retrieving with the ASA SNMP Extension Agent

setting with the ASA SNMP Extension Agent 17 database properties

OIDs for ASA SNMP Extension Agent 33

retrieving with the ASA SNMP Extension Agent

setting with the ASA SNMP Extension Agent 17 database statistics

Adaptive Server Anywhere MIB 31

OIDs for ASA SNMP Extension Agent 31

retrieving with the ASA SNMP Extension Agent

DATABASE_AUTHENTICATION option

ASA SNMP Extension Agent OID 36 DATE_FORMAT option

ASA SNMP Extension Agent OID 36

DATE_ORDER option

ASA SNMP Extension Agent OID 36

DBFileFragments property

ASA SNMP Extension Agent OID 34

DEBUG_MESSAGES option

ASA SNMP Extension Agent OID 36

DEDICATED_TASK option

ASA SNMP Extension Agent OID 36

DEFAULT_TIMESTAMP_INCREMENT option

ASA SNMP Extension Agent OID 36

DefaultCollation property

ASA SNMP Extension Agent OID 29

DELAYED_COMMIT_TIMEOUT option

ASA SNMP Extension Agent OID 36

DELAYED_COMMITS option

ASA SNMP Extension Agent OID 36

DiskRead property

ASA SNMP Extension Agent OID 31

DiskReadEng property

ASA SNMP Extension Agent OID 27

DiskReadIndInt property

ASA SNMP Extension Agent OID 31

DiskReadIndLeaf property

ASA SNMP Extension Agent OID 31

DiskReadTable property

ASA SNMP Extension Agent OID 31

DiskWrite property

ASA SNMP Extension Agent OID 31

DIVIDE_BY_ZERO_ERROR option

ASA SNMP Extension Agent OID 36

documentation

conventions viii SQL Anywhere Studio vi

DriveType property

ASA SNMP Extension Agent OID 34

dynamic traps

about 19

Encryption property

ASA SNMP Extension Agent OID 34

ESCAPE_CHARACTER option

ASA SNMP Extension Agent OID 36

EXCLUDE_OPERATORS option

ASA SNMP Extension Agent OID 36

ExtendDB property

ASA SNMP Extension Agent OID 31

Index

EXTENDED_JOIN_SYNTAX option

ASA SNMP Extension Agent OID 36

ExtendTempWriteproperty

ASA SNMP Extension Agent OID 31

feedback

documentation xii providing xii

File property

ASA SNMP Extension Agent OID 34

FileSize property

ASA SNMP Extension Agent OID 34

FileVersion property

ASA SNMP Extension Agent OID 34

FipsMode property

ASA SNMP Extension Agent OID 29

FIRE_TRIGGERS option

ASA SNMP Extension Agent OID 36

FIRST_DAY_OF_WEEK option

ASA SNMP Extension Agent OID 36

FLOAT_AS_DOUBLE option

ASA SNMP Extension Agent OID 36

FOR_XML_NULL_TREATMENT option

ASA SNMP Extension Agent OID 36

FORCE_VIEW_CREATION option

ASA SNMP Extension Agent OID 36

FreeBuffers property

ASA SNMP Extension Agent OID 27

FreePageBitmaps property

ASA SNMP Extension Agent OID 34

FreePages property

ASA SNMP Extension Agent OID 34

FullCompare property

ASA SNMP Extension Agent OID 31

functions

executing using ASA SNMP Extension Agent 17

GetData property

ASA SNMP Extension Agent OID 31

GLOBAL_DATABASE_ID option

ASA SNMP Extension Agent OID 36

GlobalDBId property

ASA SNMP Extension Agent OID 34

HistogramHashFix property

ASA SNMP Extension Agent OID 34

Histograms property

ASA SNMP Extension Agent OID 34

HttpPorts property

ASA SNMP Extension Agent OID 29

HttpsPorts property

ASA SNMP Extension Agent OID 29

iAnywhere.mib ﬁle

about 7 location 24

icons

used in manuals x

IdleCheck property

ASA SNMP Extension Agent OID 31

IdleChkpt property

ASA SNMP Extension Agent OID 31

IdleTimeout property

ASA SNMP Extension Agent OID 29

IdleWrite property

ASA SNMP Extension Agent OID 31

IndAdd property

ASA SNMP Extension Agent OID 31

IndexStatistics property

ASA SNMP Extension Agent OID 34

IndLookup property

ASA SNMP Extension Agent OID 31

INTEGRATED_SERVER_NAME option

ASA SNMP Extension Agent OID 36

IOToRecover property

ASA SNMP Extension Agent OID 31

IQStore property

ASA SNMP Extension Agent OID 34

IsFipsAvailable property

ASA SNMP Extension Agent OID 29

IsIQ property

ASA SNMP Extension Agent OID 29

IsJavaAvailable property

ASA SNMP Extension Agent OID 29

IsNetworkServer property

ASA SNMP Extension Agent OID 29

ISOLATION_LEVEL option

ASA SNMP Extension Agent OID 36

Index

IsRuntimeServer property

ASA SNMP Extension Agent OID 29

JAVA_HEAP_SIZE option

ASA SNMP Extension Agent OID 36 JAVA_INPUT_OUTPUT option

ASA SNMP Extension Agent OID 36 JAVA_NAMESPACE_SIZE option

ASA SNMP Extension Agent OID 36 JAVA_PAGE_BUFFER_SIZE option

ASA SNMP Extension Agent OID 36 JavaGlobFix property

ASA SNMP Extension Agent OID 27 JavaHeapSize property

ASA SNMP Extension Agent OID 31 JavaNSSize property

ASA SNMP Extension Agent OID 31 JavaObjectsEnabled property

ASA SNMP Extension Agent OID 29 JDKVersion property

ASA SNMP Extension Agent OID 34

Language property

ASA SNMP Extension Agent OID 29, 34 LargeProcedureIDs property

ASA SNMP Extension Agent OID 34 LegalCopyright property

ASA SNMP Extension Agent OID 29 LegalTrademarks property

ASA SNMP Extension Agent OID 29 LicenseCount property

ASA SNMP Extension Agent OID 29 LicensedCompany property

ASA SNMP Extension Agent OID 29 LicensedUser property

ASA SNMP Extension Agent OID 29 LicensesInUse property

ASA SNMP Extension Agent OID 27 LicenseType property

ASA SNMP Extension Agent OID 29 LivenessTimeout property

ASA SNMP Extension Agent OID 29 LOCK_REJECTED_ROWS option

ASA SNMP Extension Agent OID 36 LockedHeapPages property

ASA SNMP Extension Agent OID 27

LockTablePages property

ASA SNMP Extension Agent OID 31

LOG_DEADLOCKS option

ASA SNMP Extension Agent OID 36

LOG_DETAILED_PLANS option

ASA SNMP Extension Agent OID 36

LOG_MAX_REQUESTS option

ASA SNMP Extension Agent OID 36

LogFileFragments property

ASA SNMP Extension Agent OID 34

LogFreeCommit property

ASA SNMP Extension Agent OID 31

LOGIN_MODE option

ASA SNMP Extension Agent OID 36

LOGIN_PROCEDURE option

ASA SNMP Extension Agent OID 36

LogMirrorName property

ASA SNMP Extension Agent OID 34

LogName property

ASA SNMP Extension Agent OID 34

LogWrite property

ASA SNMP Extension Agent OID 31

LTMGeneration property

ASA SNMP Extension Agent OID 34

LTMTrunc property

ASA SNMP Extension Agent OID 34

MachineName property

ASA SNMP Extension Agent OID 29

MainHeapBytes property

ASA SNMP Extension Agent OID 27

MainHeapPages property

ASA SNMP Extension Agent OID 27

management information bases

about 6

managers

about 6

MapPages property

ASA SNMP Extension Agent OID 31

MapPhysicalMemoryEng property

ASA SNMP Extension Agent OID 27

MAX_CURSOR_COUNT option

ASA SNMP Extension Agent OID 36

MAX_HASH_SIZE option

ASA SNMP Extension Agent OID 36

Index

MAX_PLANS_CACHED option

ASA SNMP Extension Agent OID 36

MAX_RECURSIVE_ITERATIONS option

ASA SNMP Extension Agent OID 36

MAX_STATEMENT_COUNT option

ASA SNMP Extension Agent OID 36

MAX_WORK_TABLE_HASH_SIZE option

ASA SNMP Extension Agent OID 36

MaxCacheSize property

ASA SNMP Extension Agent OID 27

MaxIO property

ASA SNMP Extension Agent OID 31

MaxMessage property

ASA SNMP Extension Agent OID 29

MaxRead property

ASA SNMP Extension Agent OID 31

MaxWrite property

ASA SNMP Extension Agent OID 31

MessageWindowSize property

ASA SNMP Extension Agent OID 29

metadata tables

Adaptive Server Anywhere MIB 24

MIBs see also management information bases

deﬁned 6 supported by ASA SNMP Extension Agent 6

MIN_PASSWORD_LENGTH option

ASA SNMP Extension Agent OID 36

MinCacheSize property

ASA SNMP Extension Agent OID 27

MultiByteCharSet property

ASA SNMP Extension Agent OID 34

MultiPacketsReceived property

ASA SNMP Extension Agent OID 27

MultiPacketsSent property

ASA SNMP Extension Agent OID 27

Name property

ASA SNMP Extension Agent OID 29, 34

NamedConstraints property

ASA SNMP Extension Agent OID 34

NativeProcessorArchitecture property

ASA SNMP Extension Agent OID 29

NEAREST_CENTURY option

ASA SNMP Extension Agent OID 36

newsgroups

technical support xii

NON_KEYWORDS option

ASA SNMP Extension Agent OID 36

NumProcessorsAvail property

ASA SNMP Extension Agent OID 29

NumProcessorsMax property

ASA SNMP Extension Agent OID 29

object identiﬁers see OIDs ODBC_DESCRIBE_BINARY_AS_VARBINARY

option

ASA SNMP Extension Agent OID 36

ODBC_DISTINGUISH_CHAR_AND_VARCHAR

option

ASA SNMP Extension Agent OID 36

OIDs see also object identiﬁers

about 6 Adaptive Server Anywhere MIB 23 database options 36 database properties 33 database statistics 31 deﬁned 6 RDBMS MIB 42 server properties 29 server statistics 27

OmniIdentiﬁer property

ASA SNMP Extension Agent OID 29

ON_CHARSET_CONVERSION_FAILUREoption

ASA SNMP Extension Agent OID 36

ON_TSQL_ERROR option

ASA SNMP Extension Agent OID 36

OPTIMISTIC_WAIT_FOR_COMMIT option

ASA SNMP Extension Agent OID 36

OPTIMIZATION_GOAL option

ASA SNMP Extension Agent OID 36

OPTIMIZATION_LEVEL option

ASA SNMP Extension Agent OID 36

OPTIMIZATION_LOGGING option

ASA SNMP Extension Agent OID 36

OPTIMIZATION_WORKLOAD option

ASA SNMP Extension Agent OID 36

options

database options in Adaptive Server Anywhere

MIB 36

PacketsReceived property

Index

ASA SNMP Extension Agent OID 27 PacketsReceivedUncomp property

ASA SNMP Extension Agent OID 27 PacketsSent property

ASA SNMP Extension Agent OID 27 PacketsSentUncomp property

ASA SNMP Extension Agent OID 27 PageRelocations property

ASA SNMP Extension Agent OID 31 PageSize property

ASA SNMP Extension Agent OID 29, 34 PeakCacheSize property

ASA SNMP Extension Agent OID 27 PINNED_CURSOR_PERCENT_OF_CACHE

option

ASA SNMP Extension Agent OID 36 Platform property

ASA SNMP Extension Agent OID 29 PlatformVer property

ASA SNMP Extension Agent OID 29 PRECISION option

ASA SNMP Extension Agent OID 36 PREFETCH option

ASA SNMP Extension Agent OID 36 PRESERVE_SOURCE_FORMAT option

ASA SNMP Extension Agent OID 36 PreserveSource property

ASA SNMP Extension Agent OID 34 PREVENT_ARTICLE_PKEY_UPDATEoption

ASA SNMP Extension Agent OID 36 ProcedurePages property

ASA SNMP Extension Agent OID 31 ProcedureProﬁling property

ASA SNMP Extension Agent OID 34 ProcessCPU property

ASA SNMP Extension Agent OID 29 ProcessCPUSystem property

ASA SNMP Extension Agent OID 29 ProcessCPUUser property

ASA SNMP Extension Agent OID 29 ProcessorArchitecture property

ASA SNMP Extension Agent OID 29 ProductName property

ASA SNMP Extension Agent OID 29 ProductVersion property

ASA SNMP Extension Agent OID 29 ProﬁleFilterConn property

ASA SNMP Extension Agent OID 29

ProﬁleFilterUser property

ASA SNMP Extension Agent OID 29

properties

database properties in Adaptive Server Anywhere

MIB 33

server property OIDs in Adaptive Server

Anywhere MIB 29

QUERY_PLAN_ON_OPEN option

ASA SNMP Extension Agent OID 36

QueryCachePages property

ASA SNMP Extension Agent OID 31

QueryLowMemoryStrategy property

ASA SNMP Extension Agent OID 31

QueryRowsMaterialized property

ASA SNMP Extension Agent OID 31

QuittingTime property

ASA SNMP Extension Agent OID 29

QUOTED_IDENTIFIER option

ASA SNMP Extension Agent OID 36

RDBMS MIB

about 9 list of tables 42

rdbmsDbInfoTable

description 42

rdbmsDbLimitedResourceTable

description 44

rdbmsDbParamTable

description 43

rdbmsDbTable

description 42

RDBMS-MIB.mib ﬁle

about 9 location 42

rdbmsSrvInfoTable

description 45

rdbmsSrvLimitedResourceTable

description 47

rdbmsSrvParamTable

description 46

rdbmsSrvTable

description 45

READ_PAST_DELETED option

Index

ASA SNMP Extension Agent OID 36

ReadOnly property

ASA SNMP Extension Agent OID 34

RECOVERY_TIME option

ASA SNMP Extension Agent OID 36

RecoveryUrgency property

ASA SNMP Extension Agent OID 31

RelocatableHeapPages property

ASA SNMP Extension Agent OID 31

RememberLastStatement property

ASA SNMP Extension Agent OID 29

REMOTE_IDLE_TIMEOUT option

ASA SNMP Extension Agent OID 36

RemoteputWait property

ASA SNMP Extension Agent OID 27

RemoteTrunc property

ASA SNMP Extension Agent OID 34

REPLICATE_ALL option

ASA SNMP Extension Agent OID 36

Req property

ASA SNMP Extension Agent OID 27

RequestFilterConn property

ASA SNMP Extension Agent OID 29

RequestFilterDB property

ASA SNMP Extension Agent OID 29

RequestLogFile property

ASA SNMP Extension Agent OID 29

RequestLogging property

ASA SNMP Extension Agent OID 29

RequestLogMaxSize property

ASA SNMP Extension Agent OID 29

RequestLogNumFiles property

ASA SNMP Extension Agent OID 29

RETURN_DATE_TIME_AS_STRING option

ASA SNMP Extension Agent OID 36

RETURN_JAVA_AS_STRING option

ASA SNMP Extension Agent OID 36

RI_TRIGGER_TIME option

ASA SNMP Extension Agent OID 36

ROLLBACK_ON_DEADLOCK option

ASA SNMP Extension Agent OID 36

RollbackLogPages property

ASA SNMP Extension Agent OID 31

ROW_COUNTSoption

ASA SNMP Extension Agent OID 36

SCALE option

ASA SNMP Extension Agent OID 36

SendFail property

ASA SNMP Extension Agent OID 27

SeparateCheckpointLog property

ASA SNMP Extension Agent OID 34

SeparateForeignKeys property

ASA SNMP Extension Agent OID 34

server properties

OIDs for ASA SNMP Extension Agent 29 retrieving with the ASA SNMP Extension Agent

setting with the ASA SNMP Extension Agent 17

server statistics

OIDs for ASA SNMP Extension Agent 27 retrieving with the ASA SNMP Extension Agent

15 simple network management protocol see SNMP SNMP

about 6 agents 6 dynamic traps 19 installing 10 managers 6 traps 6 using the ASA SNMP Extension Agent 3 using traps 18

SNMP service

restarting 11

SORT_COLLATION option

ASA SNMP Extension Agent OID 36

SQL Anywhere Studio

documentation vi

SQL_FLAGGER_ERROR_LEVEL option

ASA SNMP Extension Agent OID 36

SQL_FLAGGER_WARNING_LEVEL option

ASA SNMP Extension Agent OID 36

StartTime property

ASA SNMP Extension Agent OID 29

statistics

database statistics in Adaptive Server Anywhere

MIB 31

server statistics OIDs for ASA SNMP Extension

Agent 27 stored procedures

executing using ASA SNMP Extension Agent 17

Index

STRING_RTRUNCATIONoption

ASA SNMP Extension Agent OID 36

StringHistrogramsFix property

ASA SNMP Extension Agent OID 34

SUBSUME_ROW_LOCKS option

ASA SNMP Extension Agent OID 36

support

newsgroups xii

supported platforms

ASA SNMP Extension Agent 4

SUPPRESS_TDS_DEBUGGING option

ASA SNMP Extension Agent OID 36

SyncTrunc property

ASA SNMP Extension Agent OID 34

TableBitMaps property

ASA SNMP Extension Agent OID 34

TablesQualTriggers property

ASA SNMP Extension Agent OID 34

TDS_EMPTY_STRING_IS_NULL option

ASA SNMP Extension Agent OID 36

technical support

newsgroups xii

TEMP_SPACE_LIMIT_CHECK option

ASA SNMP Extension Agent OID 36

TempDirproperty

ASA SNMP Extension Agent OID 29

TempFileNameproperty

ASA SNMP Extension Agent OID 34

TempTablePages property

ASA SNMP Extension Agent OID 31

THREAD_COUNT option

ASA SNMP Extension Agent OID 36

THREAD_STACK option

ASA SNMP Extension Agent OID 36

THREAD_SWAPS option

ASA SNMP Extension Agent OID 36

Threads property

ASA SNMP Extension Agent OID 29

TIME_FORMAT option

ASA SNMP Extension Agent OID 36

TIME_ZONE_ADJUSTMENT option

ASA SNMP Extension Agent OID 36

TIMESTAMP_FORMAT option

ASA SNMP Extension Agent OID 36

TimeZoneAdjustment property

ASA SNMP Extension Agent OID 29

TotalBuffers property

ASA SNMP Extension Agent OID 27

TransactionsSpanLogs property

ASA SNMP Extension Agent OID 34

traps

about 6, 18 dynamic traps 19 using with ASA SNMP Extension Agent 18

TriggerPages property

ASA SNMP Extension Agent OID 31

TRUNCATE_DATE_VALUES option

ASA SNMP Extension Agent OID 36

TRUNCATE_TIMESTAMP_VALUES option

ASA SNMP Extension Agent OID 36

TRUNCATE_WITH_AUTO_COMMIT option

ASA SNMP Extension Agent OID 36

TSQL_HEX_CONSTANT option

ASA SNMP Extension Agent OID 36

TSQL_VARIABLES option

ASA SNMP Extension Agent OID 36

UniqueIdentiﬁer property

ASA SNMP Extension Agent OID 34

UnschReq property

ASA SNMP Extension Agent OID 27

UPDATE_STATISTICS option

ASA SNMP Extension Agent OID 36

UPGRADE_DATABASE_CAPABILITY option

ASA SNMP Extension Agent OID 36

USER_ESTIMATES option

ASA SNMP Extension Agent OID 36

VariableHashSize property

ASA SNMP Extension Agent OID 34

ViewPages property

ASA SNMP Extension Agent OID 31

WAIT_FOR_COMMIT option

ASA SNMP Extension Agent OID 36

Windows 2000

installing SNMP 10

Windows 2003

Index

installing SNMP 10

Windows XP

installing SNMP 10

Sybase Adaptive Server Anywhere SNMP Extension Agent User Manual

Specifications and Main Features

Frequently Asked Questions

User Manual

Contents

About This Manual

SQL Anywhere Studio documentation

Documentation conventions

The Adaptive Server Anywhere sample database

Finding out more and providing feedback

The Adaptive Server Anywhere SNMP Extension Agent

Introduction to the Adaptive Server Anywhere SNMP Extension Agent

Understanding SNMP

The Adaptive Server Anywhere MIB

The RDBMS MIB

Using the Adaptive Server Anywhere SNMP Extension Agent

Installing SNMP

Obtaining values using the Adaptive Server Anywhere SNMP Extension Agent

Setting values using the Adaptive Server Anywhere SNMP Extension Agent

Executing stored procedures using the Adaptive Server Anywhere SNMP Extension Agent

Using traps

Creating dynamic traps

Adaptive Server Anywhere MIB Reference

The Adaptive Server Anywhere MIB

Agent

asaMetaData tables

asaSrvMetaData.asaSrvStatMetaDataTable

asaSrvMetaData.asaSrvPropMetaDataTable

asaDbMetaData.asaDbStatMetaDataTable

asaDbMetaData.asaDbPropMetaDataTable

asaDbMetaData.asaDbOptMetaDataTable

Server statistics

Server properties

Database statistics

Database properties

Database options

RDBMS MIB Reference

The RDBMS MIB

rdbmsDbTable

rdbmsDbInfoTable

rdbmsDbParamTable

rdbmsDbLimitedResourceTable

rdbmsSrvTable

rdbmsSrvInfoTable

rdbmsSrvParamTable

rdbmsSrvLimitedResourceTable

Index