Experienced database engineers know that problem queries comes in all shapes and sizes. Some are runaway queries that never seen to end. Others are small changes that become magnified as they run thousands of times. Keeping an eye on all the database activity on your system is not humanly possible. For that reason, IBM introduced the Query Supervisor for Db2 for IBM i. Query Supervisor provides realtime monitoring of queries so that you can detect, understand and address problem queries when they happen. This session will give you a working introduction to Query Supervisor and show you how it fits in with other database tools so that you can take control of problem queries on your system.
Learning Objectives: 1. Understand how Query Supervisor works_x000D_ 2. Configure Query Supervisor for basic operation_x000D_ 3. Apply insights gained from Query Supervisor
