Specifying and changing resource limits
You can specify resource limits to be enforced by the resource limit facility by populating the resource limit tables with rows of data that describe the limits.
Before you begin
About this task
Resource limits apply only to dynamic SQL statements. The resource limits are specified in supplied user tables that are named DSNRLSTxx or DSNRLMTxx, where xx is a unique identifier.
If both DSNRLMTxx and DSNRLSTxx tables exist, rows in the DSNRLMTxx table that match a statement take priority over any matching rows in the DSNRLSTxx table.
Procedure
Results
- SELECT
- INSERT
- UPDATE
- MERGE
- TRUNCATE
- DELETE
However, if you change the resource limit specification table while a thread is executing, the limit that existed when the thread issued its first SQL statement applies throughout the life of the thread, until DB2® reads in the new limit.
DB2 reads in a new limit in the following situations:
- When the application uses a different primary authorization ID.
- When the resource limit facility is stopped and started again.
- When a predictively governed package is loaded for execution.