The course is designed to instruct delegates how to develop and maintain existing applications in an efficient manner, up to and including DB2 11. It is intended for DBA's, analysts and programmers.
IT personnel and developers who have been exposed to using DB2 under z/OS and wish to understand more of the SQL performance and tuning aspects of the product.
Those attending the course should have used DB2 in the past, and preferably attended our DB2-SQL Application Programming course. A good working knowledge of DB2 SQL is a requirement.
The course is designed to instruct delegates how to develop and maintain existing applications in an efficient manner, up to and including DB2 11. The course will look at existing SQL to see if it is performing poorly, and to identify why this is the case, and how to reconstruct it so that it can perform better. The course contains practical exercises to consolidate the theory sessions.
Key Topics:The different DB2 versions
System Performance Overview
Single Table Access Paths
Multiple Table Access
Using EXPLAIN to Analyse Access Paths
Indexes and Performance
Reorganising Table Spaces and Indexes
On-line and Batch Performance Guidelines
Locking and Performance
Other Serialisation Mechanisms
Packages, Plans and Bind options
Using XML and XML in DB2 11
Last modified: 20-Dec-2017