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