Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

COMPATIBILITY NO_TRAN_DISCONNECT

COMPATIBILITY NO_TRAN_DISCONNECT

When the number of log files is not permitted to increase (because of FIXED_LOG_SPACE YES in the configuration), and if the need for more logs is caused by a pending transaction, the server disconnects the client associated with the transaction by default. This keyword option disables this support and if the client does not make a subsequent server request, then the pending transaction will eventually lead to the server terminating abruptly with a L56 ctcatend. The server terminates because it cannot ensure that a commit or abort will be added to the transaction logs before the log that holds the TRANBEG() will become inactive. (If the client makes a server request, it will see the transaction attribute that indicates the need to abandoned the transaction, and the ctcatend shutdown will be avoided.)

TOCIndex