The resource limit facility
The resource limit facility (sometimes abbreviated RLF) enables you to control the amount of processor resources that are used by SQL statements.
Resource limits apply to the following types of SQL statements:
- SELECT
- INSERT
- UPDATE
- MERGE
- TRUNCATE
- DELETE
You can specify resource limits for dynamic SQL statements and static SQL statements.
Resource limits apply to SQL statement regardless of whether they are issued locally or remotely. The resource limit facility does not apply to primary or secondary authorization IDs that have installation SYSADM or installation SYSOPR authority.
You can establish a single limit for all users, different limits
for individual users, or both. You can choose to have these limits
applied before the statement is executed through predictive
governing, or while a statement is running, through reactive
governing. You can also use reactive and predictive governing
in combination. You define these limits in one or more resource
limit tables, named DSNRLSTxx or DSNRLMTxx,
depending on the monitoring purpose.