LTXHWM

onconfig.std
value

50

units

Percent

range of values

1 through 100

takes effect

When shared memory is initialized

utilities

onutil

refer to

Avoiding long transactions in the chapter on what is the logical log in the IBM Informix: Administrator's Guide

LTXHWM specifies the long-transaction high-water mark. The value of LTXHWM is the percentage of available logical-log space that, when spanned by a single transaction, triggers the database server to heuristically abort the transaction. Other transactions continue to execute, and the rollback procedure itself generates logical-log records, so the logical log continues to fill. (The LTXEHWM parameter exists for this reason.)

When the database server is initialized, if LTXHWM is set greater than 50 and DYNAMIC_LOGS is set to 0, a warning is issued. In this case it is recommended that you either reduce the value of LTXHWM or set DYNAMIC_LOGS to a non-zero value.

To modify the LTXHWM parameter dynamically, use the onutil SET command. Example:

% onutil
1> SET LTXHWM 70;