G570 DB2 Data Base Administration

Course Code: G-570
Recommended Duration: 5 Days

Benefits

The student will learn how to normalize a relational database, and how to define DB2 objects, including Data Bases, Table Spaces, Storage Groups, Indexes, Tables, Views, and Aliases. The student will also develop proficiency in loading, modifying, backing up, recovering, and tuning DB2 Data Bases, using DB2 utilities, service 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.

Related IBM Materials

Classroom access to a set of DB2 Reference manuals is desirable, but not required.

Major Topics Include

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 12 machine exercises.

Course Description

DB2 Data Base Administration