To mark a query so that it is considered for acceleration and then routed to Data Gate, you can set a special register at the
beginning of your SQL query code. You can also set a ZPARM to the effect that queries of a certain
type are always routed to Data Gate.
Procedure
- To set a ZPARM for the automatic routing of certain queries to Data Gate:
On the DSNTIP82 installation panel
of your
Db2 for z/OS system, set, for
example:
QUERY_ACCELERATION 5
This setting will always route an incoming
query to Data Gate, without checking its
eligibility. For a description of all values, see the entry QUERY_ACCELERATION in
Setting ZPARMs for IBM Db2 Analytics Accelerator in Db2 for z/OS.
- To use a special register, add the following line at the beginning of your SQL
code:
SET CURRENT QUERY ACCELERATION ALL
This setting will always route an incoming query to Data Gate, without checking its eligibility.
You can set the special register to other values. For a description of all values, see the entry
QUERY_ACCELERATION in Setting ZPARMs for IBM Db2 Analytics Accelerator in Db2 for z/OS. The values that you can set the
special register to are the values in parentheses after the numbers, for example
ENABLE after the number 2.