Conditions for query routing to an accelerator

Queries can be routed to an accelerator only if certain conditions are met. There are also adverse conditions that prohibit query acceleration. Both types of conditions are discussed in this section.

A query can be routed to an accelerator if the following general conditions are met:
  1. The accelerator is in an operational mode and has been started.
  2. Db2 for z/OS® has been configured so that the query will be routed to a connected accelerator provided that this query meets all other conditions.
  3. The accelerator supports the SQL expressions that are used in the query.
  4. All data that is referenced by the query, such as the contents of tables and views, is available on one and the same accelerator. To satisfy this condition, the accelerator must have been loaded with the data in question.