Home About Courses Schedule Services Webinars Contact Search

Db2 11 for z/OS New Application Features

SEE SCHEDULE

Duration: 2 Days

Method: Instructor led, Hands-on workshops

Price: $1125.00

Course Code: DB2111


Audience

This course is intended for developers who support applications that run on Db2 for z/OS and are interested in the new features of Db2 11.

Description

This course introduces the attendee to the new SQL, optimization and application features of Db2 11 for z/OS.As with prior releases, Db2 delivers a large number of new features, functions, and enhancements with many specific to the developers.

Objectives

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

  • Understand the new SQL Features of Db2 11
  • Understand the new SQL Optimization Features of Db2 11.
  • Be ready to implement and support these features in applications

Prerequisites

Experience developing, administering or supporting applications that use a previous release of Db2 for z/OS.

Topics

  • I. Db2 11 Overview
    • Db2 11 Features
    • Migration Overview
    • Access Path Stability
  • II. Schema Enhancements
    • Global Variables
    • Transparent Archiving
    • Sequence Enhancements
  • III. SQL Enhancements
    • Grouping Sets
    • Rollup / Cube
    • Native SQL Variable Arrays
    • Pure XML Enhancements
    • Temporal Data Enhancements
    • Global Temporary Table Enhancements
  • IV. Performance Enhancements
    • Stage 1 Predicates
    • Case logic
    • Predicate Pushdown
    • IN / OR Predicate Combinations
    • Like Predicate Enhancements
    • Early Out Join Processing
    • Missing Statistics
    • Explain Table Changes