Chapter 5 Database Options
177
CHECKPOINT_TIME option
Set the maximum number of minutes that the database server will run
without doing a checkpoint.
Integer
Can be set only for the PUBLIC group. DBA authority is required to set the
option. You must shut down and restart the database server for the change to
take effect.
60
This option is used with the "RECOVERY_TIME option" on page 208 to
decide when checkpoints should be done.
$ For information on checkpoints, see "Checkpoints and the checkpoint
log" on page 668 of the book ASA User’s Guide.
CIS_ROWSET_SIZE option
Set the number of rows that are returned from remote servers for each fetch.
Integer
Can be set for an individual connection or for the PUBLIC group. Takes
effect when a new connection is made to a remote server.
50
This option sets the ODBC FetchArraySize value when using ODBC to
connect to a remote database server.
CLOSE_ON_ENDTRANS option
Controls the closing of cursors at the end of a transaction.
ON, OFF
ON
When CLOSE_ON_ENDTRANS is set to ON, cursors are closed whenever
a transaction is committed unless the cursor was opened WITH HOLD. The
behavior when a transaction is rolled back is governed by the
ANSI_CLOSE_CURSORS_AT_ROLLBACK option.
Function
Allowed values
Scope
Default
Description
Function
Allowed values
Scope
Default
Description
Function
Allowed values
Default
Description
To Next Page
Loading...