DB2 UDB/390 Performance and Tuning
Duration: 3 Days
The Course is designed to instruct those delegates how to develop and maintain existing applications in an efficient manner, up to and including DB2 10.
The course will look at existing SQL to see if it is performing poorly, and to identify why it could perform poorly, and how to reconstruct so that it could perform better.
The course will contain practical exercises to consolidate the theory sessions.
Topics Covered In This Course
Introduction to DB2 versions
System architecture & started tasks
Stage 1/ Stage 2 predicates
Catalog(Including changes in 10)
Indexes and performance
Explain & Filter factor
Third party tools
Online Performance Guidelines
Batch performance guidelines
Locking & Performance
Consolidation of Version 8/9/10 differences
CTE's and Recursive SQL
Previous DB2 knowledge is required.
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]