Resource limit facility tables

Resource limit facility tables allow you to limit the amount of processor resources, in service units, used by SQL statements in specified contexts.

Start of changeYou can specify resource limits for dynamic SQL statements and static SQL statements.End of change The limits that you specify apply to individual SQL statements that qualify for a scope that you define. You can specify reactive or predictive governing, or use a combination of reactive and predictive limits in the same resource limit table.
Deprecated function: The following resource limit table formats are deprecated:
  • Starting in Db2 12, DSNRLSTxx table formats and related index formats from before DB2® version 8 format are not supported. When Db2 detects DSNRLSTxx tables with unsupported formats, it issues message DSNT731I.
  • DSNRLMTxx table formats and related index formats from before Db2 11 are deprecated. In Db2 12, if Db2 detects DSNRLMTxx tables in a deprecated format, it issues message DSNT732I, processing for the START RLIMIT command continues, and the resource limit facility starts using the deprecated objects.

For more information, see Convert RLF tables to the current format.