Home About Courses Schedule Services Webinars Contact Search

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

SEE SCHEDULE

Duration: 3.0 days

Method: Instructor led, Hands-on workshops

Price: $1920.00

Course Code: DB2120



View Related Video

Audience

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

Description

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.

Objectives

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

Prerequisites

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

Topics

  1. Introduction
    • Release Overview
    • Four Major Enhancement Themes
    • Breaking Limits
    • Continuous delivery of new capabilities
  2. Migration
    • Overview of the Migration Process
    • Db2 12 Prerequisites
    • Release Incompatibilities
    • zParm Changes
    • Function Level activation
    • Control of Application Compatibility
  3. Key Performance Enhancements
    • OLTP Performance Enhancements
    • Automated Statistics Collection
    • Scalability Enhancements
    • Query Performance Enhancements
    • Access Path Improvements
  4. Database Administration Enhancements
    • Online Schema Enhancements
    • Object Ownership Transfer
    • Temporal table changes
    • Partition Management
    • RTS tables improvements
    • LOB Compression
    • Key DDL changes
  5. Command and Utility Changes
    • New and changed commands
    • Utility changes and performance
  6. Application Enablement
    • Obfuscated data definition statements
    • Session tokens
    • Data sharing global transactions
    • DRDA fast load
    • pureXML enhancements
    • JSON support enhancements
    • Additional Enhancements
  7. SQL Enhancements
    • Advanced triggers
    • SQL pagination
    • Merge enhancements
    • Enhanced global variables
    • Enhanced Array support
    • Changed SQL statements