DB2 11 Transition and Update

The course is designed to introduce delegates using DB2 to the new features available to them in version 11.

DB2 Analysts, Systems Programmers, Applications Programmers, etc...  The emphasis on certain subjects will be adjusted to reflect the audience; for example if the delegates on the course are all applications programmers then less in depth teaching will be given for the UTILITIES part of the course.

Those attending the course should be familiar with DB2.

The course is designed to instruct those delegates using DB2 as Analysts, Systems Programmers, Applications programmers, or Administrators in all aspects, relevant to their working Environment, with the new features available to them with VERSION 11, for CM and NFM mode.

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.