-START ACCEL (DB2)

The DB2® command START ACCEL notifies the DB2 subsystem that it should use the specified accelerator servers.

Abbreviation: -STA ACCEL

On successful completion of the command, queries for the specified accelerator servers can begin to run. DB2 resets trace statistics to 0 each time that you execute the START ACCEL command.

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                  |        |   
>>-START ACCEL--+-(--------accelerator-name-+------)-+---------->

>--+-------------------------------+---------------------------->
   |            .-*-----------.    |   
   '-ACCESS--(--+-MAINT-------+--)-'   
                '-EXPLAINONLY-'        

>--+------------------------+----------------------------------->
   |           .-LOCAL-.    |   
   '-SCOPE--(--+-GROUP-+--)-'   

>--+-----------------------------------+-----------------------><
   |             .-,-----------.       |   
   |             V             |       |   
   '-MEMBER(-------member-name-+-----)-'

Option descriptions

(accelerator-name)

The accelerator server name.

(*)

Indicates that the start command applies to all accelerator servers.

ACCESS

Specifies whether access to accelerator servers is general or restricted. Valid values are:

(*): Allows general access; all authorized users can use the accelerator server.
(MAINT): Allows only installation SYSADM and installation SYSOPR access to the accelerator server.
(EXPLAINONLY): Prohibits use of the accelerator server except for SQL EXPLAIN execution. No queries will be executed by this server.

SCOPE

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

(LOCAL): Starts the accelerator server for the current member.
(GROUP): Starts accelerator servers for the entire data sharing group.

MEMBER

Restricts the start of the identified accelerator server to specific members of the data sharing group. The default is to start accelerator server on the local member. In a non-data-sharing environment, the option is ignored.

Usage notes

Start of change You must issue START ACCEL when you add a new accelerator server to the SYSACCELERATORS pseudo-catalog table, or when you have modified the information in this table and issued the -STOP ACCEL command. End of change

If both SCOPE(GLOBAL) and MEMBER(member-name) are specified, the command will be executed only on the specified member or members.

You can monitor the status of a started accelerator server by running the -DISPLAY ACCEL command.

Example

The following command starts all accelerator servers.

-START ACCEL

Sample results:

 DSNX811I ) DSNX8STA START ACCELERATOR SUCCESSFUL FOR BLINK1
 DSNX811I ) DSNX8STA START ACCELERATOR SUCCESSFUL FOR BLINK2
 DSNX811I ) DSNX8STA START ACCELERATOR SUCCESSFUL FOR BLINK3
 DSNX819I ) DSNX8STA ALL ACCELERATORS STARTED
 DSN9022I ) DSNX8CMD '-START ACCEL' NORMAL COMPLETION