beautypg.com

Database options, Database options” on – Sybase Adaptive Server Anywhere SNMP Extension Agent User Manual

Page 48

background image

OID

Type

Name

Property

1.3.6.1.4.1.897.2.2.2.53.

n

String

dbPropUniqueIdentifier

UniqueIdentifier

Database options

The following table lists the OIDs and names of the database options that can
be retrieved using the Adaptive Server Anywhere SNMP Extension Agent.

Writable options are marked with an asterisk (*). The value

n

is the database

number in the

asasnmp.ini

file.

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

dbOptAnsiCloseCursorsOn-
Rollback*

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

dbOptAnsiUpdateCon-
straints*

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

36