Displaying information about IBM Db2 Analytics Accelerator eligible SQL

To evaluate static SQL statements to determine if they are accelerator-eligible, you must verify that you have the correct ZPARM settings. This includes setting the new ZPARM, ACCELMODEL to YES. Refer to the IBM® Db2 Analytics Accelerator for z/OS® documentation and the IBM Db2 Analytics Accelerator Modeling APAR PM90886 for additional information.

You must issue a BIND or REBIND PACKAGE for the Db2 packages. You can use the option APREUSE(ERROR) with the REBIND PACKAGE command to ensure that the current access plan remains unchanged. ACCELMODEL=YES is required during BIND/REBIND only, not at static SQL statement execution time. For dynamically executed statements in packages, no BIND or REBIND is required.