02 9482 8200 info@datasync.com.au

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

Code: CL25
Duration: 3 days

Description

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.

Outcomes

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

Audience

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

Prerequisites

  • 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

Contents

  • 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

Format

Classroom and hands on lab exercises.

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