Home

Adaptive Server® Anywhere SNMP Extension Agent User`s Guide

Contents

1. 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 23 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 1 String asaVersion Agent version 1 3 6 1 4 1 897 2 3 2 n String asaDBConnStr Connection string 1 3 6 1 4 1 897 2 3 3 n Integer32 asaConnected 1 if the agent is connected 0 otherwise 1 3 6 1 4 1 897 2 3 4 n Integer32 asaStarted 1 if the database is started 0 otherwise 1 3 6 1 4 1 897 2 3 5 n String asaProc DS 1 3 6 1 4 1 897 2 3 6 String asaRestart 0 asaMetaData tables The following metadata tables are included in the Adaptive Server Anywhere MIB asaSrvMetaData asaSrvStatMetaD
2. 27 34 34 34 36 34 36 31 31 ASA SNMP Extension Agent OID CheckpointLogPageInUse property ASA SNMP Extension Agent OID CheckpointLogPagesRelocated property ASA SNMP Extension Agent OID CheckpointLogPagesWritten property ASA SNMP Extension Agent OID CheckpointLogSavePreimage property ASA SNMP Extension Agent OID CheckpointLogSize property ASA SNMP Extension Agent OID CheckpointLogWrites property ASA SNMP Extension Agent OID CheckpointUrgency property ASA SNMP Extension Agent OID Checksum property ASA SNMP Extension Agent OID Chkpt property ASA SNMP Extension Agent OID ChkptFlush property ASA SNMP Extension Agent OID ChkptPage property ASA SNMP Extension Agent OID CIS OPTION option ASA SNMP Extension Agent OID CIS ROWSET SIZE option ASA SNMP Extension Agent OID CLOSE ON ENDTRANS option ASA SNMP Extension Agent OID ClusteredIndexes property ASA SNMP Extension Agent OID Collation property ASA SNMP Extension Agent OID CommandLine property ASA SNMP Extension Agent OID CommitFile property ASA SNMP Extension Agent OID CompactPlatform Ver property ASA SNMP Extension Agent OID CompanyName property ASA SNMP Extension Agent OID CompressedBTrees property ASA SNMP Extension Agent OID Compression property ASA SNMP Extension Agent OID ConnCount property ASA SNMP Extension Agent OID 31 31 31 31 34 31 31 31 36 36 36 34 34 29 31 29 29 34
3. 34 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 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 CurrlO property ASA SNMP Extension Agent OID 31 CurrRead property ASA SNMP Extension Agent OID 31 CurrWrite property ASA SNMP Extension Agent OID 31 D database options OIDs for ASA SNMP Extension Agent 36 retrieving with the ASA SNMP Extension Agent 15 setting with the ASA SNMP Extension Agent 17 database properties OIDs for ASA SNMP Extension Agent 33 retrieving with the ASA SNMP Extension Agent 15 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 15 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 DBFileFragments property ASA SNMP Extension Agent OID DEBUG MESSAGES option
4. ASA SNMP Extension Agent OID FIRE TRIGGERS option ASA SNMP Extension Agent OID FIRST DAY OF WEEK option ASA SNMP Extension Agent OID FLOAT AS DOUBLE option ASA SNMP Extension Agent OID FOR XML NULL TREATMENT option ASA SNMP Extension Agent OID FORCE VIEW CREATION option ASA SNMP Extension Agent OID FreeBuffers property ASA SNMP Extension Agent OID FreePageBitmaps property ASA SNMP Extension Agent OID FreePages property ASA SNMP Extension Agent OID FullCompare property ASA SNMP Extension Agent OID functions executing using ASA SNMP Extension Agent G GetData property ASA SNMP Extension Agent OID GLOBAL DATABASE ID option ASA SNMP Extension Agent OID GlobalDBId property ASA SNMP Extension Agent OID 52 36 31 xii xii 34 34 34 29 36 36 36 36 36 27 34 34 31 H 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 iAnywhere mib file about location icons used in manuals IdleCheck property ASA SNMP Extension Agent OID IdleChkpt property ASA SNMP Extension Agent OID IdleTimeout property ASA SNMP Extension Agent OID IdleWrite property ASA SNMP Extension Agent OID IndAdd property ASA SNMP Extension Agent OID IndexStatistics property ASA SNMP Extension Agent OID IndLookup property ASA SNMP Ext
5. PDFbooks The SQL Anywhere books are provided as a set of PDF files viewable with Adobe Acrobat Reader The PDF books are accessible from the online books or from the Windows Start menu Printed books The complete set of books is available from Sybase sales or from eShop the Sybase online store at http eshop sybase com eshop documentation Documentation conventions Syntax conventions This section lists the typographic and graphical conventions used in this documentation The following conventions are used in the SOL syntax descriptions Keywords All SOL 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 identifiers or expressions are shown like the words owner and table name in the following example ALTER TABLE owner table name Repeating items Lists of repeating items are shown with an element of the list followed by an ellipsis three dots like column constraint in the following example ADD column definition column constraint One or more list elements are allowed In this example if more than one is specified they must be separated by commas Optional portions Optional portions of a statement are enclosed by sguare brackets RELEASE SAVEPOINT savepoint name These sguare brackets indicate that the savepoint name is optional The sguare brackets should not
6. The SOL Anywhere Studio documentation Vi 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 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 The documentation consists of the following books Introducing SOL Anywhere Studio This book provides an overview of the SOL Anywhere Studio database management and synchronization technologies It includes tutorials to introduce you to each of the pieces that make up SOL 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 configuring databases and database servers Adaptive Server Anywhere SOL 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 SOL Reference Manual This book provides a complete reference for the SOL language used by Adaptive Server Anywhere It also describes the Adaptive Server Anywhere system
7. 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 Documentation formats viii UltraLite Interface Guides 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 SOL 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 SOL 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
8. XA Library XA Server and XP Server are trademarks of Sybase Inc or its subsidiaries All other trademarks are property of their respective owners ii Contents About This Manual v SOL Anywhere Studio documentation vi Documentation 5 ix The Adaptive Server Anywhere sample database xi Finding out more and providing feedback xii Using the Adaptive Server Anywhere SNMP Ex tension Agent 1 1 The Adaptive Server Anywhere SNMP Extension Agent 3 Introduction to the Adaptive Server Anywhere SNMP Exten SION AJON ccs Lode go eee ee ee ee es 4 Understanding SNMP 6 Using the Adaptive Server Anywhere SNMP Extension Agent 10 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 5 42 Index 49 iii iv About This Manual Subject Audience This book covers material related to running and configuring the Adaptive Server Anywhere SNMP Extension Agent 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 SOL Anywhere Studio documentation
9. 1 The Adaptive Server Anywhere SNMP Extension Agent asaMetaData tables The RDBMS MIB The Adaptive Server Anywhere MIB includes metadata tables that provide a way to guery 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 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 t For more information about the information stored in the Adaptive Server Anywhere MIB metadata tables see asaMetaData tables on page 24 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 t For descriptions of the supported tables contained in the RDBMS MIB see RDBMS MIB Reference on page
10. 1 897 2 2 2 21 String dbPropFreePageBitMaps FreePageBitMaps 1 3 6 1 4 1 897 2 2 2 22 n String dbPropFreePages FreePages 1 3 6 1 4 1 897 2 2 2 23 n String dbPropGlobalDBId GlobalDBId 1 3 6 1 4 1 897 2 2 2 24 n String dbPropHistogramHashFix HistogramHashFix 34 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 1QStore 1 3 6 1 4 1 897 2 2 2 28 n String dbPropJDK Version 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 31 n String dbPropLogFileFragments LogFileFragments 1 3 6 1 4 1 897 2 2 2 32 n String dbPropLogMirrorName LogMirrorName 1 3 6 1 4 1 897 2 2 2 33 n String dbPropLogName LogName 1 3 6 1 4 1 897 2 2 2 34 n String dbPropLTMGeneration LTMGeneration 1 3 6 1 4 1 897 2 2 2 35 n String dbPropLTMTrunc LTMTrunc 1 3 6 1 4 1 897 2 2 2 36 n String dbPropMultiByteCharSet MultiByteCharSet 1 3 6 1 4 1 897 2 2 2 37 n String dbPropName Name 1 3 6 1 4 1 897 2 2 2 38 n String dbPropNamedConstraints NamedConstraints 1 3 6 1 4 1 897 2 2 2 39 n String dbPropPageSize PageSize 1 3 6 1 4 1 897 2 2 2 40 n String dbPropPreserveSource PreserveSource 1 3 6 1 4 1 897 2 2 2 41 n String dbPropProcedureProfiling ProcedureProfiling 1 3 6 1 4 1
11. 36 36 36 36 27 26 26 25 24 36 36 34 36 27 36 34 34 36 36 49 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 C C2 property ASA SNMP Extension Agent OID CacheHits property ASA SNMP Extension Agent OID CacheHitsEng property ASA SNMP Extension Agent OID CachePinned property ASA SNMP Extension Agent OID CacheRead property ASA SNMP Extension Agent OID CacheReadEng property ASA SNMP Extension Agent OID CacheReadIndInt property ASA SNMP Extension Agent OID CacheReadIndLeaf property ASA SNMP Extension Agent OID CacheReadTable property ASA SNMP Extension Agent OID CacheReplacements property ASA SNMP Extension Agent OID Capabilities property ASA SNMP Extension Agent OID CaseSensitive property ASA SNMP Extension Agent OID CaseSensitivePasswords property ASA SNMP Extension Agent OID CHAINED option ASA SNMP Extension Agent OID CharSet property ASA SNMP Extension Agent OID CHECKPOINT TIME option ASA SNMP Extension Agent OID CheckpointLogBitmapPagesWiritten property ASA SNMP Extension Agent OID CheckpointLogBitmapSize property ASA SNMP Extension Agent OID CheckpointLogCommitToDisk property 50 29 27 27 27 27 29 31 27 27 31 27 31 31 31
12. 41 The Adaptive Server Anywhere Extension Agent provides read only access to all of the supported variables in the RDBMS MIB None of the variables in the RDBMS MIB are writable through the Adaptive Server Anywhere Extension Agent A virtual table contains a fixed number of attributes and any number for rows Elements in the table are retrieved using GET requests by appending the column number and row number to the OID of the table A 1 must be appended to the table OID so the OID looks as follows table 1 colnum rownum By default the RDBMS MIB is located in C Program Files Sybase SQL Anywhere 9 snmp RDBMS MIB mib Using the Adaptive Server Anywhere SNMP Extension Agent Installing SNMP 10 ww 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 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 7 8 Open the Control Panel On Windows 2000 from the Start menu choose Settings gt Control Panel On Windows XP from the Start menu choose Control Panel Double click Add Remove Programs The Add Remove Programs dialog appears In the left pan
13. ASA SNMP Extension Agent OID DEDICATED TASK option ASA SNMP Extension Agent OID DEFAULT TIMESTAMP INCREMENT option ASA SNMP Extension Agent OID DefaultCollation property ASA SNMP Extension Agent OID DELAYED COMMIT TIMEOUT option ASA SNMP Extension Agent OID DELAYED COMMITS option ASA SNMP Extension Agent OID DiskRead property ASA SNMP Extension Agent OID DiskReadEng property ASA SNMP Extension Agent OID DiskReadIndInt property ASA SNMP Extension Agent OID DiskReadIndLeaf property ASA SNMP Extension Agent OID DiskReadTable property ASA SNMP Extension Agent OID DiskWrite property ASA SNMP Extension Agent OID DIVIDE BY ZERO ERROR option ASA SNMP Extension Agent OID documentation conventions SQL Anywhere Studio DriveType property ASA SNMP Extension Agent OID dynamic traps about E Encryption property ASA SNMP Extension Agent OID ESCAPE CHARACTER option ASA SNMP Extension Agent OID EXCLUDE OPERATORS option ASA SNMP Extension Agent OID ExtendDB property ASA SNMP Extension Agent OID 36 34 36 36 31 27 31 31 31 31 36 viii vi 34 19 34 36 36 31 51 Index EXTENDED JOIN SYNTAX option ASA SNMP Extension Agent OID ExtendTempWrite property ASA SNMP Extension Agent OID F feedback documentation providing File property ASA SNMP Extension Agent OID FileSize property ASA SNMP Extension Agent OID File Version property ASA SNMP Extension Agent OID FipsMode property
14. 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 1 For information about creating traps see Creating dynamic traps on page 19 The following is a sample asasnmp ini file for the Adaptive Server Anywhere SNMP Extension Agent ASAAgent DB1 ConnSt r UID DBA PWD SQL ENG serverl1 DBN sales DBF sales db Trapl 1 1 5 gt 50000 UtilDbPwd test DB2 ConnSt r UID DBA PWD SQL ENG serverl1 DBN field DBF field db UtilDbPwd test Disabled DB3 ConnSt r UID DBA PWD SQL LINKS tcpip ENG server2 DBN hq DBF hq db UtilDbPwd test Because there are no parameters specified 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 specified for DB1 which fires 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 Anywh
15. 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 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 e W yp 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 N 7 API N 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 SOL Anywhere directory The sample database represents a small company It contains internal information about the company emplo
16. 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 MIB created specifically 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 t For more information about the Adaptive Server Anywhere MIB see The Adaptive Server Anywhere MIB on page 7 RDBMS MIB generic vendor independent MIB for relational databases This MIB contains information about the database servers and databases in your system t 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 OID The Adaptive Server Anywhere MIB was created for the Adaptive Server Anywhere SNMP Extension Agent It includes all database server statistics and properties as well as all database statistics properties and options The statistics and properties are all read only with a few exceptions and the database options are all read write By default the Adaptive Server Anywhere MIB is located in C Program Files Syba
17. 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 configure 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 SOL 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 eguivalent to the C2 certified 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 Mo
18. 1 897 2 4 2 2 1 4 db OID asaDbPropOID OID of Adaptive Server Anywhere MIB entry 1 3 6 1 4 1 897 2 4 2 2 1 5 db String asaDbPropName Property name 1 Values 1 Server 2 Database 2 Values 1 Statistic 2 Property 3 Option 3 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 guery 26 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 2 1 3 6 1 4 1 897 2 4 2 1 1 3 db Integer32 asaDbOptType 3 1 3 6 1 4 1 897 2 4 2 1 1 4 db OID asaDbOptOID OID of Adaptive Server Any where MIB entry 1 3 6 1 4 1 897 2 4 2 1 1 5 db String asaDbOptName Option name 1 Values 1 Server 2 Database 2 Values 1 Statistic 2 Property 3 Option 3 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 guery Server statistics This table lists the OIDs and names of the database server statistics that can be retrieved using the Adaptive Server Anywhere SNMP Extension Agent The value n is the database number in the asasnmp ini file OID Type Name Statistic 1 3 6 1 4 1 897 2 1 1 1 n Integer3
19. 2 srvStatActiveReq ActiveReq 1 3 6 1 4 1 897 2 1 1 2 n Integer32 srvStatAvaillO AvaillO 1 3 6 1 4 1 897 2 1 1 3 n Counter64 srvStatBytesReceived BytesReceived 1 3 6 1 4 1 897 2 1 1 4 n Counter64 srvStatBytesReceivedUn BytesReceivedUncomp comp 1 3 6 1 4 1 897 2 1 1 5 n Counter64 srvStatBytesSent BytesSent 1 3 6 1 4 1 897 2 1 1 6 n Counter64 srvStatBytesSentUncomp BytesSentUncomp 1 3 6 1 4 1 897 2 1 1 7 n Counter64 srvStatCacheHitsEng CacheHitsEng 1 3 6 1 4 1 897 2 1 1 8 n Integer32 srvStatCachePinned CachePinned 27 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 n Integer32 srvStatLicensesInUse LicensesInUse 1 3 6 1 4 1 897 2 1 1 16 n Integer32 srvStatLockedHeapPages LockedHeapPages 1 3 6 1 4 1 897 2 1 1 17 n Counter64 srvStatMainHeapBytes MainHeapBytes 1 3 6 1 4 1 897 2 1 1 18 n Integer32 srvStatMainHeapPages MainHeapPages 1 3 6 1 4 1 897 2 1 1 19 n Integer32 srvStatMapPhysicalMemo MapPhysicalMemoryEng ryEng 1 3 6 1 4 1 897 2 1 1 20 n Integer32 srvStatMaxCacheSize MaxCacheSize 1 3 6 1 4 1 897 2 1 1 21
20. 3 6 1 4 1 897 2 2 3 60 n Integer32 dbOptNearestCentury Nearest century 1 3 6 1 4 1 897 2 2 3 61 n String dbOptNonKeywords Non keywords 1 3 6 1 4 1 897 2 2 3 62 n String dbOptODBCDistinguishCha ODBC distinguish char rAndVarchar and varchar 1 3 6 1 4 1 897 2 2 3 63 n String dbOptOnCharsetConversion On charset conversion Failure failure 1 3 6 1 4 1 897 2 2 3 64 n String dbOptOnTsqlError On_tsql_error 1 3 6 1 4 1 897 2 2 3 65 n String dbOptOptimistic WaitFor Optimistic_wait_for_commit Commit 1 3 6 1 4 1 897 2 2 3 66 n String dbOptOptimizationGoal Optimization_goal 38 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 dbOptPinnedCursorPer Pinned_cursor_percent_of_ centOfCache cache 1 3 6 1 4 1 897 2 2 3 71 n Integer32 dbOptPrecision Precision 1 3 6 1 4 1 897 2 2 3 72 n String dbOptPrefetch Prefetch 1 3 6 1 4 1 897 2 2 3 73 n String dbOptPreserveSourceFormat Preserve source format 1 3 6 1 4 1 897 2 2 3 74 n String dbOptPreventArticlePkey Up Prevent_article_pkey_update date 1 3 6 1 4 1 897 2 2 3 75 n String dbOptQueryPlanOnOpen Query_plan_on_open 1 3 6 1 4 1 897 2 2 3 76 n String dbOptQuotedIdentifier Quo
21. 4 1 897 2 2 1 4 n Counter64 dbStatCacheRead CacheRead 1 3 6 1 4 1 897 2 2 1 5 n Integer32 dbStatCacheReadTable CacheReadTable 1 3 6 1 4 1 897 2 2 1 6 n Integer32 dbStatChkpt Chkpt 1 3 6 1 4 1 897 2 2 1 7 n Integer32 dbStatChkptFlush ChkptFlush 1 3 6 1 4 1 897 2 2 1 8 n Integer32 dbStatChkptPage ChkptPage 1 3 6 1 4 1 897 2 2 1 9 n Integer32 dbStatCheckpointUrgency CheckpointUrgency 1 3 6 1 4 1 897 2 2 1 10 n Integer32 dbStatCheckpointLogBitmap CheckpointLogBitmap Size Size 1 3 6 1 4 1 897 2 2 1 11 n Integer32 dbStatCheckpointLogBitmap CheckpointLogBitmap PagesWritten PagesWritten 31 OID Type Name Property 1 3 6 1 4 1 897 2 2 1 12 n Integer32 dbStatCheckpointLogCommit CheckpointLogCommit ToDisk ToDisk 1 3 6 1 4 1 897 2 2 1 13 n Integer32 dbStatCheckpointLogPagel CheckpointLogPageInUse nUse 1 3 6 1 4 1 897 2 2 1 14 n Integer32 dbStatCheckpointLogPagesRe CheckpointLogPagesRelo located cated 1 3 6 1 4 1 897 2 2 1 15 n Integer32 dbStatCheckpoint Checkpoint LogSavePreimage LogSavePreimage 1 3 6 1 4 1 897 2 2 1 16 n Integer32 dbStatCheckpointLogSize CheckpointLogSize 1 3 6 1 4 1 897 2 2 1 17 n Integer32 dbStatCheckpointLog Writes CheckpointLog Writes 1 3 6 1 4 1 897 2 2 1 18 n Integer32 dbStatCheckpointLog CheckpointLogPages Writ PagesWritten ten 1 3 6 1 4 1 897 2 2 1 19 n Integer32 dbStatCommitFile CommitFile 1 3 6 1 4 1 897 2 2 1 20 n Integer32 dbStatConnCount ConnCount 1 3 6 1 4 1 897 2 2 1 21 n In
22. 6 1 4 1 897 2 1 2 45 n String srvPropRequestLogging RequestLogging 1 3 6 1 4 1 897 2 1 2 46 n String srvPropReguestLogMaxSize ReguestLogMaxSize 1 3 6 1 4 1 897 2 1 2 47 n String srvPropStartTime StartTime 1 3 6 1 4 1 897 2 1 2 48 n String srvPropTempDir TempDir 30 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 n String srvPropProfileFilterUser ProfileFilterUser 1 3 6 1 4 1 897 2 1 2 55 n String srvPropReguestLogNumFiles RequestLogNumFlles 1 3 6 1 4 1 897 2 1 2 56 n String srvPropIsFipsAvailable IsFipsAvailable 1 3 6 1 4 1 897 2 1 2 57 n 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 value n is the database number in the asasnmp ini file OID Type Name Property 1 3 6 1 4 1 897 2 2 1 1 n Counter64 dbStatCacheHits CacheHits 1 3 6 1 4 1 897 2 2 1 2 n Integer32 dbStatCacheReadIndInt CacheReadIndInt 1 3 6 1 4 1 897 2 2 1 3 n Integer32 dbStatCacheReadIndLeaf CacheReadIndLeaf 1 3 6 1
23. 6 1 4 1 897 2 2 1 42 n Integer32 dbStatLockTablePages LockTablePages 1 3 6 1 4 1 897 2 2 1 43 n Integer32 dbStatMapPages MapPages 1 3 6 1 4 1 897 2 2 1 44 n Integer32 dbStatMaxIO MaxIO 1 3 6 1 4 1 897 2 2 1 45 n Counter64 dbStatMaxRead MaxRead 1 3 6 1 4 1 897 2 2 1 46 n Integer32 dbStatMaxWrite MaxWrite 1 3 6 1 4 1 897 2 2 1 47 n Integer32 dbStatPageRelocations PageRelocations 1 3 6 1 4 1 897 2 2 1 48 n Integer32 dbStatProcedurePages ProcedurePages 1 3 6 1 4 1 897 2 2 1 49 n Integer32 dbStatOueryCachePages OueryCachePages 1 3 6 1 4 1 897 2 2 1 50 n Integer32 dbStatQueryLowMemoryStrat QueryLowMemoryStrat egy egy 1 3 6 1 4 1 897 2 2 1 51 n Counter64 dbStatQueryRowsMaterialized QueryRowsMaterialized 1 3 6 1 4 1 897 2 2 1 52 n Integer32 dbStatRecoveryUrgency RecoveryUrgency 1 3 6 1 4 1 897 2 2 1 53 n Integer32 dbStatLogFreeCommit LogFreeCommit 1 3 6 1 4 1 897 2 2 1 54 n Integer32 dbStatLog Write LogWrite 1 3 6 1 4 1 897 2 2 1 55 n Integer32 dbStatRelocatableHeapPages RelocatableHeapPages 1 3 6 1 4 1 897 2 2 1 56 n Integer32 dbStatRollbackLogPages RollbackLogPages 1 3 6 1 4 1 897 2 2 1 57 n Integer32 dbStatTempTablePages TempTablePages 1 3 6 1 4 1 897 2 2 1 58 n Integer32 dbStatTriggerPages TriggerPages 1 3 6 1 4 1 897 2 2 1 59 n Integer32 dbStatViewPages ViewPages Database properties The following table lists the OIDs and names of the database properties that 33 can be retrieved using the Adaptive Server Any
24. 897 2 2 2 42 n String dbPropReadOnly ReadOnly 1 3 6 1 4 1 897 2 2 2 43 n String dbPropRemoteTrunc RemoteTrunc 1 3 6 1 4 1 897 2 2 2 44 n String dbPropSeparateCheckpointLog SeparateCheckpointLog 1 3 6 1 4 1 897 2 2 2 45 n String dbPropSeparateForeignKeys SeparateForeignKeys 1 3 6 1 4 1 897 2 2 2 46 n String dbPropStringHistogramsFix StringHistogramsFix 1 3 6 1 4 1 897 2 2 2 47 n String dbPropSyncTrunc SyncTrunc 1 3 6 1 4 1 897 2 2 2 48 n String dbPropTableBitMaps TableBitMaps 1 3 6 1 4 1 897 2 2 2 49 n String dbPropTablesQualTriggers TablesQualTriggers 1 3 6 1 4 1 897 2 2 2 50 n String dbPropTempFileName TempFileName 1 3 6 1 4 1 897 2 2 2 51 n String dbPropTransactionsSpanLogs TransactionsSpanLogs 1 3 6 1 4 1 897 2 2 2 52 n String dbPropVariableHashSize VariableHashSize 35 OID Type Name Property 1 3 6 1 4 1 897 2 2 2 53 n Database options String dbPropUniqueldentifier Uniqueldentifier 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 3 2 n String dbOptAnsinull Ansinull 1 3 6 1 4 1 897 2 2 3 3 n String dbOptAnsiBlanks Ansi blanks 1 3 6 1 4 1 897 2 2 3 4 n String dbOptAns
25. A SNMP Extension Agent OID TIMESTAMP_FORMAT option ASA SNMP Extension Agent OID TimeZoneAdjustment property 36 34 36 xii 36 34 34 34 36 xii 36 29 34 31 36 36 36 29 36 36 36 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 U Uniqueldentifier 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 V VariableHashSize property ASA SNMP Extension Agent OID 34 ViewPages property ASA SNMP Extension Agent OID 31 W WAIT FOR COMMIT option ASA SNMP Extension Agent OID 36 Windows 2000 installing SNMP 10 Windows 2003 57 Index installing SNMP Windows XP installing SNMP 58 10 10
26. 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 O 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 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 AvantGo Pylon Conduit AvantGo Pylon PIM Server AvantGo Pylon Pro Backup Server BayCam Bit Wise BizTracker Certified PowerBuilder Developer Certified SYBASE Professional Certified SYBASE Professional Logo ClearCon
27. Agent OID PageRelocations property ASA SNMP Extension Agent OID PageSize property ASA SNMP Extension Agent OID PeakCacheSize property ASA SNMP Extension Agent OID 27 27 27 27 31 29 34 27 PINNED CURSOR PERCENT OF CACHE option ASA SNMP Extension Agent OID Platform property ASA SNMP Extension Agent OID PlatformVer property ASA SNMP Extension Agent OID PRECISION option ASA SNMP Extension Agent OID PREFETCH option ASA SNMP Extension Agent OID PRESERVE SOURCE FORMAT option ASA SNMP Extension Agent OID PreserveSource property ASA SNMP Extension Agent OID 36 29 29 36 36 36 34 PREVENT ARTICLE PKEY UPDATE option ASA SNMP Extension Agent OID ProcedurePages property ASA SNMP Extension Agent OID ProcedureProfiling property ASA SNMP Extension Agent OID ProcessCPU property ASA SNMP Extension Agent OID ProcessCPUSystem property ASA SNMP Extension Agent OID ProcessCPUUser property ASA SNMP Extension Agent OID ProcessorArchitecture property ASA SNMP Extension Agent OID ProductName property ASA SNMP Extension Agent OID ProductVersion property ASA SNMP Extension Agent OID ProfileFilterConn property 36 31 34 29 29 29 29 29 29 ASA SNMP Extension Agent OID 29 ProfileFilterUser 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
28. Commits Cooperative_commits 1 3 6 1 4 1 897 2 2 3 23 n Integer32 dbOptCooperativeCommit Cooperative_commit_ Timeout timeout 1 3 6 1 4 1 897 2 2 3 24 n String dbOptDatabaseAuthentica Database_authentication tion 1 3 6 1 4 1 897 2 2 3 25 n String dbOptDateFormat Date_format 1 3 6 1 4 1 897 2 2 3 26 n String dbOptDateOrder Date_order 1 3 6 1 4 1 897 2 2 3 27 n String dbOptDebugMessages Debug_messages 1 3 6 1 4 1 897 2 2 3 28 n String dbOptDedicatedTask Dedicated_task 1 3 6 1 4 1 897 2 2 3 29 n Integer32 dbOptDefaultTimestampIn Default timestamp crement increment 1 3 6 1 4 1 897 2 2 3 30 n String dbOptDelayedCommits Delayed commits 1 3 6 1 4 1 897 2 2 3 31 n Integer32 dbOptDelayedCommitTime Delayed commit timeout out 1 3 6 1 4 1 897 2 2 3 32 n String dbOptDivideByZeroError Divide by zero error 1 3 6 1 4 1 897 2 2 3 33 n String dbOptEscapeCharacter Escape character 1 3 6 1 4 1 897 2 2 3 34 n String dbOptExcludeOperators Exclude operators 1 3 6 1 4 1 897 2 2 3 35 n String dbOptExtendedJoinSyntax Extended join syntax 1 3 6 1 4 1 897 2 2 3 36 n String dbOptFireTriggers Fire triggers 1 3 6 1 4 1 897 2 2 3 37 n Integer32 dbOptFirstDayOfWeek First day of week 1 3 6 1 4 1 897 2 2 3 38 n String dbOptFloatAsDouble Float_as_double 1 3 6 1 4 1 897 2 2 3 39 n String dbOptForceViewCreation Force view creation 1 3 6 1 4 1 897 2 2 3 40 n String dbOptForXmlNullTreatment For xml null treatment 1 3 6 1 4 1 897 2 2 3 41 n Integer32 dbOptGlob
29. ID MAX_CURSOR_COUNT option ASA SNMP Extension Agent OID MAX HASH SIZE option ASA SNMP Extension Agent OID 27 31 36 36 36 34 31 36 36 34 34 31 34 34 29 27 27 31 27 36 36 53 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 defined 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 N Name property ASA SNMP Extension Agent OID 29 34 NamedConstraints property ASA SNMP Extension Agent OID 34 NativeProcessorArchitecture property ASA SNMP Extension A
30. InfoSizeUnits Calculated based on dbInfoSizeAllo cated and dbInfoSizeUsed 1 bytes 2 KB 3 MB 4 GB 5 TB Each unit is 1024 times the previ ous 1 3 6 1 2 1 39 1 2 1 4 db Integer rdbmsDbInfoSizeAllo db_property pagesize db_ cated property filesize 1 3 6 1 2 1 39 1 2 1 5 db Integer rdbmsDbInfoSizeUsed db_property pagesize db property filesize db property freepages 1 3 6 1 2 1 39 1 2 1 6 db String rdbmsDbInfoLast NULL Backup This OID is not currently supported by the Adaptive Server Anywhere SNMP Extension Agent rdbmsDbParamTable This table lists the configuration parameters for the databases on the system The value db is the database number in the asasnmp ini file while n is 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 db String rdbmsDbParamName Option name 1 3 6 1 2 1 39 1 3 1 2 db Integer rdbmsDbParamSubIndex n 1 3 6 1 2 1 39 1 3 1 3 db OID rdbmsDbParamID OID in Adaptive Server Anywhere MIB correspond ing to this option 1 3 6 1 2 1 39 1 3 1 4 db String rdbmsDbParamCurr Value Option value 1 3 6 1 2 1 39 1 3 1 5 db String rdbmsDbParamComment NULL 43 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 eac
31. a OUERY_PLAN_ON_OPEN option ASA SNMP Extension Agent OID 36 OueryCachePages 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 R RDBMS MIB about 9 list of tables 42 rdbmsDbInfoTable description 42 rdbmsDbLimitedResourceTable description 44 rdbmsDbParamTable description 43 rdbmsDbTable description 42 RDBMS MIB mib file about 9 location 42 rdbmsSrvInfoTable description 45 rdbmsSrvLimitedResourceTable description 47 rdbmsSrvParamTable description 46 rdbmsSrvTable description 45 READ PAST DELETED option 55 Index ASA SNMP Extension Agent OID ReadOnly property ASA SNMP Extension Agent OID RECOVERY TIME option ASA SNMP Extension Agent OID Recovery Urgency 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 OID Req property ASA SNMP Extension Agent OID RequestFilterConn property ASA SNMP Extension Agent OID RequestFilterDB property ASA SNMP Extension Agen
32. alDatabaseld Global database id 1 3 6 1 4 1 897 2 2 3 42 n Integer32 dbOptlsolationLevel Isolation level 37 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 2 2 3 49 n String dbOptLoginProcedure Login_procedure 1 3 6 1 4 1 897 2 2 3 50 n String dbOptLogDetailedPlans Log_detailed_plans 1 3 6 1 4 1 897 2 2 3 51 n Integer32 dbOptLogMaxRequests Log max requests 1 3 6 1 4 1 897 2 2 3 52 n Integer32 dbOptMaxCursorCount Max cursor count 1 3 6 1 4 1 897 2 2 3 53 n Integer32 dbOptMaxHashSize Max hash size 1 3 6 1 4 1 897 2 2 3 54 n Integer32 dbOptMaxPlansCached Max_plans_cached 1 3 6 1 4 1 897 2 2 3 55 n Integer32 dbOptMaxRecursiveltera Max_recursive_iterations tions 1 3 6 1 4 1 897 2 2 3 56 n Integer32 dbOptMaxStatementCount Max_statement_count 1 3 6 1 4 1 897 2 2 3 57 n Integer32 dbOptMax WorkTableHash Max work table hash size Size 1 3 6 1 4 1 897 2 2 3 58 n Integer32 dbOptMinPasswordLength Min password length 1 3 6 1 4 1 897 2 2 3 59 n Integer32 dbOptInternal Internal 1
33. apnum is the dynamic trap number It must start at 1 and be sequential oid isthe 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 prefix 1 3 6 1 4 1 897 2 is prepended 1 For a list of OIDs in the Adaptive Server Anywhere MIB see Adaptive Server Anywhere MIB Reference on page 23 t For a list of OIDs in the RDBMS MIB see RDBMS MIB Reference on page 41 dbnum isthe database number This field is optional but if specified it must match the database number of the DBn section of the asasnmp ini file op must have one of the following values equality 4 lt gt gt lt inequality lt lt less than or equal gt or gt greater than or equal less than gt greater than 19 Dynamic trap behavior Trap examples Trap information Note Only eguality or ineguality are supported for string values value 15 the value to use in the expression String values may be enclosed in single or double guotes these guotes will not be included in the value If you want the beginning or closing guotation marks to be included in the string you must double them Note that single guotes occurring within the string should not be doubled You can specify as many trap fields as yo
34. ataTable asaSrvMetaData asaSrvPropMetaDataTable asaSrvMetaData asaDbStatMetaDataTable asaSrvMetaData asaDbPropMetaDataTable asaSrvMetaData asaDbOptMetaDataTable asaSrvMetaData asaSrvStatMetaDataTable 24 This table contains metadata about the database server statistics The value db is the database number in the asasnmp ini file 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 1 1 3 6 1 4 1 897 2 4 1 1 1 3 db Integer32 asaSrvStat Type 1 1 3 6 1 4 1 897 2 4 1 1 1 4 db OID asaSrvStatOID OID of Adaptive Server Any where MIB entry 1 3 6 1 4 1 897 2 4 1 1 1 5 db String asaSrvStatName Statistic name 1 Values 1 Server 2 Database 2 Values 1 Statistic 2 Property 3 Option 3 The OID returned does not include the database number You must append the database number to the OID before it can be used in a query asaSrvMetaData asaSrvPropMetaDataTable This table contains metadata about the database server properties The value db is the database number in the asasnmp ini file OID Type Name Value returned 1 3 6 1 4 1 897 2 4 1 2 1 1 db Integer32 asaSrvPropIndex db 1 3 6 1 4 1 897 2 4 1 2 1 2 db Integer32 asaSrvPropObjType 1 1 3 6 1 4 1 897 2 4 1 2 1 3 db Integer32 asaSrvPropType 2 1 3 6 1 4 1 897 2 4 1 2 1 4 db OID asaSrvPropOID OID of Adaptive Server Anywh
35. ault Setting this value to 0 disables dynamic traps This field is optional Each DBn section of the asasnmp ini file describes a database how to connect to it and any dynamic traps that exist for the database The fields in this section are case sensitive The value for n is a number that identifies the database The numbers must start with 1 and numbers cannot be skipped For example if the asasnmp ini file contained entries for DB1 DB2 and DB4 the DB4 entry would be ignored because the file 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 field is required If you want to use an ODBC data source to connect to the database it must be a system data source not a user data source If you want to use an integrated login you must map to the SYSTEM account because the SNMP Agent runs as a service However this means that anything that runs as a service can then connect to the database without a password Alternatively you can change the account that the service runs under and then create an integrated login for that account The string ASTART NO IDLE 0 CON SNMP ASTOP NO is prepended to the connection string This string does the following e prevents the Adaptive Server Anywhere SNMP Extension Agent from trying to autostart a database server disables idle timeout since it is likely t
36. biLink 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 OAnywhere 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 SOL Remote User s Guide This book describes all aspects of the SOL 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 file transfer SOL Anywhere Studio Help This book includes the context sensitive help for Sybase Central Interactive SOL and other graphical tools It is not included in the printed documentation set
37. boundAssocia 0 rdbmsSrvParamTable tions This OID is not currently supported by the Adaptive Server Anywhere SNMP Extenstion Agent This table lists the server options that can be set by the Adaptive Server Anywhere SNMP Extension Agent through the Adaptive Server Anywhere MIB n is the index as follows n Server option 1 ConnsDisabled 2 LivenessTimeout default 3 QuittingTime 4 RememberLastStatement 5 RequestLogFile 6 RequestLogging 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 7 1 1 n db String rdbmsDbSrvParamName Name of option n 1 3 6 1 2 1 39 1 7 1 2 n db Integer rdbmsDbSrvParamSubIndex n 1 3 6 1 2 1 39 1 7 1 3 n db OID rdbmsDbSrvParamID 1 3 6 1 4 1 897 2 1 3 6 1 2 1 39 1 7 1 4 n db String rdbmsDbSrvParamCurrValue Current value of option n 1 3 6 1 2 1 39 1 7 1 5 n db String rdbmsDbSrvParamComment Full name of option n rdbmsSrvLimitedResourceTable 46 This table contains information about server configuration parameters 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 n Connec prop property LicenseCount 1 tions erty LicensesInUse Processors prop property NumProcessorsMax 2 erty NumProcessorsAvail if this is 0 then it returns prop erty NumProce
38. daptive Server Anywhere SNMP Extension Agent set the value of asaAgent asaProc OID 1 3 6 1 4 1 897 2 3 5 db where db is the database number in the asasnmp ini file 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 17 Using traps 18 Ww For example setting the value of asaAgent asaProc to the string pchin updatesales paraml 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 t 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 configure 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 configure your SNMP Service to send traps to your current machine To configure the SNMP service 1 Right click My Computer and choose Manage from the popup menu The Comp
39. e Extension Agent is connected to database db Setting this value to 0 causes the Adaptive Server Anywhere Extension Agent to shut down the database while setting this value to 1 causes the Adaptive Server Anywhere Exten sion Agent to attempt to start the database Returns whether database db is run ning Setting this value to 0 causes the Adaptive Server Anywhere Ex tension Agent to shut down the database while setting this value to 1 attempts to start the database Setting this value to a string proc_ name causes the Adaptive Server Anywhere Extension Agent to exe cuted the procedure proc_name in the database Arguments can be supplied for example proc_name string 4 if no arguments are supplied paren theses are appended to the name Getting the value returns 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 2 n order to be able to start a database by setting this variable the DBF parameter must be specified in the connection string along with DBN if desired and DBKEY if required and either a the UtilDbPwd field must be set in the asasnmp ini file or b the start database permission on the server specified with the gd server option must be set to all Chapter
40. e of the Add Remove Programs dialog click Add Remove Windows Components The Windows Components wizard appears On the first page of the Windows Components wizard double click Management and Monitoring Tools The Management and Monitoring Tools dialog appears Select the Simple Network Management Protocol option and then click OK Click Next Click Finished when the installation completes 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 6 4 To check that the SNMP services installed on your computer 1 Open the Control Panel On Windows 2000 from the Start menu choose Settings gt 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 SOL 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 SOL 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 Op
41. en data is retrieved from the database it can be cached inside the Adaptive Server Anywhere SNMP Extension Agent so that subseguent retrievals of the same type of data for example server properties or database statistics do not reguire communication with the database While caching the data means that you can obtain the data more guickly on subseguent retrievals the data may be out of date The CacheTime field 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 O the data retrieved is always be up to date because data is retrieved from the database for every reguest This field 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 field can be used to change the cache time or disable the cache by setting the value to 0 This field is optional For more information about the rdbmsDbLimitedResourceTable table see rdbmsDbLimitedResourceTable on page 44 Trapt Creates a dynamic trap The value t must be a positive integer Chapter 1 The Adaptive Server Anywhere SNMP Extension Agent Sample asasnmp ini file starting at 1 Skipping numbers is not
42. en the Control Panel On Windows 2000 from the Start menu choose Settings gt 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 11 Configuring the Adaptive Server Anywhere SNMP Extension Agent 12 ie 94 ie kod 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 ini file in the C Program Files Sybase SQL Anywhere 9 win32 directory Once you edit this file 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 Sta
43. ension Agent OID INTEGRATED SERVER NAME option ASA SNMP Extension Agent OID IOToRecover property ASA SNMP Extension Agent OID IOStore property ASA SNMP Extension Agent OID IsFipsAvailable property ASA SNMP Extension Agent OID IsIQ property ASA SNMP Extension Agent OID IsJavaAvailable property ASA SNMP Extension Agent OID IsNetworkServer property ASA SNMP Extension Agent OID ISOLATION LEVEL option ASA SNMP Extension Agent OID 34 34 29 29 24 31 31 29 31 31 34 31 34 29 29 29 29 36 Index IsRuntimeServer property ASA SNMP Extension Agent OID 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 JDK Version property ASA SNMP Extension Agent OID L Language property ASA SNMP Extension Agent OID LargeProcedureIDs property ASA SNMP Extension Agent OID LegalCopyright property ASA SNMP Extension Agent OID LegalTrademarks property ASA SNMP Extension Agent OID LicenseCount property ASA SNMP Extension Agent OID LicensedCompany property ASA SNMP Extension Agent OID LicensedU
44. ept id contact code char 2 pk N N type char 10 emp id dept head id id integer pk description char 50 last name char 15 first name char 15 title char 2 code code street char 30 department city char 20 state char 2 fin_data dept id integer lt pk gt zip char 5 dept name char 40 phone char 10 year char 4 lt pk gt dept head id integer lt fk gt fax char 10 quarter char 2 lt pk gt code char 2 lt pk fk gt amount numeric 9 xi Finding out more and providing feedback xii 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 sglanywhere general sybase public sglanywhere linux sybase public sglanywhere mobilink sybase public sqlanywhere product futures discussion sybase public sqlanywhere replication sybase public sglanywhere ultralite sybase public sglanywhere ganywhere Newsgroup disclaimer iAnywhere Solutions has no obligation to provide solutions information or ideas on its newsgroups nor is iAnywhere Solutions obliged to provide anything other than a systems operator to monitor the service and insure its operation and availability iAnywhere Solutions Technical Ad
45. ere MIB entry 1 3 6 1 4 1 897 2 4 1 2 1 5 db String asaSrvPropName Property name 1 Values 1 Server 2 Database 2 Values 1 Statistic 2 Property 3 Option 3 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 guery asaDbMetaData asaDbStatMetaDataTable This table contains metadata about the database statistics 25 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 2 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 entry 1 3 6 1 4 1 897 2 4 2 1 1 5 db String asaDbStatName Statistic name 1 Values 1 Server 2 Database 2 Values 1 Statistic 2 Property 3 Option 3 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 guery asaDbMetaData asaDbPropMetaDataTable This table contains metadata about the database properties 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 2 1 1 db Integer32 asaDbPropIndex db 1 3 6 1 4 1 897 2 4 2 2 1 2 db Integer32 asaDbPropObjType 2 1 3 6 1 4 1 897 2 4 2 2 1 3 db Integer32 asaDbPropType 22 1 3 6 1 4
46. ere SNMP Extension Agent you can retrieve the values of all the following Database server properties t For a list of the database server property OIDs see Server properties on page 29 Database server statistics 15 t Fora list of the database server statistic OIDs see Server statistics on page 27 Database options t For a list of the database option OIDs see Database options on page 36 Database properties t For a list of the database property OIDs see Database properties on page 33 Database statistics t Fora 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 1 database 1 1 3 6 1 4 1 897 2 1 2 1 3 1 3 6 1 4 1 897 2 2 1 4 1 1 3 6 1 4 1 897 2 2 2 7 4 1 3 6 1 4 1 897 2 2 3 5 2 1 3 6 1 4 1 897 2 3 1 1 3 6 1 4 1 897 2 3 2 1 16 Server property C2 on database3 NO Database statistic CacheRead on 11397 database 1 Database property CaseSensi OFF tivePasswords on database 4 Database option ANSI OFF INTEGER OVERFLOW on database 2 Agent version 9 0 1 1841 Connection string for database 1 UID DBA PWD SQL ENGz server DBN sales DBF sales db C
47. gent OID 29 NEAREST CENTURY option ASA SNMP Extension Agent OID 36 newsgroups technical support xii 54 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 O object identifiers 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 OlDs see also object identifiers about 6 Adaptive Server Anywhere MIB 23 database options 36 database properties 33 database statistics 31 defined 6 RDBMS MIB 42 server properties 29 server statistics 27 Omnildentifier property ASA SNMP Extension Agent OID 29 ON CHARSET CONVERSION FAILURE option ASA SNMP Extension Agent OID 36 ON TSOL 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 P PacketsReceived property Index ASA SNMP Extension Agent OID PacketsReceivedUncomp property ASA SNMP Extension Agent OID PacketsSent property ASA SNMP Extension Agent OID PacketsSentUncomp property ASA SNMP Extension
48. h dbspace as follows 1 13 are for normal dbspaces numbered 0 12 in the database 14isthe 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 OID Type Name Value returned 1 3 6 1 2 1 39 1 4 1 1 n db String rdbmsDbLimitedResource Name of dbspace or Trans Name action Log Transaction Log Mirror Temporary File or Write File 1 3 6 1 2 1 39 1 4 1 2 n db OID rdbmsDbLimitedResourceID 1 3 6 1 4 1 897 2 1 3 6 1 2 1 39 1 4 1 3 n db Integer rdbmsDbLimitedResource Free space available on disk Limit current file size in bytes 1 3 6 1 2 1 39 1 4 1 4 n db Integer rdbmsDbLimitedResourceCur Current file size rent 1 3 6 1 2 1 39 1 4 1 5 n db Integer rdbmsDbLimitedResource Current size Highwater 1 3 6 1 2 1 39 1 4 1 6 n db Integer rdbmsDbLimitedResource 0 Failure 1 3 6 1 2 1 39 1 4 1 7n db String rdbmsDbLimite Bytes dResourceDescription 1 This OID is not currently supported by the Adaptive Server Anywhere SNMP Extenstion Agent 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 135644 OT oA 1 3 6 1 2 1 39 1 5 1 2 db String rdbmsSrv VendorName property Compa
49. hapter 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 gueries 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 ts 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 A
50. hat the Adaptive Server Anywhere SNMP Extension Agent will sit idle for some time 13 14 e 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 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 find the database file However if the permission reguired 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 file in the asasnmp ini file 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 field is optional CacheTime Wh
51. i 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 reguests to agents and agents respond to gueries from managers Additionally agents can notify managers when specific events occur using notifications called traps SNMP agents handle reguests 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 unigue number under its parent The full name of a variable including all its parents is called the Object Identifier 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 file 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
52. iCloseCursorsOn Ansi close cursors on Rollback rollback 1 3 6 1 4 1 897 2 2 3 5 n String dbOptAnsilntegerOverflow Ansi_integer_overflow 1 3 6 1 4 1 897 2 2 3 6 n String dbOptAnsiPermissions Ansi_permissions 1 3 6 1 4 1 897 2 2 3 7 n String dbOptAnsiUpdateCon Ansi_update_constraints straints 1 3 6 1 4 1 897 2 2 3 8 n String dbOptAuditing Auditing 1 3 6 1 4 1 897 2 2 3 9 n String dbOptAuditingOptions Auditing options 1 3 6 1 4 1 897 2 2 3 10 n String dbOptAutomaticTimestamp Automatic timestamp 1 3 6 1 4 1 897 2 2 3 11 n String dbOptBackgroundPriority Background priority 1 3 6 1 4 1 897 2 2 3 12 n String dbOptBlocking Blocking 1 3 6 1 4 1 897 2 2 3 13 n Integer32 dbOptBlockingTimeout Blocking timeout 1 3 6 1 4 1 897 2 2 3 14 n String dbOptChained Chained 1 3 6 1 4 1 897 2 2 3 15 n Integer32 dbOptCheckpointTime Checkpoint time 1 3 6 1 4 1 897 2 2 3 16 n Integer32 dbOptCisOption Cis option 1 3 6 1 4 1 897 2 2 3 17 n Integer32 dbOptCisRowsetSize Cis rowset size 1 3 6 1 4 1 897 2 2 3 18 n String dbOptCloseOnEndtrans Close on endtrans 36 Chapter 2 Adaptive Server Anywhere MIB Reference OID Type Name Option 1 3 6 1 4 1 897 2 2 3 19 n String dbOptConnectionAuthentica Connection_authentication tion 1 3 6 1 4 1 897 2 2 3 20 n String dbOptContinueA fterRaiseer Continue_after_raise_error ror 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 dbOptCooperative
53. locks 40 CHAPTER 3 RDBMS MIB Reference About this chapter Contents This chapter contains descriptions of each of the tables in the RDBMS MIB Topic page The RDBMS MIB 42 41 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 db OID rdbmsDbPrivateMibOID 1 3 6 1 4 1 897 2 1 3 6 1 2 1 39 1 1 1 3 db String rdbmsDb VendorName property CompanyName 1 3 6 1 2 1 39 1 1 1 4 db String rdbmsDbName db_property name 1 3 6 1 2 1 39 1 1 1 5 db String rdbmsDbContact property LicensedUser rdbmsDbinfoTable This table provides additional information about the databases on the 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 2 1 1 db String rdbmsDbInfoProduct property PropertyName Name 1 3 6 1 2 1 39 1 2 1 2 db String rdbmsDbInfoVersion property ProductVersion 42 Chapter 3 RDBMS MIB Reference OID Type Name Value returned 1 3 6 1 2 1 39 1 2 1 3 db Integer rdbmsDb
54. n Integer32 srvStatMinCacheSize MinCacheSize 1 3 6 1 4 1 897 2 1 1 22 n Counter64 srvStatMultiPacketsReceived MultiPacketsReceived 1 3 6 1 4 1 897 2 1 1 23 n Counter64 srvStatMultiPacketsSent MultiPacketsSent 1 3 6 1 4 1 897 2 1 1 24 n Counter64 srvStatPacketsReceived PacketsReceived 1 3 6 1 4 1 897 2 1 1 25 n Counter64 srvStatPacketsReceivedUn PacketsReceivedUncomp comp 1 3 6 1 4 1 897 2 1 1 26 n Counter64 srvStatPacketsSent PacketsSent 1 3 6 1 4 1 897 2 1 1 27 n Counter64 srvStatPacketsSentUncomp PacketsSentUncomp 1 3 6 1 4 1 897 2 1 1 28 n Integer32 srvStatPeakCacheSize PeakCacheSize 1 3 6 1 4 1 897 2 1 1 29 n Integer32 srvStatRemoteputWait RemoteputWait 1 3 6 1 4 1 897 2 1 1 30 n Integer32 srvStatReq Req 1 3 6 1 4 1 897 2 1 1 31 n Counter64 srvStatSendFail SendFail 1 3 6 1 4 1 897 2 1 1 32 n Integer32 srvStatTotalBuffers TotalBuffers 1 3 6 1 4 1 897 2 1 1 33 n Integer32 srvStatUnschReq UnschReq 28 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 n String srvPropCommandLine Comma
55. ndLine 1 3 6 1 4 1 897 2 1 2 4 n String srvPropCompactPlatform Ver CompactPlatform Ver 1 3 6 1 4 1 897 2 1 2 5 n String srvPropCompanyName CompanyName 1 3 6 1 4 1 897 2 1 2 6 n String srvPropConnsDisabled ConnsDisabled 1 3 6 1 4 1 897 2 1 2 7 n String srvPropConsoleLogFile ConsoleLogFile 1 3 6 1 4 1 897 2 1 2 8 n String srvPropDefaultCollation DefaultCollation 1 3 6 1 4 1 897 2 1 2 9 n String srvPropIdleTimeout IdleTimeout 1 3 6 1 4 1 897 2 1 2 10 n String srvPropIsIO IsIQ 1 3 6 1 4 1 897 2 1 2 11 n String srvPropIsJavaAvailable IsJavaAvailable 1 3 6 1 4 1 897 2 1 2 12 n String srvPropIsNetworkServer IsNetworkServer 1 3 6 1 4 1 897 2 1 2 13 n String srvPropIsRuntimeServer IsRuntimeServer 1 3 6 1 4 1 897 2 1 2 14 n String srvPropJavaObjectsEnabled JavaObjectsEnabled 1 3 6 1 4 1 897 2 1 2 15 n String srvPropLanguage Language 1 3 6 1 4 1 897 2 1 2 16 n String srvPropLegalCopyright LegalCopyright 1 3 6 1 4 1 897 2 1 2 17 n String srvPropLegalTrademarks LegalTrademarks 1 3 6 1 4 1 897 2 1 2 18 n String srvPropLicenseCount LicenseCount 1 3 6 1 4 1 897 2 1 2 19 n String srvPropLicensedCompany LicensedCompany 1 3 6 1 4 1 897 2 1 2 20 n String srvPropLicensedUser LicensedUser 1 3 6 1 4 1 897 2 1 2 21 n String srvPropLicenseType LicenseType 1 3 6 1 4 1 897 2 1 2 22 n String srvPropLivenessTimeout LivenessTimeout 29 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 s
56. nect 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 eFulfillment 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 Work Architecture Enterprise Work Designer Enterprise Work Modeler 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 Warehouse Studio 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 Ne
57. nyName 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 db String rdbmsSrvContact property LicencedCompany rdbmsSrvinfoTable This table lists additional information about the database servers in 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 6 1 1 db Integer rdbmsSrvInfoStartupTime property StartTime 1 3 6 1 2 1 39 1 6 1 2 db Integer rdbmsSrvInfoFinishedTransactions 0 1 3 6 1 2 1 39 1 6 1 3 db Integer rdbmsSrvInfoDiskReads property DiskReadEng 1 3 6 1 2 1 39 1 6 1 4 db Integer rdbmsSrvInfoLogicalReads 0 1 3 6 1 2 1 39 1 6 1 5 db Integer rdbmsSrvInfoDiskWrites prop erty DiskWriteEng 1 3 6 1 2 1 39 1 6 1 6 db Integer rdbmsSrvInfoLogical Writes 0 1 3 6 1 2 1 39 1 6 1 7 db Integer rdbmsSrvInfoPageReads 0 1 3 6 1 2 1 39 1 6 1 8 db Integer rdbmsSrvInfoPageDiskOutOfWrites 0 1 3 6 1 2 1 39 1 6 1 9 db Integer rdbmsSrvInfoSpaces 0 1 3 6 1 2 1 39 1 6 1 10 db Integer rdbmsSrvInfoHandledRequests property Req 1 3 6 1 2 1 39 1 6 1 11 db Integer rdbmsSrvInfoRequestRecvs prop erty PacketsReceivedUncomp 1 3 6 1 2 1 39 1 6 1 12 db Integer rdbmsSrvInfoRequestSends prop erty PacketsSentUncomp 45 OID Type Name Value returned 1 3 6 1 2 1 39 1 6 1 13 db Integer rdbmsSrvInfoHighwaterInboundAs 0 sociations 1 3 6 1 2 1 39 1 6 1 14 db Integer rdbmsSrvInfoMaxIn
58. oolset 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 SOL 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 Warehouse WORKS WarehouseArchitect Watcom Watcom SQL Watcom SQL Server Web Deployment Kit Web PB Web SQL WebSights WebViewer WorkGroup SQL Server
59. pFormat 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 n Integer32 dbOptTimeZoneAdjustment Time_zone_adjustment 1 3 6 1 4 1 897 2 2 3 98 n String dbOptTruncateDate Values Truncate_date_values 1 3 6 1 4 1 897 2 2 3 99 n String dbOptTruncateTimestampVal Truncate_timestamp_values ues 1 3 6 1 4 1 897 2 2 3 100 n String dbOptTruncateWithAutocom Truncate_with_auto_commit mit 1 3 6 1 4 1 897 2 2 3 101 n String dbOptTsqlHexConstant Tsql_hex_constant 1 3 6 1 4 1 897 2 2 3 102 n String dbOptT sql Variables Tsgl variables 1 3 6 1 4 1 897 2 2 3 103 n String dbOptUpdateStatistics Update_statistics 1 3 6 1 4 1 897 2 2 3 104 n String dbOptUpgradeDatabaseCapa Upgrade database bility capability 1 3 6 1 4 1 897 2 2 3 105 n String dbOptUserEstimates User estimates 1 3 6 1 4 1 897 2 2 3 106 n String dbOptWaitForCommit Wait for commit 1 3 6 1 4 1 897 2 2 3 107 n String dbOptTempSpaceLim Temp space limit check itCheck 1 3 6 1 4 1 897 2 2 3 108 n Integer32 dbOptRemoteldleTimeout Remote idle timeout 1 3 6 1 4 1 897 2 2 3 109 n Integer32 dbOptInternal Internal 1 3 6 1 4 1 897 2 2 3 110 n String dbOptODBCDescribeBina ODBC_describe_binary_ ryAsVarbinary as varbinary 1 3 6 1 4 1 897 2 2 3 111 n String dbOptRollbackOnDeadlock Rollback on deadlock 1 3 6 1 4 1 897 2 2 3 112 n String dbOptIntegratedServerName Integrated server name 1 3 6 1 4 1 897 2 2 3 113 n String dbOptLogDeadlocks Log_dead
60. rs running on different machines Supplied files 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 The following files 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 file is located in C Program Files Sybase SQL Anywhere 9 win32 iAnywhere mib The Adaptive Server Anywhere MIB contains all the OIDs for database server and database properties statistics and options that can be accessed using the Adaptive Server Anywhere SNMP Extension Agent RDBMS MIB mib The is a generic MIB for relational database management systems and contains OIDs that can be accessed using the Adaptive Server Anywhere SNMP Extension Agent SNMPv2 SMI mib This MIB is referenced by the Adaptive Server Anywhere and RDBMS MIBs SNMPv2 TC mib This MIB is referenced by the Adaptive Server Anywhere and RDBMS MIBs SYBASE MIB mib The Sybase MIB This MIB is referenced by the Adaptive Server Anywhere MIB Chapter 1 The Adaptive Server Anywhere SNMP Extension Agent asasnmp in
61. rt menu choose Settings gt 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 The ASAAgent section The DBn section To restart the Adaptive Server Anywhere SNMP Extension Agent 1 Using your SNMP management tool change the value of the asaA gent 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 t For more information see Hiding the contents of ini files ASA Database Administration Guide page 524 The ASAAgent section of the asasnmp ini file contains a TrapPollTime field with information about the Adaptive Server Anywhere Extension Agent If the TrapPollTime field is not required you can omit the entire section TrapPollTime This value specifies the poll frequency for dynamic traps if they are specified The Adaptive Server Anywhere SNMP Extension Agent polls the values every 5 seconds by def
62. rvPropMaxMessage 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 srvPropNativeProcessorArchi NativeProcessorArchitecture tecture 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 n String srvPropNumProcessorsMax NumProcessorsMax 1 3 6 1 4 1 897 2 1 2 30 n String srvPropOmnildentifier Omnildentifier 1 3 6 1 4 1 897 2 1 2 31 n String srvPropPageSize PageSize 1 3 6 1 4 1 897 2 1 2 32 n String srvPropPlatform Platform 1 3 6 1 4 1 897 2 1 2 33 n String srvPropPlatform Ver Platform Ver 1 3 6 1 4 1 897 2 1 2 34 n String srvPropProcessCPU ProcessCPU 1 3 6 1 4 1 897 2 1 2 35 n String srvPropProcessCPUSystem ProcessCPUSystem 1 3 6 1 4 1 897 2 1 2 36 n String srvPropProcessCPUUser ProcessCPUUser 1 3 6 1 4 1 897 2 1 2 37 n String srvPropProcessorArchitecture ProcessorArchitecture 1 3 6 1 4 1 897 2 1 2 38 n String srvPropProductName ProductName 1 3 6 1 4 1 897 2 1 2 39 n String srvPropProductVersion ProductVersion 1 3 6 1 4 1 897 2 1 2 40 n String srvPropQuittingTime QuittingTime 1 3 6 1 4 1 897 2 1 2 41 n String srvPropRememberLastState RememberLastStatement ment 1 3 6 1 4 1 897 2 1 2 42 n String srvPropRequestFilterConn RequestFilterConn 1 3 6 1 4 1 897 2 1 2 43 n String srvPropRequestFilterDB RequestFilterDB 1 3 6 1 4 1 897 2 1 2 44 n String srvPropRequestLogFile RequestLogFile 1 3
63. s supported platforms Agent table Adaptive Server Anywhere MIB agents about Alias property ASA SNMP Extension Agent OID ALLOW_NULLS_BY_DEFAULT option ASA SNMP Extension Agent OID ANSI BLANKS option ASA SNMP Extension Agent OID ANSI CLOSE CURSORS ON ROLLBACK option ASA SNMP Extension Agent OID 3 12 10 19 17 17 12 6 4 24 34 36 36 36 ANSI INTEGER OVERFLOW option ASA SNMP Extension Agent OID ANSI PERMISSIONS option ASA SNMP Extension Agent OID ANSI UPDATE CONSTRAINTS option ASA SNMP Extension Agent OID ANSINULL option ASA SNMP Extension Agent OID asaDbOptMetaDataTable Adaptive Server Anywhere MIB asaDbPropMetaDataTable Adaptive Server Anywhere MIB asaDbStatMetaDataTable Adaptive Server Anywhere MIB asasnmp ini file reguired for ASA SNMP Extension Agent asaSrvPropMetaDataTable Adaptive Server Anywhere MIB asaSrvStatMetaDataTable Adaptive Server Anywhere MIB AUDITING option ASA SNMP Extension Agent OID AUDITING_OPTIONS option ASA SNMP Extension Agent OID AuditingTypes property ASA SNMP Extension Agent OID AUTOMATIC_TIMESTAMP option ASA SNMP Extension Agent OID AvaillO property ASA SNMP Extension Agent OID BACKGROUND_PRIORITY option ASA SNMP Extension Agent OID BlankPadding property ASA SNMP Extension Agent OID BlobArenas property ASA SNMP Extension Agent OID BLOCKING option ASA SNMP Extension Agent OID BLOCKING_TIMEOUT option ASA SNMP Extension Agent OID
64. se SQL Anywhere 9 snmp iAnywhere mib t For information about the tables in the Adaptive Server Anywhere MIB see Adaptive Server Anywhere MIB Reference on page 23 1 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 Name Description 1 3 6 1 4 897 2 1 1 n db 1 3 6 1 4 897 2 1 2 n db 1 3 6 1 4 897 2 2 1 n db 1 3 6 1 4 897 2 2 2 n db 1 3 6 1 4 897 2 2 3 n db 1 3 6 1 4 897 2 3 1 1 3 6 1 4 897 2 3 2 db asaServer asaSrvStat asaServer asaSrvProp asaDb asaDbStat asaDb asaDbProp asaDb asaDbOpt asaA gent asa Version asaA gent asaDbConnStr Returns the value of server statistic n on database db Returns the value of server property n on database db Returns the value of database statis tic n on database db Returns the value of database prop erty n on database db Returns the value of database option n on database db Returns the version of the Adaptive Server Anywhere Extension Agent Returns the connection string for database db OID Name Description 1 3 6 1 4 897 2 3 3 db 1 3 6 1 4 897 2 3 4 db 1 3 6 1 4 897 2 3 5 db 1 3 6 1 4 897 2 4 asaA gent asaConnected asaA gent asaStarted asaA gent asaProc asaMetaData Returns whether the Adaptive Server Anywher
65. ser property ASA SNMP Extension Agent OID LicensesInUse property ASA SNMP Extension Agent OID LicenseType property ASA SNMP Extension Agent OID LivenessTimeout property ASA SNMP Extension Agent OID LOCK_REJECTED_ROWS option ASA SNMP Extension Agent OID LockedHeapPages property 29 29 36 36 36 36 27 31 31 29 34 34 34 29 29 29 29 29 27 29 29 36 ASA SNMP Extension Agent OID LockTablePages property ASA SNMP Extension Agent OID LOG_DEADLOCKS option ASA SNMP Extension Agent OID LOG_DETAILED_PLANS option ASA SNMP Extension Agent OID LOG_MAX_REQUESTS option ASA SNMP Extension Agent OID LogFileFragments property ASA SNMP Extension Agent OID LogFreeCommit property ASA SNMP Extension Agent OID LOGIN_MODE option ASA SNMP Extension Agent OID LOGIN_PROCEDURE option ASA SNMP Extension Agent OID LogMirrorName property ASA SNMP Extension Agent OID LogName property ASA SNMP Extension Agent OID LogWrite property ASA SNMP Extension Agent OID LTMGeneration property ASA SNMP Extension Agent OID LTMTrunc property ASA SNMP Extension Agent OID MachineName property ASA SNMP Extension Agent OID MainHeapBytes property ASA SNMP Extension Agent OID MainHeapPages property ASA SNMP Extension Agent OID management information bases about managers about MapPages property ASA SNMP Extension Agent OID MapPhysicalMemoryEng property ASA SNMP Extension Agent O
66. ssorsAvail OID Type Name Value returned 1 3 6 1 2 1 39 1 8 1 1 db String rdbmsSrvLimitedResource Name of resource n Name 1 3 6 1 2 1 39 1 8 1 2 db OID rdbmsSrvLimitedResour OID in Adaptive Server Anywhere ceID MIB corresponding to this option 1 3 6 1 2 1 39 1 8 1 3 db Integer rdbmsSrvLimitedResource Upper limit of resource n Limit 1 3 6 1 2 1 39 1 8 1 4 db Integer rdbmsSrvLimitedResource Current value of resource n Current 1 3 6 1 2 1 39 1 8 1 5 db Integer rdbmsSrvLimitedResource Current value of resource n Highwater 1 3 6 1 2 1 39 1 8 1 6 db Integer rdbmsSrvLimitedResource 0 Failures 1 3 6 1 2 1 39 1 8 1 7 db String rdbmsSrvLimite Name of resource n dResourceDescription 1 This OID is not currently supported by the Adaptive Server Anywhere SNMP Extenstion Agent 47 48 Index A ActiveReg property ASA SNMP Extension Agent OID Adaptive Server Anywhere MIB about Agent table asaDbOptMetaDataTable asaDbPropMetaDataTable asaDbStatMetaDataTable asaMetaData tables asaSrvPropMetaDataTable asaSrvStatMetaDataTable database options database properties database statistics list of tables server properties server statistics Adaptive Server Anywhere MIB reference 27 7 24 27 26 26 24 25 24 36 33 31 24 29 27 23 Adaptive Server Anywhere SNMP Extension Agent about asasnmp ini file configuring dynamic traps executing functions executing stored procedures restarting supported MIB
67. t OID RequestLogFile property ASA SNMP Extension Agent OID RequestLogging property ASA SNMP Extension Agent OID RequestLogMaxSize property ASA SNMP Extension Agent OID RequestLogNumFiles property ASA SNMP Extension Agent OID RETURN_DATE_TIME_AS_STRING option ASA SNMP Extension Agent OID RETURN JAVA AS STRING option ASA SNMP Extension Agent OID RI TRIGGER TIME option ASA SNMP Extension Agent OID ROLLBACK ON DEADLOCK option ASA SNMP Extension Agent OID RollbackLogPages property ASA SNMP Extension Agent OID ROW COUNTS option ASA SNMP Extension Agent OID 56 36 34 36 31 31 29 36 27 34 36 27 29 29 29 29 29 29 S 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 15 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 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 St
68. ted_identifier 1 3 6 1 4 1 897 2 2 3 77 n String dbOptReadPastDeleted Read_past_deleted 1 3 6 1 4 1 897 2 2 3 78 n Integer32 dbOptRecoveryTime Recovery_time 1 3 6 1 4 1 897 2 2 3 79 n String dbOptReplicateAll Replicate all 1 3 6 1 4 1 897 2 2 3 80 n String dbOptReturnDateTime Return date time as string AsString 1 3 6 1 4 1 897 2 2 3 81 n String dbOptReturnJavaAsString Return java as string 1 3 6 1 4 1 897 2 2 3 82 n String dbOptRITriggerTime RI trigger time 1 3 6 1 4 1 897 2 2 3 83 n String dbOptRowCounts Row counts 1 3 6 1 4 1 897 2 2 3 84 n Integer32 dbOptScale Scale 1 3 6 1 4 1 897 2 2 3 85 n String dbOptSortCollation Sort_collation 1 3 6 1 4 1 897 2 2 3 86 n String dbOptSQLFlaggerError SOL flagger error level Level 1 3 6 1 4 1 897 2 2 3 87 n String dbOptSOLFlaggerWarn SOL flagger warning level ingLevel 1 3 6 1 4 1 897 2 2 3 88 n String dbOptStringRtruncation String_rtruncation 1 3 6 1 4 1 897 2 2 3 89 n String dbOptSubsumeRowLocks Subsume_row_locks 1 3 6 1 4 1 897 2 2 3 90 n String dbOptSuppressTDSDebug Suppress_TDS_debugging ging 39 OID Type Name Option 1 3 6 1 4 1 897 2 2 3 91 String dbOptTDSEmptyStringlIs TDS empty string is null 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 dbOptTimestam
69. teger32 dbStatCurrIO CurrIO 1 3 6 1 4 1 897 2 2 1 22 n Integer32 dbStatCurrRead CurrRead 1 3 6 1 4 1 897 2 2 1 23 n Integer32 dbStatCurrWrite CurrWrite 1 3 6 1 4 1 897 2 2 1 24 n Integer32 dbStatDiskReadIndInt DiskReadIndInt 1 3 6 1 4 1 897 2 2 1 25 n Integer32 dbStatDiskReadIndLeaf DiskReadIndLeaf 1 3 6 1 4 1 897 2 2 1 26 n Counter64 dbStatDiskRead DiskRead 1 3 6 1 4 1 897 2 2 1 27 n Integer32 dbStatDiskReadTable DiskReadTable 1 3 6 1 4 1 897 2 2 1 28 n Counter64 dbStatDiskWrite DiskWrite 1 3 6 1 4 1 897 2 2 1 29 n Integer32 dbStatExtendDB ExtendDB 1 3 6 1 4 1 897 2 2 1 30 n Integer32 dbStatExtendTemp Write ExtendTempWrite 1 3 6 1 4 1 897 2 2 1 31 n Integer32 dbStatFullCompare FullCompare 1 3 6 1 4 1 897 2 2 1 32 n Integer32 dbStatGetData GetData 1 3 6 1 4 1 897 2 2 1 33 n Integer32 dbStatIdleCheck IdleCheck 1 3 6 1 4 1 897 2 2 1 34 n Integer32 dbStatIdleChkpt IdleChkpt 1 3 6 1 4 1 897 2 2 1 35 n Integer32 dbStatIdleChkTime IdleChkTime 32 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
70. twork 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 OAnywhere 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 LE T Message Format Libraries SAFE SAFE PRO SDF Secure SQL Server Secure SQL T
71. u wish in the asasnmp ini file 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 fields as you wish in the asasnmp ini file The OID used for the trap will be 1 3 6 1 4 1 897 2 4 1 and the data sent with the trap includes the following the trap number starts at 1 for the first dynamic trap sent by the Adaptive Server Anywhere SNMP agent the database index the database name trap index from the asasnmp ini file the variable name the variable value this is the current value of the variable not necessarily the threshold value 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 gt 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 notified if the cache size grew to 5 MB again Description 1 1 1 5 gt 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 gt 10485760 Trap sent if the size of the transaction log file is 20 larger than 10 MB PART
72. udio 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 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 T TableBitMaps property ASA SNMP Extension Agent OID TablesOualTriggers property ASA SNMP Extension Agent OID TDS EMPTY STRING IS NULL option ASA SNMP Extension Agent OID technical support newsgroups TEMP_SPACE_LIMIT_CHECK option ASA SNMP Extension Agent OID TempDir property ASA SNMP Extension Agent OID TempFileName property ASA SNMP Extension Agent OID TempTablePages property ASA SNMP Extension Agent OID THREAD_COUNT option ASA SNMP Extension Agent OID THREAD_STACK option ASA SNMP Extension Agent OID THREAD_SWAPS option ASA SNMP Extension Agent OID Threads property ASA SNMP Extension Agent OID TIME_FORMAT option ASA SNMP Extension Agent OID TIME_ZONE_ADJUSTMENT option AS
73. uter 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 Configuration dialog appears 7 In the SNMP Service Configuration 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 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 t For more information about dynamic traps see Creating dynamic traps on page 19 Creating dynamic traps A dynamic trap is a trap that is sent by the Adaptive Server Anywhere Extension Agent when a simple expression involving the value of a particular property statistic or option is true Dynamic traps are created in the asasnmp ini file The format of the trap information in the asasnmp ini file entry is as follows Trap lt trapnum gt 1 3 6 1 4 1 897 2 lt oid gt lt dbnum gt lt op gt lt value gt tr
74. visors 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 USING THE ADAPTIVE SERVER ANYWHERE SNMP EXTENSION 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 This chapter introduces you to the Adaptive Server Anywhere SNMP Extension Agent Contents Topic page Introduction to the Adaptive Server Anywhere SNMP Extension 4 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 serve
75. where 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 n String dbPropCapabilities Capabilities 1 3 6 1 4 1 897 2 2 2 6 n String dbPropCaseSensitive CaseSensitive 1 3 6 1 4 1 897 2 2 2 7 n String dbPropCaseSensitivePasswords CaseSensitivePasswords 1 3 6 1 4 1 897 2 2 2 8 n String dbPropCharSet CharSet 1 3 6 1 4 1 897 2 2 2 9 n String dbPropChecksum Checksum 1 3 6 1 4 1 897 2 2 2 10 n String dbPropClusteredIndexes ClusteredIndexes 1 3 6 1 4 1 897 2 2 2 11 n String dbPropCollation Collation 1 3 6 1 4 1 897 2 2 2 12 n String dbPropCompressedB Trees CompressedB Trees 1 3 6 1 4 1 897 2 2 2 13 n String dbPropCompression Compression 1 3 6 1 4 1 897 2 2 2 14 n String dbPropCurrentRedoPos CurrentRedoPos 1 3 6 1 4 1 897 2 2 2 15 n String dbPropDBFileFragments DBFileFragments 1 3 6 1 4 1 897 2 2 2 16 n String dbPropDriveType DriveType 1 3 6 1 4 1 897 2 2 2 17 n String dbPropEncryption Encryption 1 3 6 1 4 1 897 2 2 2 18 n String dbPropFile File 1 3 6 1 4 1 897 2 2 2 19 n String dbPropFileSize FileSize 1 3 6 1 4 1 897 2 2 2 20 n String dbPropFile Version FileVersion 1 3 6 1 4
76. yees departments and finances as well as product information and sales information sales orders customers and contacts All information in the database is fictional The following figure shows the tables in the sample database and how they relate to each other product sales order items Employee id integer lt pk gt a integer emp id integer lt gt name char 15 line id smallint pk manager id integer description char 30 lt prod_id integer emp_fname char 20 size char 18 id jal Wani integer emp Iname char 20 color char 6 ship date date dept id integer lt fk gt guantity integer street char 40 unit_price numeric 15 2 m emp id sales rep city char 20 id id state char 4 Y zip_code char 9 phone char 10 sales_order status char 1 customer ss_number char 11 id integer lt pk gt salary numeric 20 3 id integer lt pk gt cust id integer lt fk gt start date date fname char 15 order date date termination date date Iname char 20 4 fin code id char 2 lt fk gt birth date date address char 35 id cust id region char 7 bene health ins char 1 city char 20 sales rep integer lt fk gt bene life ins char 1 state char 2 bene day care char 1 Zip char 10 sex char 1 phone char 20 code fin_code_id company name char 35 fin code dept id d

Download Pdf Manuals

Related Search

Related Contents

Chronique Hiver 2010-2011 Pare  WACP Stress ECG - Spanish  WLAN-Installationshandbuch  2015 Nissan LEAF  dmt Affections respiratoires professionnelles chez les personnels de  DIVISION OF LIBRARY SERVICES EndNote X7 Mac User Manual  三和掲示板 開閉薄型自立式 取扱説明書 SG タイプ  取扱説明書  Télécharger  Packard Bell CT500P Computer Monitor User Manual  

Copyright © All rights reserved. Failed to retrieve file