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.

Resource limits apply only to dynamic SQL statements. 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.

Important: The following resource limit table formats are either deprecated or not supported in DB2® 12 or later releases:

DSNRLSTxx table formats earlier than the DB2 Version 8 format are not supported in DB2 12 or later releases.
DSNRLMTxx tables in formats earlier than the DB2 9 format are deprecated in DB2 12.

DSNRLMTxx resource limit tables
Resource limit tables can be used to limit the amount of resources used by a certain group of SQL statements. Statements can be limited based on client information, including the application name, user ID, workstation ID, and IP address of the client.
DSNRLSTxx resource limit tables
Resource limit tables can be used to limit the amount of resource used by certain SQL statements. Statements can be limited based on information about the SQL statement, including the collection ID, package name, authorization ID, and location name of the query.

Parent topic: DB2-supplied user tables

Related concepts:

Resource limit facility controls

Related tasks:

Limiting resource usage for packages

Setting limits for system resource usage by using the resource limit facility

Controlling resource usage