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 Series V11

Optimize DB2 Application Performance V11

Duration
5 hours

Overview

Description

The Optimize DB2 Application Performance course describes the methods used by DB2 when processing application programs containing SQL, and provides details of the tools and utilities that can be used to measure and analyse their effectiveness.

Audience

Programmers and DBAs responsible for managing the performance of SQL processing.

Prerequisites

Completion of all other courses in this curricula, or equivalent knowledge.

Objectives

After completing this course, the student will be able to:

  • Describe how locks affect DB2 performance
  • Identify the information that the EXPLAIN facility creates in the PLAN_TABLE
  • Code more efficient SQL
  • Describe the factors that influence DB2 access paths
  • Identify tools and utilities used to measure DB2 performance

Course Content

Creating, Managing, and Monitoring DB2 Locks

DB2's Data Locking Strategy

Suspensions, Timeouts and Deadlocks

Locking Rows, Pages, Tables and Table Spaces

Lock Modes

Lock Duration

Attributes of Locks

Analyzing Lock Statistics and Reports

SQL Statement Performance and Optimization

Need for Continual SQL Tuning

Tools for Measuring SQL Performance

SQL Tuning Using IBM Data Studio

SELECT Statement Use

Sort Performance

Predicate Processing

JOIN Efficiency

DB2 EXPLAIN Facility

How the EXPLAIN Facility Captures SQL Performance Data

PLAN_TABLE Data

DB2 Access Paths

Items Influencing the DB2 Access Path

PLAN_TABLE and its Access Path-Related Information

Access Paths When Joining Data

Optimize DB2 Application Performance Mastery Test

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