Course Description

DB2 Data Base Administration

This course: course objectives; course outline;
DB2 curriculum; Topic list; Course list; Home page
 

Benefits

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 profecincy in loading, modifying, backing up, recovering, and tuning DB2 Data bases, using DB2 utilities, services aids, and catalog tables.

Audience

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

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.

IBM Materials Required

Access to current versions of DB2 Command Reference, DB2 Utility Guide and Reference, and DB2 SQL Reference

• 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

Exercises

There are ten machine exercises, and two paper exercises.