CMDBID: 75985 | Course Code: CV964G | Duration: 3 Days
Overview>
This course is designed to teach the students how to prevent SQL performance problems and how to improve the performance of existing SQL.
Audience>
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.
Skills Gained>
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 more
Prerequisites>
Familiarity with SQL
Familiarity with Db2 12 for z/OS
Familiarity with Db2 12 for z/OS application programming
Outline>
Introduction to SQL performance and tuning
Performance analysis tools
Index basics
Access paths
More on indexes
Tuning methodology and index cost
Index design
Advanced access paths
Multiple table access
Subqueries
Set operations (optional)
Table design (optional)
Working with the optimizer
Locking issues
More locking issues (optional)
Massive batch (optional)
Our Clients
Our clients have included prestigious national organisations such as Oxford University Press, multi-national private corporations such as JP Morgan and HSBC, as well
as public sector institutions such as the Department of Defence and the Department of Health.