LTXEHWM configuration parameter

Use the LTXEHWM configuration parameter to specify the long-transaction, exclusive-access, high-watermark. When the logical-log space reaches the LTXEHWM threshold, the long transaction currently being rolled back is given exclusive access to the logical log.

onconfig.std value
LTXEHWM 80
if not present
90 (if DYNAMIC_LOGS is set to 1 or 2) 60 (if DYNAMIC_LOGS is set to 0)
range of values
LTXHWM through 100
units
Percent
takes effect
After you edit your onconfig file and restart the database server.
When you reset the value dynamically in your onconfig file by running the onmode -wf command.
When you reset the value in memory by running the onmode -wm command.

Usage

A transaction is long if it is not committed or rolled back when it reaches the long-transaction high-watermark.

If your system runs out of log space before the rollback completes, lower the LTXEHWM value.

If you do not want too many logical logs to be added, LTXEHWM should be set to a smaller value (around 60). If dynamic logging is turned off (DYNAMIC_LOGS = 0), LTXEHWM should be set lower (around 50) to avoid running out of logical space.
Tip: To allow users to continue to access the logical logs, even during a long transaction rollback, set LTXEHWM to 100. Set DYNAMIC_LOGS to 1 or 2 so that the database server can add a sufficient number of log files to prevent long transactions from hanging and to allow long transactions to roll back.

Copyright© 2019 HCL Technologies Limited