Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More DB2

Related Courses

DB2 UDB Database Administration

Recommended Duration:
5 Days
Version
DB2 UDB Version 8.1. Course is suitable for shops still running DB2 UDB version 7; some exercises will not apply.
Benefits
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.
Audience
Experienced DB2 programmers and Data Base Analysts who will design and implement DB2 Data Bases.
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..
Major 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 Materielized 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 
Exercises
There are sixteen hands-on exercises.