-STOP RLIMIT command (Db2)

The Db2 command STOP RLIMIT stops the resource limit facility.

All previously limited SQL statements run without limits. However, the processing time continues to accumulate for statements that continue to run after the STOP RLIMIT command is issued.

Abbreviation: -STO RLIM

Environment

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: Member

Authorization

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

Read syntax diagramSkip visual syntax diagramSTOP RLIMIT

Example

Stop the resource limit facility. 
-STOP RLIMIT