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
Start of changeREMOTELOCATIONEnd of change Start of changeVARCHAR(128) NOT NULL WITH DEFAULTEnd of change Start of changeThe location of the owner table of the referenced accelerator-only table. For tables that are not referenced accelerator-only tables, this column is blank. End of change Start of changeGEnd of change
Start of changeFL 509 FEATUREEnd of change Start of changeINTEGER NOT NULLEnd of change Start of changeIndicates 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.
End of change		 Start of changeGEnd of change