Db2 12 for z/OS SQL Performance and Tuning - CV964G - MEA

Catalog Home IBM Mainframe, Midrange & ISV Products Authorized IBM Mainframe
3.238.99.243
Your Training Location:  

Db2 12 for z/OS SQL Performance and Tuning - CV964G - MEA

Let us know if you would like a date for this course added to our schedule

This course is designed to teach the students how to prevent SQL performance problems and how to improve the performance of existing SQL.

Familiarity with SQL Familiarity with Db2 12 for z/OS Familiarity with Db2 12 for z/OS application programming

24 Hours

This course is for Db2 12 for z/OS application developers, Db2 12 for z/OS DBAs, and anyone else with a responsibility for SQL performance and tuning in a Db2 12 for z/OS environment.

After completing this course, students will be able to: Understand and design better indexes Determine how to work with the optimizer (avoid pitfalls, provide guidence) Optimize multi-table access Work with subqueries Avoid locking problems Use accounting traces and other tools to locate performance problems in existing SQL and moreCloud & Data Platform Data and AIInformation Architecture MarketDatabases and Tools for Z Portfolio




< >

Copyright © 2021 ProTech Professional Technical Services, Inc. All Rights Reserved.

Sign In Create Account

Navigation

Social Media