Removing reference tables

Run the Remove Reference Tables or Remove Reference function to delete reference tables (referencing accelerator-only tables) from an accelerator.

Before you begin

  • The owning (remote) Db2 subsystem and the referencing Db2 subsystem must share (be paired with) a common accelerator.
  • Database connection profiles must exist for both Db2 subsystems.
  • Your user ID needs the required authorizations to run the SYSPROC.ACCEL_REMOVE_REFERENCE_TABLES stored procedure on the referencing Db2 subsystem.

Procedure

  1. Connect to the referencing Db2 subsystem:
    For more information, see Connecting to a database server.
  2. Select the accelerator that is paired with the referencing Db2 subsystem:
    For more information, see Selecting an accelerator.
  3. Display the list of tables on that accelerator:
    IBM Db2 Analytics Accelerator Studio Scroll down to the Tables section.
    IBM Data Server Manager Click Manage.
    IBM Unified Experience for z/OS Click the Tables tab.
    IBM Db2 Analytics Accelerator Administration Services Move on to the next step.
    Draft comment: kuester@de.ibm.com
    Not sure if the description below is true.
  4. Start removing reference tables:
    IBM Db2 Analytics Accelerator Studio
    1. On the toolbar of the Tables section, select Federation > Remove Reference Tables.
    2. In the Db2 Subsystems window, you see a list of the Db2 subsystems that are paired with the same accelerator. Select one or more Db2 subsystems containing reference tables.
    3. Click Next.
    IBM Data Server Manager
    1. Select Federation > Remove Reference.
    2. In the selection box labeled Db2 Subsystems, you see a list of the referencing Db2 subsystems. Select one or more of these subsystems.
    IBM Unified Experience for z/OS
    • On the toolbar above the list of tables, click the Federation drop-down button and select Remove references.
    • In the Remove references window, you find a selection box labeled Db2 Subsystems. In this box, you see the list of referencing Db2 subsystems. Select one of these subsystems.
      Note: In IBM Unified Experience for z/OS, you can select only one referencing Db2 subsystem in the Revoke access window.
    IBM Db2 Analytics Accelerator Administration Services
    1. Start a /table/removeTableReferences request.
    2. In the request body, specify:
      • A connection name as the value of the connectionName": parameter. That is, you must be connected to the referencing Db2 subsystem. If you are not connected to that system yet, submit a /source/add or /source/edit request first.
      • The name of the shared accelerator as the value of the accelName": parameter. This must be the accelerator that is paired with the owning (remote) Db2 subsystem and the referencing Db2 subsystem.
  5. Select the reference tables that you want to remove:
    IBM Db2 Analytics Accelerator Studio In the Db2 Tables window, you see a list of the tables on the accelerator. Select the reference tables that you want to remove by clicking the appropriate check boxes. To select all tables that belong to a schema, select the check box in front of the schema name.

    Type the names of schemas or tables in the Name like filter field, either fully or partially, to display just schemas and tables bearing or starting with that name. The names of tables that have already been selected are grayed out.

    To the right of the Name like field, you also find controls (icons) to do the following:
    1. Select or deselect all tables
    2. Expand or collapse all schemas
    IBM Data Server Manager In the selection box labeled Db2 Tables, select the reference tables that you want to remove by clicking the appropriate check boxes. To select all tables in the selection box, select the check box in front of the NAME column header.

    You can use a filter to limit the number of tables in the selection box:

    1. Click Magnifying glass icon to display the search field.
    2. Type the names of tables in the search field, either fully or partially, to display just tables containing your search string. The names of tables that have already been selected are grayed out.
    IBM Unified Experience for z/OS In the selection box labeled Select Db2 tables, select the reference tables that you want to remove by selecting the appropriate check boxes. To select all tables in the selection box, select the check box in front of the Schema name column header.

    You can use a filter to limit the number of tables in the selection box:

    In the search field to the right of the Magnifying glass icon icon, type the names of tables, either fully or partially, to display just tables containing your search string. The names of tables that have already been selected are grayed out.
    IBM Db2 Analytics Accelerator Administration Services In the request body, specify the reference tables to remove 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 first key is the schema name, and the second key is a string called "tables":, which takes a lower-level array as its value. In this array, list the names of the tables that belong to the previously specified schema (the value of the first key in the object). Separate these table names by a comma. Also separate the JSON objects by a comma. Example:
    "selTables": [
    {
      "schemaName": "schema_name1",
      "tables": [
        "table_name1",
        "table_name2"
      ]
    },
    {
      "schemaName": "schema_name2",
      "tables": [
        "table_name1"
      ]
    }
  ],
  6. Confirm:
    IBM Db2 Analytics Accelerator Studio Click Finish.
    IBM Data Server Manager Click OK.
    IBM Unified Experience for z/OS Click Submit.
    IBM Db2 Analytics Accelerator Administration Services Click Execute.
  7. Click Finish.

Results

The selected reference tables (referencing accelerator-only tables) are removed from the accelerator. Corresponding entries are removed from the catalog of the referencing Db2 subsystem.