Db2 Analytics Accelerator – Driving for Optimum Performance

Date: 
Thursday, 27 svibanj, 2021 - 09:15 - 10:15
Program: 
z/OS Track
Speaker: 
Eberhard Hechler

In this presentation, we present techniques to improve the Accelerator performance, incl. defining and maintaining distribution and organizing keys (synopsis tables), and to define a set of rules for the Db2 for z/OS optimizer via heuristic routing criteria by setting the maximum total table cardinality, the maximum estimated total cost, and the maximum number of rows for the result set of a query. We furthermore explore profile table setting in Db2 for z/OS to control access to the Accelerator by specifying the CURRENT QUERY ACCELERATION register value for remote applications that meet the criteria that are defined in the corresponding Db2 for z/OS profile tables. In addition, we review efficient zParm settings in coexistence environments with the Accelerator v5 and v7, and review enhancements with Accelerator-only Tables (AOTs) in HA/DR environments.

 

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2023

VODICE -  12th - 15th June 2023