Product Documentation

Database Administrator's Guide

Previous Topic

Next Topic

MAX_TRANSACTION_JUMP

MAX_TRANSACTION_JUMP <maximum transaction increase value>

MAX_TRANSACTION_JUMP limits the maximum increase in the server's transaction number when opening a transaction-controlled file. This can prevent a shutdown due to transaction number overflow.

MAX_TRANSACTION_JUMP specifies a maximum transaction increase value. When opening a transaction-controlled file, if the file's transaction high water mark in the file header exceeds the server's current transaction number by more than the specified value, the server fails the file open with error 533 (MTRN_ERR). In this situation, use the ctclntrn utility to clean the transaction marks in the file, allowing the server to open it.

A value of 0 disables the setting.

If you don't know what to set it to, we recommend starting with a value of 1,000,000,000.

Default: 0 (disables the setting)

See also:

Transaction High-Water Marks

TOCIndex