DB2 Database Administration and Performance

Audience:Database Administrators and System Administrators.Prerequisites:At least nine (9) months of database administration related experience.Summary:Designed mainly for the DBA, this course focuses on the best practices, techniques, tips and guidelines for optimal database design and performance. Topics given rigorous treatment include:

• The design, creation and management of tables, table spaces and indexes
• The design creation and management of efficient DBDs
• How to optimise I/O
• How to control CPU cycles
• How to plan and implement backup/recovery strategies
• The use and optimisation of data management and recovery utilities
• How to tune the VP, RID and EDM pools
• How to exploit the DB2 optimizer and interpret EXPLAIN
• How to exploit parallelism
• How to optimise batch design
• How to optimise DB2 locks

Objectives:Upon completion of this course, the participant should be competent to improve availability, throughput and resource utilisation per the topics under 'Summary' above.