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 |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |