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 | String | dbOptAnsiIntegerOverflow* | 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 | 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 | String | dbOptAutomaticTimestamp* | automatic_timestamp |
| 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 | dbOptContinueAfterRaiseerror* | continue_after_raise_error |
| 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 | String | dbOptDivideByZeroError* | divide_by_zero_error |
| 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 | String | dbOptFloatAsDouble* | float_as_double |
| 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 | String | 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 | String | 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 | String | dbOptOptimisticWaitForCommit* | optimistic_wait_for_commit |
| 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 | String | 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 | 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 | dbOptReturnDateTimeAsString* | return_date_time_as_string |
| 1.3.6.1.4.1.897.2.2.3.81.n | String | dbOptInternal | Internal |
| 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 | 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 | String | dbOptTruncateWithAutocommit* | truncate_with_auto_commit |
| 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 | 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 | Integer32 | 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 | dbOptMaxQueryRequests* | 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 | String | dbOptUuidHasHyphens* | uuid_has_hyphens |
| 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 | String | dbOptPercentAsComment* | percent_as_comment |
| 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 | String | dbOptEncryptAesRandomIv* | encrypt_aes_random_iv |
| 1.3.6.1.4.1.897.2.2.3.138.n | Integer32 | dbOptMaxClientStatementsCached* | max_client_statements_cached |