Sybase Adaptive Server Anywhere SNMP Extension Agent Manuale Utente Pagina 1

Adaptive Server®AnywhereSNMP Extension AgentUser’s GuidePart number: DC00192-01-0902-01Last modified: December 2004

Graphic icons The following icons are used in this documentation.♦ A client application.♦ A database server, such as Sybase Adaptive Server Anywhere.♦

The Adaptive Server Anywhere sample databaseMany of the examples throughout the documentation use the AdaptiveServer Anywhere sample database.The samp

Finding out more and providing feedbackWe would like to receive your opinions, suggestions, and feedback on thisdocumentation.You can provide feedback

PART IUSING THE ADAPTIVESERVER ANYWHERESNMP EXTENSION AGENTThis part describes how to set up and configure the Adaptive ServerAnywhere SNMP Extension A

CHAPTER 1The Adaptive Server Anywhere SNMPExtension AgentAbout this chapter This chapter introduces you to the Adaptive Server Anywhere SNMPExtension

Introduction to the Adaptive Server AnywhereSNMP Extension AgentIf you are running Adaptive Server Anywhere on Windows 2000, WindowsXP, or Windows Ser

Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent♦ asasnmp.ini This file lists the databases that the Adaptive ServerAnywhere SNMP Extension

Understanding SNMPSimple Network Management Protocol (SNMP) is a standard protocol usedfor network management. SNMP allows managers and agents tocommu

Chapter 1. The Adaptive Server Anywhere SNMP Extension AgentThe Adaptive Server Anywhere MIBThe Adaptive Server Anywhere MIB was created for the Adapt

Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.No part of this publication may be rep

OID Name Description1.3.6.1.4.897.2.3.3.dbasaAgent.asaConnected Returns whether the AdaptiveServer Anywhere Extension Agentis connected to databasedb.

Chapter 1. The Adaptive Server Anywhere SNMP Extension AgentasaMetaData tables The Adaptive Server Anywhere MIB includes metadata tables that provide

Using the Adaptive Server Anywhere SNMPExtension AgentIn order to use the Adaptive Server Anywhere SNMP Extension Agent, youmust have SNMP installed o

Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent❖ To check that the SNMP services are installed on your computer1. Open the Control Panel.

Configuring the Adaptive Server Anywhere SNMP Extension AgentThe Adaptive Server Anywhere Extension Agent can monitor one or moredatabases. The databas

Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent❖ To restart the Adaptive Server Anywhere SNMP Extension Agent1. Using your SNMP managemen

• names the connection so it can be identified• prevents the database from being shut down when the Adaptive ServerAnywhere SNMP Extension Agent discon

Chapter 1. The Adaptive Server Anywhere SNMP Extension Agentstarting at 1. Skipping numbers is not allowed. This field is optional.Disabled If set to 1

☞ 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

Chapter 1. The Adaptive Server Anywhere SNMP Extension AgentSetting values using the Adaptive Server Anywhere SNMP ExtensionAgentThe Adaptive Server A

ContentsAbout This Manual vSQL Anywhere Studio documentation . . . . . . . . . . . . . viDocumentation conventions . . . . . . . . . . . . . . . . . .

For example, setting the value of asaAgent.asaProc to the string“pchin.updatesales( ’param1’, 2)” calls the updatesales storedprocedure owned by user

Chapter 1. The Adaptive Server Anywhere SNMP Extension AgentAdaptive ServerAnywhere SNMPExtension Agent trapsThe Adaptive Server Anywhere SNMP Extensi

NoteOnly equality or inequality are supported for string values.value is the value to use in the expression. String values may be enclosedin single or

PART IIADAPTIVE SERVERANYWHERE SNMPEXTENSION AGENTREFERENCEThis section lists the OIDs supported by the Adaptive Server AnywhereSNMP Extension Agent.

CHAPTER 2Adaptive Server Anywhere MIB ReferenceAbout this chapter This chapter contains descriptions of the tables in the Adaptive ServerAnywhere MIB.

The Adaptive Server Anywhere MIBThe following sections list the OIDs of the statistics, properties, and optionsthat can be retrieved and set using the

Chapter 2. Adaptive Server Anywhere MIB ReferenceOID Type Name Value returned1.3.6.1.4.1.897.2.4.1.1.1.1.dbInteger32 asaSrvStatIndexdb1.3.6.1.4.1.897.

The valuedbis the database number in theasasnmp.inifile.OID Type Name Value returned1.3.6.1.4.1.897.2.4.2.1.1.1.dbInteger32 asaDbStatIndexdb1.3.6.1.4.1

Chapter 2. Adaptive Server Anywhere MIB ReferenceasaDbMetaData.asaDbOptMetaDataTableThis table contains metadata about the database options.The valued

iv

OID Type Name Statistic1.3.6.1.4.1.897.2.1.1.9.nCounter64 srvStatCacheReadEng CacheReadEng1.3.6.1.4.1.897.2.1.1.10.nCounter64 srvStatCacheReplacements

Chapter 2. Adaptive Server Anywhere MIB ReferenceServer propertiesThe following table lists OIDs and names of the database server propertiesthat can b

OID Type Name Property1.3.6.1.4.1.897.2.1.2.23.nString srvPropMachineName MachineName1.3.6.1.4.1.897.2.1.2.24.nString srvPropMaxMessage MaxMessage1.3.

Chapter 2. Adaptive Server Anywhere MIB ReferenceOID Type Name Property1.3.6.1.4.1.897.2.1.2.49.nString srvPropThreads Threads1.3.6.1.4.1.897.2.1.2.50

OID Type Name Property1.3.6.1.4.1.897.2.2.1.12.nInteger32 dbStatCheckpointLogCommit-ToDiskCheckpointLogCommit-ToDisk1.3.6.1.4.1.897.2.2.1.13.nInteger3

