Creating database objects that support query acceleration

If you use an accelerator, you must create a database, a table space, tables, and indexes for the accelerator to use.

To create database objects for use by an accelerator:

1. Configure and run sample job DSNTIJAS in the SDSNSAMP library to create the objects that are required for an accelerator.

   After the SYSACCEL.SYSACCELERATORS and SYSACCEL.SYSACCELERATEDTABLES tables are created, they are populated by the accelerator with a server definition and the associated IP address.

   After the SYSACCEL.SYSACCELERATEDPACKAGES table and its indexes are created, they are populated by DB2® during a bind operation that specifies the QUERYACCELERATION bind option. They are not used by the accelerator.

2. Restrict access to the SYSACCEL.SYSACCELERATORS, SYSACCEL.SYSACCELERATEDTABLES, and SYSACCEL.SYSACCELERATEDPACKAGES tables that are created by job DSNTIJAS. The SYSACCEL.SYSACCELERATORS and SYSACCEL.SYSACCELERATEDTABLES tables are used by DB2 to control the acceleration behavior of the accelerator servers that are defined for the DB2 subsystem. The SYSACCELERATEDPACKAGES table is used by DB2 to control the acceleration behavior of static SQL queries in a DB2 package.