Custom Search
Provided by: Interskill Learning

2.5 Optimize DB2 UDB Application Performance

DB2

Interskill Learning
Training Provided by Interskill Learning This is course 5 of 5 in the DB2 - Database Management System Series. The course is delivered via e-Learning. It can be accessed online, at any time, place or location with internet access, or delivered through your own internal LMS (if applicable). The course is available as part of the DB2 - Database Management System Series, or in a Mainframe Bundle, comprising of the 100 most popular mainframe e-Learning titles.
This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Contact Interskill Learning for more information
Course Level:intermediate
Duration:3 hours
Training Presented in:English
2.5 Optimize DB2 UDB Application Performance

Duration

2 to 3 hours

Overview

Audience

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

Prerequisites

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

Objectives

After completing this course, the student will be able to:
• Identify some of the performance issues encountered with DB2
• Recognize the DB2 tools that are used to tune performance

Course Content

DB2 Lock Types and Performance

DB2 Locking and Concurrency
DB2 Performance Issues Associated With Locking and Concurrency

DB2 EXPLAIN Facility

The Concepts of DB2 Explain
The Concepts of the Plan Table

DB2 Access Paths

DB2 Access Paths and the Effect of Different Database Structures and Joins

Performance Management: Components and Facilities

DB2 Performance Management
The DB2 Optimizer
The DB2 Estimator

Optimize DB2 UDB Application Performance Mastery Test

About The Training Provider: Interskill Learning
Interskill Learning - Interskill Learning is a worldwide leader in the provision of e-learning, delivering reliable, quality learning solutions since 1991 to over 1500 organisations. With 1000s of titles to chose from in mainframe, desktop, IT and business subject areas, Interskill offers a comprehensive training solution for your entire workforce, regardless of their department, location or language. With three...
Want to Sell More db2 training?
tcw11-gfc-v396M-10/25/09-11:19:01-()[A]-[B]-[B] -05:27:21