Datatrain
Partners
Login
  Username
  Password
  Partner Login
 
Forgot Password?
Register Now!
Partners
Interskill Mainframe Training Newsletter - April ´17
Interskill Mainframe Training Newsletter - August ´16
Interskill Mainframe Training Newsletter - June ´15
Past Issues

Partners
Mainframe Links
Mainframe Facts - Did you know?



DidYouKnow


More facts...

Course Catalog » Database Curriculum » DB2 - Database Management System Series V10

Optimize DB2 Application Performance V10

Duration
5 hours

Overview

Description

The Optimize DB2 Application Performance course describes how SQL statements perform different types of data locking depending on their purpose. The use of the DB2 Explain facility for performance monitoring and tuning is discussed along with the DB2 Optimizer and DB2 Estimator.

Audience

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

Prerequisites

Basic knowledge of DB2, 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 Application Performance Mastery Test

Course Catalog » Database Curriculum » DB2 - Database Management System Series V10
 
 
 
  © All rights reserved. Interskill Learning Pty Ltd.
website designed & developed by blueapple
  HomeAbout UsProductsDemonstrationCourse CatalogDistributorsSite Map
    AOL Logo Interskill IBM