Sybase Adaptive Server Anywhere SNMP Extension Agent Bedienungsanleitung

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70

Zur Seite of

Richtige Gebrauchsanleitung

Die Vorschriften verpflichten den Verkäufer zur Übertragung der Gebrauchsanleitung Sybase Adaptive Server Anywhere SNMP Extension Agent an den Erwerber, zusammen mit der Ware. Eine fehlende Anleitung oder falsche Informationen, die dem Verbraucher übertragen werden, bilden eine Grundlage für eine Reklamation aufgrund Unstimmigkeit des Geräts mit dem Vertrag. Rechtsmäßig lässt man das Anfügen einer Gebrauchsanleitung in anderer Form als Papierform zu, was letztens sehr oft genutzt wird, indem man eine grafische oder elektronische Anleitung von Sybase Adaptive Server Anywhere SNMP Extension Agent, sowie Anleitungsvideos für Nutzer beifügt. Die Bedingung ist, dass ihre Form leserlich und verständlich ist.

Was ist eine Gebrauchsanleitung?

Das Wort kommt vom lateinischen „instructio”, d.h. ordnen. Demnach kann man in der Anleitung Sybase Adaptive Server Anywhere SNMP Extension Agent die Beschreibung der Etappen der Vorgehensweisen finden. Das Ziel der Anleitung ist die Belehrung, Vereinfachung des Starts, der Nutzung des Geräts oder auch der Ausführung bestimmter Tätigkeiten. Die Anleitung ist eine Sammlung von Informationen über ein Gegenstand/eine Dienstleistung, ein Hinweis.

Leider widmen nicht viele Nutzer ihre Zeit der Gebrauchsanleitung Sybase Adaptive Server Anywhere SNMP Extension Agent. Eine gute Gebrauchsanleitung erlaubt nicht nur eine Reihe zusätzlicher Funktionen des gekauften Geräts kennenzulernen, sondern hilft dabei viele Fehler zu vermeiden.

Was sollte also eine ideale Gebrauchsanleitung beinhalten?

Die Gebrauchsanleitung Sybase Adaptive Server Anywhere SNMP Extension Agent sollte vor allem folgendes enthalten:
- Informationen über technische Daten des Geräts Sybase Adaptive Server Anywhere SNMP Extension Agent
- Den Namen des Produzenten und das Produktionsjahr des Geräts Sybase Adaptive Server Anywhere SNMP Extension Agent
- Grundsätze der Bedienung, Regulierung und Wartung des Geräts Sybase Adaptive Server Anywhere SNMP Extension Agent
- Sicherheitszeichen und Zertifikate, die die Übereinstimmung mit entsprechenden Normen bestätigen

Warum lesen wir keine Gebrauchsanleitungen?

Der Grund dafür ist die fehlende Zeit und die Sicherheit, was die bestimmten Funktionen der gekauften Geräte angeht. Leider ist das Anschließen und Starten von Sybase Adaptive Server Anywhere SNMP Extension Agent zu wenig. Eine Anleitung beinhaltet eine Reihe von Hinweisen bezüglich bestimmter Funktionen, Sicherheitsgrundsätze, Wartungsarten (sogar das, welche Mittel man benutzen sollte), eventueller Fehler von Sybase Adaptive Server Anywhere SNMP Extension Agent und Lösungsarten für Probleme, die während der Nutzung auftreten könnten. Immerhin kann man in der Gebrauchsanleitung die Kontaktnummer zum Service Sybase finden, wenn die vorgeschlagenen Lösungen nicht wirksam sind. Aktuell erfreuen sich Anleitungen in Form von interessanten Animationen oder Videoanleitungen an Popularität, die den Nutzer besser ansprechen als eine Broschüre. Diese Art von Anleitung gibt garantiert, dass der Nutzer sich das ganze Video anschaut, ohne die spezifizierten und komplizierten technischen Beschreibungen von Sybase Adaptive Server Anywhere SNMP Extension Agent zu überspringen, wie es bei der Papierform passiert.

