Verhoef Training USA

Training Courses and On-Line Classes Preferred By IT Pros

Visit us at:   http://www.verhoef-training.com

103 Hillside Ave., PO Box 1515
West Caldwell, NJ 07006
Main Office:  800.631.0410
Sales Office:  800.533.3893

Advanced DB2 Application Programming

Course:   DB2M
Duration:   3 Days
Level:   II
On our website at:   http://www.verhoef-training.com/courses/DB2M.html
 
Course Summary

The Course is designed to instruct those delegates who have been introduced, or have limited exposure to DB2. It has been designed, to consolidate on the students knowledge of SQL, understand all aspects of EXPLAIN, be aware of efficiency, and to understand the new facilities available up to UDB/390 versions 8,9. The course will contain numerous practical exercises to consolidate the theory sessions.

Topics Covered In This Course

THE SYSTEM ARCHITECTURE

  • Introduction
  • DBAS
  • Remainder of the stared tasks
  • Buffer Manager/Buffer Pool
  • EDM Pool
  • Data transfer
  • Storage
  • SQL Limits
  • DB2 Objects
    • Tablespaces
      • Simple Talespace
      • Segmented Tablespaces
      • LOB Tablespaces
      • Partitioned Tablespaces
      • Universal Tablespaces
    • Tables
    • Views
    • Materialized Query Tables
  • Log Manager
  • DB2 Traces

THE CATALOG

ADVANCED SQL & CODING TECHNIQUES

  • The importance of PREDICATES
  • General guidelines for efficient SQL
  • Using Predicates 1
  • OPTIMIZE FOR n ROWS
  • FOR FETCH/READ ONLY
  • WITH clause 5
  • Table joins
    • Joins on equality
    • Subselects/Subqueries
    • Correlated Subselects
    • Unions
  • INTERSECT/EXCEPT
  • Inner joins
  • Left joins
  • Right joins
  • Full joins
  • Joining adding a WHERE clause
  • NESTED TABLES
  • CTE(COMMON TABLE EXPRESSIONS)
  • COALESCE
  • CASE
  • UPDATE
  • DELETE
  • INSERT
  • MERGE

INDEXES & PERFORMANCE

  • What Determines Application Performance
  • Design Factors That Affect Performance
  • Benefits of Indexing
  • Candidates for Indexing/Not For Indexing
  • Volatile
  • Physical Data Management
  • Index Splits
  • Creating Indexes
  • Index Guide Lines

EXPLAIN and FILTER FACTOR

The OPTIMIZER

EXPLAIN

Create PLAN_TABLE

Using

Querying

Catalog Statistics

Default Statistics

Filter Factor

DSN_STATEMNT_TABLE

REOPTIIMIZE/REBIND

VISUAL EXPLAIN

DB2 Administration Tools

DB2 Performance Analyzer

ONLINE PERFORMANCE GUIDELINES

BATCH GUIDELINES

LOCKING

Who Should Take This Course

IT personnel who have been exposed to using DB2.

Recommended Prerequisites

Those attending the course should have used DB2.

Related Courses
Code Course Title Duration Level
DB2AU
DB2 Administration for Linux, Unix and Windows
5 Days
I
Details
DB2ST
DB2 System Performance Tuning
5 Days
II
Details
DB2M10
DB2 10 z/OS Transition
1 Day
II
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.