Starting and stopping resource limit tables
You can create several resource limit tables and start and stop them as needed to support the type and amount of processing that occurs at different times.
About this task
At installation time, you can specify a default set of resource limit tables to be used each time that Db2 is restarted. The RLF subsystem parameter value controls the automatic start, and the value of the RLFTBL subsystem parameter specifies the tables to start when Db2 starts.
If the resource limit facility is active and you restart it without stopping it, any jobs that are active continue to use their original limits, and all new jobs use the limits that are specified in the new table.
If you stop the resource limit facility while a statement is running, it runs with no limit, but its processing time continues to accumulate. If you later restart the resource limit facility, the new limit takes effect for an active job only when the job passes one of several internal checkpoints. For example, an SQL statement that builds a result table and fetches from it, passes those checkpoints at intervals that might range from moments to hours. As a result, a change to a resource limit might not stop an active statement within the time that you expect.
Only one pair of resource limit tables, containing one table of each type (DSNRLSTxx or DNSRLMTxx ), can be active at any time.
Procedure
To start and stop limit tables:
Example
| AUTHID | PLANNAME | LUNAME |
|---|---|---|
| BADUSER | LUDBD1 | |
| ROBYN | LUDBD1 | |
| LUDBD1 |
| AUTHID | ASUTIME | LUNAME |
|---|---|---|
| BADUSER | 0 | LUDBD1 |
| ROBYN | NULL | LUDBD1 |
| 50000 | LUDBD1 |
In this example, you might issue the following command when the day shift begins:
-START RLIMIT ID=01Then, when it is time for the night shift to begin, you might issue the following command to switch to the other table:
-START RLIMIT ID=02After you issue this command, new threads from the ROBYN authorization ID from LUDBD1 can issue SQL statements without limits. Threads that already existed at the time that you issued the command continue under the limits that are specified in the DSNRLST01 table.