Setting Acceleration preferences

Use the Acceleration page of the Preferences window to specify the query acceleration settings.

1. From the main menu, select View > Preferences.
   The Preferences window opens.
2. On the left side of the window, click Acceleration.
3. To be able to override the acceleration options that were specified for your resource limits group by the administrator, select the Override acceleration options if possible check box on the right side of the screen.
   Note: The settings from this page are applied only if the following conditions are met:

   • The Acceleration options can be overriden check box is selected in the resource limits for the current data source .
   • The object that you are running does not have specified resource limits or if the Acceleration options can be overriden check box is selected in the object resource limits.
4. Click the Enable acceleration check box and specify the acceleration type:

   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.