SUMMARY:   The Course is designed to instruct those attending the course in all elements of developing and maintaining a DB2 LUW environment. AUDIENCE:   DB2 personnel who are new to DB2, or who have not used it for a long time and are expected to maintain or are required to write and perform activities associated with a DB2 LUW environment up to DB2 9. PREREQUISITES:   Those attending the course should be familiar with elementary aspects of a relational database, and are familiar with using a Linux, Unix or Windows environment. DURATION:   4 Days COURSE CONTENT:   Day 1 Introduction to DB2 Versions System architecture Terms/Terminology Instance/Database Tablespace Tables Table partitioning(9) Views Merge Materialization MQT Columns Nulls Referential Integrity Buffer Pools Alias Attributes Numeric Character Date/Time ROWID IDENTITY UDT Lob’s Unicode SQL Execution Environment Command line processing COMMAND CENTER CONTROL CENTER(WIZARD) Data Definition Language CONNECT DATABASE TABLESPACE TABLE ALTER Day 2 SELECT (single table) */ALL/COLUMNS/DISTICT/CONCATENATOR/literals/ORDER BY FETCH FIRST Efficiency aspects Predicates = IN BETWEEN LIKE GROUP AND/OR Built in function MAX/MIN/SUM/COUNT/AVG/COUNT_BIG Scalar Functions Examples and use of some of them e.g. SUBSTR/VALUE etc Complex SQL Table joins EQ JOIN SUBSELECT CORRELATED SUBSELECT UNION Left/Right/Full Joins In Line Tables CASE Remainder of DML statements UPDATE/DELETE/INSERT CTE’s Day 3 Embedded SQL Static and Dynamic SQL Cursors Development cycle Precompile DBRMs BIND PLANS/PACKAGES Execution of executable program LOCKING STRATEGY Introduction What resources can be locked? The different locks available Duration of a lock Commit/rollback Locking notes INDEXING Physical data management Tablespace Object Page Record identifier Indexes Type 1 and 2 RUNSTATS/REORG MDC Access strategy Multi table access path EXPLAIN VISUAL EXPLAIN Day 4 Extra Facilities OPTIMIZE FOR HANDLING NULLS TEMPORARY TABLES Remote and Distributed Environments Logs Security GRANT/REVOKE Security levels(9) Table check constraints TRIGGERS STORED PROCEDURES Utilities BACKUP RESTORE LOAD IMPORT/EXPORT DB2 LUW Tools overview Design Advisor Index Advisor Activity Monitor Memory Visualization Health Center Remote Administration Journal Replication Center Task Center Event Analyzer Recommendation Adviser IC/07