DB2/QMF Advanced Topics & Performance for End-Users

 LENGTH OF COURSE:
2 Days

DESCRIPTION:The course will concentrate on SQL and QMF advanced topics and performance aspects of DB2. Students will understand processing that is required to execute their queries. In addition, students will learn how to use DB2 and QMF advanced features to improve performance.

PREREQUISITES: Prior DB2 /QMF experience required.

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

AUDIENCE

This course is designed for DB2 End-Users, Analyst, and Managers that need a better understanding of DB2 advanced topics and performance related issues.
KEY HIGHLIGHTS:
  • DB2 Objects
  • Cursor Processing & Dynamic SQL
  • Stored Procedure Concepts
  • DB2 / OS/390 Performance & Utilities
  • Physical Data Management
    • OS/390 Related Products
    • Table Terminology
    • Physical Storage Hierarchy
    • Tablespace and Page Types
    • Data Page and Data Record Formats
    • B-Tree Index
    • Clustering Index
  • Optimizer and Explain Features
    • How the Optimizer Works
    • The Plan Table
    • Sample Selects Illustration
    • Explain Statement Shortcomings
  • Commit Processing and Locking Strategies
    • Units of Recovery & Commit Points
    • Page, Table, & Tablespace Locks
    • Program Isolation Levels
    • Lock Table Statement
    • Factors Affecting Locking
    • Locking Trade-offs


  • Performance Considerations
    • DML Coding
    • Program Preparation
    • DDL Suggestions
    • Design Tips
    • Environment Issues
    • Performance Factors
  • Referential and Explain Feature
    • Referential Integrity Terminology
    • Insert, Update, and Delete Rules
    • Create Statements
    • The Primary Key and Foreign Keys
    • Why Not Use DB2 Referential Integrity
  • DB2 Utility Programs Overview
  • Advanced SQL
    • Subqueries
    • JOINS & JOIN Types
    • Column & Scalar Functions


  • Advanced QMF
    • Improve performance of QMF queries
    • What to do in SQL vs. QMF
    • QMF Advanced Features
    • Advanced Forms & Queries
    • Using Rocket and HPO


FROM OUR STUDENT EVALUATIONS...
"I was really looking for information on improving query performance -- that we as end-users could apply and save time and company resources. Jeff delivered. Thanks!"

Ruth Howald
Zurich Personal Insurance

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