RLIMIT—Resource limit facility


Use the Modify Resource Limit Facility panel or the RLIMIT command to change the Db2 Resource Limit Facility Table ID dynamically. The table ID is composed of one or two alphanumeric characters. Confirmation of this command invokes the Db2 START RLIMIT command. The new value takes effect immediately.

Although this value can be changed using a Db2 command, this element is included in OPERTUNE so that you can use the RLIMIT specification in a group profile, changing the RLIMIT with other elements at predetermined times using schedules.

Warning

Important

See the IBM Db2 Command and Utility Reference for more information about the Resource Limit Facility and the table suffix.

Modify Resource Limit Facility panel

DDTG DBI1 Modify Resource Limit Facility
Command ===> _________________________________________________________________

 Command: CURRENT
Description . . . . . . . . : RESOURCE LIMIT TABLE
Type the new RLF value that you wish to change to. Then press Enter.

Resource Limit Facility Parameter
Table suffix . . . . . . . . __ (alpha-numeric characters or '--' to issue
"-STOP RLIMIT")

Command syntax and parameters

image2018-12-24_21-3-8.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).

ID

Resource Limit Facility (RLF) table ID. Specify 1–2 alphanumeric characters.

--

Issues a STOP RLIMIT command.

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

Table suffix

None

None

None

None

 

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

OPERTUNE for DB2 13.1