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.