Providing Technology Training and Mentoring For Modern Technology Adoption
Review overall DB2 SQL Performance Considerations. Discuss the issues in Performance “problems”. Discuss the "behavior" or “mis-behavior” of the DB2 Optimizer. Explore DB2 SQL performance issues as revealed via the EXPLAIN Plan / VISUAL EXPLAIN feature.
The major columns PLAN_TABLE and DSN_STATEMNT_TABLE are analyzed in detail. The results of the DB2 EXPLAIN Plan / VISUAL EXPLAIN process are reviewed to obtain insights into the Way(s) that the Optimizer chooses the access path to access DB2 data.
Extensive workshops allow the students to test the performance “goodness” of several SQL statements. The Performance Guidelines are applied to COBOL Application programs. Discuss how & when the Optimizer uses Filter Factors based on Valid Statistics & Defaults
After completing this course, the student should be able to:
This course is for experienced Data Processing personnel who have used SQL and need to explore Application Performance and Tuning issues for BOTH standalone SQL and in COBOL Application programs.
At least six months experience using DB2 SQL and COBOL Programming experience is needed.
Workshop - EXPLAIN Plan / VISUAL EXPLAIN and analyze results
Visual Explain, Performance Analyzer