DB2 10 for z/OS – Getting there from DB2 Version 9 (DB2109)

Request a Quote for this class

About this Course

Getting ready to make the leap directly from DB2 Version 9 to DB2 10? We’ll help you prepare for the significant changes you’ll experience and help you take advantage of features that will help you improve the performance and functionality of the applications you support.

Audience Profile

Database Administrators and System Administrators that will be involved in planning, supporting and implementing a migration to DB2 10 for z/OS from DB2 Version 9.


Significant experience administering or supporting applications that use DB2 for z/OS.

Course Outline

1. Overview of DB2 10

  • Why Migrate?
  • Migration Phases
  • Enhancements vs. New Functions
  • Pre-Migration Checklist

2. Migration Survival

  • DB2 Catalog and Directory Changes
  • SMS Required!
  • Security Changes
  • DBM1 Storage Utilization Changes
  • zPARM Changes
  • Tablespace Default Changes
  • Changes in Utility Behavior
  • Changes in Bind Behavior

3. Schema Enhancements

  • Online Schema Changes
  • Pending Definition Changes
  • Hash Access Data Organization
  • Additional non-key columns in a unique-Index
  • Compress on Insert
  • Rotating Partitions
  • Temporal Data and Versioning

4. Utility Enhancements

  • Autonomic Statistics
  • Recover Enhancements
  • Utility Performance Enhancements
  • UTSERIAL elimination

5. Security Enhancements

  • Policy-based auditing
  • Granular Authorization Control
  • Changes to System Privileges
  • Row and Column Access Control

6. Optimizer and Performance Changes

  • IBM Data Studio Query Tuner
  • General Performance Improvements
  • Explain Table Changes
  • Access Plan Stability
  • Instance- based statement hints
  • New Bind Procedures
  • Access to Currently Committed Data

7. Application Enablement

  • Support for Temporal Data
  • New universal language interface module DSNULI
  • Extended Indicator Variables support
  • SQLPL Enhancements

8. SQL Enhancements

  • New SQL Statements
  • New and Improved Functions
  • Implicit Casting of Datatypes
  • Unicode Support
  • OLAP moving aggregates
  • pureXML