This course teaches you to perform, basic and advanced, database administrative tasks using DB2 9 for Linux, UNIX, and Windows. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. The access strategies selected by the DB2 Optimizer will be examined using the DB2 Explain tools. Various diagnostic methods will be presented, including using the db2diag.log file messages to direct your investigation of problems, as well as using the commands db2pd, INSPECT, and db2support and DB2 traces. You will learn how to implement automatic archival for database logs and how to plan a redirected database restore to relocate either selected table spaces or an entire database. This course provides a quick start to DB2 database administration skills for experienced relational Database Administrators (DBA).
You will get practical experience in the basic and advanced database administrative tasks of a wide variety of DB2 LUW utilities and functions by performing a series of lab exercises on a Linux platform. The exercises build skills that can be applied to DB2 database servers on any Linux, UNIX or Windows environment.
Course Materials
The course materials address DB2 9 for Linux, UNIX, and Windows, Version 9.7.
Hands-On Labs
Ten labs are included to address DB2 9 for Linux, UNIX, and Windows, Version 9.7.
Training Path
This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education.
