The following table lists the OIDs and names of the database options that can be retrieved using the SQL Anywhere SNMP Extension Agent.
Writable options are marked with an asterisk (*). The value n is the database number in the sasnmp.ini file.
For more information about the database options, see Alphabetical list of options.
OID | Type | Name | Option |
---|---|---|---|
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 |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |