Back To Schedule
Thursday, October 7 • 10:30am - 11:30am
Tracking & Corralling Query Resource Hogs

Log in to save this to your schedule, view media, leave feedback and see who's attending!

There's a good chance in the past that you've experienced the "fun" of a runaway query taking over your system with heavy CPU or IO usage and all the attention that follows. The reality is that fighting query fires like this is never fun - however, the good news is that Db2 provides a number of built-in tools and services that can help prevent this type of fire in the future. These tools can be used proactively to help you both track and limit the amount of resources consumed by SQL workloads.

Learning Objectives:
1) Learn how to use the ACS Plan Cache tooling to identify queries with high system resource usage_x000D_ 2) Learn how to use the new Query Supervisor and other Db2 services to monitor and control the system resources consumed by queries. _x000D_ 3) Learn about what causes queries to inefficiently use system resources

avatar for Kent Milligan

Kent Milligan

Senior Db2 for i Consultant, IBM
Kent Milligan is a Senior Db2 for i Consultant in IBM Technology Expert Labs. Kent has over 25 years of experience as a Db2 for IBM i consultant and developer working out of the IBM Rochester lab. Prior to re-joining the Db2 for i Expert Labs practice in 2020, Kent spent 5 years... Read More →

Thursday October 7, 2021 10:30am - 11:30am CDT
Breakout 4 Online