Format

Classroom

Duration

6.0 Day(s)

Description

This course teaches you how to perform basic database administration tasks using IBM DB2 Universal Database. These tasks include creating and populating databases and implementing a logical design to support recovery requirements.

Audience

Database Administrators and other technical personnel who are involved in planning, implementing, and maintaining DB2 databases.

Prerequisites

Before taking this course you should be able to:
o Use basic operating system functions such as utilities, file permissions, hierarchical file system, commands, and editor
o State the functions of the Structured Query Language (SQL) and be able to construct DDL, DML, and authorization statements
o Discuss basic relational database concepts and objects such as tables, indexes, views, and joins

These skill can be developed by taking
o OS Training
- AIX/6000 for Users or AIX Version 4 Basics
- OS/2 for Users
- Administering Microsoft Windows NT 4.0
o SQL Workshop
o DB2 Universal Database Fundamentals

Objectives

After completing this course, you should be able to:
o List and describe the components of DB2 Universal Database
o Implement DB2 security
o Perform basic administration of a DB2 database system
o Define a basic DB2 recovery strategy and perform the tasks
necessary to support the strategy
o Describe the application development process with respect
to DB2 considerations

Contents

o Overview of DB2 Universal Database
o Getting Started with DB2 UDB GUIs
o Creating Databases and Tablespaces
o Creating Objects
o Moving Data
o Recovery
o Monitoring/Problem Determination
o Concurrency
o Application Alternatives
o Application Performance
o Security