AUDIENCE:   Systems Administrators, Database Administrators and technical personnel who are involved in all stages of designing planning, implementation and maintaining DB2 for LUW Databases. The course is delivered up to DB2 9. PREREQUISITES:   Delegates are expected to have relevant operating system experience (i.e. Linux, UNIX or Windows) and knowledge of relational database theory and SQL. Previous experience of using DB2 is recommended. DURATION:   4 days. Hands on. OBJECTIVES:   The Course is designed to instruct those delegates attending the course how to perform database administration activities on DB2 in a Linux, UNIX or Windows environment. Those activities include all aspects of manual or automatic maintenance, utilities, problem determination, parallelism, distributed data management, remote administration, MDT, Health Center, federated databases and DB2 Governor. COURSE CONTENT:   Introduction to DB2 The DB2 family The Big Picture Basic Terms DB2 System Catalog Attributes SQL Execution Control Center DDL Practical Exercise Indexing Design Advisor Practical Exercise RUNSTATS REORG Access Strategies Practical Exercise Explain Visual Explain Practical Exercise MDC Automatic Computing Configuration Parameters Collecting Catalog Statistics Activity Monitor Memory Visualization Health Center Remote Administration   DB2 Administration Server   Configuration Assistant   Instance Attachment   Connection The Governor and Audit Problem Determination Tools and Techniques Parallelism and SMP Enablement Utilities   db2move   db2look   db2ocat   db2cfexp   db2cfimp   List Utilities Capacity Management   Estimate Size   Storage Management   Database Container Operations   High Availability Monitor Advanced Load Distributed Management Federated Databases Configure Multisite Update Journal Replication Center Task Center Event Analyzer Recommendation Adviser Indoubt Transaction Manager IC06/01