DB2 UDB for z/OS Application Performance & Tuning

 LENGTH OF COURSE:
3 Days

DESCRIPTION: The course will concentrate on the performance aspects of DB2 and DB2 Objects. In addition, the student will learn how to use the DB2 catalog and plan tables to improve performance.

PREREQUISITES: Prior DB2 experience or education, such as DB2 UDB for OS/390 System Fundamentals or equivalent.

INSTRUCTION TECHNIQUES: A combination of Lecture, Demonstration, and Labs (when/where available).

AUDIENCE

This course is designed for the Programmer, Analyst, or Administrator that needs to gain better understanding of the DB2 environment and architecture.
KEY HIGHLIGHTS:
  • Architecture and Objects
  • The DB2 Architecture
  • DB2 Attachments
  • DB2 Objects
    • Table Spaces Types and Performance
    • DB2 Storage Groups and Databases
    • Proper Definition and use of Indexes
    • DB2 Systems Objects and Catalog
  • DB2 Internal Components
    • DB2 VSAM Dataset and Page Set
    • Space Map Page and Data Pages
    • DB2 Pointers, Index Structure and Concerns
  • Monitoring Clustering
  • Index Physical Structure and Subpages
  • SQL Processing and Performance
  • DB2 Address Spaces
  • Database Services and SQL
  • The RDS
  • Predicate Types
  • INDEXABLE PREDICATES


  • Other Properties of Predicates
  • Filter Factors & Percentages
  • Interpolation Factors & Formulas
  • Query Access Path Selection
  • Optimize For in SQL
  • Tablespace Scans, Sequential Prefetch & types of Index Scans
  • Join Considerations
  • Using EXPLAIN & how to invoke EXPLAIN
  • The PLAN_TABLE
  • Using SPUFI and Explain
  • DB2 Space Requirements
  • Calculating Space Requirements
  • Response Time and Throughput
  • Improving your Response Time and Throughput
  • Reducing I/O with RUNSTATS and REBIND
  • RUNSTAT Catalog Updates
  • RUNSTATS and Access Strategies
  • Reducing I/O with CLOSE YES|NO
  • Reducing I/O with Proper Space Reservation


  • How DB2 uses FREE SPACE allocations
  • Reduce I/O with Indexes
  • Buffer Pool Considerations
  • Buffer Pool Thresholds
  • DB2 database Design
  • Database Referential Integrity


FROM OUR STUDENT EVALUATIONS...
"I was very impressed with this course and will do what I can to recommend the IRS make it available on a periodic basis."

John Triplett
Internal Revenue Service

Return to Home Page.
Return to Alphabetic Listing of Courses.
Return to Courses by Subject.
Request More Information or Contact Us.