CA Plan Analyzer Version 19 for DB2 for z/OS: Core Functions 200
CA Plan Analyzer Version 19 for DB2 for z/OS: Core Functions 200
View Full Course Outline
Request A Public Course
In Your Area
Request A Quote For A
Private Class
Delivery Options & Status:
Let us know if you would like a date for this course added to our schedule
Summary
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.
Prerequisites
Duration
3 Days/Lecture & Lab
Audience
Topics
Related Scheduled Courses
