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

Start of changeFor 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:End of change

  • 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

Start of changeFor more information about the hardware and software requirements for installing IBM IBM DB2 Analytics Accelerator for z/OS, see Prerequisites and Maintenance forIBM DB2 Analytics Accelerator for z/OS Version 4.1.End of change

Procedure

To enable DB2 to work with an accelerator:

  1. Install and configure an accelerator server. For information about the installation and configuration requirements for IBM 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, special registers, and bind options.
    • The ACCEL subsystem parameter controls whether a DB2 subsystem can use accelerator servers.
    • The QUERY_ACCELERATION subsystem parameter and the CURRENT QUERY ACCELERATION special register control whether DB2 considers dynamic queries for acceleration and how DB2 behaves when acceleration fails.
    • Start of changeThe QUERY_ACCEL_OPTIONS subsystem parameter specifies other types of SQL queries that are eligible for acceleration.End of change
    • Start of changeThe QUERYACCELERATION bind option controls whether a static SQL query is bound for acceleration, and if so, with what behavior.End of change
    • Start of changeThe GET_ACCEL_ARCHIVE subsystem parameter and the CURRENT GET_ACCEL_ARCHIVE special register control whether a dynamic SQL query that references a table that is archived on an accelerator server uses the archived data. End of change
    • Start of changeThe GETACCELARCHIVE bind option specifies whether a static SQL query that is bound for acceleration retrieves archived data on the accelerator, instead of active data.End of change

    The following table shows the settings that enable the sending of queries to accelerator servers.

    Subsystem parameter, special register, or bind option Valid settings
    ACCEL COMMAND or AUTO
    QUERY_ACCELERATION (if CURRENT QUERY ACCELERATION is not set) Start of changeENABLE, ENABLE_WITH_FAILBACK, ELIGIBLE, or ALLEnd of change
    CURRENT QUERY ACCELERATION Start of changeENABLE, ENABLE WITH FAILBACK, ELIGIBLE, or ALLEnd of change
    Start of changeQUERYACCELERATIONEnd of change Start of changeNONE, ENABLE, Start of changeENABLEWITHFAILBACKEnd of change, ELIGIBLE, or ALLEnd of change
    Start of changeQUERY_ACCEL_OPTIONSEnd of change Start of changeNONE, 1, 2, 3, or 4End of change
    Start of changeGET_ACCEL_ARCHIVE (if CURRENT GET_ACCEL_ARCHIVE is not set)End of change Start of changeNO or YESEnd of change
    Start of changeCURRENT GET_ACCEL_ARCHIVEEnd of change Start of changeNO or YESEnd of change
    Start of changeGETACCELARCHIVEEnd of change Start of changeNO or YESEnd of change
  4. 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.

    Start of changeAlso, you can 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 subsystem.End of change

Start of change

What to do next

Tip: The DB2 Administration Tool for z/OS is one product that you can use 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).
End of change