Advanced DB2 Application Programming

Course: DB2M

Duration: 3 Days

Level: II

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.

« Hide The Details

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.

« Hide The Details

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.

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 [email protected]

Privacy Notice