DB2 UDB for OS/390 Version 6 Transition
 

This 3 day course is intended for:

System Administrators, Data Base Administrators and Lead Application designers who will be participating in the Migration and/or implementation of DB2 UDB for OS/390 Version 6. The course introduces the attendee to the many new and enhanced features of DB2 UDB for  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:

Describe the new features and functions of:

• DB2 UDB for OS/390 Version 6
• Identify Release Incompatibilities
• Evaluate the applicability of the new features to your environment
• Develop a Plan for migrating DB2 Version 5 to Version 6

Duration: 3 days

Delivery: Class Lecture

Audience: 

System Administrators, Data Base Administrators and Lead Application personnel.

Prerequisites:

Working knowledge of DB2 for OS/390 Version 5

NOTE:

 Systems and Database personnel should attend all 3 days.
Application personnel may wish to attend only the first 2 days.

Outline:

Day 1

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

What's New
Functional Enhancements
Migration considerations
Release Incompatibilities
Preparing for fallback
Planning Task List
Pre-Migration Plan
Migration

2. SQL and Application Enhancements Overview

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

3. Network Computing & Stored Procedures

Network Enhancements
DRDA Support for three-part names
OPTIMIZE FOR n ROWS
ODBC Support
Stored Procedures Enhancements
New Language support
SQL Procedures

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
Recovery: table spaces contains LOBs

Day 3

9. Subsystem Management and Install Enhancements - Part 1

xxxxMSTR 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

10. Subsystem Management and Install
     Enhancements - Part 2

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
Stored Procedure Enhancements
Improved Data Transfer with
OPTIMIZE FOR n ROWS
Java enablement
SQLJ
JDBC application support
DB2 ODBC enhancements
Dynamic SQL Performance
Enhancements
Capacity Improvements
EA-enabled page sets
Performance Enhancements

Day 2

5. Creating and Using Distinct Types and User-Defined Functions Distinct Types (User defined data types)

Creating and using distinct types
 functions
Invoking functions with distinct types
Prepare User-defined Function for
Execution
Casting User-defined Function
Arguments

6. Creating and Using Triggers

Parts of a Trigger
Triggers:
Perform Actions or use Logic
Invoke User-defined Function
Invoke a Stored Procedure
Accessing transition tables in a user-defined function
Considerations

7. Data Base Administration Enhancements

Part 1 Functional

 Enhancements DDL Changes CREATE/ALTER database object extensions
Altering variable length columns
New ROWID data type
Catalog Changes
New Object Support DDL

8. Data Base Administration Enhancements

Part 2 Utility Changes

Utility Performance Improvements
Utility Functional Enhancements
Enhanced database commands