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
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.
- RLFENABLE
- Specifies whether resource limits apply to dynamic SQL statements only, static SQL statements only, both static and dynamic SQL statements, or none.
- RLFERR
- Specifies a default limit for dynamic SQL statements that originate from the local server.
- RLFERRSTC
- Specifies a default limit for static SQL statements that originate from the local server.
- RLFERRD
- Specifies a default limit for dynamic SQL statements that originate from remote locations.
- RLFERRDSTC
- Specifies a default limit for static SQL statements that originate from remote locations.
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: