About this Course

Code TPZL1_CL240
Duration 5 Days

This course replaces course CF242. This is the classroom version of the Instructor-led online course 3L240

This course teaches you how to perform database administration tasks using IBM DB2 Enterprise 9 with the Database Partitioning Feature (DPF). 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.


This course is for:

You should be able to:

You will be using a Linux environment in a VMware image for the lab exercises.

It will be helpful for students running DB2 on other operating systems and platforms - such as DB2 on an AIX - to have experience with using and administering their operating system environment.

Delegates will learn how to

Note: Actual installation of DB2 will not be performed in this workshop. A pre-installed system is used to exercise various administrative functions.


DB2 DPF Partitioned Database Components and Concepts

Getting Started with DB2


Creating a Partitioned DB2 Database

Partitioning and Database Partition Groups

Data Placement on the Partitions

Create Objects

Moving Data

Application Alternatives

Partitioned Database Backup and Recovery

Scaling the Database

Database and Application Performance


Monitoring and Problem Determination Tools

Locks and Concurrency


Day 1

Day 2

Day 3

Day 4

Day 5

5 Days

Training delivered by an IBM Global Training Provider
Delivery Method

Delivery method


Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0113 220 7150 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.