Db2 AI for z/OS SQL Optimization Deep Dive

Tom Beavin, IBM

Download PDF

Db2 AI for z/OS (Db2ZAI) works with Db2 to improve operational efficiency. It provides multiple use cases, reducing the cost of SQL execution, providing recommendations to tune Db2, and protecting mainframe resource from remote connections. 

This session focuses on how Db2ZAI reduces the cost of SQL execution. We’ll dive into the details of how Db2ZAI learns from queries executing on the system, and then uses that knowledge to make those queries run faster.


Tom Beavin is a developer in the Db2 for z/OS Query Optimizer team. He joined the team in 1994. Before that we was a member of the Db2 for z/OS Utilities team, working on the LOAD and REORG utilities. In recent year’s, Tom’s focus has been on designing the Db2ZAI SQL optimization feature. Tom has numerous patents and publications, mostly related to query optimization technology.