IBM Professional Certification Program

Accelerate insight. Improve skills. Get certified now.

Test C2090-544: DB2 9.7 Advanced DBA for LUW


This page is currently being updated to reflect the latest resources and courses available to help you prepare for this certification test.

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.

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 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.

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.



Promotions


Connect with Us