CL25: DB2 9 for LUW Multi-Partitioned Environment for Single Partition DBAs

Code: CL25
Duration: 3 days


This course teaches you how to perform database administration tasks using IBM DB2 Enterprise 9 with the Database Partitioning Feature. This course provides a fast path to DB2 Enterprise 9 partitioned database administration skills for experienced DB2 single partition database administrators. These tasks include customization for the DB2 Enterprise 9 with DPF system, creating and populating partitioned databases, designing a database for parallel use, and using partitioned DB2 utilities. There is no actual installation of DB2 Enterprise software in this workshop. A DB2 for Linux system is used to exercise various administrative functions.


Upon successful completion of this course, the students will be able to:

  • Describe the steps to install and customize DB2 Enterprise 9 in a DPF partitioned environmentLoad data on DB2 UDB in a partitioned environment
  • Load data on DB2 Enterprise 9 in a partitioned environment
  • Define a DB2 DPF partitioned recovery strategy and perform the tasks necessary to support the strategy
  • Identify how a database should be designed to take advantage of the parallel architecture
  • Use the DB2 utilities to manage data and maintain your DPF partitioned database


DB2 for Linux, UNIX and Windows single partition experienced database administrators involved in planning, implementing, or maintaining DB2 multi partitioned DPF databases.


  • Use basic AIX functions such as utilities, file permissions, hierarchical file system, commands and the vi editor
  • Administer a DB2 for Linux, UNIX and Windows single partition database

These skills can be developed by taking:

  • CL20: DB2 9 Database Administration Workshop for Linux
  • CL21: DB2 9 Database Administration Workshop for UNIX
  • CL23: DB2 9 Database Administration Workshop for Windows
  • CL48: DB2 9 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs


  • DB2 DPF Partitioned Database Components and Concepts
  • Getting Started with DB2
  • Installation
  • Creating a Partitioned DB2 Database
  • Partitioning and Database Partition Groups
  • Data Placement on the Partitions
  • Moving Data
  • Partitioned Database Backup and Recovery
  • Scaling the Database
  • Database and Application Performance
  • Monitoring and Problem Determination
  • Locks and Concurrency


Classroom and hands on lab exercises.

This course is offered on request and as web-based training. Please contact us for more information.