CV964G - DB2 12 for z/OS SQL Performance and Tuning - 3 Days

Date	Location	Duration	Cost	Enrol	Enquiry
2025-10-21	Virtual	3 Days	£1500.00 (plus VAT)		Enquire

Course Description

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.

Pre-requisites

Before attending this course you should have:

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

Objectives

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

Customisation

For on-site courses (i.e. at your premises), we are more than happy to tailor the course agenda to suit your exact requirements. In many cases, we are able to build your in-house standards and naming conventions into the delivered course.

Course Details

Course Content: 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