Warum sollte man Gebrauchsanleitungen lesen?

In der Gebrauchsanleitung finden wir vor allem die Antwort über den Bau sowie die Möglichkeiten des Geräts Sybase Adaptive Server Anywhere SNMP Extension Agent, über die Nutzung bestimmter Accessoires und eine Reihe von Informationen, die erlauben, jegliche Funktionen und Bequemlichkeiten zu nutzen.

Nach dem gelungenen Kauf des Geräts, sollte man einige Zeit für das Kennenlernen jedes Teils der Anleitung von Sybase Adaptive Server Anywhere SNMP Extension Agent widmen. Aktuell sind sie genau vorbereitet oder übersetzt, damit sie nicht nur verständlich für die Nutzer sind, aber auch ihre grundliegende Hilfs-Informations-Funktion erfüllen.

Inhaltsverzeichnis der Gebrauchsanleitungen

  • Seite 1

    Adaptiv e Ser v er ® An ywhere SNMP Extension Agent User’ s Guide Part number: DC00192-01-0902-01 Last modified: December 2004[...]

  • Seite 2

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

  • Seite 3

    Contents About This Manual v SQL An ywhere Studio documentation . . . . . . . . . . . . . vi Documentation conventions . . . . . . . . . . . . . . . . . . . ix The Adaptive Ser ver Anywhere sample database . . . . . . . xi Finding out more and providing feedbac k . . . . . . . . . . . xii I Using the Adaptive Server Anywhere SNMP Ex- tension Agent [...]

  • Seite 4

    iv[...]

  • Seite 5

    About This Manual Subject This book cov ers material related to running and configuring the Adapti ve Server An ywhere SNMP Extension Agent. A udience This manual is for Adaptiv e Server Anywhere users who wish to use the Adaptiv e Server Anywhere SNMP Extension Agent on W indows 2000, W indows XP , or W indo ws Server 2003 (32-bit v ersions). It [...]

  • Seite 6

    SQL An ywhere Studio documentation This book is part of the SQL Anywhere documentation set. This section describes the books in the documentation set and how you can use them. The SQL Anywhere Studio documentation The SQL Anywhere Studio documentation is a v ailable in a v ariety of forms: in an online form that combines all books in one large help[...]

  • Seite 7

    ♦ SQL Anywhere Studio Security Guide This book provides information about security features in Adaptiv e Server Anywhere databases. Adaptive Serv er Anywhere 7.0 was awarded a TCSEC (T rusted Computer System Ev aluation Criteria) C2 security rating from the U.S. Gov ernment. This book may be of interest to those who wish to run the current versio[...]

  • Seite 8

    ♦ UltraLite Interface Guides A separate book is provided for each UltraLite programming interface. Some of these interfaces are provided as UltraLite components for rapid application dev elopment, and others are provided as static interfaces for C, C++, and Ja va de velopment. In addition to this documentation set, PowerDesigner and InfoMak er in[...]

  • Seite 9

    Documentation con ventions This section lists the typographic and graphical con ventions used in this documentation. Syntax conv entions The following con ventions are used in the SQL syntax descriptions: ♦ Ke ywor ds All SQL keywords appear in upper case, like the w ords AL TER T ABLE in the following e xample: AL TER T ABLE [ owner .] table-nam[...]

  • Seite 10

    Graphic icons The following icons are used in this documentation. ♦ A client application. ♦ A database server , such as Sybase Adaptiv e Server An ywhere. ♦ A database. In some high-level diagrams, the icon may be used to represent both the database and the database server that manages it. ♦ Replication or synchronization middlew are. These[...]

  • Seite 11

    The Adaptive Server Anywhere sample database Many of the e xamples throughout the documentation use the Adapti ve Server An ywhere sample database. The sample database is held in a file named asademo.db , and is located in your SQL Anywhere directory . The sample database represents a small company . It contains internal information about the comp[...]

  • Seite 12

    Finding out more and pr o viding feedbac k W e would like to recei ve your opinions, suggestions, and feedback on this documentation. Y ou can provide feedback on this documentation and on the software through newsgroups set up to discuss SQL An ywhere technologies. These newsgroups can be found on the forums.sybase.com news serv er . The newsgroup[...]

  • Seite 13

    P A R T I U SING THE A D APTIVE S E R V E R A NYWHERE S N M P E XTENSION A G E N T This part describes how to set up and configure the Adaptiv e Server Anywhere SNMP Extension Agent.[...]

  • Seite 14

    [...]

  • Seite 15

    CHAPTER 1 The Adaptive Server Anywhere SNMP Extension Agent About this chapter This chapter introduces you to the Adaptiv e Server Anywhere SNMP Extension Agent. Contents T opic: page Introduction to the Adaptiv e Server An ywhere SNMP Extension Agent 4 Understanding SNMP 6 Using the Adaptiv e Server Anywhere SNMP Extension Agent 10 3[...]

  • Seite 16

    Intr oduction to the Adaptive Server Anywhere SNMP Extension Agent If you are running Adaptiv e Server Anywhere on W indows 2000, W indows XP , or W indows Serv er 2003 (32-bit versions), you can use the Adaptiv e Server An ywhere SNMP Extension Agent in conjunction with SNMP management applications to manage your Adaptiv e Server Anywhere database[...]

  • Seite 17

    Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent ♦ asasnmp.ini This file lists the databases that the Adaptiv e Server Anywhere SNMP Extension Agent monitors. By default, this file is located in C:Program FilesSybaseSQL Anywhere 9win32 . 5[...]

  • Seite 18

    Understanding SNMP Simple Network Management Protocol ( SNMP ) is a standard protocol used for network management. SNMP allows managers and agents to communicate: managers send requests to agents, and agents respond to queries from managers. Additionally , agents can notify managers when specific ev ents occur using notifications called traps . S[...]

  • Seite 19

    Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent The Adaptive Server Anywhere MIB The Adaptiv e Server Anywhere MIB was created for the Adapti ve Server Anywhere SNMP Extension Agent. It includes all database server statistics and properties, as well as all database statistics, properties, and options. The statistics and properties are [...]

  • Seite 20

    OID Name Description 1.3.6.1.4.897.2.3.3. db asaAgent.asaConnected Returns whether the Adaptiv e Server An ywhere Extension Agent is connected to database db . Setting this value to 0 causes the Adapti ve Server An ywhere Extension Agent to shut down the database 1 , while setting this value to 1 causes the Adaptiv e Server Anywhere Exten- sion Age[...]

  • Seite 21

    Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent asaMetaData tables The Adaptiv e Server Anywhere MIB includes metadata tables that provide a way to query the Adapti ve Server Anywhere Extension Agent to find out which variables are supported. ♦ asaSrvMetaData.asaSrvStatMetaDataT able lists the database server statistics (variables u[...]

  • Seite 22

    Using the Adaptive Server Anywhere SNMP Extension Agent In order to use the Adaptiv e Server Anywhere SNMP Extension Agent, you must hav e SNMP installed on your machine and you must create an asasnmp.ini file that contains information about the databases that are monitored by the Adaptiv e Server Anywhere SNMP Extension Agent. Installing SNMP Bef[...]

  • Seite 23

    Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent ❖ T o check that the SNMP services are installed on y our computer 1. Open the Control Panel. ♦ On W indows 2000, from the Start menu choose Settings ➤ Control Panel. ♦ On W indows XP , from the Start menu choose Control Panel. 2. In the Control Panel, double-click Administrati ve[...]

  • Seite 24

    Configuring the Adaptive Server Anywhere SNMP Extension Agent The Adaptiv e Server Anywhere Extension Agent can monitor one or more databases. The databases to be monitored are stored in the asasnmp.ini file with the following format: [ ASAAgent ] TrapPollTime= time in seconds [ DB n ] ConnStr= connection string UtilDbPwd= utility database passwo[...]

  • Seite 25

    Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent ❖ T o restar t the Adaptive Server An ywhere SNMP Extension Agent 1. Using your SNMP management tool, change the value of the asaAgent.asaRestart property , 1.3.6.1.4.1.897.2.3.6 , to 1 . Y ou can obfuscate the contents of the asasnmp.ini file with simple encryption using the File Hidi[...]

  • Seite 26

    • names the connection so it can be identified • prev ents the database from being shut down when the Adapti ve Serv er Anywhere SNMP Extension Agent disconnects If you specify any of these v alues in the connection string in the asasnmp.ini file, the values in the asasnmp.ini file will ov erride the default settings. UtilDbPwd When setting [...]

  • Seite 27

    Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent starting at 1. Skipping numbers is not allowed. This field is optional. Disabled If set to 1, this database entry is skipped by the Adapti ve Serv er Anywhere SNMP Extension Agent. This is useful for temporarily removing one database from the list of databases managed by the Adaptiv e Se[...]

  • Seite 28

    ☞ For a list of the database serv er statistic OIDs, see “Server statistics” on page 27 . ♦ Database options ☞ For a list of the database option OIDs, see “Database options” on page 36 . ♦ Database properties ☞ For a list of the database property OIDs, see “Database properties” on page 33 . ♦ Database statistics ☞ For a li[...]

  • Seite 29

    Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent Setting values using the Adaptive Ser ver An ywhere SNMP Extension Agent The Adaptiv e Server Anywhere SNMP Extension Agent responds to SNMP get, get-next, and set queries. Y ou can set any database option, some server properties, and one database property using the Adaptiv e Server Anywh[...]

  • Seite 30

    For e xample, setting the value of asaAgent.asaProc to the string “ pchin.updatesales( ’param1’, 2) ” calls the updatesales stored procedure owned by user pchin. The way you set the v alue of this OID to the procedure name will depend on your SNMP management software. ☞ For more information, see “The Adapti ve Server Anywhere MIB” on [...]

  • Seite 31

    Chapter 1. The Adaptive Server Anywhere SNMP Extension Agent Adaptive Server Anywhere SNMP Extension Agent traps The Adaptiv e Server Anywhere SNMP Extension Agent sends a trap whenev er a connection is dropped by the database server . The OID of this trap is 1.3.6.1.2.1.39.2.1 . The only other traps sent by the Adaptiv e Server Anywhere agent are [...]

  • Seite 32

    Note Only equality or inequality are supported for string values. value is the v alue to use in the expression. String values may be enclosed in single or double quotes; these quotes will not be included in the value. If you want the beginning or closing quotation marks to be included in the string, you must double them. Note that single quotes occ[...]

  • Seite 33

    P A R T I I A D APTIVE S E R V E R A NYWHERE SNMP E XTENSION A G E N T R E F E R E N C E This section lists the OIDs supported by the Adaptiv e Server Anywhere SNMP Extension Agent. It lists the contents of the tables in the Adaptive Server An ywhere MIB and the RDBMS MIB.[...]

  • Seite 34

    [...]

  • Seite 35

    CHAPTER 2 Adaptive Server Anywhere MIB Ref erence About this chapter This chapter contains descriptions of the tables in the Adaptiv e Server Anywhere MIB. Contents T opic: page The Adaptiv e Server An ywhere MIB 24 23[...]

  • Seite 36

    The Adaptive Server Anywhere MIB The following sections list the OIDs of the statistics, properties, and options that can be retriev ed and set using the Adaptive Serv er Anywhere SNMP Extension Agent. By default, Agent The Agent table lists information about the Adaptiv e Server Anywhere SNMP Extension Agent. Writable properties are marked with an[...]

  • Seite 37

    Chapter 2. Adaptive Server Anywhere MIB Ref erence OID T ype Name V alue returned 1.3.6.1.4.1.897.2.4.1.1.1.1. db Integer32 asaSrvStatInde x db 1.3.6.1.4.1.897.2.4.1.1.1.2. db Integer32 asaSrvStatObjT ype 1 1 1.3.6.1.4.1.897.2.4.1.1.1.3. db Integer32 asaSrvStatT ype 1 2 1.3.6.1.4.1.897.2.4.1.1.1.4. db OID asaSrvStatOID OID of Adapti ve Server Any- [...]

  • Seite 38

    The value db is the database number in the asasnmp.ini file. OID T ype Name V alue returned 1.3.6.1.4.1.897.2.4.2.1.1.1. db Integer32 asaDbStatInde x db 1.3.6.1.4.1.897.2.4.2.1.1.2. db Integer32 asaDbStatObjT ype 2 1 1.3.6.1.4.1.897.2.4.2.1.1.3. db Integer32 asaDbStatT ype 1 2 1.3.6.1.4.1.897.2.4.2.1.1.4. db OID asaDbStatOID OID of Adaptive Server[...]

  • Seite 39

    Chapter 2. Adaptive Server Anywhere MIB Ref erence asaDbMetaData.asaDbOptMetaDataT able This table contains metadata about the database options. The value db is the database number in the asasnmp.ini file. OID T ype Name V alue returned 1.3.6.1.4.1.897.2.4.2.1.1.1. db Integer32 asaDbOptInde x db 1.3.6.1.4.1.897.2.4.2.1.1.2. db Integer32 asaDbOptOb[...]

  • Seite 40

    OID T ype Name Statistic 1.3.6.1.4.1.897.2.1.1.9. n Counter64 srvStatCacheReadEng CacheReadEng 1.3.6.1.4.1.897.2.1.1.10. n Counter64 srvStatCacheReplacements CacheReplacements 1.3.6.1.4.1.897.2.1.1.11. n Integer32 srvStatCurrentCacheSize CurrentCacheSize 1.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. [...]

  • Seite 41

    Chapter 2. Adaptive Server Anywhere MIB Ref erence Server properties The following table lists OIDs and names of the database server properties that can be retriev ed using the Adaptive Serv er Anywhere SNMP Extension Agent. Writable properties are marked with an asterisk (*). The value n is the database number in the asasnmp.ini file. OID T ype N[...]

  • Seite 42

    OID T ype Name Property 1.3.6.1.4.1.897.2.1.2.23. n String srvPropMachineName MachineName 1.3.6.1.4.1.897.2.1.2.24. n String srvPropMaxMessage MaxMessage 1.3.6.1.4.1.897.2.1.2.25. n String srvPropMessageW indowSize MessageW indowSize 1.3.6.1.4.1.897.2.1.2.26. n String srvPropName Name 1.3.6.1.4.1.897.2.1.2.27. n String srvPropNativ eProcessorArchi-[...]

  • Seite 43

    Chapter 2. Adaptive Server Anywhere MIB Ref erence OID T ype Name Property 1.3.6.1.4.1.897.2.1.2.49. n String srvPropThreads Threads 1.3.6.1.4.1.897.2.1.2.50. n String srvPropT imeZoneAdjustment T imeZoneAdjustment 1.3.6.1.4.1.897.2.1.2.51. n String srvPropHttpPorts HttpPorts 1.3.6.1.4.1.897.2.1.2.52. n String srvPropHttpsPorts HttpsPorts 1.3.6.1.4[...]

  • Seite 44

    OID T ype Name Property 1.3.6.1.4.1.897.2.2.1.12. n Integer32 dbStatCheckpointLogCommit- T oDisk CheckpointLogCommit- T oDisk 1.3.6.1.4.1.897.2.2.1.13. n Integer32 dbStatCheckpointLogP ageI- nUse CheckpointLogPageInUse 1.3.6.1.4.1.897.2.2.1.14. n Integer32 dbStatCheckpointLogP agesRe- located CheckpointLogPagesRelo- cated 1.3.6.1.4.1.897.2.2.1.15. [...]

  • Seite 45

    Chapter 2. Adaptive Server Anywhere MIB Ref erence OID T ype Name Property 1.3.6.1.4.1.897.2.2.1.36. n Integer32 dbStatIdleWrite IdleWrite 1.3.6.1.4.1.897.2.2.1.37. n Integer32 dbStatIndAdd IndAdd 1.3.6.1.4.1.897.2.2.1.38. n Integer32 dbStatIndLookup IndLookup 1.3.6.1.4.1.897.2.2.1.39. n Integer32 dbStatIO T oRecov er IO T oRecov er 1.3.6.1.4.1.897[...]

  • Seite 46

    can be retriev ed using the Adaptive Serv er Anywhere SNMP Extension Agent. Writable properties are marked with an asterisk (*). The value n is the database number in the asasnmp.ini file. OID T ype Name Pr oper ty 1.3.6.1.4.1.897.2.2.2.1. n String dbPropAlias Alias 1.3.6.1.4.1.897.2.2.2.2. n String dbPropAuditingT ypes AuditingT ypes 1.3.6.1.4.1.[...]

  • Seite 47

    Chapter 2. Adaptive Server Anywhere MIB Ref erence OID T ype Name Pr operty 1.3.6.1.4.1.897.2.2.2.25. n String dbPropHistograms Histograms 1.3.6.1.4.1.897.2.2.2.26. n String dbPropIndexStatistics IndexStatistics 1.3.6.1.4.1.897.2.2.2.27. n String dbPropIQStore IQStore 1.3.6.1.4.1.897.2.2.2.28. n String dbPropJDKV ersion JDKV ersion 1.3.6.1.4.1.897.[...]

  • Seite 48

    OID T ype Name Pr oper ty 1.3.6.1.4.1.897.2.2.2.53. n String dbPropUniqueIdentifier UniqueIdentifier Database options The following table lists the OIDs and names of the database options that can be retriev ed using the Adaptive Serv er Anywhere SNMP Extension Agent. Writable options are marked with an asterisk (*). The value n is the database nu[...]

  • Seite 49

    Chapter 2. Adaptive Server Anywhere MIB Ref erence OID T ype Name Option 1.3.6.1.4.1.897.2.2.3.19. n String dbOptConnectionAuthentica- tion* Connection_authentication 1.3.6.1.4.1.897.2.2.3.20. n String dbOptContinueAfterRaiseer- ror* Continue_after_raise_error 1.3.6.1.4.1.897.2.2.3.21. n String dbOptCon versionError* Con version_error 1.3.6.1.4.1.8[...]

  • Seite 50

    OID T ype Name Option 1.3.6.1.4.1.897.2.2.3.43. n Integer32 dbOptJa v aHeapSize* Jav a_heap_size 1.3.6.1.4.1.897.2.2.3.44. n String dbOptJav aInputOutput* Jav a_input_output 1.3.6.1.4.1.897.2.2.3.45. n Integer32 dbOptJa v aNamespaceSize* Jav a_namespace_size 1.3.6.1.4.1.897.2.2.3.46. n Integer32 dbOptJa v aPageBuf ferSize* Java_page_b uffer_size 1.[...]

  • Seite 51

    Chapter 2. Adaptive Server Anywhere MIB Ref erence OID T ype Name Option 1.3.6.1.4.1.897.2.2.3.67. n Integer32 dbOptOptimizationLe vel* Optimization_lev el 1.3.6.1.4.1.897.2.2.3.68. n String dbOptOptimizationLogging* Optimization_logging 1.3.6.1.4.1.897.2.2.3.69. n String dbOptOptimizationW orkload* Optimization_workload 1.3.6.1.4.1.897.2.2.3.70. n[...]

  • Seite 52

    OID T ype Name Option 1.3.6.1.4.1.897.2.2.3.91. n String dbOptTDSEmptyStringIs- Null* TDS_empty_string_is_null 1.3.6.1.4.1.897.2.2.3.92. n Integer32 dbOptThreadCount* Thread_count 1.3.6.1.4.1.897.2.2.3.93. n Integer32 dbOptThreadStack* Thread_stack 1.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 Stri[...]

  • Seite 53

    CHAPTER 3 RDBMS MIB Reference About this chapter This chapter contains descriptions of each of the tables in the RDBMS MIB. Contents T opic: page The RDBMS MIB 42 41[...]

  • Seite 54

    The RDBMS MIB The following sections list the OIDs of the v alues that can be retriev ed using the Adaptiv e Server Anywhere SNMP Extension Agent. By default, the RDBMS MIB is located in C:Program FilesSybaseSQL Anywhere 9snmpRDBMS-MIB.mib . rdbmsDbT able This table lists information about the databases installed on a system. The value db is t[...]

  • Seite 55

    Chapter 3. RDBMS MIB Reference OID T ype Name V alue returned 1.3.6.1.2.1.39.1.2.1.3. db Integer rdbmsDbInfoSizeUnits Calculated based on dbInfoSizeAllo- cated and dbInfoSizeUsed. ♦ 1=bytes ♦ 2=KB ♦ 3=MB ♦ 4=GB ♦ 5=TB (Each unit is 1024 times the previ- ous.) 1.3.6.1.2.1.39.1.2.1.4. db Integer rdbmsDbInfoSizeAllo- cated db_property(‘pag[...]

  • Seite 56

    1 This OID is not currently supported by the Adaptiv e Server Anywhere SNMP Extenstion Agent. rdbmsDbLimitedResour ceT able This table lists free space information on each dbspace. In this table, n represents each dbspace as follows: ♦ 1-13 are for normal dbspaces (numbered 0-12 in the database) ♦ 14 is the transaction log file ♦ 15 is the t[...]

  • Seite 57

    Chapter 3. RDBMS MIB Reference rdbmsSrvT able This table lists the database servers running or installed on your system. The value db is the database number in the asasnmp.ini file. OID T ype Name V alue returned 1.3.6.1.2.1.39.1.5.1.1. db OID rdbmsSrvPriv ateMibOID 1.3.6.1.4.1.897.2 1.3.6.1.2.1.39.1.5.1.2. db String rdbmsSrvV endorName property(?[...]

  • Seite 58

    OID T ype Name V alue returned 1.3.6.1.2.1.39.1.6.1.13. db Integer rdbmsSrvInfoHighwaterInboundAs- sociations 0 1 1.3.6.1.2.1.39.1.6.1.14. db Integer rdbmsSrvInfoMaxInboundAssocia- tions 0 1 1 This OID is not currently supported by the Adaptiv e Server Anywhere SNMP Extenstion Agent. rdbmsSrvP aramT able This table lists the server options that can[...]

  • Seite 59

    Chapter 3. RDBMS MIB Reference The value db is the database number in the asasnmp.ini file, while n is the index of the resource as follo ws: n Name Resource Resource limit 1 Connec- tions prop- erty(‘LicensesInUse’) property(‘LicenseCount’) 2 Processors prop- erty(‘NumProcessorsA v ail’) property(‘NumProcessorsMax’) If this is 0, [...]

  • Seite 60

    48[...]

  • Seite 61

    Inde x A Activ eReq property ASA SNMP Extension Agent OID 27 Adaptiv e Server Anywhere MIB about 7 Agent table 24 asaDbOptMetaDataT able 27 asaDbPropMetaDataT able 26 asaDbStatMetaDataT able 26 asaMetaData tables 24 asaSrvPropMetaDataT able 25 asaSrvStatMetaDataT able 24 database options 36 database properties 33 database statistics 31 list of tabl[...]

  • Seite 62

    Inde x BytesReceiv ed property ASA SNMP Extension Agent OID 27 BytesReceiv edUncomp property ASA SNMP Extension Agent OID 27 BytesSent property ASA SNMP Extension Agent OID 27 BytesSentUncomp property ASA SNMP Extension Agent OID 27 C C2 property ASA SNMP Extension Agent OID 29 CacheHits property ASA SNMP Extension Agent OID 31 CacheHitsEng propert[...]

  • Seite 63

    Inde x CONNECTION_A UTHENTICA TION option ASA SNMP Extension Agent OID 36 ConnsDisabled property ASA SNMP Extension Agent OID 29 ConsoleLogFile property ASA SNMP Extension Agent OID 29 CONTINUE_AFTER_RAISERR OR option ASA SNMP Extension Agent OID 36 con ventions documentation viii CONVERSION_ERR OR option ASA SNMP Extension Agent OID 36 COOPERA TIV[...]

  • Seite 64

    Inde x EXTENDED_JOIN_SYNT AX option ASA SNMP Extension Agent OID 36 ExtendT empWrite property ASA SNMP Extension Agent OID 31 F feedback documentation xii providing xii File property ASA SNMP Extension Agent OID 34 FileSize property ASA SNMP Extension Agent OID 34 FileV ersion property ASA SNMP Extension Agent OID 34 FipsMode property ASA SNMP Exte[...]

  • Seite 65

    Inde x IsRuntimeServer property ASA SNMP Extension Agent OID 29 J J A V A_HEAP_SIZE option ASA SNMP Extension Agent OID 36 J A V A_INPUT_OUTPUT option ASA SNMP Extension Agent OID 36 J A V A_NAMESP ACE_SIZE option ASA SNMP Extension Agent OID 36 J A V A_P AGE_B UFFER_SIZE option ASA SNMP Extension Agent OID 36 Jav aGlobFix property ASA SNMP Extensi[...]

  • Seite 66

    Inde x MAX_PLANS_CA CHED option ASA SNMP Extension Agent OID 36 MAX_RECURSIVE_ITERA TIONS option ASA SNMP Extension Agent OID 36 MAX_ST A TEMENT_COUNT option ASA SNMP Extension Agent OID 36 MAX_WORK_T ABLE_HASH_SIZE option ASA SNMP Extension Agent OID 36 MaxCacheSize property ASA SNMP Extension Agent OID 27 MaxIO property ASA SNMP Extension Agent O[...]

  • Seite 67

    Inde x ASA SNMP Extension Agent OID 27 PacketsRecei vedUncomp property ASA SNMP Extension Agent OID 27 PacketsSent property ASA SNMP Extension Agent OID 27 PacketsSentUncomp property ASA SNMP Extension Agent OID 27 PageRelocations property ASA SNMP Extension Agent OID 31 PageSize property ASA SNMP Extension Agent OID 29, 34 PeakCacheSize property A[...]

  • Seite 68

    Inde x ASA SNMP Extension Agent OID 36 ReadOnly property ASA SNMP Extension Agent OID 34 RECO VER Y_TIME option ASA SNMP Extension Agent OID 36 Recov eryUrgenc y property ASA SNMP Extension Agent OID 31 RelocatableHeapPages property ASA SNMP Extension Agent OID 31 RememberLastStatement property ASA SNMP Extension Agent OID 29 REMO TE_IDLE_TIMEOUT o[...]

  • Seite 69

    Inde x STRING_R TR UNCA TION option ASA SNMP Extension Agent OID 36 StringHistrogramsFix property ASA SNMP Extension Agent OID 34 SUBSUME_R OW_LOCKS option ASA SNMP Extension Agent OID 36 support newsgroups xii supported platforms ASA SNMP Extension Agent 4 SUPPRESS_TDS_DEBUGGING option ASA SNMP Extension Agent OID 36 SyncT runc property ASA SNMP E[...]

  • Seite 70

    Inde x installing SNMP 10 W indows XP installing SNMP 10 58[...]