DB2 Tuning and Performance - Objectives

On successful completion of this course, the student, with the aid of the appropriate reference materials, should be able to:

1. Understand and explain the major components of the DB2 architecture
   
2. Use EXPLAIN output to determine DB2 access strategies and diagnose potential concurrency and performance difficulties
   
3. Understand and analyze DB2's strategy for performing joins, accessing cursors, and implementing subqueries
   
4. Understand DB2's strategy for selecting and using Indexes in data access
   
5. Arrange for efficient batch and utility processing using DB2
   
6. Use SQL to modify DB2 System Catalog Tables to influence DB2's choice of access paths
   
7. Understand the performance implications of using the DB2 security facilities
   
8. Understand and specify the parameters for the CICS and IMS attachment facilities
   
9. Understand the performance implications of Data Base Design decisions and Data Definition parameters.

Course information: G-580 / 5 Days   These Materials © Copyright 2007 by Hunter Cobb    V2.x

Topical outline
Course description
Home page

this page last updated: 01 February, 2007
this page copyright © 2007 by The Trainer's Friend, Inc.