background image

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

srvPropRequestLogNumFiles

RequestLogNumFIles

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

CheckpointLogBitmap-
Size

1.3.6.1.4.1.897.2.2.1.11.

n

Integer32

dbStatCheckpointLogBitmap-
PagesWritten

CheckpointLogBitmap-
PagesWritten

31

Summary of Contents for Adaptive Server Anywhere SNMP Extension Agent

Page 1: ...Adaptive Server Anywhere SNMP Extension Agent User s Guide Part number DC00192 01 0902 01 Last modified December 2004...

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

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

Page 4: ...iv...

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

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

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

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

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

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

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

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

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

Page 14: ......

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Page 34: ......

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Page 60: ...48...

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

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

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

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

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

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

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

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

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

Page 70: ...Index installing SNMP 10 Windows XP installing SNMP 10 58...

Reviews: