Sybase Adaptive Server Anywhere SNMP Extension Agent manual Oid

Page 52

OID

Type

Name

Option

 

 

 

 

1.3.6.1.4.1.897.2.2.3.91.n

String

dbOptTDSEmptyStringIs-

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

dbOptTimestampFormat*

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

dbOptTruncateDateValues*

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

dbOptTsqlVariables*

Tsql_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

dbOptRemoteIdleTimeout*

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_deadlocks

 

 

 

 

40

Image 52
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 Adaptive Server Anywhere sample database Asademo.dbFinding 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 Adaptive Server Anywhere MIB Files\Sybase\SQL Anywhere 9\snmp\iAnywhere.mibMIB Rdbms MIB Using the Adaptive Server Anywhere Snmp Extension Agent Installing SnmpTo 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’ Using traps To configure the Snmp serviceCreating dynamic traps Trap examples Adaptive Server Anywhere Snmp Extension Agent Reference Page Adaptive Server Anywhere MIB Reference Agent Adaptive Server Anywhere MIBAsaMetaData tables AsaSrvMetaData.asaSrvPropMetaDataTable AsaDbMetaData.asaDbPropMetaDataTable Server statistics AsaDbMetaData.asaDbOptMetaDataTableOID 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 RdbmsDbTable Rdbms MIBRdbmsDbInfoTable RdbmsDbParamTable Rdbms MIB ReferenceRdbmsDbLimitedResourceTable Write FileRdbmsSrvTable RdbmsSrvInfoTableRdbmsSrvParamTable RdbmsSrvLimitedResourceTableIf this is 0, then it returns prop Page Index Index Cooperativecommittimeout option Index Index Odbcdescribebinaryasvarbinary Pinnedcursorpercentofcache ReadOnly property Truncatetimestampvalues option Installing Snmp Windows XP