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.

Descriptions

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	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	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
1.3.6.1.4.1.897.2.2.3.156.n	Integer32	dbOptInternal	Internal
1.3.6.1.4.1.897.2.2.3.157.n	Integer32	dbOptInternal	Internal
1.3.6.1.4.1.897.2.2.3.158.n	String	dbOptJavaClassPath*	java_class_path
1.3.6.1.4.1.897.2.2.3.159.n	String	dbOptStGeometryInterpolation*	st_geometry_interpolation

Discuss this page in DocCommentXchange.