Adaptive Server® Anywhere 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. iAnywhere Solutions, Inc. is a subsidiary of Sybase, Inc.
Contents About This Manual SQL Anywhere Studio documentation . . . . . . Documentation conventions . . . . . . . . . . . . The Adaptive Server Anywhere sample database Finding out more and providing feedback . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . v vi ix xi xii I Using the Adaptive Server Anywhere SNMP Extension Agent 1 1 The Adaptive Server Anywhere SNMP Extension Agent Introduction to the Adaptive Server Anywhere SNMP Extension Agent . . . . . . . . . . . . . . . . . . .
iv
About This Manual Subject This book covers material related to running and configuring the Adaptive Server Anywhere SNMP Extension Agent. Audience This manual is for Adaptive Server Anywhere users who wish to use the Adaptive Server Anywhere SNMP Extension Agent on Windows 2000, Windows XP, or Windows Server 2003 (32-bit versions). It is to be used in conjunction with other manuals in the documentation set.
SQL Anywhere Studio documentation This book is part of the SQL Anywhere documentation set. This section describes the books in the documentation set and how you can use them. The SQL Anywhere Studio documentation The SQL Anywhere Studio documentation is available in a variety of forms: in an online form that combines all books in one large help file; as separate PDF files for each book; and as printed books that you can purchase.
♦ SQL Anywhere Studio Security Guide This book provides information about security features in Adaptive Server Anywhere databases. Adaptive Server Anywhere 7.0 was awarded a TCSEC (Trusted Computer System Evaluation Criteria) C2 security rating from the U.S. Government. This book may be of interest to those who wish to run the current version of Adaptive Server Anywhere in a manner equivalent to the C2-certified environment.
♦ 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 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.
Graphic icons The following icons are used in this documentation. ♦ A client application. ♦ A database server, such as Sybase Adaptive Server Anywhere. ♦ A database. In some high-level diagrams, the icon may be used to represent both the database and the database server that manages it. ♦ Replication or synchronization middleware. These assist in sharing data among databases. Examples are the MobiLink Synchronization Server and the SQL Remote Message Agent. ♦ A programming interface.
The Adaptive Server Anywhere sample database Many of the examples throughout the documentation use the Adaptive Server Anywhere sample database. The sample database is held in a file named asademo.db, and is located in your SQL Anywhere directory. The sample database represents a small company. It contains internal information about the company (employees, departments, and finances) as well as product information and sales information (sales orders, customers, and contacts).
Finding out more and providing feedback We would like to receive your opinions, suggestions, and feedback on this documentation. You can provide feedback on this documentation and on the software through newsgroups set up to discuss SQL Anywhere technologies. These newsgroups can be found on the forums.sybase.com news server. The newsgroups include the following: ♦ sybase.public.sqlanywhere.general ♦ sybase.public.sqlanywhere.linux ♦ sybase.public.sqlanywhere.mobilink ♦ sybase.public.sqlanywhere.
PART I U SING THE A DAPTIVE S ERVER A NYWHERE SNMP E XTENSION AGENT This part describes how to set up and configure the Adaptive Server Anywhere SNMP Extension Agent.
CHAPTER 1 The Adaptive Server Anywhere SNMP Extension Agent About this chapter Contents This chapter introduces you to the Adaptive Server Anywhere SNMP Extension Agent.
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.
Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent ♦ asasnmp.ini This file lists the databases that the Adaptive Server Anywhere SNMP Extension Agent monitors. By default, this file is located in C:\Program Files\Sybase\SQL Anywhere 9\win32.
Understanding SNMP Simple Network Management Protocol (SNMP) is a standard protocol used for network management. SNMP allows managers and agents to communicate: managers send requests to agents, and agents respond to queries from managers. Additionally, agents can notify managers when specific events occur using notifications called traps. SNMP agents handle requests to get and set the values of variables for managed objects.
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.
OID Name Description 1.3.6.1.4.897.2.3.3.db asaAgent.asaConnected Returns whether the Adaptive Server Anywhere Extension Agent is connected to database db. Setting this value to 0 causes the Adaptive Server Anywhere Extension Agent to shut down the database1 , while setting this value to 1 causes the Adaptive Server Anywhere Extension Agent to attempt to start the database2 . 1.3.6.1.4.897.2.3.4.db asaAgent.asaStarted Returns whether database db is running.
Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent asaMetaData tables The Adaptive Server Anywhere MIB includes metadata tables that provide a way to query the Adaptive Server Anywhere Extension Agent to find out which variables are supported. ♦ asaSrvMetaData.asaSrvStatMetaDataTable lists the database server statistics (variables under asa.asaServer.asaSrvStat.) ♦ asaSrvMetaData.asaSrvpropMetaDataTable lists the database server properties (variables under asa.asaServer.asaSrv.Prop.
Using the Adaptive Server Anywhere SNMP Extension Agent In order to use the Adaptive Server Anywhere SNMP Extension Agent, you must have SNMP installed on your machine and you must create an asasnmp.ini file that contains information about the databases that are monitored by the Adaptive Server Anywhere SNMP Extension Agent. Installing SNMP Before you can use the Adaptive Server Anywhere Extension Agent, you must install SNMP on your machine. By default, SNMP is not installed on Windows 2000 or Windows XP.
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.
Configuring the Adaptive Server Anywhere SNMP Extension Agent The Adaptive Server Anywhere Extension Agent can monitor one or more databases. The databases to be monitored are stored in the asasnmp.ini file with the following format: [ASAAgent] TrapPollTime=time in seconds [DBn] ConnStr=connection string UtilDbPwd=utility database password CacheTime=time in seconds Trapt=trap information Disabled=1 or 0 By default, your SQL Anywhere Studio installation places the asasnmp.
Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent ❖ To restart the Adaptive Server Anywhere SNMP Extension Agent 1. Using your SNMP management tool, change the value of the asaAgent.asaRestart property, 1.3.6.1.4.1.897.2.3.6, to 1. You can obfuscate the contents of the asasnmp.ini file with simple encryption using the File Hiding utility (dbfhide). ☞ For more information, see “Hiding the contents of .ini files” [ASA Database Administration Guide, page 524].
• names the connection so it can be identified • prevents the database from being shut down when the Adaptive Server Anywhere SNMP Extension Agent disconnects If you specify any of these values in the connection string in the asasnmp.ini file, the values in the asasnmp.ini file will override the default settings. When setting asa.agent.
Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent starting at 1. Skipping numbers is not allowed. This field is optional. Disabled If set to 1, this database entry is skipped by the Adaptive Server Anywhere SNMP Extension Agent. This is useful for temporarily removing one database from the list of databases managed by the Adaptive Server Anywhere SNMP Extension Agent, without renumbering the rest. This field is optional.
☞ 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.
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.
For example, setting the value of asaAgent.asaProc to the string “pchin.updatesales( ’param1’, 2)” calls the updatesales stored procedure owned by user pchin. The way you set the value of this OID to the procedure name will depend on your SNMP management software. ☞ For more information, see “The Adaptive Server Anywhere MIB” on page 7. Using traps A trap is an OID that is sent by an SNMP agent when a particular event occurs.
Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent Adaptive Server Anywhere SNMP Extension Agent traps The Adaptive Server Anywhere SNMP Extension Agent sends a trap whenever a connection is dropped by the database server. The OID of this trap is 1.3.6.1.2.1.39.2.1. The only other traps sent by the Adaptive Server Anywhere agent are dynamic traps. ☞ For more information about dynamic traps, see “Creating dynamic traps” on page 19.
Note Only equality or inequality are supported for string values. 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. value You can specify as many trap fields as you wish in the asasnmp.ini file. The OID used for the trap will be 1.3.6.
PART II A DAPTIVE S ERVER A NYWHERE SNMP E XTENSION AGENT R EFERENCE 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 Contents This chapter contains descriptions of the tables in the Adaptive Server Anywhere MIB.
The Adaptive Server Anywhere MIB The following sections list the OIDs of the statistics, properties, and options that can be retrieved and set using the Adaptive Server Anywhere SNMP Extension Agent. By default, Agent The Agent table lists information about the Adaptive Server Anywhere SNMP Extension Agent. Writable properties are marked with an asterisk (*). The value n is the database number in the asasnmp.ini file. OID Type Name Value returned 1.3.6.1.4.1.897.2.3.
Chapter 2. Adaptive Server Anywhere MIB Reference OID Type Name Value returned 1.3.6.1.4.1.897.2.4.1.1.1.1.db Integer32 asaSrvStatIndex db 1.3.6.1.4.1.897.2.4.1.1.1.2.db Integer32 asaSrvStatObjType 11 1.3.6.1.4.1.897.2.4.1.1.1.3.db Integer32 asaSrvStatType 12 1.3.6.1.4.1.897.2.4.1.1.1.4.db OID asaSrvStatOID OID of Adaptive Server Anywhere MIB entry3 1.3.6.1.4.1.897.2.4.1.1.1.5.
The value db is the database number in the asasnmp.ini file. OID Type Name Value returned 1.3.6.1.4.1.897.2.4.2.1.1.1.db Integer32 asaDbStatIndex db 1.3.6.1.4.1.897.2.4.2.1.1.2.db Integer32 asaDbStatObjType 21 1.3.6.1.4.1.897.2.4.2.1.1.3.db Integer32 asaDbStatType 12 1.3.6.1.4.1.897.2.4.2.1.1.4.db OID asaDbStatOID OID of Adaptive Server Anywhere MIB entry3 1.3.6.1.4.1.897.2.4.2.1.1.5.
Chapter 2. Adaptive Server Anywhere MIB Reference asaDbMetaData.asaDbOptMetaDataTable This table contains metadata about the database options. The value db is the database number in the asasnmp.ini file. OID Type Name Value returned 1.3.6.1.4.1.897.2.4.2.1.1.1.db Integer32 asaDbOptIndex db 1.3.6.1.4.1.897.2.4.2.1.1.2.db Integer32 asaDbOptObjType 21 1.3.6.1.4.1.897.2.4.2.1.1.3.db Integer32 asaDbOptType 32 1.3.6.1.4.1.897.2.4.2.1.1.4.
OID Type 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.3.6.1.4.1.897.2.1.1.12.n Counter64 srvStatDiskReadEng DiskReadEng 1.3.6.1.4.1.897.2.1.1.13.n Integer32 srvStatFreeBuffers FreeBuffers 1.3.6.1.4.1.897.2.1.1.14.n Integer32 srvStatJavaGlobFix JavaGlobFix 1.3.6.1.4.1.897.2.1.1.15.
Chapter 2. Adaptive Server Anywhere MIB Reference Server properties The following table lists OIDs and names of the database server properties that can be retrieved using the Adaptive Server Anywhere SNMP Extension Agent. Writable properties are marked with an asterisk (*). The value n is the database number in the asasnmp.ini file. OID Type Name Property 1.3.6.1.4.1.897.2.1.2.1.n String srvPropC2 C2 1.3.6.1.4.1.897.2.1.2.2.n String srvPropCharSet CharSet 1.3.6.1.4.1.897.2.1.2.3.
OID Type 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 srvPropMessageWindowSize MessageWindowSize 1.3.6.1.4.1.897.2.1.2.26.n String srvPropName Name 1.3.6.1.4.1.897.2.1.2.27.n String srvPropNativeProcessorArchitecture NativeProcessorArchitecture 1.3.6.1.4.1.897.2.1.2.28.n String srvPropNumProcessorsAvail NumProcessorsAvail 1.3.6.1.4.1.897.2.1.2.29.
Chapter 2. Adaptive Server Anywhere MIB Reference OID Type 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 srvPropTimeZoneAdjustment TimeZoneAdjustment 1.3.6.1.4.1.897.2.1.2.51.n String srvPropHttpPorts HttpPorts 1.3.6.1.4.1.897.2.1.2.52.n String srvPropHttpsPorts HttpsPorts 1.3.6.1.4.1.897.2.1.2.53.n String srvPropProfileFilterConn ProfileFilterConn 1.3.6.1.4.1.897.2.1.2.54.
OID Type Name Property 1.3.6.1.4.1.897.2.2.1.12.n Integer32 dbStatCheckpointLogCommitToDisk CheckpointLogCommitToDisk 1.3.6.1.4.1.897.2.2.1.13.n Integer32 dbStatCheckpointLogPageInUse CheckpointLogPageInUse 1.3.6.1.4.1.897.2.2.1.14.n Integer32 dbStatCheckpointLogPagesRelocated CheckpointLogPagesRelocated 1.3.6.1.4.1.897.2.2.1.15.n Integer32 dbStatCheckpointLogSavePreimage CheckpointLogSavePreimage 1.3.6.1.4.1.897.2.2.1.16.n Integer32 dbStatCheckpointLogSize CheckpointLogSize 1.3.6.1.
Chapter 2. Adaptive Server Anywhere MIB Reference OID Type 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.3.6.1.4.1.897.2.2.1.39.n Integer32 dbStatIOToRecover IOToRecover 1.3.6.1.4.1.897.2.2.1.40.n Integer32 dbStatJavaHeapSize JavaHeapSize 1.3.6.1.4.1.897.2.2.1.41.n Integer32 dbStatJavaNSSize JavaNSSize 1.3.6.1.4.1.897.2.2.1.42.
can be retrieved using the Adaptive Server Anywhere SNMP Extension Agent. Writable properties are marked with an asterisk (*). The value n is the database number in the asasnmp.ini file. OID Type Name Property 1.3.6.1.4.1.897.2.2.2.1.n String dbPropAlias Alias 1.3.6.1.4.1.897.2.2.2.2.n String dbPropAuditingTypes AuditingTypes 1.3.6.1.4.1.897.2.2.2.3.n String dbPropBlankPadding BlankPadding 1.3.6.1.4.1.897.2.2.2.4.n String dbPropBlobArenas BlobArenas 1.3.6.1.4.1.897.2.2.2.5.
Chapter 2. Adaptive Server Anywhere MIB Reference OID Type Name Property 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.3.6.1.4.1.897.2.2.2.28.n String dbPropJDKVersion JDKVersion 1.3.6.1.4.1.897.2.2.2.29.n String dbPropLanguage Language 1.3.6.1.4.1.897.2.2.2.30.n String dbPropLargeProcedureIDs LargeProcedureIDs 1.3.6.1.4.1.897.2.2.2.
OID Type Name Property 1.3.6.1.4.1.897.2.2.2.53.n String dbPropUniqueIdentifier UniqueIdentifier Database options The following table lists the OIDs and names of the database options that can be retrieved using the Adaptive Server Anywhere SNMP Extension Agent. Writable options are marked with an asterisk (*). The value n is the database number in the asasnmp.ini file. OID Type Name Option 1.3.6.1.4.1.897.2.2.3.1.n String dbOptAllowNullsByDefault* Allow_nulls_by_default 1.3.6.1.4.1.897.2.2.
Chapter 2. Adaptive Server Anywhere MIB Reference OID Type Name Option 1.3.6.1.4.1.897.2.2.3.19.n String dbOptConnectionAuthentication* Connection_authentication 1.3.6.1.4.1.897.2.2.3.20.n String dbOptContinueAfterRaiseerror* Continue_after_raise_error 1.3.6.1.4.1.897.2.2.3.21.n String dbOptConversionError* Conversion_error 1.3.6.1.4.1.897.2.2.3.22.n String dbOptCooperativeCommits* Cooperative_commits 1.3.6.1.4.1.897.2.2.3.23.
OID Type Name Option 1.3.6.1.4.1.897.2.2.3.43.n Integer32 dbOptJavaHeapSize* Java_heap_size 1.3.6.1.4.1.897.2.2.3.44.n String dbOptJavaInputOutput* Java_input_output 1.3.6.1.4.1.897.2.2.3.45.n Integer32 dbOptJavaNamespaceSize* Java_namespace_size 1.3.6.1.4.1.897.2.2.3.46.n Integer32 dbOptJavaPageBufferSize* Java_page_buffer_size 1.3.6.1.4.1.897.2.2.3.47.n String dbOptLockRejectedRows* Lock_rejected_rows 1.3.6.1.4.1.897.2.2.3.48.n String dbOptLoginMode* Login_mode 1.3.6.1.4.1.897.
Chapter 2. Adaptive Server Anywhere MIB Reference OID Type Name Option 1.3.6.1.4.1.897.2.2.3.67.n Integer32 dbOptOptimizationLevel* Optimization_level 1.3.6.1.4.1.897.2.2.3.68.n String dbOptOptimizationLogging* Optimization_logging 1.3.6.1.4.1.897.2.2.3.69.n String dbOptOptimizationWorkload* Optimization_workload 1.3.6.1.4.1.897.2.2.3.70.n Integer32 dbOptPinnedCursorPercentOfCache* Pinned_cursor_percent_of_cache 1.3.6.1.4.1.897.2.2.3.71.n Integer32 dbOptPrecision* Precision 1.3.6.1.
OID Type Name Option 1.3.6.1.4.1.897.2.2.3.91.n String dbOptTDSEmptyStringIsNull* 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.3.6.1.4.1.897.2.2.3.94.n Integer32 dbOptThreadSwaps* Thread_swaps 1.3.6.1.4.1.897.2.2.3.95.n String dbOptTimestampFormat* Timestamp_format 1.3.6.1.4.1.897.2.2.3.96.n String dbOptTimeFormat* Time_format 1.3.6.1.4.1.897.2.2.3.97.
CHAPTER 3 RDBMS MIB Reference About this chapter Contents This chapter contains descriptions of each of the tables in the RDBMS MIB.
The RDBMS MIB The following sections list the OIDs of the values that can be retrieved using the Adaptive Server Anywhere SNMP Extension Agent. By default, the RDBMS MIB is located in C:\Program Files\Sybase\SQL Anywhere 9\snmp\RDBMS-MIB.mib. rdbmsDbTable This table lists information about the databases installed on a system. The value db is the database number in the asasnmp.ini file. OID Type Name Value returned 1.3.6.1.2.1.39.1.1.1.1.db Integer rdbmsDbIndex db 1.3.6.1.2.1.39.1.1.1.2.
Chapter 3. RDBMS MIB Reference OID Type Name Value returned 1.3.6.1.2.1.39.1.2.1.3.db Integer rdbmsDbInfoSizeUnits Calculated based on dbInfoSizeAllocated and dbInfoSizeUsed. ♦ 1=bytes ♦ 2=KB ♦ 3=MB ♦ 4=GB ♦ 5=TB (Each unit is 1024 times the previous.) 1.3.6.1.2.1.39.1.2.1.4.db Integer rdbmsDbInfoSizeAllocated db_property(‘pagesize’) * db_property(‘filesize’) 1.3.6.1.2.1.39.1.2.1.5.
1 This OID is not currently supported by the Adaptive Server Anywhere SNMP Extenstion Agent. rdbmsDbLimitedResourceTable This table lists free space information on each dbspace. In this table, n represents each dbspace as follows: ♦ 1-13 are for normal dbspaces (numbered 0-12 in the database) ♦ 14 is the transaction log file ♦ 15 is the transaction log mirror file ♦ 16 is the temporary file ♦ 17 is the write file The value db is the database number in the asasnmp.ini file.
Chapter 3. RDBMS MIB Reference rdbmsSrvTable This table lists the database servers running or installed on your system. The value db is the database number in the asasnmp.ini file. OID Type Name Value returned 1.3.6.1.2.1.39.1.5.1.1.db OID rdbmsSrvPrivateMibOID 1.3.6.1.4.1.897.2 1.3.6.1.2.1.39.1.5.1.2.db String rdbmsSrvVendorName property(‘CompanyName’) 1.3.6.1.2.1.39.1.5.1.3.db String rdbmsSrvProductName property(‘ProductName’) 1.3.6.1.2.1.39.1.5.1.4.
OID Type Name Value returned 1.3.6.1.2.1.39.1.6.1.13.db Integer rdbmsSrvInfoHighwaterInboundAssociations 01 1.3.6.1.2.1.39.1.6.1.14.db Integer rdbmsSrvInfoMaxInboundAssociations 01 1 This OID is not currently supported by the Adaptive Server Anywhere SNMP Extenstion Agent. rdbmsSrvParamTable This table lists the server options that can be set by the Adaptive Server Anywhere SNMP Extension Agent through the Adaptive Server Anywhere MIB.
Chapter 3. RDBMS MIB Reference The value db is the database number in the asasnmp.ini file, while n is the index of the resource as follows: Name Resource Resource limit Connections property(‘LicensesInUse’) property(‘LicenseCount’) Processors propproperty(‘NumProcessorsMax’) erty(‘NumProcessorsAvail’)If this is 0, then it returns prop- n 1 2 erty(‘NumProcessorsAvail’)) OID Type Name Value returned 1.3.6.1.2.1.39.1.8.1.1.db String rdbmsSrvLimitedResourceName Name of resource n 1.3.6.1.2.
48
Index A 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.
Index BytesReceived property ASA SNMP Extension Agent OID BytesReceivedUncomp property ASA SNMP Extension Agent OID BytesSent property ASA SNMP Extension Agent OID BytesSentUncomp property ASA SNMP Extension Agent OID 27 27 27 27 C 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 AS
Index CONNECTION_AUTHENTICATION option ASA SNMP Extension Agent OID ConnsDisabled property ASA SNMP Extension Agent OID ConsoleLogFile property ASA SNMP Extension Agent OID CONTINUE_AFTER_RAISERROR option ASA SNMP Extension Agent OID conventions documentation CONVERSION_ERROR option ASA SNMP Extension Agent OID COOPERATIVE_COMMIT_TIMEOUT option ASA SNMP Extension Agent OID COOPERATIVE_COMMITS option ASA SNMP Extension Agent OID CurrentCacheSize property ASA SNMP Extension Agent OID CurrentRedoPos property
Index EXTENDED_JOIN_SYNTAX option ASA SNMP Extension Agent OID ExtendTempWrite property ASA SNMP Extension Agent OID H 36 xii xii HistogramHashFix property ASA SNMP Extension Agent OID Histograms property ASA SNMP Extension Agent OID HttpPorts property ASA SNMP Extension Agent OID HttpsPorts property ASA SNMP Extension Agent OID 34 I 31 F feedback documentation providing File property ASA SNMP Extension Agent OID FileSize property ASA SNMP Extension Agent OID FileVersion property ASA SNMP Extension
Index IsRuntimeServer property ASA SNMP Extension Agent OID 29 J JAVA_HEAP_SIZE option ASA SNMP Extension Agent OID JAVA_INPUT_OUTPUT option ASA SNMP Extension Agent OID JAVA_NAMESPACE_SIZE option ASA SNMP Extension Agent OID JAVA_PAGE_BUFFER_SIZE option ASA SNMP Extension Agent OID JavaGlobFix property ASA SNMP Extension Agent OID JavaHeapSize property ASA SNMP Extension Agent OID JavaNSSize property ASA SNMP Extension Agent OID JavaObjectsEnabled property ASA SNMP Extension Agent OID JDKVersion propert
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 MessageWin
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
Index ASA SNMP Extension Agent OID ReadOnly property ASA SNMP Extension Agent OID RECOVERY_TIME option ASA SNMP Extension Agent OID RecoveryUrgency property ASA SNMP Extension Agent OID RelocatableHeapPages property ASA SNMP Extension Agent OID RememberLastStatement property ASA SNMP Extension Agent OID REMOTE_IDLE_TIMEOUT option ASA SNMP Extension Agent OID RemoteputWait property ASA SNMP Extension Agent OID RemoteTrunc property ASA SNMP Extension Agent OID REPLICATE_ALL option ASA SNMP Extension Agent OI
Index STRING_RTRUNCATION option ASA SNMP Extension Agent OID StringHistrogramsFix property ASA SNMP Extension Agent OID SUBSUME_ROW_LOCKS option ASA SNMP Extension Agent OID support newsgroups supported platforms ASA SNMP Extension Agent SUPPRESS_TDS_DEBUGGING option ASA SNMP Extension Agent OID SyncTrunc property ASA SNMP Extension Agent OID 36 34 36 xii 4 36 34 T TableBitMaps property ASA SNMP Extension Agent OID TablesQualTriggers property ASA SNMP Extension Agent OID TDS_EMPTY_STRING_IS_NULL option A
Index installing SNMP Windows XP installing SNMP 58 10 10
