DB2 Application Development for Performance - D212 ( 3 Days )
Price: $1800.00
Course Outline
Download Course Outline (PDF)
View Course Schedule
Abstract/Overview
This hands-on course examines DB2 for OS/390 UDB performance issues from the application programmer’s perspective. The discussion of DB2 performance factors is accompanied by practical tips and techniques for designing and implementing efficient DB2 applications. The SQL language is revisited to study efficient coding techniques. Hands-on exercises ensure an effective learning experience.
Audience - Who Should Attend?
The course is primarily intended for application designers, programmer analysts, and programmers who design or code DB2 for OS/390 UDB-based applications.
Prerequisite
Familiarity with the SQL language and DB2 application programming, or equivalent knowledge, is assumed. Ideally, students have taken Information Balance's "DB2 Application Programming Workshop" and "DB2 Advanced SQL Workshop".
Objective
- Understand the major factors contributing to DB2 performance.
- Learn how tablespace, table, and index design effect performance.
- Have a comprehensive understanding of how application design affects performance.
- Learn about the impact of concurrency on performance.
- Understand how the Optimizer works.
- Gain an in-depth knowledge of DB2 Access Paths.
- Become fully conversant in the use of the Explain facility, including the use of Optimizer hints.
- Be able to judge the efficiency of SQL statements and tune ineffective queries.
- Learn to use utilities as part of the performance tuning process.
Content
Introduction
- What is Performance?
- The Past, Present, and Future
Application Tuning
- Performance Factors
- Tuning
- Tools and Techniques
- Introduction to EXPLAIN
Database Design for Performance
- Tablespace Design
- Simple, Segmented, Partitioned
- Shared and Non-Shared
- Free Space
- Table Design
- Normalization/Denormalization
- Defining DB2 Data Types
- Nulls
- Index Design
- Index Structure, Levels, Options
- When and When Not to Index
Application Design for Performance
- On-Line Design
- Static, Dynamic SQL
- Prompt, List, Object Dialogues
- Batch Design
- Restartability
- Sequential, List Prefetch
- Utility Alternatives
Concurrency Control for Performance
- Concurrency Control
- The Performance Dilemma
- DB2 Locking Strategy
- Lock Size
- Lock Duration
- Lock Mode
- Improving Concurrency
- Avoiding Deadlocks
Access Paths
- Single Index Access
- Multiple Index Access
- Join Strategies
The Explain Facility
- What is it?
- The PLAN_TABLE
- Invoking the EXPLAIN Facility
- Interpreting EXPLAIN Output
- Optimizer Hints
SQL Processing
- The Optimizer
- Processing SQL
- SQL Cost
- Filter Factor
Coding for Performance
- Using Predicates
- Effective Multi-table Access
- Avoiding Sorts
Utilities and Performance
- LOAD -COPY, MERGECOPY
- RUNSTATS
- REORG
Course Schedule
| Start Date | Location | Class Code | Duration (days) |
| Wed, Oct 20 2010 | Toronto | P35715 | 3 |
| Wed, Nov 03 2010 | Ottawa | P35738 | 3 |
| | | | |
top