DB2 10 for z/OS Application Performance and Tuning

DB2 10 for z/OS Application Performance and Tuning Course Description

Duration: 5.00 days (40 hours)

This course is designed to teach you how to prevent application performance problems and to improve the performance of existing applications.

Next Class Dates

Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with a Learning Consultant.

Back to Top

Intended Audience for this DB2 10 for z/OS Application Performance and Tuning Course

  • » This advanced course is for DB2 for z/OS application developers, DB2 for z/OS DBAs and anyone else with a responsibility for application performance and tuning in a DB2 for z/OS environment.

Back to Top

This Course is also part of:

Back to Top

DB2 10 for z/OS Application Performance and Tuning Course Objectives

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

Back to Top

DB2 10 for z/OS Application Performance and Tuning Course Outline

      1. Introduction to Application Performance and Tuning
        1. Why Performance Disappoints
        2. Causes of Performance Problems
        3. A Simple Example
        4. SQL EXPLAIN Information
        5. Modify the Index
        6. The Accounting Trace
        7. Accounting Trace Information
        8. Filter Factors
        9. Another Index Modification
        10. Who Detects Problems?
        11. When Should Problems be Detected?
        12. VQUBE2
        13. What is a Touch?
        14. Further Analysis (1 of 2)
        15. Further Analysis (2 of 2)
        16. The Message
      2. Performance Analysis Tools
        1. Components of Response Time
        2. Methodology Formulas
        3. VQUBE2
        4. Simple Example in VQUBE2
        5. SQL EXPLAIN
        6. The Plan Table
        7. Running the Explain
        8. Interpreting the Results
        9. The Accounting Trace
        10. Reading an Accounting Trace
        11. The Bubble Chart
        12. Monitoring Execution
        13. Performance Thresholds
        14. Tuning Potential
      3. Towards Better Indexes
        1. DB2 Index Structure and Usage, Part 1
        2. DB2 Index Structure and Usage, Part 2
        3. Tuning Methodology and Index Cost
        4. Lab 1: Customer Order Application
        5. Index Design
        6. Lab 2: Poorly Performing Application
        7. Advanced Access Paths
      4. Multiple Table Access
        1. Joining Issues
        2. Lab 3: Joining Tables
        3. Subqueries and Global Query Optimization
        4. Lab 4: Different Implementations of One Problem
        5. Union, Except, and Intersect
        6. Subqueries
        7. Towards Better Tables
        8. Table Design
        9. Materialized Query Tables
        10. Temporal Tables
      5. Learning to Live with the Optimizer
        1. Dangerous Predicates
        2. Section 6.2 Lab 5: Introduction to Browsing
        3. Filter Factors
        4. Helping the Optimizer
      6. Massive Batch
        1. Batch Performance Issues
        2. Benefit Analysis
        3. Massive Delete
      7. Locking Issues
        1. Serialization
        2. Transaction Locking
        3. Application Design

Back to Top

Do you have the right background for DB2 10 for z/OS Application Performance and Tuning?

Skills Assessment

We ensure your success by asking all students to take a FREE Skill Assessment test. These short, instructor-written tests are an objective measure of your current skills that help us determine whether or not you will be able to meet your goals by attending this course at your current skill level. If we determine that you need additional preparation or training in order to gain the most value from this course, we will recommend cost-effective solutions that you can use to get ready for the course.

Our required skill-assessments ensure that:

  1. All students in the class are at a comparable skill level, so the class can run smoothly without beginners slowing down the class for everyone else.
  2. NetCom students enjoy one of the industry's highest success rates, and pass rates when a certification exam is involved.
  3. We stay committed to providing you real value. Again, your success is paramount; we will register you only if you have the skills to succeed.
This assessment is for your benefit and best taken without any preparation or reference materials, so your skills can be objectively measured.

Take your FREE Skill Assessment test »

Back to Top

Award winning, world-class Instructors

Our instructors are passionate at teaching and are experts in their respective fields. Our average NetCom instructor has many, many years of real-world experience and impart their priceless, valuable knowledge to our students every single day. See our world-class instructors.   See more instructors...

Back to Top

Client Testimonials & Reviews about their Learning Experience

We are passionate in delivering the best learning experience for our students and they are happy to share their learning experience with us.
Read what students had to say about their experience at NetCom.   Read student testimonials...

Back to Top