Setting default resource limits for SQL statements

You can specify default resource limits that apply to certain categories of SQL statements when no resource limit table row applies to the statement.

Start of change

Before you begin

The RLFENABLE subsystem parameter is set to an appropriate value.

End of change

About this task

You can use subsystem parameters to set default limits that apply to all SQL statements of certain types. The subsystem parameter values are used only if no resource limit table row applies to a statement.

Procedure

To set resource limits that apply to SQL statements by default:

  1. Set the values of the appropriate subsystem parameter for the type of SQL statements that you want to limit:
    Option Description
    Local dynamic SQL statements Set the value of the RLFERR subsystem parameter.
    Dynamic SQL statements from remote locations Set the value of the RLFERRD subsystem parameter.
    Start of changeLocal static SQL statementsEnd of change Start of changeSet the value of the RLFERRSTC subsystem parameterEnd of change
    Start of changeStatic SQL statements from remote locationsEnd of change Start of changeSet the value of the RLFERRDSTC subsystem parameter.End of change
  2. Issue a START RLIMIT command to start or restart the resource limit facility.
    You might need to first issue a STOP RLIMIT command if resource limits are already started for all resource limits that you want to apply.

Results

Each value specifies the action that Db2 takes for SQL statements when no row that applies to the statement is found in the resource limit table.