DB2 UDB for OS/390 Application Performance and Tuning
Duration
Five Days
Overview
This course covers issues impacting the performance of DB2 applications programs. Topics include indexing, database design, SQL processing, SQL tuning and locking.
Audience
This course is designed for DB2 developers and DBA responsible for DB2 application performance
Pre-requisites
- Attendees to this class should have working knowledge of SQL
- DB2 UDB for OS/390 Database Administration
- DB2 UDB for z/OS & OS/390 Applications Programming Workshop
Course Topics
- Overall Performance Considerations
- Performance Management in DB2
- Indexing
- Optimizer and Access Path Selection
- Complex Access Paths
- EXPLAIN Facility
- SQL Processing and Tuning
- Locking and concurrency
Course Objectives
- Outline key DB2 performance factors.
- Analyze when to create an index.
- Reduce the performance problems passed to DBA's.
- Reduce CPU costs and charges, improve disk contention problems, and improve bufferpool memory utilization.
- Understand the optimizer decision factors in order to influence the optimizer.
- Outline complex access paths such as sorts, nested loop, merge scan and hypbrid joins.
- Understand the Explain facility.
- Understand predicates and SQL tuning factors.
- Understand locking modes and tradeoffs and concurrency issues.
Benefits
Students decipher key DB2 performance factors focusing on indexing, the DB2 optimizer and access path selection. The Explain facility is examined and SQL tuning recommendations are made. Locing and concurrency issues are also addressed.
