DB2 Data Base Administration

Course Number:  610-TF
Recommended Duration:  5 days

Intended Audience
Experienced DB2 programmers and Data Base Analysts who will design and implement DB2 Data Bases.

Course Overview
This course is intended to provide data base administrators (DBAs) with the knowledge and skills necessary to define, manage, and tune DB2 data bases.  The course introduces the techniques of Entity-Relationship Diagrams and Normalization.  This is followed by the DB2 SQL statements for DB2 object definition (CREATE, DROP, and ALTER), and the utilities used by DBAs to load, reorganize, recover, and manage DB2 tables.

Objectives
The student will learn how to normalize a relational database, and how to define DB2 objects, including Data Bases, Storage Groups, Table Spaces, Tables, Indexes, Views, and Aliases.  The student will also develop a proficiency in loading, modifying, backing up, recovering, and tuning DB2 Data bases, using DB2 utilities, services aids, and catalog tables.

Prerequisites
The student entering this course should be familiar with DB2 concepts, have a basic proficiency with SQL data manipulation verbs, have experience in using ISPF/PDF, and should be able to code JCL to run simple batch jobs.

Topics

• DB2 architecture

• Data base design

• Entity / Relationship Model

• Normalization

• Primary and foreign keys

• DB2 objects

• Creating Data Bases, Storage Groups, Table Spaces, Tables, Indexes, Views, Synonyms, and Aliases

• VSAM file allocation

• Referential integrity

• DB2 catalog tables

• Space estimates

• Loading and unloading tables

• Reorganizing table spaces

• Backup and recovery

• Data base tuning

• Application tuning

• Data Security

• Distributed processing