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
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.
Learn how to tune for optimum performance the IBM DB2 9 for Linux, UNIX, and Windows relational database management system and associated applications written for this environment. Learn about DB2 9 for Linux, UNIX, and Windows in a single partition database environment. Explore performance issues affecting the design of the database and applications using the database, the major database performance parameters, and the different tools that assist in performance monitoring and tuning. Use tools that are common across the Linux, UNIX, and Windows environments. During labs running on DB2 9.7, develop your ability to use monitoring tools, Explain tools and DB2 utilities like RUNSTATS, REORG and db2batch to tune a database running on your local LINUX workstation.
Learn how to tune for optimum performance the IBM DB2 9 for Linux, UNIX, and Windows relational database management system and associated applications written for this environment. Learn about DB2 9 for Linux, UNIX, and Windows in support of single partition and multiple partition (DPF) database environments.
Explore performance issues affecting the design of the database and applications using the database, the major database performance parameters, and the different tools that assist in performance monitoring and tuning.
Use tools in class that are common across the Linux, UNIX, and Windows operating systems environments. During labs running on DB2 9, develop your ability to use monitoring tools, Explain tools and DB2 utilities like RUNSTATS, REORG and db2batch to tune a database running on your local LINUX workstation using single and multiple partition DB2 databases.
This is the classroom version of Instructor led online course DB2 9 for LUW Advanced Database Administration for Experts - ILO (3L46)
This course is designed to teach you how to:
• Fully use the advanced technical functions and features of DB2 LUW.
• Perform advanced monitoring using the DB2 administrative views and routines in SQL queries. Use the db2diag.log file messages to direct your investigation of problems using db2pd, INSPECT, db2support, and DB2 traces. Use DB2's health monitoring and Health Center to review the health indicator status for the instance, database, and table spaces. The type of problems monitored and resolved include buffer pool activity, lock contention, long running SQL statements, and log space utilization. Understand how automatic and manual first occurrence data capture can help to collect the diagnostic information needed to solve problems.
• Configure and manage the implementation of DB2 instance or database level auditing, including using the db2audit command and creation of audit policies which can be assigned to specific tables, users or database roles to perform selective collection of audit records.
• Explore DB2's management of disk space usage in Database Managed Storage (DMS) table spaces, including the activities of the rebalancer. Use DB2 commands and utilities to check the high water mark on table spaces and to monitor the rebalance operation. Move data from one table to another or from one database to another using utilities, such as db2move and db2relocatedb.
• Implement automatic storage management for table spaces or enable automatic resize options for DMS managed table spaces to reduce administration requirements and complexity.
• Exploit and monitor the REORG utility processing for offline and online table, and index reorganization This includes planning for the disk space and database log space necessary for reorganization. Configure the options and policies to automate the collection of table and index statistics or the reorganization of DB2 tables and indexes to improve performance and provide efficient disk space utilization. Monitor and review DB2's automated operations using health monitoring and diagnostic log messages.
• Utilize the REORG Utility to implement row compression for large tables, to reduce disk utilization and improve I/O performance for a DB2 database and understand the automatic creation of compression dictionaries.
• For Multidimensional Clustering (MDC) tables, determine how to select the dimension columns and table space extent size for efficient implementation of MDC tables. Compare the block indexes used for MDC table with rows based indexes. Select the MDC rollout option that best matches application needs and achieves the best performance results.
• Determine configuration options to use for connecting DB2 clients to DB2 LUW database servers using TCP/IP using the configuration assistant. Implement DB2 support for Lightweight Directory Access Protocol (LDAP) or DB2 thin client support to reduce administration requirements. Enablement of remote administration through use of DB2 Administration Server (DAS).
• Plan and implement range based table partitioning for large DB2 tables. Utilize the ALTER TABLE ATTACH and DETACH options to support roll-in and roll-out operations for range-partitioned tables. Compare the advantages of selecting or combining range partitioning with the hash-based partitioning used in DB2 DPF databases or the multiple dimensions provided by MDC tables.
• You get practical experience in the planning and utilization of a wide variety DB2 LUW utilities and functions by performing a series of lab exercises using DB2 Enterprise 9.5 installed on a Linux platform. The exercises build skills that can be applied to DB2 database servers on any Linux, UNIX or Windows environment.
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).
This replaced course CF49. This is the Classroom version of the Instructor Led Online Course 3L49 Gain a deeper understanding of the advanced recovery features of DB2 9 for Linux, UNIX, and Windows database environments with single and multiple partition databases. Get practical experience in the planning and utilization of a wide variety of DB2 recovery facilities in a series of database recovery scenarios you complete during lab exercises using DB2 Enterprise 9.5 for Linux.
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.