SET CURRENT QUERY ACCELERATION

SET CURRENT QUERY ACCELERATION option directs UNLOAD PLUS to use IBM Db2 Analytics Accelerator for z/OS.

Related topic

Basic-processing-options

(BMC.DB2.SPE2310)

Set query acceleration_SPE2310-2311.png

Important

This option is valid only when DIRECT NO is in effect.

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;

 

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