DB2 Data Base Administration
Course Title: DB2 Data Base Administration
Course#: DB13T
Duration: 5 days
Overview:
The student will learn how to normalize a relational database, and how to define DB2 objects, including Data Bases, Storage Groups, Table Spaces, Tables, Indexes, Views, and Aliases. The student will also develop a proficiency in loading, modifying, backing up, recovering, and tuning DB2 Data bases, using DB2 utilities, services aids, and catalog tables.
Topics:
Exercises:
There are ten machine exercises, and two paper exercises.
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.
Course#: DB13T
Duration: 5 days
Overview:
The student will learn how to normalize a relational database, and how to define DB2 objects, including Data Bases, Storage Groups, Table Spaces, Tables, Indexes, Views, and Aliases. The student will also develop a proficiency in loading, modifying, backing up, recovering, and tuning DB2 Data bases, using DB2 utilities, services aids, and catalog tables.
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 and unloading tables
- Reorganizing table spaces
- Backup and recovery
- Data base tuning
- Application tuning
- Data Security
- Distributed processing
Exercises:
There are ten machine exercises, and two paper exercises.
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.
Clients
