DB2 UDB for z/OS Advanced Topics

 LENGTH OF COURSE:
3 Days

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

PREREQUISITES: Prior DB2 programming experience.

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

AUDIENCE

This course is designed for DB2 Programmers, Analysts and Administrators that need a better understanding of DB2 Advanced topics.
KEY HIGHLIGHTS:
  • DB2 Objects
  • Cursor Processing
  • Dynamic SQL
  • Stored Procedure Concepts
  • DB2 / OS/390 Performance
  • DB2 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
    • Foreign Keys
    • Why Not Use DB2 Referential Integrity
  • DB2 Utility Programs Overview
  • What's new in DB2


FROM OUR STUDENT EVALUATIONS...
"Jeff has a great deal of knowledge and a great personality. This course was excellent for 3 DBA's that report to me and will improve their productivity in the future."

Bill Goetschous
Liberty Mutual Insurance

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