DB2 Database Design & Administration
Duration
Five Days
Abstract
This course provides attendees with a comprehensive introduction to designing and administering DB2 databases. The course covers the complete spectrum from initial data model, through logical and physical database design, data security, and ongoing administration to ensure that the data remains complete, consistent, and in its most efficient state.
Audience
This course is of interest to anyone needing an understanding of the design, implementation, and ongoing support and maintenance of DB2 databases.
Pre-requisites
A fundamental understanding of the DB2 relational database management system is assumed, as is an understanding of data processing in general. Familiarity with the OS390 or z/OS operating system and TSO/ISPF would also be of benefit.
Release Level
The materials in the course reflect DB2 UDB for z/OS Version 8.
Objectives
- Data modeling techniques
- The process of normalization of data
- Mapping data models to DB2 objects
- Choosing the correct data types, and physical design characteristics
- Data integrity issues
- Page layouts and storage estimations
- Indexing, locking strategy and other performance implications
- Use of utilities and service aids in ongoing maintenance
- Security and auditing considerations.
- Program preparation and bind
