SQL Anywhere MIB database options

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 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 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 dbOptInternal Internal
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
1.3.6.1.4.1.897.2.2.3.144.n String dbOptProgressMessages* progress_messages
1.3.6.1.4.1.897.2.2.3.145.n Integer32 dbOptBlockingOthersTimeout* blocking_others_timeout
1.3.6.1.4.1.897.2.2.3.146.n Integer32 dbOptInternal Internal
1.3.6.1.4.1.897.2.2.3.147.n String dbOptTimestampWithTimeZoneFormat* timestamp_with_time_zone_format
1.3.6.1.4.1.897.2.2.3.148.n Integer32 dbOptHttpConnectionPoolTimeout* http_connection_pool_timeout
1.3.6.1.4.1.897.2.2.3.149.n Integer32 dbOptHttpConnectionPoolBasesize* http_connection_pool_basesize
1.3.6.1.4.1.897.2.2.3.150.n String dbOptStGeometryDescribeType* st_geometry_describe_type
1.3.6.1.4.1.897.2.2.3.151.n String dbOptStGeometryAstextFormat* st_geometry_astext_format
1.3.6.1.4.1.897.2.2.3.152.n String dbOptStGeometryAsbinaryFormat* st_geometry_asbinary_format
1.3.6.1.4.1.897.2.2.3.153.n String dbOptStGeometryAsxmlFormat* st_geometry_asxml_format
1.3.6.1.4.1.897.2.2.3.154.n String dbOptReservedKeywords* reserved_keywords
1.3.6.1.4.1.897.2.2.3.155.n String dbOptStGeometryOnInvalid* st_geometry_on_invalid