DB2 Performance and Tuning Course for UNIX/Windows

Course: DB2PTUW

Duration: 3 Days

Level: II

Course 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.

« Hide The Details

Topics Covered In This Course

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

Who Should Take This Course

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.

Recommended Prerequisites

Those attending the course should be familiar with DB2.

« Hide The Details

Related Courses

Code	Course Title	Duration	Level
DB2U	DB2 SQL Application Programming	5 Days	I	Details
DB2LUW	DB2 LUW (Linux, UNIX, Windows) FOR PROGRAMMERS	4 Days	I	Details
DB2UDBI	DB2 for LUW (Linux, UNIX, Windows)	2 Days	I	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.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.

Notify me the next time this course is confirmed!

Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com