Courses and publications are offered to help you prepare for the certification tests. The courses are recommended, but not required, before taking a certification test.
Study Guide for the certification test.
All Course Formats
Get the technical information about the new functions and features available in DB2 9.7 for Linux, UNIX, and Windows for current DB2 version 8, 9.1 and 9.5 database systems. This course assumes you are familiar with the functionality of the previous DB2 releases.
If you are transitioning from DB2 for LUW V8.2 to 9.7, you may consider attending the 4-day transition course, DB2 9.5 for Linux, UNIX, and Windows Transition from DB2 V8.2 (CL31) or DB2 9.5 for Linux, UNIX, and Windows Transition from DB2 V8.2 - ILO (3L31) before attending CL31.
If you are transitioning from DB2 for LUW V9.1 to 9.7, you may consider attending the 2-day transition course, DB2 9.5 for Linux, UNIX, and Windows Transition from DB2 9 (CL31) or DB2 9.5 for Linux, UNIX, and Windows Transition from DB2 9 - ILO (3L31) before attending CL31.
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. 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.