CA Plan Analyzer Version 19 for DB2 for z/OS: Core Functions 200

Catalog Home IBM Mainframe & Midrange Authorized Broadcom

There are no scheduled dates for this course.

  Available by Request

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




< >

Recently Viewed Courses:

Copyright © 2019 ProTech. All Rights Reserved.

Sign In Create Account

Navigation

Social Media