DB2 UDB for z/OS Systems Performance & Tuning

 LENGTH OF COURSE:
2 Days

DESCRIPTION: The course will concentrate on the performance aspects of DB2 Systems. The course is designed for the student that is familiar with DB2 but needs to gain a better understanding of DB2 System Components and Performance. The course is not designed to teach SQL performance and tuning.

PREREQUISITES: Prior DB2 experience or education, such as DB2 System Fundamentals or equivalent.

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

AUDIENCE

This course is designed for Data Base Administrators, Systems Programmers, and Advanced Programmers that need a better understanding of the DB2 systems environment and architecture.
KEY HIGHLIGHTS:
  • Overall Performance Considerations
    • Performance Planning
    • Performance Objectives
    • Response Time & Contention
    • Basic Tuning Strategy
  • Workload Types
    • Resource and Performance Factors
    • DB2 Advantages & Disadvantages
    • Key Resources & Factors
    • Performance Problems
    • Online vs. Batch Performance
  • Overall Monitoring Considerations
  • DB2 Catalog Statistics
    • Monitoring Tables & Indexes
    • REORGS
    • Application Plans & Packages
    • Storage Groups
  • Trace Facility
    • Trace Overhead
    • IFCIDS
    • Trace Classes
    • Accounting Traces
    • Controlling the Trace
    • Instrumentation Facility Interface


  • Monitors
    • DB2PM Overview
    • Audit Reports
    • Summary Reports
    • System Parameters
    • Transit Time
    • SQL Trace Reports
    • I/O Activity Reports
    • Locking
    • Statistics Summary
    • CPU Times
    • Service Controller
    • Subsystem Service Component
    • EDM Pool
    • Buffer Pool
    • Thread Accounting
  • Attachments, Thread Processing & Workload Control
    • Attachments
    • DB2 Threads
    • Thread Reuse
    • Workload Control
    • TSO, CICS, & IMS attach
    • QMF Governor
    • Resource Limit Facility


  • System Resources
    • EDM Pool
    • Database Buffer Pools
    • Hiperpools
    • Buffer Status
    • Buffer Pool Thresholds
    • Alter & Display Commands
  • OS/390 and Hardware Resources
    • Resource Utilization
    • CPU Resources
    • SRM Controls
    • RMF Reports
    • Capacity Planning
    • Real Storage
    • Paging & Expanded Storage
    • DASD Response Time
    • Improving I/0



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