COMMON POWERUp 2021

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