Resource limit facility implications for data sharing
The resource limit facility controls the amount of processor time that SQL statements can consume in DB2®.
Different members of a data sharing group can use the same or different resource limit facility tables. Each resource limit table must have a unique name within the data sharing group.
The following controls for the resource limit facility apply only to a single member:
- The following DB2 commands apply only to the member where the command was issued:
- START RLIMIT
- STOP RLIMIT
- DISPLAY RLIMIT
- The following subsystem parameters apply only for the member where
the value is set:
- RLF
- RLFERR
- RLFERRD
While a resource limit table is active in any member, the following
actions are restricted:
- DROP commands for any object that is associated with the resource limit table.
- STOP DATABASE commands for a database or table space that contains the resource limit tables.
- START DATABASE commands with the ACCESS(UT) option for a database or table space that contains the resource limit tables.