Overview

This course teaches you how to perform basic database administration tasks using DB2 9. These tasks include creating

DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements. New features, such as range partitioning, data row compression, and pure XML (native XML storage) will be introduced.

requirements, to ensure that your system meets the minimum requirements for this course.

Training Paths that reference this course are:

PureData System for Transactions - Database Administrator

Database Administration - DB2 BLU Acceleration

Database Administration - Single Partition

Audience

This intermediate course is for System administrators, database administrators, and technical personnel involved in planning, implementing, and maintaining DB2 databases.

Prerequisites

You should be able to:

Use basic OS functions such as utilities, file permissions, hierarchical file system, commands, and editor

State the functions of the Structured Query Language (SQL), and be able to construct DDL, DML, and authorization statements

Discuss basic relational database concepts and objects such as tables, indexes, views, and joins

These skills can be developed by taking:

OS Training:

Course Outline :: 2L232G: DB2 9 Administration Workshop for Windows (SPVC)::

o AIX 5L Basics o Linux Basics and Administration o Windows Systems Administration o Or by having equivalent HP-UX or Solaris administration experience

DB2 SQL Workshop

DB2 Fundamentals

Key Topics

Overview of DB2 on Linux, UNIX and Windows

Command Line Processor (CLP) and GUI usage

The DB2 environment

Creating databases and data placement

Creating database objects

Moving data

Backup and recovery

Locking and concurrency

Problem determination

Security

Objectives