DB2 DBAs - From z/OS and OS/390 to Cross Platform
 

This 3 day course:

is intended for the DB2 for z/OS and OS/390 DBA who now faces the task of managing and administering cross-platform databases. During this session we discuss the differences between the various platforms and the DB2 database managers. Emphasis is placed on the administrative responsibilities, the physical differences in the environments, database structures and operational and recovery procedures. Leverage your existing knowledge and explore the differences, not the commonality, between the environments and the database objects.

Topics Covered:

• Inroduction to the Different Environments
• Workstation Based Tools
• Working with DB2 Commands
• Data Structure Differences
• Operations & Recovery
• Working with Data
• Performance Tuning

Duration: 3 days

Delivery: Class lecture

Audience: 

Experienced DB2 for z/OS and OS/390 DBAs and Application Developers who will design, develop and implement DB2 UDB Cross Platform Databases.

Outline:

1. Introduction to the Different Environments

Platforms Supported
Instances vs Subsystems
Environment Variables
Profile Registry
DB2 Administration Server DAS
Node & Database Configuration Files
Labs

2. The Workstation-based Tools

Administration Tools
Control Center
Command Center
Script Center
Journal
Alert Center
DDA
Performance Monitor
Labs

3. Working with DB2 Commands

Database support with Command Center
Using CLP(Command Line Processor)

4. Database Structure Differences

Database Objects
Node groups
Storage Objects
Tablespaces
Containers
Buffers
Initial Table Spaces
System Catalog Tables
Database Directories
Database Recovery Log
Labs

5. Operations & Recovery

Recovery Environment
Log Files
Circular Logging
Active Logs
Archive Logging
Recovery History
Backup & Recovery
Data Movement
Performance Aids
Labs

6. Working with Data

File Formats
Importing / Exporting
Load Utility
Labs

7. Performance Tuning

Visual Explain
Controlling the Optimizer
DB2 LOOK
Reorganization of Tables
Labs