Plans for recovering the Db2 tables and indexes used to support Db2 query acceleration

The process of recovering the Db2® tables and indexes that are created specifically for use with IBM® Db2 Analytics Accelerator for z/OS® is different than the process of recovering Db2 catalog tables and indexes.

To support Db2 query acceleration with IBM Db2 Analytics Accelerator, certain Db2 tables and indexes are created and then used by both Db2 and IBM Db2 Analytics Accelerator. These Db2 tables and indexes have the qualifier SYSACCEL and are not created in the Db2 catalog table spaces. Instead, they are created independently in separate table spaces by running DDL that is provided by IBM. Because these Db2 SYSACCEL objects are not part of the Db2 catalog space, they must be backed up and recovered separately, as you do with your user data. For these SYSACCEL objects, follow the recommended backup and recovery steps and strategies that are provided for user data.

For more information about the SYSACCEL objects that are used to support Db2 query acceleration and how they are created, see Tables that support query acceleration and Creating database objects that support query acceleration.