Test C2090-544: DB2 9.7 Advanced DBA for LUW
It is highly recommended that you use a variety of resources to prepare for certification exams.
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. When preparing for the certification test, keep in mind that real world experience is required to stand a reasonable chance of passing the certification test. Courseware does not replace the requirement for experience. Please note that course offerings are continuously being added and updated. If you want to purchase a training course, feel free to contact an IBM Global Training Provider.
Study Guide for the certification test.
All Course Formats
Course duration: 1 days
Course number: CL31x
Abstract: This course is designed to describe the major technical features and enhancements provided by the DB2 for Linux, UNIX and Windows database 10.5 software. DB2 10.5 has two primary areas of focus. One key feature of DB2 10.5 is new support for column-organized tables to provide accelerated analytic processing called BLU Acceleration. Another important focus are for DB2 10.5 is a set of enhancements for the DB2 pureScale feature, including online topology changes and the support for High Availability Disaster Recovery (HADR) with a DB2 pureScale cluster.
Course duration: 4.0 days
Course number: CL41x
Abstract: 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.
Course duration: 5 days
Course number: CL44x
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.
Course duration: 5 days
Course number: CL46x
Abstract: This course is designed to teach you how to: Fully use the advanced technical functions and features of DB2 LUW 10.1 and 10.5. Implement DB2 BLU Acceleration, column-organized table support, for a new or existing DB2 database. Describe how the column dictionaries used for DB2 BLU Acceleration are built and utilized to provide extreme compression for column-organized tables. Explain the default workload management used for DB2 BLU Acceleration processing and how you can tailor the WLM objects to efficiently use system resources. Monitor a DB2 database or application that uses column-organized tables using SQL monitor functions. Create optimization profiles that allow applications to control specific operations included in the access plans selected by the DB2 Optimizer, like which index is used to access a table or which join method to utilize for joining tables. Perform advanced monitoring using the DB2 administrative views and routines in SQL queries. 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 SQL queries 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 like db2move. Utilize the ADMIN_MOVE_TABLE procedure to implement table changes with a minimal impact to data availability for applications. Implement automatic storage management for table spaces and storage groups 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. 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 with MDC tables with rows based indexes. Select the MDC rollout option that best matches application needs and achieves the best performance results. 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 partitioned 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 Advanced Enterprise Edition 10.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. The course materials cover DB2 10.5 for Linux, UNIX, and Windows.
Course duration: 4 days
Course number: CL485x
Abstract: This course teaches you to perform, basic and advanced, database administrative tasks using DB2 10.5 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 various db2pd command options. Students 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 REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces, will be discussed. We will also cover using the TRANSPORT option of RESTORE to copy schemas of objects between two DB2 databases. 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).
DB2 9 for LUW Advanced Database Recovery
Course duration: 4 days
Course number: CL49x
Abstract: 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.7 for Linux. The purpose of this course is to enable the learning to 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. In this course, the learning will receive 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.7 for Linux.
Before taking your test, please review our testing policies and guidelines, and registration process.
Register for a Test
Register for an IBM Certification test at Pearson VUE and take a step into your future. Take a minute to review how to Create Pearson VUE account associated with IBM and Selecting Tests on the Pearson VUE Website.