Disabling query acceleration for tables

You can disable accelerated queries against selected tables without entirely disabling the associated accelerator.

Before you begin

  • You need a connection to a database that has an accelerator attached to it.
  • You (your user ID) must be connected to the database and have the rights to control the accelerator.
  • The tables that you want to disable must have been added to the accelerator.

About this task

The task of disabling tables is carried out by the SYSPROC.ACCEL_SET_TABLES_ACCELERATION stored procedure on your data server. For information about the privileges that are required to run this procedure and further details, follow the appropriate Related reference link at the end of this topic.

Procedure

  1. Select the accelerator. For more information, see Selecting an accelerator.
  2. Select the tables you want to disable. In IBM Db2 Analytics Accelerator Studio, you might have to scroll down to the list of tables.
  3. Disable acceleration for the selected tables:
    IBM Db2 Analytics Accelerator Studio Select Acceleration > Disable from the toolbar.
    IBM Data Server Manager Select Acceleration > Disable Acceleration from the toolbar.
    IBM Unified Experience for z/OS
    1. On the accelerator details page, click the Tables tab.
    2. Scroll down to the list of tables.
    3. Select the tables to enable:
      1. To enable acceleration for all schemas (that is, all tables in all schemas), select the check box in front of the column label Schema name.
      2. To enable acceleration for all tables belonging to a schema, select the check box in front of a schema name.
      3. To enable acceleration for individual tables, click the twistie in front of a schema name to expand the list of tables belonging to that schema. Then select the check box in front of one or more table names.
    4. On the toolbar above the list of tables, select Take action > Disable acceleration.
    IBM Db2 Analytics Accelerator Administration Services
    1. Start a ​/table​/enableDisableAcceleration request.
    2. In the request body:
      1. Specify the connection name ("connectionName":).
      2. Specify the accelerator name ("accelName":).
      3. Specify the tables in an array that serves as the value of the "selTables" parameter. The first-level elements in this array must be JSON objects (key-value pairs), in which the key is the schema name, followed by the value, which is an array that contains the names of the tables belonging to that schema. Separate these table names by a comma. Also separate the JSON objects by a comma. Example:
        "selTables": [
    {
      "SYSABC": [
        "TABLE01",
        "TABLE02"
      ]
    },
    {
      "SYSDEF": [
        "TABLE01"
      ]
    }
  ],
      4. Set the "enableAcceleration": parameter to the value false.
    3. Click Execute.

Results

This disables query acceleration for the selected tables only. Other tables that are associated with the same accelerator are not affected.