Chapter 5 Database Options
175
Integer, in kilobytes
256
Any value longer than the BLOB_THRESHOLD option is replicated as a
blob. That is, it is broken into pieces and replicated in chunks, before being
reconstituted by using a SQL variable and concatenating the pieces at the
recipient site.
If you set BLOB_THRESHOLD to a high value in remote Adaptive Server
Anywhere databases, blobs are not broken into pieces, and operations can be
applied to Adaptive Server Enterprise by the Message Agent. Each SQL
statement must fit within a message, so this only allows replication of small
blobs.
BLOCKING option
Controls the behavior in response to locking conflicts.
ON or OFF
Can be set for an individual connection or for the PUBLIC group. Takes
effect immediately.
ON
If BLOCKING is ON, any transaction attempting to obtain a lock that
conflicts with an existing lock held by another transaction waits until every
conflicting lock is released. At that time, the write goes through. If
BLOCKING is OFF, the transaction that attempts to obtain a conflicting lock
receives an error.
$ For more information, see "Two-phase locking" on page 422 of the
book ASA User’s Guide.
CHAINED option
Controls transaction mode in the absence of a BEGIN TRANSACTION
statement.
ON, OFF
ON
OFF for Open Client and JDBC connections
Allowed values
Default
Description
Function
Allowed values
Scope
Default
Description
Function
Allowed values
Default
To Next Page
Loading...