DB2 9 for LUW Multiple Partition DBA Workshop

start > courses and registration > training feature sheet

code.

CF242

length.

5 days

type.

Instructor-Led

partner.

IBM

price.

$3,125

This course teaches you how to perform database administration tasks using IBM DB2 in a partitioned environment. These tasks include installing DB2 in a partitioned environment, creating and populating databases, designing a database for parallel use, examining explain data for parallel queries, and using DB2 utilities.

Phoenix, AZ	sep.29.2008 - oct.3.2008	register
Phoenix, AZ	nov.10.2008 - nov.14.2008	register
San Francisco, CA	sep.29.2008 - oct.3.2008	register
El Segundo/Los Angeles, CA	sep.29.2008 - oct.3.2008	register
Sacramento/Elk Grove, CA	sep.29.2008 - oct.3.2008	register
San Francisco, CA	nov.10.2008 - nov.14.2008	register
El Segundo/Los Angeles, CA	nov.10.2008 - nov.14.2008	register
Sacramento/Elk Grove, CA	nov.10.2008 - nov.14.2008	register
Englewood/Denver, CO	sep.29.2008 - oct.3.2008	register
Englewood/Denver, CO	nov.10.2008 - nov.14.2008	register
Atlanta, GA	aug.4.2008 - aug.8.2008	register
New York/Downtown, NY	oct.20.2008 - oct.24.2008	register
Bellevue/Seattle, WA	sep.29.2008 - oct.3.2008	register
Bellevue/Seattle, WA	nov.10.2008 - nov.14.2008	register

who can benefit

Database Administrators, Application Developers, and Consultants who are involved in planning, implementing, or maintaining DB2 for LUW partitioned databases.

prerequisites

Before taking this course, you should be able to:

	Use basic Linux/UNIX functions such as utilities, file permissions, hierarchical file system, commands, and the vi editor
	State the functions of the Structured Query Language (SQL) and be able to construct DDL, DML, and authorization statements
	Discuss basic relational concepts and objects such as tables, indexes, views, and joins
	These skills can be developed by taking:
	Linux/UNIX basics (for example, Linux Basics)
	DB2 SQL Workshop
	DB2 Family Fundamentals
	The student 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.

skills gained

After completing this course, you should be able to:

	Describe the steps to install and customize DB2 in a partitioned environment
	Use GUI and Command Line tools to administer the database
	Create objects and load data into DB2 databases
	Define a DB2 partitioned recovery strategy and perform the tasks necessary to support the strategy
	Describe the application development process with respect to DB2 considerations
	Identify how a database should be designed to take advantage of the parallel architecture
	Use DB2 utilities to manage data and maintain your database
	Implement DB2 security
	Note: Actual installation of DB2 will not be performed in this workshop. A pre-installed system is used to exercise various administrative functions.

ibm education advantage programs eligibility:

YES - IBM Education Pack - online account

course content details

	Course Topics

	Components and Concepts
	Getting Started with DB2
	Installation
	Creating Databases
	Partitioning and Database Partition Groups
	Data Placement on the Partition
	Create Objects
	Moving Data
	Application Alternatives
	Recovery
	Scaling the Database
	Performance and Application Concepts
	Security
	Monitoring and Problem Determination Tools
	Locks and Concurrency

	Agenda - Day 1

	Welcome
	Unit 1 - Components and Concepts
	Paper Lab
	Unit 2 - Getting Started with DB2
	Unit 3 - Installation
	Installation Lab
	Unit 4 - Creating Databases

	Day 2

	Creating Database Lab
	Unit 5 - Partitioning and Database Partition Groups
	Partitioning Keys and Database Partition Groups Lab
	Unit 6 - Data Placement on the Partition
	Creating Table Spaces Lab
	Unit 7 - Create Objects

	Day 3

	Creating Objects Lab
	Unit 8 - Moving Data (Import and Load)
	Moving Data Lab - import and Load
	Unit 8 Continued - Moving Data (Partitioned Load)
	Moving Data Lab - Partitioned Load
	Unit 9 - Application Alternatives
	Application Basics Lab

	Day 4

	Unit 10 - Backup and Recovery
	Backup and Recovery Lab
	Unit 11 - Scaling the Database
	Scaling Lab
	Unit 12 - Performance and Application Concepts
	Application Performance Tools Lab

	Day 5

	Unit 13 - Security
	Security Lab
	Unit 14 - Monitoring and Problem Determination Tools
	Unit 15 - Locking and Concurrency
	Locking and Concurrency Lab