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.

Begin general-use programming interface information.

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.End general-use programming interface information.