-START RLIMIT command (Db2)

The -START RLIMIT command starts the resource limit facility (governor) and specifies a resource limit specification table for the facility to use.

You can issue START RLIMIT even if the resource limit facility or resource limit table is already active. Db2 reads resource limit tables into memory to use for START RLIMIT command processing. When you update the active resource limit tables, Db2 detects the resource limit changes and automatically refreshes the in-memory resource limit tables with these changes.

Deprecated function: The following resource limit table formats are deprecated:
  • DSNRLMTxx table formats and related index formats from before Db2 11 are deprecated. In Db2 13, if Db2 detects DSNRLMTxx tables in a deprecated format, it issues message DSNT732I, processing for the START RLIMIT command continues, and the resource limit facility starts using the deprecated objects.

For more information, see Converting RLF tables to the current format.

Abbreviation: -STA RLIM

Environment for -START RLIMIT

This command can be issued from a z/OS® console, a DSN session under TSO, a DB2I panel (DB2 COMMANDS), an IMS or CICS® terminal, or a program using the instrumentation facility interface (IFI).

Data sharing scope: Group or member

Authorization for -START RLIMIT

To execute this command, you must use a privilege set of the process that includes one of the following authorities:
  • SYSOPR authority
  • SYSCTRL authority
  • SYSADM authority

Db2 commands that are issued from a logged-on z/OS console or TSO SDSF can be checked by Db2 authorization using primary and secondary authorization IDs. Start of changeA logged-on z/OS user ID must be defined in RACF or a similar security server.End of change

Syntax for -START RLIMIT

Read syntax diagramSkip visual syntax diagram START RLIMIT ID= idSCOPE(LOCALGROUP)

Option descriptions for -START RLIMIT

The following keywords are optional.
ID= id
Identifies the resource limit specification table for the governor to use.

id is the one or two identification character that is specified when the table is created. You can start a resource limit table that is already active by specifying the same ID that was specified in the last START RLIMIT command.

The full name of the table is authid.DSNRLSTid or authid.DSNRLMTid, where authid is the value that is specified in field RESOURCE AUTHID on installation panel DSNTIPP.

The default ID is specified by the value of the RLFTBL subsystem parameter.

SCOPE
Specifies the scope of the command in a data sharing group.
(LOCAL)
Starts the resource limit facility for the local member only. This is the default value.
(GROUP)
Starts the resource limit facility for the entire data sharing group.

Usage notes for -START RLIMIT

Trace information for commands issued with group scope
If this command is issued with options that specify group scope in a Db2 data sharing member, it also runs on all other active members. IFICID 090 trace records for other group members can show that the same command was issued by the SYSOPR authorization ID from the 016.TLPKN5F correlation ID, in addition to the trace records from the member where the original command was issued. See Command scope in Db2 data sharing.

Examples for -START RLIMIT

Example 1
Start the resource limit facility using the DSNRLST01 resource limit table. 
-START RLIMIT ID=01
Example 2
Start the resource limit facility using the DSNRLST01 resource limit table for all members of the data sharing group. 
-START RLIMIT ID=01 SCOPE(GROUP)