Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » SQL Anywhere MIB Reference » The SQL Anywhere MIB

SQL Anywhere MIB database properties Next Page

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 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.nStringdbOptTempSpaceLimitCheck*temp_space_limit_check
1.3.6.1.4.1.897.2.2.3.108.nInteger32dbOptRemoteIdleTimeout*remote_idle_timeout
1.3.6.1.4.1.897.2.2.3.109.nInteger32dbOptAnsiSubstringansi_substring
1.3.6.1.4.1.897.2.2.3.110.nStringdbOptODBCDescribeBinaryAsVarbinary*odbc_describe_binary_as_varbinary
1.3.6.1.4.1.897.2.2.3.111.nStringdbOptRollbackOnDeadlockrollback_on_deadlock
1.3.6.1.4.1.897.2.2.3.112.nStringdbOptIntegratedServerName*integrated_server_name
1.3.6.1.4.1.897.2.2.3.113.nStringdbOptLogDeadlocks*log_deadlocks
1.3.6.1.4.1.897.2.2.3.114.nInteger32dbOptInternalInternal
1.3.6.1.4.1.897.2.2.3.115.nStringdbOptWebserviceNamespaceHost*webservice_namespace_host
1.3.6.1.4.1.897.2.2.3.116.nInteger32dbOptMaxQueryRequests*max_query_tasks
1.3.6.1.4.1.897.2.2.3.117.nInteger32dbOptRequestTimeout*request_timeout
1.3.6.1.4.1.897.2.2.3.118.nStringdbOptSynchronizeMirrorOnCommit* synchronize_mirror_on_commit
1.3.6.1.4.1.897.2.2.3.119.nInteger32dbOptHttpSessionTimeout*http_session_timeout
1.3.6.1.4.1.897.2.2.3.120.nStringdbOptUuidHasHyphens*uuid_has_hyphens
1.3.6.1.4.1.897.2.2.3.121.nStringdbOptAllowSnapshotIsolation* allow_snapshot_isolation
1.3.6.1.4.1.897.2.2.3.122.nStringdbOptVerifyPasswordFunction* verify_password_function
1.3.6.1.4.1.897.2.2.3.123.nStringdbOptDefaultDbspace*default_dbspace
1.3.6.1.4.1.897.2.2.3.124.nStringdbOptCollectStatisticsOnDmlUpdates* collect_statistics_on_dml_updates
1.3.6.1.4.1.897.2.2.3.125.nStringdbOptJavaMainUserid* java_main_userid
1.3.6.1.4.1.897.2.2.3.126.nStringdbOptJavaLocation*java_location
1.3.6.1.4.1.897.2.2.3.127.nString dbOptOemString*oem_string
1.3.6.1.4.1.897.2.2.3.128.nInteger32dbOptMaxTempSpace*max_temp_space
1.3.6.1.4.1.897.2.2.3.129.nStringdbOptSecureFeatureKey*secure_feature_key
1.3.6.1.4.1.897.2.2.3.130.nStringdbOptMaterializedViewOptimization* materialized_view_optimization
1.3.6.1.4.1.897.2.2.3.131.nInteger32dbOptUpdatableStatementIsolation* updatable_statement_isolation
1.3.6.1.4.1.897.2.2.3.132.nStringdbOptTsqlOuterJoins*tsql_outer_joins
1.3.6.1.4.1.897.2.2.3.133.nStringdbOptPostLoginProcedure*post_login_procedure
1.3.6.1.4.1.897.2.2.3.134.nStringdbOptConnAuditing* conn_auditing
1.3.6.1.4.1.897.2.2.3.135.nStringdbOptPercentAsComment* percent_as_comment
1.3.6.1.4.1.897.2.2.3.136.nStringdbOptJavaVmOptions* java_vm_options
1.3.6.1.4.1.897.2.2.3.137.n StringdbOptEncryptAesRandomIv*encrypt_aes_random_iv
1.3.6.1.4.1.897.2.2.3.138.nInteger32dbOptMaxClientStatementsCached* max_client_statements_cached