ADMIN ACCELERATOR ADD statement

The ADMIN ACCELERATOR ADD statement defines a Db2 table on an accelerator.

Syntax

Read syntax diagramSkip visual syntax diagramADMINACCELERATORADDTABLESON,accelerator-nameINCLUDE,table-name

Option descriptions

accelerator-name
The name of the accelerator on which you want to define the specified table or tables.

You can specify more than one accelerator. Separate each name with a comma.

INCLUDE table-name
Specifies the table or tables that are to be defined on the accelerator. If multiple accelerators are specified in the statement, the table or tables are added to each accelerator.
table-name
The qualified name of the table (schema.name).

If you specify more than one table name, separate each name by a comma.

If you use wildcard characters, you can specify only one table name, and you must enclose the name or schema with a wildcard character in quotation marks. You can use the following wildcard characters:

_
Indicates a single character
%
Indicates a varying length string
*
Indicates a varying length string

Example table name specifications:

ADMF001.TBT1,ADMF002.TBT2
"ADMF%"."TBT_"
SYSADM."*"