DB2 11 for z/OS Application Performance and Tuning

This Application Performance and Tuning course is designed to teach the students how to prevent application performance problems and to improve the performance of existing applications. Students will learn about indexes, table design, locking, and other issues relevant to application performance. This course includes paper exercises and machine exercises designed to reinforce the lecture content.

After completing this course, students will be able to:

• Design better indexes
• Determine how to live with the optimizer (avoid pitfalls, help when necessary)
• Avoid locking problems
• Use accounting trace information to find significant performance problems in an operational application

1. Introduction to Application Performance and Tuning
2. List common causes of application performance problems
3. Evalutate different approaches for detecting the problems
4. Describe possible solutions
5. Performance Analysis Tools
6. Understand components of local response time (LRT)
7. Identify touch random (TR), touch sequential (TS), and fetch (F) time costs
8. Utilize VQUBE3 to estimate local response time (LRT)
9. Locate necessary time values in an accounting trace report
10. Draw and interpret a bubble chart
11. Towards Better Indexes
12. Understand DB2 index structure and usage
13. Evalute the cost of creating a new index or modifying an existing index
14. Design the best possible index for a single table query
15. Describe prefetch operations and multi-index access
16. Multiple Table Access
17. Identify various join methods and join types
18. Predict table join order
19. Design the best indexes for joining tables
20. Optimmize correlated and non-correlated subqueries
21. Utilize UNION, INTERSECT, and EXCEPT operations
22. Towards Better Tables
23. Evaluate clustering alternatives
24. Understand basic rules of nomalization
25. Consider conditions for denormalization
26. Define materialized query tables
27. Learning to Live with the Optimizer
28. Describe the limitations related to dangerous predicates
29. Identify situations when the optimizer needs help with filter factor estimates
30. Massive Batch
31. Detect performance problems with massive batch jobs
32. Make batch jobs run faster
33. Locking Issues
34. Describe DB2 serialization
35. Understand transaction locking
36. Avoid locking problems in application design
37. Course Summary
38. Summarize the topics covered in this course