Creating database objects that support query acceleration

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

Before you begin

1. Apply or verify that you have applied the PTF for APAR PI96858 (UI56078) and for APAR PI96859 (UI56897). For a data sharing group, you must apply these PTFs on all members of the group.
2. After applying the PTFs, restart the Db2 subsystem or each Db2 data sharing member in a data sharing group.

To create database objects for use by an accelerator:

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

   • The SYSACCEL.SYSACCELERATORS and SYSACCEL.SYSACCELERATEDTABLES tables are created. The accelerator will populate these tables with a server definition and the associated IP address.
   • The SYSACCEL.SYSACCELERATEDPACKAGES table and its indexes are created. This table and its indexes will be populated by Db2 during a bind operation that specifies the QUERYACCELERATION bind option. They are not used by the accelerator.
   • The SYSACCEL.SYSACCELERATEDTABLESAUTH table and its index are created for federation support. This table and its index will be populated by the IBM® Db2 Analytics Accelerator for z/OS® SYSPROC.ACCEL_GRANT_TABLES_REFERENCE and SYSPROC.ACCEL_REVOKE_TABLES_REFERENCE stored procedures.
2. Restrict access to the SYSACCEL.SYSACCELERATORS, SYSACCEL.SYSACCELERATEDTABLES, and SYSACCEL.SYSACCELERATEDPACKAGES tables that were 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.