Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

Locking

 
AUTO_LOCK_RETRY

Enables automatic retries of data record locks when a c-tree function call fails with a data record lock error DLOK_ERR.

 
AUTO_LOCK_RETRY_SLEEP

Set the sleep time between retries.

 
BLOCKING_LOCK_TIMEOUT_SEC

Avoids excessively long blocking lock waits by returning error UTIM_OUT (827) to the caller of the lock request.

 
CHECKLOCK_FILE (CHECKLOCK_FILE, CHECKLOCK_FILE)

Enable or disable ctCHECKLOCK mode for specified data files.

 
COMPATIBILITY LKISAM_MODES

Disables error if the lokmod parameter includes any modifier bits intended for FairCom use only.

 
ITIM_RETRY_DEFER

Introduces a delay before internally retrying an ISAM record read operation when an ITIM_ERR (160) is encountered.

 
ITIM_RETRY_LIMIT

Enables retrying the operation the specified number of times before returning ITIM_ERR (160) if an index is out-of-sync with the data temporarily while another user is performing an update.

 
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 DLOK_ERR

Enables logging of DLOK_ERR (42) lock error information to CTSTATUS.FCS.

 
DIAGNOSTICS LOCK_DUMP

Enable the use of the LockDump() function for non ADMIN users.

In This Section

AUTO_LOCK_RETRY

AUTO_LOCK_RETRY_SLEEP

BLOCKING_LOCK_TIMEOUT_SEC

CHECKLOCK_FILE

COMPATIBILITY LKISAM_MODES

ITIM_RETRY_DEFER

ITIM_RETRY_LIMIT

DIAGNOSTICS DLOK_ERR

DIAGNOSTICS LOCK_DUMP

TOCIndex