When a change in SQL performance is uncovered, database administrators need to find the cause and a potential solution before the SQL enters production. This process can be challenging and time-consuming.
CA Plan Analyzer® for DB2 for z/OS is a robust SQL-tuning and reporting tool that offers analysis capabilities that go beyond the plan and package levels. You can analyze any SQL, from a single statement to an entire application.
This course is designed to teach you how to use the product to improve DB2 performance by efficiently analyzing SQL and utilizing expert rules that offer SQL performance improvement recommendations. You will learn how to set up EXPLAIN processes, compare historical versions of access paths, and generate detailed access path analysis reports.
3 Days/Lecture & Lab