Purpose
This course teaches optimum performance tuning for the relational database management system product and associated database applications. Performance issues affecting database and application design are discussed, as well as the major database performance parameters. The course also introduces different tools used to assist performance monitoring and tuning.
The course material applies to DB2 UDB Version 6.1. The course is based on the DB2 UDB V6 Control Centre GUI, which is platform-independent and therefore applicable to any UDB server environment. The course lab environment includes use of the GUI Control Centre on an NT operating system.
Audience
Database designers, database administrators and application developers involved with performance issues.
Prerequisites
Before attending this course, you should be able to administer a DB2 Universal Database on a serial processor (non-partitioned).
These skills can be developed by attending one of the following courses:
DB2 UDB Database Administration Workshop for UNIX (CF21)
DB2 UDB Database Administration Workshop for OS/2 (CF22)
DB2 UDB Database Administration Workshop for Windows NT (CF23).
Objectives
After completing this course, you should be able to:
Define the impact of database design (tables, indexes, data placement, etc.) on database performance
Describe database application programming considerations and how they affect performance
Identify and describe the parameters (database and non-database) which affect performance
Tune parameters to achieve optimum performance
Identify and use tools to assist in monitoring and tuning a database.
Day 1 (9am-12:30pm)
DB2 UDB Review
Day 1 (1:30pm-5:00pm)
Basic Database Performance
The DB2 Execution Model
Day 2 (9am-12:30pm)
DB Design for Performance
DB Application Design and Programming Issues
Day 2 (1:30pm-5:00pm)
Tools and Utilities for Performance
SQL Performance
Day 3 (9am-12:30pm)
How does the Optimizer Work
Analyzing SQL Statements
Day 3 (1:30pm-5:00pm)
Visual Explain
Database System Monitor
Day 4 (9am-12:30pm)
DB2 Tuning for Performance
DBM and DB Tuning
Day 4 (1:30pm-5:00pm)
Tuning with the Smartguide
Configuration Parameters Relevant to Performance
This is a version-specific reference outline. Confirm the current syllabus and delivery arrangements with EIEIO.