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
    • RLFENABLE
    • RLFERR
    • RLFERRD
    • RLFERRSTC
    • RLFERRDSTC
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.