DB2 UDB for z/OS and OS/390 Version 6 Transition Overview

This 1 day course is intended for:

Experienced System Administrators, Data Base Administrators and Lead Application designers who will be participating in the Migration and/or implementation of DB2 UDB for z/OS and OS/390 Version 6. The course introduces the attendee to the many new and enhanced features of DB2 UDB for z/OS and OS/390 Version 6 and details migration considerations.

Topics Covered:

• Object-relational extensions and active data
• Network computing Enhancements
• Performance and availability Enhancements
• DB2 Utility Enhancements
• Data sharing enhancements
• User Defined Functions, Data Types and Triggers
• Migration Considerations

Objectives:

The course introduces the attendee to the many new and enhanced features of DB2 UDB for z/OS and OS/390 Version 6 and details migration considerations

Duration: 1 day

Delivery: Class Lecture

Audience: 

System Administrators, Data Base Administrators and Lead Application designers.

Prerequisites:

Working knowledge of DB2 for OS/390 Version 5

NOTE:

This session is an overview. It covers a great deal of information in a short amount of time.

Outline

1. DB2 UDB for z/OS and OS/390 Version 6 Migration & Implementation Introduction

Functional Enhancements
Migration considerations
Release Incompatibilities
Preparing for fallback
Planning Task List
Pre-Migration Plan
Migration

2. Subsystem Management and Install Enhancements

xxxMSTR Enhancements and Changes
Checkpoint Frequency Control
Logging Enhancements
Restart and Recovery Enhancements
IRLM Enhancements
Monitoring Enhancements
xxxxDBM1 Enhancements and Changes
Data Space Storage Pools
Buffer Pools in Data Spaces
Buffer Steal Algorithm
8KB and 16KB Page Size
VDWQT as Number of Pages
Set Default Buffer Pools
EDM Pool Relief
Data Sharing Enhancements
GBP Duplexing
New GBP Caching Options
Distributed Processing
DB2 Database Connection Pooling
DRDA Support for Three-part Names
Moving from Private Protocol to DRDA
Capacity Improvements
EA-enabled page sets
Performance Enhancements

3. Data Base Administration Enhancements

Functional Enhancements
Altering variable length columns
New ROWID data type
Rebalancing a Partitioned Tablespace
Utility Performance Improvements
Utility Functional Enhancements
Related Enhancements

4. Object-relational Extensions and Active Data

Large Objects (LOBs)
Working with large objects (LOBs)
Introduction to defining LOBs
Declaring LOB host variables and LOB locators
LOB system processing
Managing buffer pools for LOBs
Locking LOBs
Recovering table spaces that contain LOBs
Creating and Using Distinct Types, User-Defined Functions and Triggers
Distinct Types (User defined data types)
User-defined functions
Triggers
Accessing transition tables in a user-defined functions
Considerations

5. SQL and Application Enhancements Overview

Summary of SQL Changes
Query Enhancements
Predictive governing
Giving optimization hints to DB2
Productivity Enhancements