RLFERRD—RLF remote error action


Use the Modify RLF Remote Error Action panel or the RLFERRD command to specify what action Db2 takes when access to the resource limit specification tables fails and the Resource Limit Facility is initialized for a remote query.

You can set RLFERRD to NORUN to terminate all dynamic SQL statements immediately with an SQL error code.

Modify RLF Remote Error Action panel

DDTJ DEBD Modify RLF Remote Error Action
Command ===>
Command ===> _________________________________________________________________
 Command: CURRENT
Description . . . . . . . . : RLF REMOTE 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-57-7.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. This is the default.

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

DSNTIPR

None

DSN6FAC

RLFERRD

 

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