Chapter 2. Adaptive Server Anywhere MIB ReferenceOID Type Name Property1.3.6.1.4.1.897.2.2.1.36.nInteger32 dbStatIdleWrite IdleWrite1.3.6.1.4.1.897.2.

can be retrieved using the Adaptive Server Anywhere SNMP ExtensionAgent.Writable properties are marked with an asterisk (*). The valuenis thedatabase

Chapter 2. Adaptive Server Anywhere MIB ReferenceOID Type Name Property1.3.6.1.4.1.897.2.2.2.25.nString dbPropHistograms Histograms1.3.6.1.4.1.897.2.2

OID Type Name Property1.3.6.1.4.1.897.2.2.2.53.nString dbPropUniqueIdentifier UniqueIdentifierDatabase optionsThe following table lists the OIDs and nam

Chapter 2. Adaptive Server Anywhere MIB ReferenceOID Type Name Option1.3.6.1.4.1.897.2.2.3.19.nString dbOptConnectionAuthentica-tion*Connection_authen

About This ManualSubject This book covers material related to running and configuring the AdaptiveServer Anywhere SNMP Extension Agent.Audience This ma

OID Type Name Option1.3.6.1.4.1.897.2.2.3.43.nInteger32 dbOptJavaHeapSize* Java_heap_size1.3.6.1.4.1.897.2.2.3.44.nString dbOptJavaInputOutput* Java_i

Chapter 2. Adaptive Server Anywhere MIB ReferenceOID Type Name Option1.3.6.1.4.1.897.2.2.3.67.nInteger32 dbOptOptimizationLevel* Optimization_level1.3

OID Type Name Option1.3.6.1.4.1.897.2.2.3.91.nString dbOptTDSEmptyStringIs-Null*TDS_empty_string_is_null1.3.6.1.4.1.897.2.2.3.92.nInteger32 dbOptThrea

CHAPTER 3RDBMS MIB ReferenceAbout this chapter This chapter contains descriptions of each of the tables in the RDBMS MIB.ContentsTopic: pageThe RDBMS

The RDBMS MIBThe following sections list the OIDs of the values that can be retrieved usingthe Adaptive Server Anywhere SNMP Extension Agent. By defau

Chapter 3. RDBMS MIB ReferenceOID Type Name Value returned1.3.6.1.2.1.39.1.2.1.3.dbInteger rdbmsDbInfoSizeUnits Calculated based on dbInfoSizeAllo-cat

1This OID is not currently supported by the Adaptive Server AnywhereSNMP Extenstion Agent.rdbmsDbLimitedResourceTableThis table lists free space infor

Chapter 3. RDBMS MIB ReferencerdbmsSrvTableThis table lists the database servers running or installed on your system.The valuedbis the database number

OID Type Name Value returned1.3.6.1.2.1.39.1.6.1.13.dbInteger rdbmsSrvInfoHighwaterInboundAs-sociations011.3.6.1.2.1.39.1.6.1.14.dbInteger rdbmsSrvInf

Chapter 3. RDBMS MIB ReferenceThe valuedbis the database number in theasasnmp.inifile, whilenis theindex of the resource as follows:nName Resource Reso

SQL Anywhere Studio documentationThis book is part of the SQL Anywhere documentation set. This sectiondescribes the books in the documentation set and

48

IndexAActiveReq propertyASA SNMP Extension Agent OID 27Adaptive Server Anywhere MIBabout 7Agent table 24asaDbOptMetaDataTable 27asaDbPropMetaDataTable

IndexBytesReceived propertyASA SNMP Extension Agent OID 27BytesReceivedUncomp propertyASA SNMP Extension Agent OID 27BytesSent propertyASA SNMP Extens

IndexCONNECTION_AUTHENTICATION optionASA SNMP Extension Agent OID 36ConnsDisabled propertyASA SNMP Extension Agent OID 29ConsoleLogFile propertyASA SN

IndexEXTENDED_JOIN_SYNTAX optionASA SNMP Extension Agent OID 36ExtendTempWrite propertyASA SNMP Extension Agent OID 31Ffeedbackdocumentation xiiprovid

IndexIsRuntimeServer propertyASA SNMP Extension Agent OID 29JJAVA_HEAP_SIZE optionASA SNMP Extension Agent OID 36JAVA_INPUT_OUTPUT optionASA SNMP Exte

IndexMAX_PLANS_CACHED optionASA SNMP Extension Agent OID 36MAX_RECURSIVE_ITERATIONS optionASA SNMP Extension Agent OID 36MAX_STATEMENT_COUNT optionASA

IndexASA SNMP Extension Agent OID 27PacketsReceivedUncomp propertyASA SNMP Extension Agent OID 27PacketsSent propertyASA SNMP Extension Agent OID 27Pa

IndexASA SNMP Extension Agent OID 36ReadOnly propertyASA SNMP Extension Agent OID 34RECOVERY_TIME optionASA SNMP Extension Agent OID 36RecoveryUrgency

IndexSTRING_RTRUNCATION optionASA SNMP Extension Agent OID 36StringHistrogramsFix propertyASA SNMP Extension Agent OID 34SUBSUME_ROW_LOCKS optionASA S

♦ SQL Anywhere Studio Security Guide This book providesinformation about security features in Adaptive Server Anywheredatabases. Adaptive Server Anywh

Indexinstalling SNMP 10Windows XPinstalling SNMP 1058

♦ UltraLite Interface Guides A separate book is provided for eachUltraLite programming interface. Some of these interfaces are providedas UltraLite co

Documentation conventionsThis section lists the typographic and graphical conventions used in thisdocumentation.Syntax conventions The following conve