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".