• Sep 14, 2016 from 8:30am to 12:30pm
  • Location: Omaha, NE
  • Latest Activity: Sep 2, 2021

Jase Alpers from IBM will be our featured speaker.  He'll present the following topics.

Runstats Challenges for Optimal Query Performance -
Accurate and relevant statistics are the basis of reliable good query performance.  How do I identify the important statistics?  How do I manage statistics collection?  What new features does DB2 for z/OS provide to help with runstats challenges?  In this session, we'll answer these questions and more as we discuss various runstats challenges and misconceptions.

Tuning Queries Like a DB2 Developer -
Tuning DB2 applications for optimal DB2 performance does not need to be a complex exercise. Most SQL performance problems can be easily solved by identifying and resolving differences between optimizer's expectations and reality. In this session, we'll walk through the process used at the lab to identify and resolve access path performance problems. We'll discuss the primary reasons optimizer "gets it wrong" along with options to correct the poor performance.

Jase Alpers is part of the DB2 for z/OS optimizer development team out of the IBM Silicon Valley Lab. He is a frequent speaker on DB2 query optimization having presented at IOD as well as many DB2 user groups over the years. Jase has more than 15 years experience with DB2 in application development, consulting, DB2 support, and DB2 optimizer development. Prior to joining the DB2 optimizer team, Jase led the SQL performance and Relational Data Systems DB2 support teams. Jase's work is focused on driving improvements to DB2 query optimization as well as deep dive analysis and resolution of SQL performance problems. In the last several releases of DB2, Jase has designed and delivered enhancements to automate identification and management of which statistics to collect for optimal query performance.

Schedule for the meeting:
8:30-9:00      User Group Announcements - Doug Partch
            IBM Announcements - Clif Burnes
9:00-10:30    Runstats Challenges for Optimal Performance - Jase Alpers
10:30-10:45    Break
10:45-12:15    Tuning Queries Like a DB2 Developer - Jase Alpers
12:15-12:30    Wrap-Up, End of Meeting

Votes: 0
E-mail me when people leave their comments –

You need to be a member of WorldofDb2 to add comments!

Join WorldofDb2