Home About Courses Schedule Services Webinars Contact Search

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

SEE SCHEDULE

Duration: 3 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
    • Pre-migration report review
    • Db2 12 Prerequisites
    • Release Incompatibilities
    • zParm Changes
    • Function Level activation
    • Control of Application Compatibility
  3. 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
  4. 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
  5. Command and Utility Changes
    • New and changed commands
    • Utility changes and performance
  6. Application Enablement
    • SQL PL Enhancements
      • Advanced Triggers
      • Obfuscated DDL for Routines
    • Session tokens
    • Data sharing global transactions
    • DRDA fast load
    • pureXML enhancements
    • JSON support enhancements
  7. SQL Enhancements
    • SQL pagination
    • Piece-wise Deletion
    • Merge enhancements
    • Enhanced global variables
    • Enhanced Array support
    • Changed SQL statements
  8. Key Performance Enhancements
    • OLTP Performance Enhancements
    • Automated Statistics Collection
    • Scalability Enhancements
    • Query Performance Enhancements
    • Access Path Improvements
  9. (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