Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Apptune for Db2 13.1.

Display of accelerator information in batch Explain reports


The skeleton JCL members for Explain (PSSSANLY) and Explain and Compare (PSSSBOTH) include a new optional Explain parameter, ACCEL=. ACCEL=Y (the default) displays accelerator eligibility rules in batch Explain reports.

The skeleton JCL member for Explain (PSSSANLY) includes an optional Explain parameter, QACCEL. The QACCEL parameter sets the CURRENT QUERY ACCELERATION special register to override the default value of the Db2 subsystem. This feature lets you test potential impact to the IBM Db2 Analytics Accelerator (IDAA) by performing a dynamic explain.



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*