Chapter 5 Database Options
185
500
This option has meaning only when DELAYED_COMMITS is set to ON. it
governs when a COMMIT entry in the transaction log is written to disk.
With DELAYED_COMMITS set to ON, the database engine waits for the
number of milliseconds set in the DELAYED_COMMIT_TIMEOUT option
for other connections to fill a page of the log before writing the current page
contents to disk.
$ For more information, see "DELAYED_COMMITS option" on
page 184.
DELETE_OLD_LOGS option
Controls whether transaction logs are deleted when their messages have been
replicated.
ON, OFF, DELAY
OFF
This option is used at MobiLink clients, by SQL Remote, and by the
Adaptive Server Anywhere Replication Agent. The default setting is OFF.
When it is set to ON, each old transaction log is deleted when all the changes
it contains have been sent and confirmed as received. When it is set to
DELAY, each old transaction log with a file name indicating that it was
created on the current day is not deleted.
$ For more information about how to use the DELETE_OLD_LOGS
option in conjunction with the Backup statement to delete old copies of
transaction logs, see the "BACKUP statement" on page 401.
DESCRIBE_JAVA_FORMAT option [ISQL]
Controls whether Java objects are interpreted as strings (for display) or as
binary (for loading and unloading).
varchar, binary
varchar
When set to varchar, Interactive SQL converts all data fetched from the
database to strings. The database server calls the toString() method on
Java columns to provide formatted output for the Interactive SQL data
window.
Default
Description
Function
Allowed values
Default
Description
Function
Allowed values
Default
Description
To Next Page
Loading...