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

Resource limits apply only to dynamic SQL statements. Resource limits apply to SQL statement regardless of whether they are issued locally or remotely. The resource limit facility does not control static SQL statements regardless of whether they are issued locally or remotely, and no limits 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.