RLFERR—RLF error action


Use the Modify RLF Error Action panel or the RLFERR command to specify what action Db2 will take when access to the resource limit specification tables fails and the Resource Limit Facility is initialized. You can set RLFERR to NORUN to terminate all dynamic SQL statements immediately with an SQL error code.

Modify RLF Error Action panel

DDTJ DEBD Modify RLF Error Action
Command ===> _________________________________________________________________

 Command: CURRENT
Description . . . . . . . . : RLF ERROR ACTION

Type the new RLF Error Action that you wish to change to. Then press Enter.

RLF Error Action
RLF Error Action value . . . (NOLIMIT, NORUN, 1 - 5000000)

Command syntax and parameters

image2018-12-24_20-52-10.png

Value

Description

DB2ssid

Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies.

opertuneID

OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job).

NOLIMIT

Ad hoc SQL statements are allowed to execute with no limit imposed.

NORUN

Ad hoc SQL statements are terminated.

servUnits

The RLF limit in CPU service units. Specify a numerical value in the range 1–5000000.

NORESET

The changes you request remain in effect until the Db2 subsystem is cycled.

Db2 parameter values

Field

Installation panel

CLIST parameter

ZPARM macro

ZPARM parameter

RLF Error Action value

DSNTIPO

None

DSN6SYSP

RLFERR

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*