SYSACCEL.SYSACCELERATEDTABLES table

The SYSACCEL.SYSACCELERATEDTABLES table contains rows that describe the characteristics of each table that is marked for acceleration.

Rows in this table can be inserted, updated, and deleted.

Column name Data type Description Use
NAME
VARCHAR(128)
NOT NULL
 The name of the table. G
CREATOR
VARCHAR(128)
NOT NULL
 The schema of the table. G
ACCELERATORNAME
VARCHAR(128)
NOT NULL
 A unique name for the accelerator server. This is the name by which the accelerator server is known to the local Db2 accelerated query tables. G
REMOTENAME
VARCHAR(128)
NOT NULL
 The name of the base alias object. G
REMOTECREATOR
VARCHAR(128)
NOT NULL
 The owner of the base alias object. G
ENABLE
CHAR(1)
NOT NULL
 Indicates whether the remote table is enabled or disabled for query acceleration:
Y
Enabled
N
Disabled
T
Transition state. Queries are not sent to an accelerator server.
 G
CREATEDBY
VARCHAR(128)
NOT NULL
 The primary authorization ID of the user who created the table. G
CREATEDTS
TIMESTAMP
NOT NULL
WITH DEFAULT
 The time when the CREATE statement was executed for the table. G
ALTEREDTS
TIMESTAMP
NOT NULL
WITH DEFAULT
 The time when the table was last altered. G
REFRESH_TIME
TIMESTAMP
NOT NULL
WITH DEFAULT
 The timestamp when the data was last refreshed. If the data was not refreshed, this column contains the default timestamp ('0001-01-01.00.00.00.000000'). G
SUPPORTLEVEL
SMALLINT
NOT NULL
 Internal use only. I
ARCHIVE
CHAR(1)
 The archive status of the table in the accelerator database:
A
The table is archived in the accelerator server that is specified by the ACCELERATORNAME value. The accelerator server contains active and archived data.
B
The table is partially archived in the accelerator server that is specified by the ACCELERATORNAME value. The accelerator server can answer queries that contain active data.
C
The table is archived in other accelerator servers. The accelerator server that is specified by the ACCELERATORNAME value contains only active data.
X
The table was restored on another accelerator server. The accelerator server that is specified by the ACCELERATORNAME value cannot answer queries.
blank
The table is not archived in an accelerator server.
 G
REMOTELOCATION VARCHAR(128) NOT NULL WITH DEFAULT The location of the owner table of the referenced accelerator-only table. For tables that are not referenced accelerator-only tables, this column is blank. G
FEATURE INTEGER NOT NULL Indicates additional features of the table:
0
The table does not have any of the additional features that are indicated by the other values. 0 is the default value.
1
The table is a high availability accelerator-only table.
 G