CV963G: DB2 11 for z/OS Application Performance and Tuning

Module 1: Introduction to Application Performance and Tuning
Module 2: List Common Causes of Application Performance Problems
Module 3: Evalutate Different Approaches for Detecting the Problems
Module 4: Describe Possible Solutions
Module 5: Performance Analysis Tools
Module 6: Understand Components of Local Response Time (LRT)
Module 7: Identify Touch Random (TR), Touch Sequential (TS), and Fetch (F) Time Costs
Module 8: Utilize VQUBE3 to Estimate Local Response Time (LRT)
Module 9: Locate Necessary Time Values in an Accounting Trace Report
Module 10: Draw and Interpret a Bubble Chart
Module 11: Towards Better Indexes
Module 12: Understand DB2 Index Structure and Usage
Module 13: Evalute the Cost of Creating a New Index or Modifying an Existing Index
Module 14: Design the Best Possible Index for a Single Table Query
Module 15: Describe Prefetch Operations and Multi-Index Access
Module 16: Multiple Table Access
Module 17: Identify Various Join Methods and Join Types
Module 18: Predict Table Join Order
Module 19: Design the Best Indexes for Joining Tables
Module 20: Optimmize Correlated and Non-Correlated Subqueries
Module 21: Utilize UNION, INTERSECT, and EXCEPT Operations
Module 22: Towards Better Tables
Module 23: Evaluate Clustering Alternatives
Module 24: Understand Basic Rules of Nomalization
Module 25: Consider Conditions for Denormalization
Module 26: Define Materialized Query Tables
Module 27: Learning to Live with the Optimizer
Module 28: Describe the Limitations Related to Dangerous Predicates
Module 29: Identify Situations when the Optimizer Needs Help with Filter Factor Estimates
Module 30: Massive Batch
Module 31: Detect Performance Problems with Massive Batch Jobs Make Batch Jobs Run Faster
Module 32: Locking Issues
Module 33: Describe DB2 Serialization
Module 34: Understand Transaction Locking
Module 35: Avoid Locking Problems in Application Design
Module 36: Course Summary
Module 37: Summarize the Topics Covered in this Course