Office of Administration - Information Technology Services

Information Technology Services

DB2 Database Design & Administration

Duration: 5 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.

Prerequisites:

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 :

Attendees learn:

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

Scheduled Classes