Advanced DB2 Application Programming
- Recommended Duration:
- 5 Days
- Version
- DB2 Version 7. Class is suitable for those using DB2 version 5 or 6 also.
- Benefits
- Students who complete this course will be able to: construct efficient queries in DB2 using multiple tables; discern the access strategy for a query; be able to define, load, and maintain DB2 tables; understand the use of packages; utilitize DB2 distributed data base features; code programs that use the Call Attachment Facility and dynamic SQL.
- Audience
- Experienced DB2 programmers who need to construct complex, efficient queries in both on-line and batch environments, understand DB2 access strategies, and access distributed data bases.
- Prerequisites
- Students should have 6 months recent experience designing and coding application programs using DB2 SQL, or have completed the "DB2 Application Programming" course within the last 12 months.
- Major Topics
-
- Relational Access Concepts; EXPLAIN, PLAN_TABLEs and Access Strategies
- Use of Indexes and Filter Factors; Indexable, Stage 1 & Stage 2 Predicates
- Joins, Outer Joins, Subqueries, and Nested Table Expressions
- Joined Access Strategies - Nested Loop, Merge Scan, and Hybrid
- Packages; Remote Units of Work, and Distributed Units of Work; DRDA
- Creating tables and indexes
- DB2 Data Types
- Normalization
- Modifying DB2 table definitions
- Referential Integrity
- Views and Synonyms
- LOAD, REORG, and RUNSTATS Utilities
- Call Attachment Facility
- Dynamic SQL
- Stored Procedures
- Exercises
- There are five machine exercises.
- Notes
- This course includes the material in "Advanced SQL Query Building", and overlaps 30% with "DB2 Data Base Administration".