Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

I/O Control

 
COMPATIBILITY DIRECT_IO

Reverts to the previous behavior of using direct I/O instead of O_DSYNC synchronous writes (or O_SYNC if O_DSYNC is not defined) for transaction logs on Solaris.

 
COMPATIBILITY FDATASYNC

For Unix systems, enables the optional use of fdatasync() instead of fsync().

 
COMPATIBILITY FORCE_WRITETHRU

Forces the automatic addition of the WRITETHRU mode to all files opened without the TRNLOG file mode.

 
COMPATIBILITY PREV610A_FLUSH

Provides a balance between update performance and recoverability of data in the event of an abnormal FairCom Server termination affecting non-transaction files.

 
COMPATIBILITY WTHRU_UPDFLG

Disables the ‘update’ flag on files with the WRITETHRU file mode.

 
DEFAULT_CHANNELS

Changes the number of I/O channels assigned to a file with ctDUPCHANEL in its file mode at open, unless the file is in the SET_FILE_CHANNELS list.

 
IDLE_NONTRANFLUSH and IDLE_TRANFLUSH

Deprecated: Sets the interval FairCom DB waits before checking to see if the server is idle before flushing data and index caches during idle time. These keywords have been replaced by the following:

 
IO_ERROR_BLOCK_RETRY

Specifies the maximum number of failed IO_ERROR_BLOCK_SIZE-sized I/O operations that must occur before the I/O operation is considered to have failed.

 
IO_ERROR_BLOCK_SIZE

Causes a read or write operation that fails with Windows system error 1450 (ERROR_NO_SYSTEM_RESOURCES) to be retried in blocks of the specified size.

 
IO_ERROR_BLOCK_SLEEP

Specifies a time in milliseconds between IO_ERROR_BLOCK_RETRY retry attempts.

 
SET_FILE_CHANNELS

Permits the number of I/O channels to be explicitly set for the named file regardless of whether the file mode, at open, includes ctDUPCHANEL.

 
UNBUFFERED_IO

Enables unbuffered I/O for the specified file on Windows systems.

 
Diagnostics

Diagnostics keywords are intended to be used to help collect data to be analyzed for troubleshooting. The use of these keywords should be avoided in normal operation as they may cause additional overhead (e.g., logging).

 
DIAGNOSTICS DIRECT_IO

Enables a check on each write operation for a file for which direct I/O is requested that the properties of the write operation meet the direct I/O requirements.

 
DIAGNOSTICS LOWL_FILE_IO (DIAGNOSTICS LOWL_FILE_IO, DIAGNOSTICS LOWL_FILE_IO)

Logs low-level system errors into the server status file, CTSTATUS.FCS.

In This Section

COMPATIBILITY DIRECT_IO

COMPATIBILITY FDATASYNC

COMPATIBILITY FORCE_WRITETHRU

COMPATIBILITY PREV610A_FLUSH

COMPATIBILITY WTHRU_UPDFLG

DEFAULT_CHANNELS

IDLE_NONTRANFLUSH and IDLE_TRANFLUSH

IO_BLOCK_SIZE

IO_ERROR_BLOCK_RETRY

IO_ERROR_BLOCK_SIZE

IO_ERROR_BLOCK_SLEEP

NONTRAN_DATA_FLUSH_SEC

NONTRAN_INDEX_FLUSH_SEC

OPEN_FILES_ALERT_THRESHOLD

OPTIMIZE_FILE_OPEN

OPTIMIZE_FILE_CLOSE

PENDING_FILE_OPEN_RETRY_LIMIT

SET_FILE_CHANNELS

SYSTEM_FILE_ID_LIST

DIAGNOSTICS SYSTEM_FILE_ID_LIST

TRAN_DATA_FLUSH_SEC

TRAN_INDEX_FLUSH_SEC

UNBUFFERED_IO

DIAGNOSTICS DIRECT_IO

DIAGNOSTICS LOWL_FILE_IO

TOCIndex