Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 11.0.1 (中文) » SQL Anywhere 服务器 - 数据库管理 » 监控数据库 » SQL Anywhere SNMP Extension Agent » SQL Anywhere MIB 参考

 

SQL Anywhere MIB 数据库选项

下表列出了可使用 SQL Anywhere SNMP Extension Agent 检索的数据库选项的 OID 和名称。

星号 (*) 标记的为可写选项。值 n 是 sasnmp.ini 文件中的数据库编号。

有关数据库属性的详细信息，请参见按字母顺序排列的选项列表。

OID 类型 名称 选项
1.3.6.1.4.1.897.2.2.3.1..n String dbOptAllowNullsByDefault* allow_nulls_by_default
1.3.6.1.4.1.897.2.2.3.2..n String dbOptAnsinull* ansinull
1.3.6.1.4.1.897.2.2.3.3..n String dbOptAnsiBlanks* ansi_blanks
1.3.6.1.4.1.897.2.2.3.4..n String dbOptAnsiCloseCursorsOnRollback* ansi_close_cursors_on_rollback
1.3.6.1.4.1.897.2.2.3.5..n Integer32 dbOptInternal Internal
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 dbOptAnsiUpdateConstraints* ansi_update_constraints
1.3.6.1.4.1.897.2.2.3.8..n String dbOptAuditing* auditing
1.3.6.1.4.1.897.2.2.3.9..n String dbOptAuditingOptions* auditing_options
1.3.6.1.4.1.897.2.2.3.10..n Integer32 dbOptInternal Internal
1.3.6.1.4.1.897.2.2.3.11..n String dbOptBackgroundPriority* background_priority
1.3.6.1.4.1.897.2.2.3.12..n String dbOptBlocking* blocking
1.3.6.1.4.1.897.2.2.3.13..n Integer32 dbOptBlockingTimeout* blocking_timeout
1.3.6.1.4.1.897.2.2.3.14..n String dbOptChained* chained
1.3.6.1.4.1.897.2.2.3.15..n Integer32 dbOptCheckpointTime* checkpoint_time
1.3.6.1.4.1.897.2.2.3.16..n Integer32 dbOptCisOption* cis_option
1.3.6.1.4.1.897.2.2.3.17..n Integer32 dbOptCisRowsetSize* cis_rowset_size
1.3.6.1.4.1.897.2.2.3.18..n String dbOptCloseOnEndtrans* close_on_endtrans
1.3.6.1.4.1.897.2.2.3.19..n String dbOptConnectionAuthentication* connection_authentication
1.3.6.1.4.1.897.2.2.3.20..n String dbOptContinueAfterRaiserror* continue_after_raiserror
1.3.6.1.4.1.897.2.2.3.21..n String dbOptConversionError* conversion_error
1.3.6.1.4.1.897.2.2.3.22..n String dbOptCooperativeCommits* cooperative_commits
1.3.6.1.4.1.897.2.2.3.23..n Integer32 dbOptCooperativeCommitTimeout* cooperative_commit_timeout
1.3.6.1.4.1.897.2.2.3.24..n String dbOptDatabaseAuthentication* database_authentication
1.3.6.1.4.1.897.2.2.3.25..n String dbOptDateFormat* date_format
1.3.6.1.4.1.897.2.2.3.26..n String dbOptDateOrder* date_order
1.3.6.1.4.1.897.2.2.3.27..n String dbOptDebugMessages* debug_messages
1.3.6.1.4.1.897.2.2.3.28..n String dbOptDedicatedTask* dedicated_task
1.3.6.1.4.1.897.2.2.3.29..n Integer32 dbOptDefaultTimestampIncrement* 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 dbOptDelayedCommitTimeout* delayed_commit_timeout
1.3.6.1.4.1.897.2.2.3.32..n Integer32 dbOptInternal Internal
1.3.6.1.4.1.897.2.2.3.33..n String dbOptEscapeCharacter* escape_character
1.3.6.1.4.1.897.2.2.3.34..n String dbOptExcludeOperators* exclude_operators
1.3.6.1.4.1.897.2.2.3.35..n String dbOptExtendedJoinSyntax* extended_join_syntax
1.3.6.1.4.1.897.2.2.3.36..n String dbOptFireTriggers* fire_triggers
1.3.6.1.4.1.897.2.2.3.37..n Integer32 dbOptFirstDayOfWeek* first_day_of_week
1.3.6.1.4.1.897.2.2.3.38..n Integer32 dbOptInternal Internal
1.3.6.1.4.1.897.2.2.3.39..n String dbOptForceViewCreation* force_view_creation
1.3.6.1.4.1.897.2.2.3.40..n String dbOptForXmlNullTreatment* for_xml_null_treatment
1.3.6.1.4.1.897.2.2.3.41..n Integer32 dbOptGlobalDatabaseId* global_database_id
1.3.6.1.4.1.897.2.2.3.42..n Integer32 dbOptIsolationLevel* isolation_level
1.3.6.1.4.1.897.2.2.3.43..n Integer32 dbOptInternal Internal
1.3.6.1.4.1.897.2.2.3.44..n Integer32 dbOptInternal Internal
1.3.6.1.4.1.897.2.2.3.45..n Integer32 dbOptInternal Internal
1.3.6.1.4.1.897.2.2.3.46..n Integer32 dbOptInternal Internal
1.3.6.1.4.1.897.2.2.3.47..n String dbOptLockRejectedRows* lock_rejected_rows
1.3.6.1.4.1.897.2.2.3.48..n String dbOptLoginMode* login_mode
1.3.6.1.4.1.897.2.2.3.49..n String dbOptLoginProcedure* login_procedure
1.3.6.1.4.1.897.2.2.3.50..n Integer32 dbOptInternal Internal
1.3.6.1.4.1.897.2.2.3.51..n Integer32 dbOptInternal Internal
1.3.6.1.4.1.897.2.2.3.52..n Integer32 dbOptMaxCursorCount* max_cursor_count
1.3.6.1.4.1.897.2.2.3.53..n Integer32 dbOptMaxHashSize* max_hash_size
1.3.6.1.4.1.897.2.2.3.54..n Integer32 dbOptMaxPlansCached* max_plans_cached
1.3.6.1.4.1.897.2.2.3.55..n Integer32 dbOptMaxRecursiveIterations* max_recursive_iterations
1.3.6.1.4.1.897.2.2.3.56..n Integer32 dbOptMaxStatementCount* max_statement_count
1.3.6.1.4.1.897.2.2.3.57..n Integer32 dbOptInternal Internal
1.3.6.1.4.1.897.2.2.3.58..n Integer32 dbOptMinPasswordLength* min_password_length
1.3.6.1.4.1.897.2.2.3.59..n Integer32 dbOptInternal Internal
1.3.6.1.4.1.897.2.2.3.60..n Integer32 dbOptNearestCentury* nearest_century
1.3.6.1.4.1.897.2.2.3.61..n String dbOptNonKeywords* non_keywords
1.3.6.1.4.1.897.2.2.3.62..n String dbOptODBCDistinguishCharAndVarchar* odbc_distinguish_char_and_varchar
1.3.6.1.4.1.897.2.2.3.63..n String dbOptOnCharsetConversionFailure* on_charset_conversion_failure
1.3.6.1.4.1.897.2.2.3.64..n String dbOptOnTsqlError* on_tsql_error
1.3.6.1.4.1.897.2.2.3.65..n Integer32 dbOptInternal Internal
1.3.6.1.4.1.897.2.2.3.66..n String dbOptOptimizationGoal* optimization_goal
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 Integer32 dbOptInternal Internal
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 dbOptPinnedCursorPercentOfCache* pinned_cursor_percent_of_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 dbOptPreventArticlePkeyUpdate* prevent_article_pkey_update
1.3.6.1.4.1.897.2.2.3.75..n Integer32 dbOptInternal Internal
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 dbOptReturnDateTimeAsString* return_date_time_as_string
1.3.6.1.4.1.897.2.2.3.81..n Integer32 dbOptInternal Internal
1.3.6.1.4.1.897.2.2.3.82..n Integer32 dbOptInternal Internal
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 dbOptSQLFlaggerErrorLevel* sql_flagger_error_level
1.3.6.1.4.1.897.2.2.3.87..n String dbOptSQLFlaggerWarningLevel* sql_flagger_warning_level
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 dbOptSuppressTDSDebugging* suppress_tds_debugging
1.3.6.1.4.1.897.2.2.3.91..n String dbOptTDSEmptyStringIsNull* tds_empty_string_is_null
1.3.6.1.4.1.897.2.2.3.92..n Integer32 dbOptInternal Internal
1.3.6.1.4.1.897.2.2.3.93..n Integer32 dbOptInternal Internal
1.3.6.1.4.1.897.2.2.3.94..n Integer32 dbOptInternal Internal
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 Integer32 dbOptInternal Internal
1.3.6.1.4.1.897.2.2.3.99..n String dbOptTruncateTimestampValues* truncate_timestamp_values
1.3.6.1.4.1.897.2.2.3.100..n Integer32 dbOptInternal Internal
1.3.6.1.4.1.897.2.2.3.101..n Integer32 dbOptInternal Internal
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 dbOptUpgradeDatabaseCapability* upgrade_database_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 dbOptTempSpaceLimitCheck* temp_space_limit_check
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 String dbOptAnsiSubstring* ansi_substring
1.3.6.1.4.1.897.2.2.3.110..n String dbOptOdbcDescribeBinaryAsVarbinary* odbc_describe_binary_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
1.3.6.1.4.1.897.2.2.3.114..n Integer32 dbOptInternal Internal
1.3.6.1.4.1.897.2.2.3.115..n String dbOptWebserviceNamespaceHost* webservice_namespace_host
1.3.6.1.4.1.897.2.2.3.116..n Integer32 dbOptMaxQueryTasks* max_query_tasks
1.3.6.1.4.1.897.2.2.3.117..n Integer32 dbOptRequestTimeout* request_timeout
1.3.6.1.4.1.897.2.2.3.118..n String dbOptSynchronizeMirrorOnCommit* synchronize_mirror_on_commit
1.3.6.1.4.1.897.2.2.3.119..n Integer32 dbOptHttpSessionTimeout* http_session_timeout
1.3.6.1.4.1.897.2.2.3.120..n Integer32 dbOptInternal Internal
1.3.6.1.4.1.897.2.2.3.121..n String dbOptAllowSnapshotIsolation* allow_snapshot_isolation
1.3.6.1.4.1.897.2.2.3.122..n String dbOptVerifyPasswordFunction* verify_password_function
1.3.6.1.4.1.897.2.2.3.123..n String dbOptDefaultDbspace* default_dbspace
1.3.6.1.4.1.897.2.2.3.124..n String dbOptCollectStatisticsOnDmlUpdates* collect_statistics_on_dml_updates
1.3.6.1.4.1.897.2.2.3.125..n String dbOptJavaMainUserid* java_main_userid
1.3.6.1.4.1.897.2.2.3.126..n String dbOptJavaLocation* java_location
1.3.6.1.4.1.897.2.2.3.127..n String dbOptOemString* oem_string
1.3.6.1.4.1.897.2.2.3.128..n Integer32 dbOptMaxTempSpace* max_temp_space
1.3.6.1.4.1.897.2.2.3.129..n String dbOptSecureFeatureKey* secure_feature_key
1.3.6.1.4.1.897.2.2.3.130..n String dbOptMaterializedViewOptimization* materialized_view_optimization
1.3.6.1.4.1.897.2.2.3.131..n Integer32 dbOptUpdatableStatementIsolation* updatable_statement_isolation
1.3.6.1.4.1.897.2.2.3.132..n String dbOptTsqlOuterJoins* tsql_outer_joins
1.3.6.1.4.1.897.2.2.3.133..n String dbOptPostLoginProcedure* post_login_procedure
1.3.6.1.4.1.897.2.2.3.134..n String dbOptConnAuditing* conn_auditing
1.3.6.1.4.1.897.2.2.3.135..n Integer32 dbOptInternal Internal
1.3.6.1.4.1.897.2.2.3.136..n String dbOptJavaVmOptions* java_vm_options
1.3.6.1.4.1.897.2.2.3.137..n Integer32 dbOptInternal Internal
1.3.6.1.4.1.897.2.2.3.138..n Integer32 dbOptMaxClientStatementsCached* max_client_statements_cached
1.3.6.1.4.1.897.2.2.3.139..n String dbOptQueryMemTimeout* query_mem_timeout
1.3.6.1.4.1.897.2.2.3.140..n String dbOptAllowReadClientFile* allow_read_client_file
1.3.6.1.4.1.897.2.2.3.141..n String dbOptAllowWriteClientFile* allow_write_client_file
1.3.6.1.4.1.897.2.2.3.142..n String dbOptPriority* priority
1.3.6.1.4.1.897.2.2.3.143..n String dbOptMaxPriority* max_priority
Copyright ©  2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1