AUDIENCE:   The course is ideal for Systems Administrators, Developers, Database Administrators and technical personnel who are involved in all stages of designing, planning, implementing and maintaining a DB2 for LUW Database, but wish to ensure that they are using the language efficiently. The course is delivered up to DB2 9.5 PREREQUISITES:   Delegates are expected to have a reasonable working knowledge of DB2 on the appropriate platform (ie. Linux, UNIX or Windows). DURATION:   3 days. Hands on. OBJECTIVES:   The course is designed to instruct those delegates attending the course how to develop and implement DB2 applications using SQL in an efficient and effective manner. COURSE CONTENT:   Introduction to DB2 The DB2 family The Big Picture Basic Terms DB2 System Catalog Tables and views Attributes Including XML Consolidation of DDL With Regard To Efficiency up to and Including DB2 9.5 Consolidation Of Operating System Commands Including DB2LOOK Indexing Cluster Ratio Effect on sorting RUNSTATS REORG Reorgchk Access Strategies Explain · DB2expln · OPTIMIZATION SERVICE CENTER Range Clustered Tables MDC Design Advisor SQL With Regard To Efficiency CTE’S Embedded SQL Static and Dynamic SQL Cursors Development Cycle Locking Strategy Logs Snapshot and Event Monitor Introduction to Automatic Computing Configuration Parameters IC 09/09