Enabling Db2 for IBM Db2 Analytics Accelerator for z/OS

In the Db2 for z/OS environment, an accelerator is a solution that can run queries on behalf of Db2.

In addition to any other accelerators that might be available in the marketplace, IBM offers a high-performance accelerator appliance: IBM Db2 Analytics Accelerator for z/OS. The information in the following topics assumes that you use IBM Db2 Analytics Accelerator for z/OS, or an equivalent accelerator.

An accelerator server is a specific instance of an accelerator. For certain types of queries, such as business intelligence (BI) queries, processing on an accelerator server can be faster than processing on Db2.

Before you begin

For applications that run on a remote client or driver, the level of that client or driver must support DB2® 9 in new-function mode or later. The following types of clients and drivers are the minimum levels that are supported. Later versions are required to support some functions:

  • Non-Java™ clients or drivers that are shipped with Db2 for Linux®, UNIX, and Windows at the Version 9.1 GA level
  • IBM Data Server Driver for JDBC and SQLJ Version 3.1.57
For more information about the hardware and software requirements for installing IBM Db2 Analytics Accelerator for z/OS, see the appropriate document for your accelerator.
Tip: You can used products like Db2 Administration Tool for z/OS to customize parameters and manage accelerator servers for IBM Db2 Analytics Accelerator for z/OS. With the Db2 Administration Tool for z/OS, you can start, stop, add, and delete accelerator servers. You can also use the Db2 Administration Tool for z/OS to populate, maintain, and control accelerated tables. For more information, see Using IBM Db2 Analytics Accelerator for z/OS (Db2 Administration Tool for z/OS).

Procedure

To enable Db2 to work with an accelerator, complete the following steps:

  1. Install and configure an accelerator server. For information about the installation and configuration requirements for IBM Db2 Analytics Accelerator for z/OS, see the IBM Db2 Analytics Accelerator for z/OS documentation.
    The product documentation for the accelerator also includes information about installing and setting up the stored procedures that enable the accelerator to work with Db2.
  2. Create a database, a table space, tables, and indexes that are used to support the acceleration of queries.
  3. Enable Db2 to send queries to the accelerator server by setting subsystem parameters, bind options, and special registers.
  4. Identify the accelerator servers that are available to Db2 by issuing the -START ACCEL command.

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.