Use the Acceleration page of the Edit
Resource Limits Group Schedule window to activate query acceleration. The Acceleration page is available only for Db2 for z/OS
databases that support IDAA.
With this resource limit enabled, you are able to save your data to the accelerator server that
is associated with the database that you are currently using, and run accelerated queries. With this
resource limit disabled, you cannot run accelerated queries.
The Acceleration page includes the following settings:
- Enable acceleration
- This check box specifies whether the acceleration is enabled.
- Acceleration type
- This field specifies the conditions that determine whether the queries are run by the database
or by the accelerator. The following options are available:
-
| Option |
Description |
| NONE |
Specifies that no queries are sent to an accelerator server. |
| ENABLE |
Specifies that queries are accelerated only if the database determines that it
is advantageous to do so. If an accelerator failure occurs while a query is running or if the
accelerator returns an error, database returns a negative SQLCODE to the application. |
| ENABLE WITH FAILBACK |
Specifies that queries are accelerated only if the database determines that it
is advantageous to do so. If the accelerator returns an error during the PREPARE or first OPEN
command for the query, the database executes the query without the accelerator. If the accelerator
returns an error during a FETCH or a subsequent OPEN command, the database returns the error to the
user and does not execute the query. |
| ELIGIBLE |
Specifies that queries are accelerated if they are eligible for acceleration.
Queries that are not eligible for acceleration are executed by the database. If an accelerator
failure occurs while a query is running or if the accelerator returns an error, the database returns
a negative SQLCODE to the application. |
| ALL |
Specifies that queries are accelerated if they are eligible for acceleration.
Queries that are not eligible for acceleration are not executed by the database, and an SQL error is
returned. If an accelerator failure occurs while a query is running or if the accelerator returns an
error, the database returns a negative SQLCODE to the application. |
- Acceleration options can be overridden
- This check box specifies whether acceleration options can be overridden.