IBM Db2 Analytics Accelerator for z/OS V5.1.8 User's Guide

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.


IBM Db2 Analytics Accelerator for z/OS V5.1.8 User's Guide - cover page
Brand
IBM
Category
Application program
Document type
User Manual
Language
English
Pages
249
File format
PDF
File size
3.2 MB
Published
30 November, 2023
Updated
30 November, 2023
MD5 checksum
0B09F1C0805D081CA1B0DB4E9C2B2E1A

About this manual

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.

What's inside

  • Introduction
  • Basic concepts
  • Conditions for query routing to an accelerator
  • Interface elements of IBM Db2 Analytics Accelerator Studio
  • Tasks
  • Status information and incremental updates
  • Troubleshooting
  • Appendices

Specifications

Version5.1.8
Product number5697-DA5

Frequently asked questions

What is the product number for IBM Db2 Analytics Accelerator for z/OS V5.1.8?

The product number is 5697-DA5.

What conditions can prevent query routing to an accelerator?

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.

Download PDF (3.2 MB)

More IBM Manuals


View all IBM manuals →