IBM Db2 SQL PA V5.2 enhancements overview and demo

Thu, Dec 19, 2024 1:00 PM EST

Summary

IBM Db2 SQL Performance Analyzer for z/OS (also referred to as SQL Performance Analyzer or SQL PA) is a query analysis tool you can use to optimize the performance of your SQL statements for Db2.  

In this webinar, we will cover what’s new SQL PA V5.2.  We will look at the new layouts of the Query Limit and Query Block reports, review the new line commands, describe the integration of SQL PA with the IBM Db2 Admin Tool and look at these new screens. From Db2 Query Monitor, we’ll jump into SQL PA and perform a what-if analysis against it.  From SQL PA, we’ll jump into the Admin tool to create an index and rebind the package, returning all the way back to Db2 Query Monitor.  

View a demo of using the Db2 Query Monitor tool to find a poor performing SQL statement. Take 45 minutes out of your busy schedule to see what’s new with SQL PA and how it can help you tune your SQL.

Key speakers



Tom Glasser, Sr. Solutions Advisor - zSystems Center of Excellence, Rocket Software