Home > DB2 for z/OS > DB2 Database Administration & Performance

DB2 Database Administration & Performance

Course Code:	DZODAP
Duration:	5 days
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.
Detailed Outline

Course Schedule