-STOP ACCEL (DB2)

The DB2® command STOP ACCEL causes the DB2 subsystem to stop using the specified accelerator servers.

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 that uses the instrumentation facility interface (IFI).

Data sharing scope: Group or local, depending on the SCOPE option.

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 by using primary and secondary authorization IDs.

Syntax

               .-(--*--)----------------------------.   
               |        .-,----------------.        |   
               |        V                  |        |   
>>-STOP ACCEL--+-(--------accelerator-name-+------)-+----------->

>--+---------------------+--+------------------------+---------->
   |       .-QUIESCE-.   |  |           .-LOCAL-.    |   
   '-MODE(-+-FORCE---+-)-'  '-SCOPE--(--+-GROUP-+--)-'   

>--+---------------------+-------------------------------------><
   '-MEMBER(member-name)-'

Option descriptions

(accelerator-name)

The accelerator server name. This option limits the stop command to the specified accelerator server.

(*)

Indicates that the stop command applies to all accelerator servers.

MODE

Indicates whether currently executing active accelerator threads are allowed to complete. Valid values are:

(QUIESCE): Allows active accelerator threads to complete normally and terminates only inactive accelerator threads.
(FORCE): Terminates all currently executing accelerator threads. DB2 reverts to baseline processing for the originating threads.

SCOPE

Specifies the scope of the command. In a non-data-sharing environment, the option is ignored. Valid values are:

(LOCAL): Stops the current data sharing member from using the specified accelerator servers. This is the default.
(GROUP): Stops the data sharing group from using the specified accelerator servers.

MEMBER

Stops specific members of the data sharing group from using the specified accelerator servers.

Usage notes

If you specify both SCOPE(GLOBAL) and MEMBER(member-name), the command will be executed only on the specified members of the data sharing group.

Example

The following command is used to stop the current data sharing member from using all accelerators, and to terminate only inactive accelerator threads.

-STOP ACCEL(*) MODE(QUIESCE) SCOPE(LOCAL)

The output is similar to the following output:

 DSNX821I ) DSNX8STO STOP ACCELERATOR SUCCESSFUL FOR BLINK1
 DSNX821I ) DSNX8STO STOP ACCELERATOR SUCCESSFUL FOR BLINK2
 DSNX821I ) DSNX8STO STOP ACCELERATOR SUCCESSFUL FOR BLINK3
 DSNX829I ) DSNX8STO ALL ACCELERATORS STOPPED
 DSN9022I ) DSNX8CMD '-STOP ACCEL' NORMAL COMPLETION