SESSION_LIMIT_TEMPSPACE configuration parameter

The SESSION_LIMIT_TEMPSPACE configuration parameter specifies the maximum amount of temporary table space that a session can allocate. 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
20480 - 2147483648
units
KB
takes effect
After you edit your onconfig file and restart the database server.

Usage

The SESSION_LIMIT_TEMPSPACE configuration parameter limits how much temporary table space a session can allocate, and can conserve system resources within a tenant-database environment.

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

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


Copyright© 2019 HCL Technologies Limited