SET CURRENT QUERY ACCELERATION

The SET CURRENT QUERY ACCELERATION option directs BMC AMI Unload to use IBM Db2 Analytics Accelerator for z/OS.

Related topics

Option descriptions—UNLOAD syntax

DIRECT

SELECT-statement-options


image-2023-7-24_13-21-45.png

Important

(BMC.DB2.SPE2310)

  • This option is valid only when DIRECT NO is in effect.
  • We recommend that you specify DIRECT NO for any IDAA related table unload.

ALL

Offloads eligible query processing to the accelerator server for all SELECT statements in the UNLOAD step.

To offload query processing, your system, object, and query must meet all requirements as described in the IBM documentation for the accelerator server.

NONE

Query acceleration is not performed.

This option overrides the value that is defined in the QUERY_ACCELERATION DSNZPARM on your system.

Example
UNLOAD DIRECT NO
SET CURRENT QUERY ACCELERATION ALL
SELECT * FROM <creator>.<tableName> FOR READ ONLY;

 

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