Enabling an accelerator

Queries can only be routed to an accelerator if the accelerator has been enabled in Db2 for z/OS.

Before you begin

  • You need a connection to a database that has an accelerator attached to it.
  • You (your user ID) must be connected to the database and have the rights to control the accelerator.
  • The Acceleration status of the accelerator must be Stopped.

Procedure

Use one of the following methods to enable an accelerator:

  • On the command-line in Db2 for z/OS, enter -start ACCEL <name> where <name> is the name of the accelerator.
  • In your administration client:
    1. Connect to the Db2 subsystem or data sharing group that the accelerator is attached to. For more information, see Connecting to a database server.
    2. Select the accelerator. For more information, see Selecting an accelerator.
    3. Start the accelerator:
      IBM Db2 Analytics Accelerator Studio Click Button for enabling an accelerator on the toolbar.
      IBM Data Server Manager Click the Start button on the toolbar.
      IBM Unified Experience for z/OS In the upper right corner, locate the Accelerator actions button and select Accelerator actions > Start acceleration.
      IBM Db2 Analytics Accelerator Administration Services
      1. Start an /accelerator/startStopAccelerator request.
      2. In the request body:
        1. Specify the connection name ("connectionName":).
        2. Specify the accelerator name ("accelName":).
        3. Set "startAccel": to the value true.
      3. Click Execute.
      This invokes the Db2 command -START ACCEL on your data server.

Results

When an accelerator has been enabled, its acceleration status changes to Started.