Db2 - z/OS to LUW Transition for Developers

Db2 - z/OS to LUW Transition for Developers

Audience

Anyone familiar with Db2 under the z/OS environment transitioning to using Db2 LUW in either Windows, UNIX or Linux.

Prerequisites

Those attending the course should be familiar with Db2 under z/OS.

Duration

3 days. Hands on.

Objectives

To gain a detailed understanding of Db2 LUW for anyone with a mainframe Db2 background.

Course Contents

Introduction
Environment/System Changes.
Upgrade Issues.
Upgrade Performance.

SQL
Query performance improvements.
Temporal data enhancements.
SQL Grouping Sets, including Rollup, Cube.
UDF Changes.
Transparent Archive Query.

Performance
Improvements.
Query transformation improvements SQL.
Enhanced duplicate removal.
Select list do-once.
Column processing improvements.
Data decompression performance improvement.
Suppress-null indexes.
PCTFREE FOR UPDATE.
DGTT.
Extended optimization.
Open dataset limit.

Application Features
Global variables.
SQLPL improvements.
Alias support for Sequence objects.
Row/Column Access Control UNION/UNION ALL support.
Unicode column support for an EBCDIC table.
BIND Changes.

Utilities
REORG changes / Improvements.
DISPLAY UTILITY enhancements.
LOAD.
RUNSTATS.
DSNACCOX.

XML
New Features.
Features Enhancements.
Performance Enhancements.

Other
Db2 11 and zEC12 Synergy.
RAS Improvements.
JSON support.
Db2 Cypress.
QMF.

Virtual Courses

ALL of our courses can be delivered virtually! Our Bath public schedule courses are available as live virtual sessions, using the popular Zoom Virtual Classroom and remote labs. Delegates can test their access at: www.zoom.us/test

Public Courses

On-Site Courses

Can't attend one of our public classes? Booking for multiple people?

All our courses are available on your site! Delivered for your staff, at your premises.

Contact us to find out more...