Db2 12 for z/OS Transition for SQL Developers

SEE SCHEDULE

Duration: 1 Day

Method: Instructor led, lecture only.

Price: $600.00

Course Code: DB2112

Audience

SQL Developers that regularly use Db2 for z/OS as a development platform.

Description

Learn all about the new SQL features of Db2 for z/OS in this fast paced one day course! We'll focus only on the features that relate directly to application development.

Objectives

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

Effectively use the new features of Db2 12 for z/OS
Understand how new features will be delivered going forward

Prerequisites

A working knowledge of Db2 for z/OS.

Topics

I. Db2 12 Overview
- Why Db2 12?
- Phases of the Migration
II. Continuous Delivery of New Functions
- Overview of currently available function levels
- Controlling new features and incompatibilities at the application level
- APPLCOMPAT bind parameter
III. Temporal Table Enhancements
- Business Time Control
- System Time Enhancements
  - Track all SQL modifications
  - Track who modified data
  - Logical Transactions
IV. SQL Enhancements
- MERGE Statement Overhaul
- Piece-wise DELETE
- SQL Pagination (scroll forward/back queries)
V. SQL Performance
- Sort Improvements
- Execution time adaptive indexes
- Expression sharing
- Access path stability features