Sybase Adaptive Server Anywhere SNMP Extension Agent manual Adaptive Server Anywhere MIB Reference

Page 51

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

dbOptPreventArticlePkeyUp-

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*

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

SQL_flagger_error_level

 

 

Level*

 

1.3.6.1.4.1.897.2.2.3.87.n

String

dbOptSQLFlaggerWarn-

SQL_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

Image 51
Contents Adaptive Server Anywhere Snmp Extension Agent User’s Guide Page Contents Page About This Manual SQL Anywhere Studio documentation Page Page Documentation conventions Following icons are used in this documentation Asademo.db Adaptive Server Anywhere sample databaseFinding out more and providing feedback Using the Adaptive Server Anywhere Snmp Extension Agent Page Adaptive Server Anywhere Snmp Extension Agent Agent are included in your SQL Anywhere Studio installation Adaptive Server Anywhere Snmp Extension Agent Understanding Snmp Files\Sybase\SQL Anywhere 9\snmp\iAnywhere.mib Adaptive Server Anywhere MIBMIB Rdbms MIB Installing Snmp Using the Adaptive Server Anywhere Snmp Extension AgentTo restart the Snmp service Control Panel Configuring the Adaptive Server Anywhere Snmp Extension Agent To restart the Adaptive Server Anywhere Snmp Extension Agent Page ASAAgent DB1 Software SET Option PUBLIC.opt = ’value’ To configure the Snmp service Using trapsCreating dynamic traps Trap examples Adaptive Server Anywhere Snmp Extension Agent Reference Page Adaptive Server Anywhere MIB Reference Adaptive Server Anywhere MIB AgentAsaMetaData tables AsaSrvMetaData.asaSrvPropMetaDataTable AsaDbMetaData.asaDbPropMetaDataTable AsaDbMetaData.asaDbOptMetaDataTable Server statisticsOID Server properties OID Database statistics OID Database properties OID Adaptive Server Anywhere MIB Reference Database options Adaptive Server Anywhere MIB Reference OID Adaptive Server Anywhere MIB Reference OID Rdbms MIB Reference Rdbms MIB RdbmsDbTableRdbmsDbInfoTable Rdbms MIB Reference RdbmsDbParamTableWrite File RdbmsDbLimitedResourceTableRdbmsSrvInfoTable RdbmsSrvTableRdbmsSrvLimitedResourceTable RdbmsSrvParamTableIf this is 0, then it returns prop Page Index Index Cooperativecommittimeout option Index Index Odbcdescribebinaryasvarbinary Pinnedcursorpercentofcache ReadOnly property Truncatetimestampvalues option Installing Snmp Windows XP