Tables that support query acceleration

Start of change To interact with accelerator servers, Db2 requires several tables that record characteristics of accelerated servers and tables. End of change

The following table lists these tables, the table spaces and indexes for these tables, and the index fields for each index. The indexes are in ascending order, except where noted.

Table 1. Tables, table spaces, and indexes for tables that support acceleration of queries
Table	Description	Table space*	Indexes	Index fields
SYSACCEL.SYSACCELERATORS table	Records the characteristics of accelerator servers.	SYSTSACC	DSNACC01	ACCELERATORNAME
SYSACCEL.SYSACCELERATEDTABLES table	Records the characteristics of each table that is marked for acceleration.	SYSTSACT	DSNACT01	CREATOR, NAME, ACCELERATORNAME
SYSACCEL.SYSACCELERATEDPACKAGES table	Records the characteristics of Db2 packages that are bound with the QUERYACCELERATION and GETACCELARCHIVE bind options.	SYSTSACP	DSNACP01	LOCATION, COLLID, NAME, VERSION
SYSACCEL.SYSACCELERATEDPACKAGES table		SYSTSACP	DSNACP02	LOCATION, COLLID, NAME, CONTOKEN
SYSACCEL.SYSACCELERATEDTABLESAUTH table	Records the privileges that are held by user users over tables that are enabled for acceleration.	SYSTSATA	DSNATA01	TCREATOR, TNAME, ACCELERATORNAME, GRANTEE
* The table spaces listed in this table are universal table spaces (UTSs). Prior to these table spaces being migrated to type UTS, all of the catalog tables for accelerated queries used the SYSACCEL segmented table space. SYSACCEL is still supported; however, segmented table spaces have been deprecated. If you want to migrate from the single SYSACCEL segmented table space, see Migrating query acceleration tables to universal table spaces.