Instruction/ maintenance manual of the product Adaptive Server Anywhere SNMP Extension Agent Sybase
Go to page of 70
Adaptiv e Ser v er ® An ywhere SNMP Extension Agent User’ s Guide Part number: DC00192-01-0902-01 Last modified: 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.
Contents About This Manual v SQL An ywhere Studio documentation . . . . . . . . . . . . . vi Documentation conventions . . . . . . . . . . . . . . . . . . . ix The Adaptive Ser ver Anywhere sample database . . . . . . . xi Finding out more and providing feedbac k .
iv.
About This Manual Subject This book cov ers material related to running and configuring the Adapti ve Server An ywhere SNMP Extension Agent. A udience This manual is for Adaptiv e Server Anywhere users who wish to use the Adaptiv e Server Anywhere SNMP Extension Agent on W indows 2000, W indows XP , or W indo ws Server 2003 (32-bit v ersions).
SQL An ywhere 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.
♦ SQL Anywhere Studio Security Guide This book provides information about security features in Adaptiv e Server Anywhere databases. Adaptive Serv er Anywhere 7.0 was awarded a TCSEC (T rusted Computer System Ev aluation Criteria) C2 security rating from the U.
♦ 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 dev elopment, and others are provided as static interfaces for C, C++, and Ja va de velopment.
Documentation con ventions This section lists the typographic and graphical con ventions used in this documentation. Syntax conv entions The following con ventions are used in the SQL syntax descriptions: ♦ Ke ywor ds All SQL keywords appear in upper case, like the w ords AL TER T ABLE in the following e xample: AL TER T ABLE [ owner .
Graphic icons The following icons are used in this documentation. ♦ A client application. ♦ A database server , such as Sybase Adaptiv e Server An ywhere. ♦ A database. In some high-level diagrams, the icon may be used to represent both the database and the database server that manages it.
The Adaptive Server Anywhere sample database Many of the e xamples throughout the documentation use the Adapti ve Server An ywhere sample database. The sample database is held in a file named asademo.db , and is located in your SQL Anywhere directory .
Finding out more and pr o viding feedbac k W e would like to recei ve your opinions, suggestions, and feedback on this documentation. Y ou can provide feedback on this documentation and on the software through newsgroups set up to discuss SQL An ywhere technologies.
P A R T I U SING THE A D APTIVE S E R V E R A NYWHERE S N M P E XTENSION A G E N T This part describes how to set up and configure the Adaptiv e Server Anywhere SNMP Extension Agent.
.
CHAPTER 1 The Adaptive Server Anywhere SNMP Extension Agent About this chapter This chapter introduces you to the Adaptiv e Server Anywhere SNMP Extension Agent.
Intr oduction to the Adaptive Server Anywhere SNMP Extension Agent If you are running Adaptiv e Server Anywhere on W indows 2000, W indows XP , or W indows Serv er 2003 (32-bit versions), you can use .
Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent ♦ asasnmp.ini This file lists the databases that the Adaptiv e Server Anywhere SNMP Extension Agent monitors. By default, this file is located in C:Program FilesSybaseSQL Anywhere 9win32 .
Understanding SNMP Simple Network Management Protocol ( SNMP ) is a standard protocol used for network management. SNMP allows managers and agents to communicate: managers send requests to agents, and agents respond to queries from managers. Additionally , agents can notify managers when specific ev ents occur using notifications called traps .
Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent The Adaptive Server Anywhere MIB The Adaptiv e Server Anywhere MIB was created for the Adapti ve Server Anywhere SNMP Extension Agent. It includes all database server statistics and properties, as well as all database statistics, properties, and options.
OID Name Description 1.3.6.1.4.897.2.3.3. db asaAgent.asaConnected Returns whether the Adaptiv e Server An ywhere Extension Agent is connected to database db .
Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent asaMetaData tables The Adaptiv e Server Anywhere MIB includes metadata tables that provide a way to query the Adapti ve Server Anywhere Extension Agent to find out which variables are supported.
Using the Adaptive Server Anywhere SNMP Extension Agent In order to use the Adaptiv e Server Anywhere SNMP Extension Agent, you must hav e SNMP installed on your machine and you must create an asasnmp.ini file that contains information about the databases that are monitored by the Adaptiv e Server Anywhere SNMP Extension Agent.
Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent ❖ T o check that the SNMP services are installed on y our computer 1. Open the Control Panel. ♦ On W indows 2000, from the Start menu choose Settings ➤ Control Panel. ♦ On W indows XP , from the Start menu choose Control Panel.
Configuring the Adaptive Server Anywhere SNMP Extension Agent The Adaptiv e Server Anywhere Extension Agent can monitor one or more databases. The databases to be monitored are stored in the asasnmp.
Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent ❖ T o restar t the Adaptive Server An ywhere 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 . Y ou can obfuscate the contents of the asasnmp.
• names the connection so it can be identified • prev ents the database from being shut down when the Adapti ve Serv er Anywhere SNMP Extension Agent disconnects If you specify any of these v alues in the connection string in the asasnmp.ini file, the values in the asasnmp.
Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent starting at 1. Skipping numbers is not allowed. This field is optional. Disabled If set to 1, this database entry is skipped by the Adapti ve Serv er Anywhere SNMP Extension Agent.
☞ For a list of the database serv er 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 .
Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent Setting values using the Adaptive Ser ver An ywhere SNMP Extension Agent The Adaptiv e Server Anywhere SNMP Extension Agent responds to SNMP get, get-next, and set queries.
For e xample, 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 v alue of this OID to the procedure name will depend on your SNMP management software.
Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent Adaptive Server Anywhere SNMP Extension Agent traps The Adaptiv e Server Anywhere SNMP Extension Agent sends a trap whenev er a connection is dropped by the database server . The OID of this trap is 1.
Note Only equality or inequality are supported for string values. value is the v alue 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.
P A R T I I A D APTIVE S E R V E R A NYWHERE SNMP E XTENSION A G E N T R E F E R E N C E This section lists the OIDs supported by the Adaptiv e Server Anywhere SNMP Extension Agent. It lists the contents of the tables in the Adaptive Server An ywhere MIB and the RDBMS MIB.
.
CHAPTER 2 Adaptive Server Anywhere MIB Ref erence About this chapter This chapter contains descriptions of the tables in the Adaptiv e Server Anywhere MIB.
The Adaptive Server Anywhere MIB The following sections list the OIDs of the statistics, properties, and options that can be retriev ed and set using the Adaptive Serv er Anywhere SNMP Extension Agent. By default, Agent The Agent table lists information about the Adaptiv e Server Anywhere SNMP Extension Agent.
Chapter 2. Adaptive Server Anywhere MIB Ref erence OID T ype Name V alue returned 1.3.6.1.4.1.897.2.4.1.1.1.1. db Integer32 asaSrvStatInde x db 1.3.6.1.4.1.897.2.4.1.1.1.2. db Integer32 asaSrvStatObjT ype 1 1 1.3.6.1.4.1.897.2.4.1.1.1.3. db Integer32 asaSrvStatT ype 1 2 1.
The value db is the database number in the asasnmp.ini file. OID T ype Name V alue returned 1.3.6.1.4.1.897.2.4.2.1.1.1. db Integer32 asaDbStatInde x db 1.3.6.1.4.1.897.2.4.2.1.1.2. db Integer32 asaDbStatObjT ype 2 1 1.3.6.1.4.1.897.2.4.2.1.1.3. db Integer32 asaDbStatT ype 1 2 1.
Chapter 2. Adaptive Server Anywhere MIB Ref erence asaDbMetaData.asaDbOptMetaDataT able This table contains metadata about the database options. The value db is the database number in the asasnmp.ini file. OID T ype Name V alue returned 1.3.6.1.4.1.897.
OID T ype Name Statistic 1.3.6.1.4.1.897.2.1.1.9. n Counter64 srvStatCacheReadEng CacheReadEng 1.3.6.1.4.1.897.2.1.1.10. n Counter64 srvStatCacheReplacements CacheReplacements 1.3.6.1.4.1.897.2.1.1.11. n Integer32 srvStatCurrentCacheSize CurrentCacheSize 1.
Chapter 2. Adaptive Server Anywhere MIB Ref erence Server properties The following table lists OIDs and names of the database server properties that can be retriev ed using the Adaptive Serv er Anywhere SNMP Extension Agent. Writable properties are marked with an asterisk (*).
OID T ype Name Property 1.3.6.1.4.1.897.2.1.2.23. n String srvPropMachineName MachineName 1.3.6.1.4.1.897.2.1.2.24. n String srvPropMaxMessage MaxMessage 1.3.6.1.4.1.897.2.1.2.25. n String srvPropMessageW indowSize MessageW indowSize 1.3.6.1.4.1.897.2.
Chapter 2. Adaptive Server Anywhere MIB Ref erence OID T ype Name Property 1.3.6.1.4.1.897.2.1.2.49. n String srvPropThreads Threads 1.3.6.1.4.1.897.2.1.2.50. n String srvPropT imeZoneAdjustment T imeZoneAdjustment 1.3.6.1.4.1.897.2.1.2.51. n String srvPropHttpPorts HttpPorts 1.
OID T ype Name Property 1.3.6.1.4.1.897.2.2.1.12. n Integer32 dbStatCheckpointLogCommit- T oDisk CheckpointLogCommit- T oDisk 1.3.6.1.4.1.897.2.2.1.13. n Integer32 dbStatCheckpointLogP ageI- nUse CheckpointLogPageInUse 1.3.6.1.4.1.897.2.2.1.14. n Integer32 dbStatCheckpointLogP agesRe- located CheckpointLogPagesRelo- cated 1.
Chapter 2. Adaptive Server Anywhere MIB Ref erence OID T ype Name Property 1.3.6.1.4.1.897.2.2.1.36. n Integer32 dbStatIdleWrite IdleWrite 1.3.6.1.4.1.897.2.2.1.37. n Integer32 dbStatIndAdd IndAdd 1.3.6.1.4.1.897.2.2.1.38. n Integer32 dbStatIndLookup IndLookup 1.
can be retriev ed using the Adaptive Serv er Anywhere SNMP Extension Agent. Writable properties are marked with an asterisk (*). The value n is the database number in the asasnmp.ini file. OID T ype Name Pr oper ty 1.3.6.1.4.1.897.2.2.2.1. n String dbPropAlias Alias 1.
Chapter 2. Adaptive Server Anywhere MIB Ref erence OID T ype Name Pr operty 1.3.6.1.4.1.897.2.2.2.25. n String dbPropHistograms Histograms 1.3.6.1.4.1.897.2.2.2.26. n String dbPropIndexStatistics IndexStatistics 1.3.6.1.4.1.897.2.2.2.27. n String dbPropIQStore IQStore 1.
OID T ype Name Pr oper ty 1.3.6.1.4.1.897.2.2.2.53. n String dbPropUniqueIdentifier UniqueIdentifier Database options The following table lists the OIDs and names of the database options that can be retriev ed using the Adaptive Serv er Anywhere SNMP Extension Agent.
Chapter 2. Adaptive Server Anywhere MIB Ref erence OID T ype Name Option 1.3.6.1.4.1.897.2.2.3.19. n String dbOptConnectionAuthentica- tion* Connection_authentication 1.3.6.1.4.1.897.2.2.3.20. n String dbOptContinueAfterRaiseer- ror* Continue_after_raise_error 1.
OID T ype Name Option 1.3.6.1.4.1.897.2.2.3.43. n Integer32 dbOptJa v aHeapSize* Jav a_heap_size 1.3.6.1.4.1.897.2.2.3.44. n String dbOptJav aInputOutput* Jav a_input_output 1.3.6.1.4.1.897.2.2.3.45. n Integer32 dbOptJa v aNamespaceSize* Jav a_namespace_size 1.
Chapter 2. Adaptive Server Anywhere MIB Ref erence OID T ype Name Option 1.3.6.1.4.1.897.2.2.3.67. n Integer32 dbOptOptimizationLe vel* Optimization_lev el 1.3.6.1.4.1.897.2.2.3.68. n String dbOptOptimizationLogging* Optimization_logging 1.3.6.1.4.1.897.
OID T ype Name Option 1.3.6.1.4.1.897.2.2.3.91. n String dbOptTDSEmptyStringIs- Null* TDS_empty_string_is_null 1.3.6.1.4.1.897.2.2.3.92. n Integer32 dbOptThreadCount* Thread_count 1.3.6.1.4.1.897.2.2.3.93. n Integer32 dbOptThreadStack* Thread_stack 1.
CHAPTER 3 RDBMS MIB Reference About this chapter This chapter contains descriptions of each of the tables in the RDBMS MIB. Contents T opic: page The RDBMS MIB 42 41.
The RDBMS MIB The following sections list the OIDs of the v alues that can be retriev ed using the Adaptiv e Server Anywhere SNMP Extension Agent. By default, the RDBMS MIB is located in C:Program FilesSybaseSQL Anywhere 9snmpRDBMS-MIB.mib . rdbmsDbT able This table lists information about the databases installed on a system.
Chapter 3. RDBMS MIB Reference OID T ype Name V alue returned 1.3.6.1.2.1.39.1.2.1.3. db Integer rdbmsDbInfoSizeUnits Calculated based on dbInfoSizeAllo- cated and dbInfoSizeUsed. ♦ 1=bytes ♦ 2=KB ♦ 3=MB ♦ 4=GB ♦ 5=TB (Each unit is 1024 times the previ- ous.
1 This OID is not currently supported by the Adaptiv e Server Anywhere SNMP Extenstion Agent. rdbmsDbLimitedResour ceT able This table lists free space information on each dbspace.
Chapter 3. RDBMS MIB Reference rdbmsSrvT able This table lists the database servers running or installed on your system. The value db is the database number in the asasnmp.ini file. OID T ype Name V alue returned 1.3.6.1.2.1.39.1.5.1.1. db OID rdbmsSrvPriv ateMibOID 1.
OID T ype Name V alue returned 1.3.6.1.2.1.39.1.6.1.13. db Integer rdbmsSrvInfoHighwaterInboundAs- sociations 0 1 1.3.6.1.2.1.39.1.6.1.14. db Integer rdbmsSrvInfoMaxInboundAssocia- tions 0 1 1 This OID is not currently supported by the Adaptiv e Server Anywhere SNMP Extenstion Agent.
Chapter 3. RDBMS MIB Reference The value db is the database number in the asasnmp.ini file, while n is the index of the resource as follo ws: n Name Resource Resource limit 1 Connec- tions prop- erty.
48.
Inde x A Activ eReq property ASA SNMP Extension Agent OID 27 Adaptiv e Server Anywhere MIB about 7 Agent table 24 asaDbOptMetaDataT able 27 asaDbPropMetaDataT able 26 asaDbStatMetaDataT able 26 asaMet.
Inde x BytesReceiv ed property ASA SNMP Extension Agent OID 27 BytesReceiv edUncomp property ASA SNMP Extension Agent OID 27 BytesSent property ASA SNMP Extension Agent OID 27 BytesSentUncomp property.
Inde x CONNECTION_A UTHENTICA TION 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_.
Inde x EXTENDED_JOIN_SYNT AX option ASA SNMP Extension Agent OID 36 ExtendT empWrite property ASA SNMP Extension Agent OID 31 F feedback documentation xii providing xii File property ASA SNMP Extensio.
Inde x IsRuntimeServer property ASA SNMP Extension Agent OID 29 J J A V A_HEAP_SIZE option ASA SNMP Extension Agent OID 36 J A V A_INPUT_OUTPUT option ASA SNMP Extension Agent OID 36 J A V A_NAMESP AC.
Inde x MAX_PLANS_CA CHED option ASA SNMP Extension Agent OID 36 MAX_RECURSIVE_ITERA TIONS option ASA SNMP Extension Agent OID 36 MAX_ST A TEMENT_COUNT option ASA SNMP Extension Agent OID 36 MAX_WORK_T.
Inde x ASA SNMP Extension Agent OID 27 PacketsRecei vedUncomp property ASA SNMP Extension Agent OID 27 PacketsSent property ASA SNMP Extension Agent OID 27 PacketsSentUncomp property ASA SNMP Extensio.
Inde x ASA SNMP Extension Agent OID 36 ReadOnly property ASA SNMP Extension Agent OID 34 RECO VER Y_TIME option ASA SNMP Extension Agent OID 36 Recov eryUrgenc y property ASA SNMP Extension Agent OID .
Inde x STRING_R TR UNCA TION option ASA SNMP Extension Agent OID 36 StringHistrogramsFix property ASA SNMP Extension Agent OID 34 SUBSUME_R OW_LOCKS option ASA SNMP Extension Agent OID 36 support news.
Inde x installing SNMP 10 W indows XP installing SNMP 10 58.
An important point after buying a device Sybase Adaptive Server Anywhere SNMP Extension Agent (or even before the purchase) is to read its user manual. We should do this for several simple reasons:
If you have not bought Sybase Adaptive Server Anywhere SNMP Extension Agent yet, this is a good time to familiarize yourself with the basic data on the product. First of all view first pages of the manual, you can find above. You should find there the most important technical data Sybase Adaptive Server Anywhere SNMP Extension Agent - thus you can check whether the hardware meets your expectations. When delving into next pages of the user manual, Sybase Adaptive Server Anywhere SNMP Extension Agent you will learn all the available features of the product, as well as information on its operation. The information that you get Sybase Adaptive Server Anywhere SNMP Extension Agent will certainly help you make a decision on the purchase.
If you already are a holder of Sybase Adaptive Server Anywhere SNMP Extension Agent, but have not read the manual yet, you should do it for the reasons described above. You will learn then if you properly used the available features, and whether you have not made any mistakes, which can shorten the lifetime Sybase Adaptive Server Anywhere SNMP Extension Agent.
However, one of the most important roles played by the user manual is to help in solving problems with Sybase Adaptive Server Anywhere SNMP Extension Agent. Almost always you will find there Troubleshooting, which are the most frequently occurring failures and malfunctions of the device Sybase Adaptive Server Anywhere SNMP Extension Agent along with tips on how to solve them. Even if you fail to solve the problem, the manual will show you a further procedure – contact to the customer service center or the nearest service center
