The IBM Db2 Analytics Accelerator for z/OS V5.1.8 User's Guide describes how to use the IBM Db2 Analytics Accelerator for z/OS.
This guide describes how to use IBM Db2 Analytics Accelerator for z/OS version 5.1.8 (product number 5697-DA5) to accelerate SQL queries on Db2 for z/OS. It covers basic concepts such as accelerators, virtual accelerators, distribution keys, and zone maps, as well as conditions for query routing and incompatibilities with Db2.
The document details the IBM Db2 Analytics Accelerator Studio interface, including the Administration Explorer, Object List Editor, and accelerator views. It provides step-by-step tasks for connecting to databases, adding accelerators, loading tables, enabling query acceleration, managing incremental updates, and troubleshooting common errors.
| Version | 5.1.8 |
|---|---|
| Product number | 5697-DA5 |
The product number is 5697-DA5.
Conditions include incompatibilities between Db2 and the accelerator, correlated subqueries, COUNT_BIG function, data type mismatches, decimal arithmetic differences, encoding issues, exception handling, maximum row length, predicate evaluation, scalar functions, SQL issues, and time/date value handling.