Db2 Data Gate query acceleration

You can configure Db2 Data Gate so that analytical Db2 for z/OS® queries are routed to a Db2 Warehouse target database on Cloud Pak for Data. This shifts the query workload and saves valuable z/OS processing resources. In most cases, this will also accelerate your queries.

The original encoding of the tables in the Db2 subsystem is retained when you enable the query acceleration feature for your Db2 Data Gate. So the query results do not differ from the results you get when you execute the query in Db2 for z/OS.

Just a few configuration steps are required to enable query acceleration, provided that a Db2 Warehouse target database exists.

Db2 Warehouse is optimized for analytical queries. The target database sends the query result sets back to Db2 for z/OS, in a manner that is completely transparent to the application that submitted the query.