About this course

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.


Prerequisites

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.

Outline

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

Create Objects

Moving Data

Application Alternatives

Partitioned Database Backup and Recovery

Scaling the Database

Database and Application Performance

Security

Monitoring and Problem Determination Tools

Locks and Concurrency

Agenda

Day 1

Day 2

Day 3

Day 4

Day 5

5 Days

Duration
Training delivered by an IBM Global Training Provider
Delivery Method

Delivery method

Classroom

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 0345 074 7998 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.