background image

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

1.3.6.1.4.1.897.2.4.2.1.1.3.

db

Integer32

asaDbOptType

3

2

1.3.6.1.4.1.897.2.4.2.1.1.4.

db

OID

asaDbOptOID

OID of Adaptive Server Any-
where MIB entry

3

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 query.

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

Integer32

srvStatActiveReq

ActiveReq

1.3.6.1.4.1.897.2.1.1.2.

n

Integer32

srvStatAvailIO

AvailIO

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-
comp

BytesReceivedUncomp

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

Содержание Adaptive Server Anywhere SNMP Extension Agent

Страница 1: ...Adaptive Server Anywhere SNMP Extension Agent User s Guide Part number DC00192 01 0902 01 Last modified December 2004...

Страница 2: ...ss 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 Libr...

Страница 3: ...SNMP Ex tension Agent 1 1 The Adaptive Server Anywhere SNMP Extension Agent 3 Introduction to the Adaptive Server Anywhere SNMP Exten sion Agent 4 Understanding SNMP 6 Using the Adaptive Server Anywhe...

Страница 4: ...iv...

Страница 5: ...ver Anywhere SNMP Extension Agent Audience This manual is for Adaptive Server Anywhere users who wish to use the Adaptive Server Anywhere SNMP Extension Agent on Windows 2000 Windows XP or Windows Ser...

Страница 6: ...ng managing and configuring databases and database servers Adaptive Server Anywhere SQL User s Guide This book describes how to design and create databases how to import export and modify data how to...

Страница 7: ...tutorials that walk you through how to set up and run MobiLink applications QAnywhere User s Guide This manual describes MobiLink QAnywhere a messaging platform that enables the development and deploy...

Страница 8: ...ated 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...

Страница 9: ...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...

Страница 10: ...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 middleware These assist in shar...

Страница 11: ...char 2 street char 30 city char 20 state char 2 zip char 5 phone char 10 fax char 10 customer id integer pk fname char 15 lname char 20 address char 35 city char 20 state char 2 zip char 10 phone char...

Страница 12: ...re qanywhere 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...

Страница 13: ...PART I USING THE ADAPTIVE SERVER ANYWHERE SNMP EXTENSION AGENT This part describes how to set up and configure the Adaptive Server Anywhere SNMP Extension Agent...

Страница 14: ......

Страница 15: ...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 Agent 4 Understanding SNM...

Страница 16: ...ures generate traps based on property or statistic values Supplied files The following files for the Adaptive Server Anywhere SNMP Extension Agent are included in your SQL Anywhere Studio installation...

Страница 17: ...Server Anywhere SNMP Extension Agent asasnmp ini This file lists the databases that the Adaptive Server Anywhere SNMP Extension Agent monitors By default this file is located in C Program Files Sybase...

Страница 18: ...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...

Страница 19: ...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 OID Name Descr...

Страница 20: ...e 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 t...

Страница 21: ...tables on page 24 The RDBMS MIB 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 informatio...

Страница 22: ...from the Start menu choose Settings Control Panel On Windows XP from the Start menu choose Control Panel 2 Double click Add Remove Programs The Add Remove Programs dialog appears 3 In the left pane of...

Страница 23: ...Anywhere SNMP Extension Agent If you installed SQL Anywhere Studio and then installed SNMP the SNMP service will detect the Adaptive Server Anywhere SNMP Extension Agent automatically To restart the...

Страница 24: ...dit 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 Op...

Страница 25: ...tabase 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...

Страница 26: ...abase on the same server executes the START DATABASE statement and then disconnects This field is optional CacheTime When data is retrieved from the database it can be cached inside the Adaptive Serve...

Страница 27: ...G server1 DBN field DBF field db UtilDbPwd test Disabled 1 DB3 ConnStr UID DBA PWD SQL LINKS tcpip ENG server2 DBN hq DBF hq db UtilDbPwd test Because there are no parameters specified in the ASAAgent...

Страница 28: ...ble 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 database 1 1 1 3 6...

Страница 29: ...e 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 execut...

Страница 30: ...e 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 you...

Страница 31: ...information in the asasnmp ini file entry is as follows Trap trapnum 1 3 6 1 4 1 897 2 oid dbnum op value trapnum is the dynamic trap number It must start at 1 and be sequential oid is the OID of the...

Страница 32: ...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...

Страница 33: ...R 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...

Страница 34: ......

Страница 35: ...R 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...

Страница 36: ...nStr 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...

Страница 37: ...MetaData 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...

Страница 38: ...number to the OID before it can be used in a query asaDbMetaData asaDbPropMetaDataTable This table contains metadata about the database properties The value db is the database number in the asasnmp in...

Страница 39: ...You must append the database number to the OID before it can be used in a query Server statistics This table lists the OIDs and names of the database server statistics that can be retrieved using the...

Страница 40: ...alMemoryEng 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 n Integer32 srvStatMinCacheSize MinCacheSize 1 3 6 1 4 1 897 2 1 1 22 n Counter64 srvStatMult...

