Optimize DB2 UDB Application Performance

Duration

3 – 4 hours

Overview

Audience

Programmers and DBAs requiring training in managing and accessing DB2 databases, particularly the use of SQL.

Prerequisites

Basic understanding of DB2 UDB, relational databases, and SQL.

Objectives

After completing this course, the student should be able to:
  • Understand some of the performance issues encountered with DB2
  • Use DB2 tools to tune performance

Course Content

Unit 1 DB2 LOCK TYPES AND PERFORMANCE

  • Understand DB2 locking and concurrency
  • Understand DB2 performance issues associated with locking and concurrency

Unit 2 DB2 EXPLAIN FACILITY

  • Understand the concepts of DB2 EXPLAIN
  • Understand the concepts of the PLAN table

Unit 3 DB2 ACCESS PATHS

  • Understand DB2 access paths and the effect of different database structures and joins

Unit 4 PERFORMANCE MANAGEMENT: COMPONENTS AND FACILITIES

  • Understand DB2 performance management
  • Understand the DB2 optimizer
  • Understand the DB2 estimator
 
© Copyright 2007. All rights reserved. Interskill Learning, Inc.