DB2 UDB for z/OS and OS/390 Data Base Administration
 

This 4.5 day course:

provides the attendee with the skill set required to conduct a physical database design, perform database implementations and to maintain DB2 for z/OS and OS/390 databases in an ongoing production environment.
 

Topics Covered:

• DB2 and the z/OS and OS/390 Environment
• Database Structures & Design
• Database Design Implementation
• Operations & Recovery
• Introduction to Performance

Duration: 4.5 days

Delivery: Class lecture

Audience: 

DB2 Database Administrators, Data Administrators and Analysts who will be designing, implementing and/or maintaining DB2 for z/OS and OS/390 databases.

Prerequisites:

An understanding of the relational data model and SQL.

Outline:

1. DB2 and the z/OS and OS/390 Environment

 DB2 Structural Overview
 DB2 and OS/390
 Address Spaces
 Systems Services
 Database Services
 IRLM
 Distributed Data Facility
 Stored Procedures
 DB2 Data Sharing Overview
 DB2 and Storage Management
 DB2 and RACF
 Attachment Facilities
 Data Structure Management
 Commands & Utilities Overview
 Data Access
 The Logical to Physical Transition Process
 Workshop #1

2. Database Structures - Part. 1

 Databases
 Storage Management Choices
 Tablespaces
 Workshop #2
 Table Design
 Column Design
 Workshop #3

3. Database Structures - Part 2. Data Access & Data Integrity

 Indexes
 Workshop #4
 Data Integrity
 Referential Integrity
 Constraint Rules
 UDTs & UDFs
 Using Views
 Triggers
 The DB2 Catalog
 Workshop #5

4. Loading & Managing DB2 Databases

 Design Implementation
 Load Utility
 Check Utility
 Copy Utility
 Workshop #6

5. Operational Utilities

 Runstats Utility
 Analyzing Statistics
 Reorg Utility
 Workshop #7

6. Database Backup & Recovery

 Backup & Recovery Procedures
 Full vs Incremental Copies
 Utilities: CopyMergecopy
             Quiesce    Report
             Recover      Modify
 Workshop #8

7. Database Performance

 RDS & Access Paths
 Indexes
 Access Path Selection
 Filtering
 Predicate Types
 Matching Indexes to Predicates
 DB2 Locking
 Locking Strategies
 Tuning for Optimum Concurrency
 Workshop #9