-DISPLAY RLIMIT command (Db2)

The -DISPLAY RLIMIT command displays the current status of the resource limit facility (governor).

If the facility has already been started, DISPLAY RLIMIT also displays the ID of the resource limit specification table or the resource limit middleware table that is being used.

Abbreviation: -DIS RLIM

Environment for -DISPLAY RLIMIT

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

Data sharing scope: Member

Authorization for -DISPLAY RLIMIT

To execute this command, you must use a privilege set of the process that includes one of the following privileges or authorities:
  • Start of changeDISPLAY privilegeEnd of change
  • System DBADM authority
  • 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 -DISPLAY RLIMIT

Read syntax diagramSkip visual syntax diagramDISPLAY RLIMIT

Output for -DISPLAY RLIMIT

Message DSNT700I or DSNT701I indicates the beginning of the output of the command.

DSNT700I - Active

Message DSNT700I indicates that the governor is active.

DSNT700I table-name IS THE ACTIVE RESOURCE LIMIT SPECIFICATION TABLE

table-name is the table that the governor is using to determine resource limits.

If you want the governor to use a different resource limit specification table, issue the START RLIMIT command and specify the ID of the table.

If you do not want the governor to be active, issue the STOP RLIMIT command.

DSNT701I - Not active

Message DSNT701I indicates that the governor is not active.

DSNT701I RESOURCE LIMIT FACILITY IS INACTIVE

If you want the governor to be active, issue the START RLIMIT command and specify the ID of the resource limit specification table to be used.

DSN9022I - Normal completion

When the DISPLAY RLIMIT command ends normally, message DSN9022I is issued.

DSN9022I = DSNTCDIS 'DISPLAY RLIMIT' NORMAL COMPLETION

Examples for -DISPLAY RLIMIT

Example: Displaying the current status of the resource limit facility
The following command displays the current status of the resource limit facility.
-DISPLAY RLIMIT

When the resource limit facility is inactive, the output is similar to the following output.

DSNT701I - RESOURCE LIMIT FACILITY IS INACTIVE
DSN9022I - DSNTCDIS 'DISPLAY RLIMIT' NORMAL COMPLETION

When the resource limit facility is active, the output is similar to the following output.

DSNT700I = SYSADM.DSNRLST03 IS THE ACTIVE RESOURCE LIMIT
SPECIFICATION TABLE
DSN9022I = DSNTCDIS 'DISPLAY RLIMIT' NORMAL COMPLETION