Verhoef Training, Inc.

P.O.Box 1515, West Caldwell, NJ 07006
Phone:(800)631-0410 Fax:(973)403-3468



DB2 Performance and Tuning Course for UNIX/Windows




SUMMARY:   The Course is designed for those applications programmer, users and administrators who have used DB2, but need to be aware of, and feel confident with, all aspects of the product; with particular attention being paid to all aspects of efficiency.
The presentation is a mixture of lecture sessions and a comprehensive workshop, which is designed to introduce all aspects of relational technology as implemented by DB2, up to and including version 8.

AUDIENCE:   Programmers, applications developers and DBAs who are exposed to, or required to write and perform activities associated with application development and implementation in a DB2 environment.

PREREQUISITES:   Those attending the course should be familiar with DB2.

DURATION:   3 Days

COURSE CONTENT:  

DAY 1 TOPICS

  • Introduction to DB2
  • Versions
  • Overview of the system architecture
    • Consolidation Terms/Terminology
    • Connect
    • Database
    • Instance
    • Tablespace
    • Buffer Pools
    • Tables
    • MQT
    • Views
      • Merge
      • Materialization
    • Columns
    • Attributes
    • Online Schema Evalolution
  • System Catalog
    • How to search the catalog
    • Relevant tables and columns
  • History tables
  • Advanced SQL
    • The importance of PREDICATES
    • Stage 1/2
    • General guidelines for efficient SQL
    • Using Predicates
    • Consolidation of Scalar functions
  • DB2 design

      DAY 2 TOPICS

      • Advanced SQL & Coding Techniques(cont)
        • Special registers
        • OPTIMIZE FOR n ROWS
        • FOR FETCH/READ ONLY
        • FETCH FIRST ONLY
        • WITH clause
        • Table joins
      • Indexes & Performance
        • Physical Data Management
        • Page
        • Record identifier
        • Indexes
        • Index Splits
        • Creating Indexes
      • MDC’s
      • Index Assist
      • The OPTIMIZER
      • EXPLAIN
        • PLAN_TABLE
        • Using
        • Querying
      • DSN_STATEMNT_TABLE
      • REOPTIIMIZE/REBIND
      • BIND MANAGER
      • VISUAL EXPLAIN
      • Catalog Updating

      DAY 3 TOPICS

      • Embedded SQL
        • Online Guidelines
        • Batch Guidelines
        • Consolidating of Development techniques
        • Consolidation of Design Techniques
      • Locking
        • What resources can be locked
        • The different locks available
        • Duration of a lock
        • SAVEPOINTS
        • Locking notes
      • Stored Procedures
        • Advantages
        • Types of Stored Procedures
        • An SQL Procedure
        • An External Procedure
        • Writing an External Procedure
        • Calling the Stored Procedure
        • The SQL Procedure Language
        • Stored Procedure Builder/Development Centre (Version 8)
      • Triggers
        • Types of triggers
        • Creation
        • Implementation
      • Other products (if necessary)
        • Journal
        • Replication Center
        • Task Center
        • Event Analyzer
        • Health Center
        • Indoubt Transaction Manager
        • Memory Visualizer
        • Configuration Assistant
      IC/05

        • © 2007 Verhoef Training, Inc.