Alphabetical list of options
208
RECOVERY_TIME option
Sets the maximum length of time, in minutes, that the database server will
take to recover from system failure.
Integer, in minutes
Can be set only for the PUBLIC group. Takes effect when server is restarted.
2
This option is used with the "CHECKPOINT_TIME option" on page 177 to
decide when checkpoints should be done.
Adaptive Server Anywhere uses a heuristic to estimate the recovery time
based on the operations that have been performed since the last checkpoint.
Thus, the recovery time is not exact.
$ For more information, see "The automatic recovery process" on
page 670 of the book ASA User’s Guide.
ROW_COUNTS option
Specifies whether the database will always count the number of rows in a
query when it is opened.
ON, OFF
Can be set for an individual connection or for the PUBLIC group. Takes
effect immediately.
OFF
If this option is set to OFF, the row count is usually only an estimate. If this
option is set to ON, the row count is always accurate. Opening queries may
take significantly longer.
REPLICATE_ALL option
Allows an entire database to act as a primary site in a Replication Server
setup.
ON, OFF
OFF
Function
Allowed values
Scope
Default
Description
Function
Allowed values
Scope
Default
Description
Function
Allowed values
Default
To Next Page
Loading...