You must add a
table to the accelerator before you can use the accelerator for query enhancement or storage saver
purposes. An accelerator-shadow table exists both in Db2 and in the accelerator.
Before you begin
You cannot add a Db2 table to an
accelerator if any of the following conditions are true:
The table is not a base table; that is, the value in the TYPE column of the SYSIBM.SYSTABLES
table is not T.
The table uses a row-level security label; that is, the value in the SECURITY_LABEL column of
the SYSIBM.SYSTABLES table is R.
The row-level access control is defined for the table; that is, the value in the CONTROL column
of the SYSIBM.SYSTABLES table is R or B.
Additional conditions can
prevent tables from being added to an accelerator. For a complete list of restrictions, see SYSPROC.ACCEL_ADD_TABLES
Procedure
To add an accelerator-shadow table:
Navigate to the Add Accelerated Tables
(ADBPZATA) panel by taking one of the following paths:
To add a table from the accelerated table panels, complete the following steps:
On the DB2 Administration Menu
(ADB2) panel, specify option Z, and press Enter.
On the System Administration
(ADB2Z) panel, specify option AT , and press Enter.
On the DB2 Display/Manage Accelerated Tables
(ADBPZMAT) panel, specify option 1, and press Enter.
On the Display Accelerated Tables
(ADBPZAT) panel, specify ADD, and press Enter.
To add a table from the system catalog, complete the following steps:
On the DB2 Administration Menu
(ADB2) panel, specify option 1, and press Enter.
On the System Catalog
(ADB21) panel, specify T, and press Enter.
On the Tables, Views, and
Aliases (ADB21T) panel, specify ADDA next to the table that you want
to add, and press Enter.
On the Add Accelerated Tables
(ADBPZATA) panel, specify the appropriate information to define a Db2 table on an accelerator.
Figure 1. Add Accelerated Tables panel (ADBPZATA)
ADBPZATA ----------------- DB2X Add Accelerated Tables ----------------- 17:08
Command ===>
Enter details of table(s) to be defined on an accelerator:
Accelerator name . . (? to look up)
Table schema . . . . > (Default is ADMF001)
Table name . . . . . > (? to look up, * for all tables)
LOAD . . . . . . . . (Y - Yes, to load after ADD.
Load will be skipped if
accelerator is virtual)
ENABLE . . . . . . . (Y - Yes, to enable after ADD)
Press ENTER to add accelerated tables, or PF3 to cancel add.
F1=HELP F2=SPLIT F3=END F4=RETURN F5=RFIND F6=RCHANGE
F7=UP F8=DOWN F9=SWAP F10=LEFT F11=RIGHT F12=RETRIEVE
Complete the following fields:
Accelerator Name
The name of the accelerator on which the table is to be defined.
Table schema
The schema of the table to be defined.
Table name
The name of the table to be defined.
LOAD
Specify whether to load the table in the accelerator by using the LOAD stored procedure. The
table is not loaded if the accelerator is a virtual accelerator.
ENABLE
Specify whether to enable the table for acceleration. If the accelerator is real, the
SYSPROC.ACCEL_SET_TABLES_ACCELERATION stored procedure is called. If the accelerator is virtual, the
ENABLE column in SYSACCELERATEDTABLES is set to Y. If both LOAD and ENABLE are requested, LOAD is
performed first, followed by ENABLE.
Information about selected Db2 table is
inserted into the SYSACCEL.SYSACCELERATEDTABLES table.