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.
All Course Formats
This course is designed to teach you how to perform database administration tasks using DB2 10.1. These tasks include creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements. The commands and functions available to implement database security, perform application monitoring and handle problem determination will be covered. This course provides a fast path to DB2 database administration skills for experienced relational DBAs.
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 10.1 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 db2pd commands 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. The selection of indexes to improve application performance and the use of SQL statements to track database performance and health will be covered. This course provides a quick start to DB2 database administration skills for experienced relational Database Administrators (DBA).
Linux® is one of the fastest growing server operating platforms within the past few years. DB2® has long been known for its technology leadership. This IBM® Redbooks® publication is an informative guide that describes how to effectively integrate DB2 for Linux, UNIX®, and Windows® (LUW) with SUSE and Red Hat Linux operating systems. This book provides both introductory and detailed information about installing, configuring, managing, and monitoring DB2 in a Linux environment. We describe the DB2 product family and features for Linux, and we provide step-by-step instructions for a single as well as for a multiple partition DB2 system installation and configuration. We discuss how to migrate single and multiple partition DB2 to DB2 Version 9.5, and discuss, in detail, DB2 database administration in a Linux environment, procedures and tools for database backup and recovery, online maintenance, and system monitoring. We cover DB2 integrated tools and their features and use. We discuss aspects of DB2 application development in the Linux environment and provide general tips about building and running DB2 applications on Linux and the use of DB2 application development tools.
These best practice papers present advice on the most optimal ways you can use DB2 to satisfy key business data processing needs. These papers are authored by leading experts in IBM's development and consulting teams, and have been extensively tested. Each best practice paper is designed to provide practical guidance for the most common DB2 product configurations. By applying these recommendations, you may improve the value of your DB2 data servers and align yourself with IBM's technical direction for DB2.