Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More DB2

Related Courses

DB2 Database Administration

Recommended Duration:
5 Days
Version
DB2 Version 7. Class is suitable for those using DB2 version 5 or 6 also.
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 6 months recent experience designing and coding application programs using SQL in DB2, in one or more environments (CICS, IMS/DB/DC, TSO, or batch) in which DB2 is used and recent experience using ISPF (especially the text editor) and should be able to code JCL to run simple batch jobs or have completed the "DB2 Application Programming" course within the last 12 months.
Major 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 tables
  • Reorganizing table spaces
  • Backup and recovery
  • Data base tuning
  • Application tuning
  • Data Security
  • Distributed processing 
Exercises
There are nine machine exercises.
Notes
This course overlaps 30% with "Advanced DB2 Application Programming".