Home About Courses Schedule Services Webinars Contact Search

Db2 12 for z/OS Transition - What Administrators Need to Know


Duration: 3 Days

Method: Instructor led, Hands-on workshops

Price: $1920.00

Course Code: DB2120

View Related Video


System and Database Administrators who will be performing or supporting a migration from Db2 11 to Db2 12 for z/OS.


This workshop prepares you to support the migration to Db2 12 and to exploit the new features. The course begins with an overview of the migration process and helps you understand what you need to do in order to be ready for the continuous delivery of future Db2 function levels.


Upon successful completion of this course, the student will be able to:

  • Understand the single phase migration process and function level activation
  • Develop pre-migration and post-migration procedures
  • Exploit new features and functions


Significant administration experience on a previous release of Db2 for z/OS.


  • I. Introduction
    • Release Overview
    • Four Major Enhancement Themes
    • Breaking Limits
    • Continuous delivery of new capabilities
  • II. Migration
    • Overview of the Migration Process
    • Pre-migration report review
    • Db2 12 Prerequisites
    • Release Incompatibilities
    • zParm Changes
    • Function Level activation
    • Control of Application Compatibility
  • III. System Administration Enhancements
    • Bufferpool Changes
    • Automatic Statistics Collection
    • EDM Pool Management
    • Resource Limit Facility for Static SQL
    • Dynamic SQL Access Path Stability
    • Insert Algorithm 2
  • IV. Database Administration Enhancements
    • Partitioned Tablespace Evolution
      • Absolute Page Numbering
      • Relative Page Numbering (RPN)
    • Online Schema Enhancements
    • Object Ownership Transfer
    • Temporal table changes
    • LOB Compression
    • Key DDL changes
  • V. Command and Utility Changes
    • New and changed commands
    • Utility changes and performance
  • VI. Application Enablement
    • SQL PL Enhancements
      • Advanced Triggers
      • Obfuscated DDL for Routines
    • Data sharing global transactions
    • DRDA fast load
    • pureXML enhancements
    • JSON support enhancements
  • VII. SQL Enhancements
    • SQL pagination
    • Piece-wise Deletion
    • Merge enhancements
    • Enhanced global variables
    • Enhanced Array support
    • Changed SQL statements
  • VIII. (Optional) Db2 for z/OS Profile Tables
    • Profile Tables
    • Monitoring Remote Connections & Threads
    • Setting Special Registers and Global Variables
    • Subsystem property changes
    • Profiles and Query Acceleration