Resource limit facility controls

System administrators can use the resource limit facility to limit the amount of time that is permitted for the execution of certain types SQL statements and bind operations.

Introductory concepts

Begin general-use programming interface information.Resource limits can apply only to the following types of SQL statements:

Subsystem parameters

The following subsystem parameters control the resource limit facility:

RLF
Specifies whether the resource limit facility starts automatically when Db2 starts.
RLFTBL
Specifies the identifier of the resource limit tables to be started automatically when Db2 starts, or when no ID value is specifed in a START RLIMIT command.
Start of changeRLFENABLEEnd of change
Start of changeSpecifies whether resource limits apply to dynamic SQL statements only, static SQL statements only, both static and dynamic SQL statements, or none.End of change
RLFERR
Specifies a default limit for dynamic SQL statements that originate from the local server.
Start of changeRLFERRSTCEnd of change
Start of changeSpecifies a default limit for static SQL statements that originate from the local server.End of change
RLFERRD
Specifies a default limit for dynamic SQL statements that originate from remote locations.
Start of changeRLFERRDSTCEnd of change
Start of changeSpecifies a default limit for static SQL statements that originate from remote locations.End of change

Commands

You can use the following commands for controlling the resource limit facility:

START RLIMIT
Starts the resource limit facility and identifies a resource limit specification table. You can also use the START RLIMIT command to switch resource limit specification tables.
STOP RLIMIT
Stops the resource limit facility and removes any set limits.
DISPLAY RLIMIT
Displays the current status of the resource limit facility. If the resource limit facility has been started, the output from the command also identifies the resource limit specification table.

Supplied user tables

The limits are defined in resource limit specification tables and can vary for different users. One resource limit table is used for each invocation of the resource limit facility and that table is specified in the START RLIMIT command.

The following user tables control the resource limit facility:

RLSTxx
Specify resource limits that apply based on the collection ID, package name, authorization ID, and location name of the SQL statement.
RLMTxx
Specify resource limits that apply based on client information, including the application name, user ID, workstation ID, and IP address of the client

End general-use programming interface information.