DB2 UDB Database Administration

Course Number:  707-JK
Recommended Duration:  5 days

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

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

DB2 UDB Version 8.1.  Course is suitable for shops still running DB2 UDB version 7; some exercises will not apply.

Prerequisites
Students should have at least six months SQL (DB2, Oracle, etc...) database administration experience or 6 months recent experience designing and coding application programs using DB2 UDB, or have completed one of a "DB2 UDB Programming" course.

Topics

• DB2 UDB architecture

• Data base design

• Interactive tools and control center

• Entity / Relationship Model and Normalization

• DB2 objects

• Databases and tablespaces

• File allocation with SMS and DMS

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

• Understanding materialized query tables

• Referential integrity (Primary and foreign keys)

• DB2 catalog tables

• Loading tables

• Reorganizing table spaces

• Backup and recovery

• Stored procedures and stored procedure builder

• User-Defined Functions (UDFs)

• Database triggers

• Visual explain and efficiency considerations

• Data base tuning

• Application tuning

• Data security