DB2 UDB Version 7 for z/OS and OS/390 Transition
 

This 2.5 day course:

is an in-depth look at the many new and enhanced features of DB2 UDB for z/OS and OS/390 Version 7. Not only are you introduced to the features but we also provide you with details on how to utilize the features and provide an extensive set of examples. Attend this course prior to migrating to Version 7 to obtain the knowledge required to build your migration plan and to select and implement the new features that best fit your environment. The course covers new and changed functionality, migration planning and fallback. The course is modularized; it is recommended that application personnel attend the first day and database and systems personnel attend all 2.5 days.

Topics Covered:

• DB2 UDB for z/OS and OS/390 Version 7 Enhancements Overview
• Application Enhancements
• Network Computing
• DB2 Features & Tools
• Performance & Availability
• Database Administration & Utilities
• DB2 Data Sharing
• Installation & Migration

Duration: 2.5 days

Delivery: Class lecture

Audience: 

All personnel who require update information pertaining to DB2 UDB for z/OS and OS/390 Version 7.

Prerequisites: none

Outline:

1.  Version 7 Enhancements Overview

     What's New?
     DB2 V7 Packaging
     Release incompatibilities
     Planning Task List

2.  Application Enhancements

     SQL Enhancements
         UNION everywhere
         Constraints
         Row expressions
         Limiting fetch
         Self-referencing UPDATE/DELETE
     Language support
         Precompiler support
         Java
         SQL Procedures
     Query performance enhancements
     PLAN_TABLE changes
     Bind Changes

3.  Network Computing

     Family Compatibility
     Global transactions
     DB2 XML Extenders
     Security enhancements
     UNICODE
     Monitoring

4.  DB2 Features and Tools

     Features
         Client Tools
         Net.Data
         Warehouse Manager
         QMF
         DB2 Net Search Extender
     DB2 Tools

5.  Database Administration

     DDL & DCL Changes
     More DBADM Authority
     Enhanced management of constraints
     improved Thread Management
     Comprehensive Statistics History
     Real-time Statistics

6.  Utilities

     New Packaging
     Dynamic utility jobs
             LISTDEF
             TEMPLATE
             OPTIONS
     New utilities
             UNLOAD
             CopytoCopy
             Cross Loader
     Utility Changes

7.  Performance & Availability

     DB2 and z/OS
     Query performance enhancements
     Index Advisor
     Online subsystem parameters
     Log manager enhancements
     Restart enhancements

8. DB2 Data Sharing

     Coupling Facility
     Group Attach
     IMMEDWRITE Bind
     Restart Light

9.  Installation & Migration

     Installation
     Migration & Fallback
     Release incompatibilities Review
     Data Sharing coexistence