IBM Db2 Analytics Accelerator for z/OS, Version 7.5.14

Advanced concepts

The advanced concepts are related to more sophisticated features of IBM Db2 Analytics Accelerator for z/OS.

Accelerator-archive tables
These are table partitions or entire tables whose data was moved to an archive on an accelerator by the High-Performance Storage Saver. Moving table data saves storage space on IBM Z®.
Accelerator-only tables and in-database transformation
Accelerator-only tables are tables that do not originate from Db2 base tables. Their data exists only on an accelerator. Data in accelerator-only tables can only be modified by data-manipulation (DML) statements (INSERT, UPDATE, and DELETE). With accelerator-only tables, you can do in-database transformation (IDT) in a more efficient way.
Workload balancing
Workload balancing can be described as follows: If more than one accelerator is connected to a Db2 subsystem, and the tables that are referenced in a query are defined on more than one of these accelerators, IBM Db2 Analytics Accelerator for z/OS automatically picks the accelerator with the lowest utilization for processing.
Asynchronous result fetching
Asynchronous fetching is a method to improve the fetch performance for queries that return large result sets. Especially for queries that are executed from local applications, such as DSNTIAUL, the fetch performance of large result sets can be drastically reduced by asynchronous fetching.