-STOP RLIMIT command (Db2)

The -STOP RLIMIT command 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 for -STOP 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: Member

Authorization for -STOP 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 -STOP RLIMIT

Read syntax diagramSkip visual syntax diagramSTOP RLIMIT

Example for -STOP RLIMIT

Stop the resource limit facility. 
-STOP RLIMIT