SESSION_LIMIT_LOGSPACE configuration parameter

The SESSION_LIMIT_LOGSPACE configuration parameter specifies the maximum amount of log space that a session can use for individual transactions. 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
5120 - 2147483648
units
KB
takes effect
After you edit your onconfig file and restart the database server.

Usage

The SESSION_LIMIT_LOGSPACE configuration parameter limits how much log space a session can use for each transaction, and can conserve system resources within a tenant-database environment.

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

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


Copyright© 2019 HCL Technologies Limited