Страница 41: ...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 srvPropIsIQ IsIQ 1 3 6 1 4 1 897 2 1 2 11 n Strin...

Страница 42: ...cessCPU 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 s...

Страница 43: ...atistics 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 Count...

Страница 44: ...nCount 1 3 6 1 4 1 897 2 2 1 21 n Integer32 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...

Страница 45: ...ons 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 dbStatQueryCachePages QueryCachePages 1 3 6 1 4 1 897 2 2 1 50 n Integ...

Страница 46: ...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 dbPropCompressedBTrees Compressed...

Страница 47: ...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 dbPropPreserveSour...

Страница 48: ...low 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 straints Ansi_update_constraints 1 3 6 1 4 1 897 2...

Страница 49: ...3 29 n Integer32 dbOptDefaultTimestampIn crement Default_timestamp_ 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 dbOptDelayedCo...

Страница 50: ...897 2 2 3 54 n Integer32 dbOptMaxPlansCached Max_plans_cached 1 3 6 1 4 1 897 2 2 3 55 n Integer32 dbOptMaxRecursiveItera tions Max_recursive_iterations 1 3 6 1 4 1 897 2 2 3 56 n Integer32 dbOptMaxSt...

Страница 51: ...entifier 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 dbOptReplicateA...

Страница 52: ...2 3 101 n String dbOptTsqlHexConstant Tsql_hex_constant 1 3 6 1 4 1 897 2 2 3 102 n String dbOptTsqlVariables Tsql_variables 1 3 6 1 4 1 897 2 2 3 103 n String dbOptUpdateStatistics Update_statistics...

Страница 53: ...CHAPTER 3 RDBMS MIB Reference About this chapter This chapter contains descriptions of each of the tables in the RDBMS MIB Contents Topic page The RDBMS MIB 42 41...

Страница 54: ...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 rdbmsDbVendorName property CompanyName 1 3 6 1 2 1 39 1 1 1 4 db String rd...

Страница 55: ...st Backup NULL1 1 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 syst...

Страница 56: ...ng rdbmsDbLimitedResource Name Name of dbspace or Trans 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...

Страница 57: ...eturned 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 01 1 3 6 1 2 1 39 1 6 1 3 db Integer rdbmsSrvInf...

Страница 58: ...ion 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 r...

Страница 59: ...rce n 1 3 6 1 2 1 39 1 8 1 2 db OID rdbmsSrvLimitedResour ceID OID in Adaptive Server Anywhere MIB corresponding to this option 1 3 6 1 2 1 39 1 8 1 3 db Integer rdbmsSrvLimitedResource Limit Upper li...

Страница 60: ...48...

Страница 61: ...on Agent OID 36 ANSI_INTEGER_OVERFLOW option ASA SNMP Extension Agent OID 36 ANSI_PERMISSIONS option ASA SNMP Extension Agent OID 36 ANSI_UPDATE_CONSTRAINTS option ASA SNMP Extension Agent OID 36 ANSI...

Страница 62: ...y ASA SNMP Extension Agent OID 31 CheckpointLogCommitToDisk property ASA SNMP Extension Agent OID 31 CheckpointLogPageInUse property ASA SNMP Extension Agent OID 31 CheckpointLogPagesRelocated propert...

Страница 63: ...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 36 DBFileFr...

Страница 64: ...ABASE_ID option ASA SNMP Extension Agent OID 36 GlobalDBId property ASA SNMP Extension Agent OID 34 H HistogramHashFix property ASA SNMP Extension Agent OID 34 Histograms property ASA SNMP Extension A...

Страница 65: ...ASA SNMP Extension Agent OID 29 LOCK_REJECTED_ROWS option ASA SNMP Extension Agent OID 36 LockedHeapPages property ASA SNMP Extension Agent OID 27 LockTablePages property ASA SNMP Extension Agent OID...

Страница 66: ...gent OID 34 NativeProcessorArchitecture property ASA SNMP Extension Agent OID 29 NEAREST_CENTURY option ASA SNMP Extension Agent OID 36 newsgroups technical support xii NON_KEYWORDS option ASA SNMP Ex...

Страница 67: ...SNMP Extension Agent OID 29 ProcessCPUUser property ASA SNMP Extension Agent OID 29 ProcessorArchitecture property ASA SNMP Extension Agent OID 29 ProductName property ASA SNMP Extension Agent OID 29...

Страница 68: ...Agent OID 36 ROLLBACK_ON_DEADLOCK option ASA SNMP Extension Agent OID 36 RollbackLogPages property ASA SNMP Extension Agent OID 31 ROW_COUNTS option ASA SNMP Extension Agent OID 36 S SCALE option ASA...

Страница 69: ...on Agent OID 36 TIME_ZONE_ADJUSTMENT option ASA SNMP Extension Agent OID 36 TIMESTAMP_FORMAT option ASA SNMP Extension Agent OID 36 TimeZoneAdjustment property ASA SNMP Extension Agent OID 29 TotalBuf...

Страница 70: ...Index installing SNMP 10 Windows XP installing SNMP 10 58...

Отзывы: