DB2 UDB for z/OS Database Design, Administration & Performance

 LENGTH OF COURSE:
5 Days

DESCRIPTION: This course is designed to give students the techniques and procedures used to properly Design and Plan the DB2 database Environment. Students will learn the database Design Process and Review the Steps required to Normalize a database in the DB2 Environment. In addition, students will evaluate administration techniques and how to evaluate the performance of DB2 applications.

PREREQUISITES: Working knowledge of DB2 fundamentals, terminology and facilities.

INSTRUCTION TECHNIQUES: A combination of Lecture, Exercises and Labs (when/where available).

AUDIENCE

DB2 Database Administrators, Programmers, Analyst, and Managers.
KEY HIGHLIGHTS:
  • Understand the Relational database and the DB2 Environment
  • Understand the Design, Use, and Establishment of the DB2 Index
  • Design DB2 Views and Construct Views using Data Definition Language
  • Understand How to Load a DB2 Table
  • Demonstrate an understanding of the DB2 Catalog
  • Code and execute DB2 Commands and Utilities
  • Understand Database Administration including:
    • DB2 Utilities
    • DB2 Service Aids
    • Utilities for Inconsistent Data
    • Reorganization of Database
    • Load and Copy Utilities
    • Recover Utilities and Parameters
    • DSN1COPY
    • Printing Tablespaces and Indexspaces
  • Understand the Internal Structure of the DB2 Table


  • Tune a DB2 Table and Related Components
  • Evaluate Stage 1 and Stage 2 Predicates for performance
  • Use EXPLAIN to evaluate SQL performance
  • Discuss Distributed Data and DB2
  • Discuss the Distributed Relational Data Architecture
  • Evaluate the IBM Information Warehouse and Understand DDCS
  • Establish Disk Space Requirement for DB2 Tables
  • Understand the DB2 Security Environment and use the Grant/Revoke Commands
  • Review the Routine and Customary Functions of the DB2 Data Administrator
  • Identify database Design Problems and Performance Issues
  • Review Shop Specific Issues Related to database Design


FROM OUR STUDENT EVALUATIONS...
"Jeff was excellent at keeping the student's interested. His examples were excellent! Excellent at getting class participation! Class was definitely enjoyable."

Madeleine A. Hale
Liberty Mutual Insurance

Return to Home Page.
Return to Alphabetic Listing of Courses.
Return to Courses by Subject.
Request More Information or Contact Us.