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.