Identify available accelerators to Db2 for z/OS

You can identify the accelerator servers that are available to Db2 by issuing the -START ACCEL command.

Before you begin

Ensure that the following prerequisite tasks are completed:

  1. Install and configure an accelerator server, as described in IBM Db2 Analytics Accelerator for z/OS documentation.
  2. Create a database, a table space, tables, and indexes that are used to support the acceleration of queries.
  3. Enable queries to be accelerated by setting subsystem parameters, bind options, and special registers.

For more information about these and other prerequisites, see Enabling Db2 for IBM Db2 Analytics Accelerator for z/OS.

Tip: You can also use either the Db2 Administration Tool for z/OS or IBM® Db2 Analytics Accelerator Studio to enable and start accelerator servers. Both of these products enable accelerator servers by invoking the -START ACCEL command on a Db2 for z/OS subsystem.

Procedure

Identify the accelerator servers that are available to Db2 by issuing the -START ACCEL command.
On successful completion of the -START ACCEL command, queries for the specified accelerator servers can begin to run. Alternatively, if you specify the ACCEL subsystem parameter as AUTO, accelerator servers are automatically enabled and started when the Db2 subsystem is started.

Results

Eligible queries are candidates to be passed to an accelerator server. However, even if a query is eligible for acceleration, Db2 might not pass the query to an accelerator server. For more information, see How Db2 determines whether to accelerate eligible queries.