SESSION_LIMIT_TXN_TIME configuration parameter

The SESSION_LIMIT_TXN_TIME configuration parameter specifies the maximum amount of time that a transaction can run in a session. This limit does not apply to a user who holds administrative privileges, such as user informix or a DBSA user.

onconfig.std value
0 (off)
if not present
0 (off)
values
60 - 2147483647
units
Seconds
takes effect
After you edit your onconfig file and restart the database server.

Usage

The SESSION_LIMIT_TXN_TIME configuration parameter limits how much time a transaction can run in a session, and can prevent individual session transactions from monopolizing the logical log.

The database server terminates a transaction that exceeds the time limit, puts a message in the database server message log, and triggers the event alarm 21019.

The session_limit_txn_time tenant database property set through the tenant create or tenant update SQL API command takes precedent over the SESSION_LIMIT_TXN_TIME configuration parameter setting.


Copyright© 2018 HCL Technologies Limited