DB30 - DB2 Version 11 Transition
Duration2 Days (customisation)
Availability

Course Description

This course is aimed at Systems Programmers, Programmers and DBA's who need to understand the new features and facilities of DB2 Version 11. This lecture based course covers all of the new features in detail.

Pre-requisites

A strong working knowledge of DB2 Version 10 is required to attend this course.

Environment

The lectures apply to DB2 running in a z/OS environment.

Customisation

For on-site courses (i.e. at your premises), we are more than happy to tailor the course agenda to suit your exact requirements. In many cases, we are able to build your in-house standards and naming conventions into the delivered course.

Course Details

SYSTEM ENHANCEMENTS
Synergy with IBM zEnterprise, System z and z/OS
Using zIIP speciality processors
Cancel thread and cancel SQL statement improvements
Continuous block fetching
Support for global variables
Local stored procedure execution improvement
Connectivity improvements
SCALABILITY ENHANCEMENTS
Extended RBA and LRSN
NOT LOGGED for declared global temporary tables
More open data sets (DSMAX)
PBG mapping tables to lift the 64 GB limit
AVAILABILITY ENHANCEMENTS
Online schema changes and enhanced recovery options
Automatic recovery of indexes from GRECP or LPL status
Improved availability when altering limit keys
Work file database enhancements
Governing of parallel processing of utilities
Compression dictionary availability for CDC tables
DROP column support
Defer define object enhancements
Allow BIND, REBIND, and DDL to break-in persistent threads
Idle thread break-in
SQL ENHANCEMENTS
Global variables
Array data type
Aliases and public aliases for SEQUENCES
New built-in functions
SET CURRENT APPLICATION COMPATIBILITY
Temporal special registers
Temporal support on VIEWs
DGTT
CUBE, ROLLUP and GROUPING SETS
LIKE_BLANK_INSIGNIFICANT DSNZPARM
APPLICATION ENHANCEMENTS
Ensuring application compatibility
Transparent archiving of temporal data
Providing support for big data
Using the scoring adapter to add predictive analytics to OLTP applications
Using JavaScript Object Notation with IBM DB2
Suppressing null indexes
XML ENHANCEMENTS
XQuery support
XML performance enhancements
XQuery FLWOR expressions performance enhancements
XMLTABLE performance enhancements
SECURITY ENHANCEMENTS
Enhancements for exit authorization checking
Enhancements to program authorization
Column masking enhancements
UTILITY ENHANCEMENTS
Online REORG enhancements
Enhanced statistics
Backup and recovery enhancements
LOAD and UNLOAD enhancements
Compression dictionaries for Change Data Capture
General enhancements
Deprecated functions
PERFORMANCE ENHANCEMENTS
Reduced need for REORG
More opportunities for RELEASE(DEALLOCATE)
Optimizer enhancements
DATA SHARING ENHANCEMENTS
Group buffer pool write-around protocol
Improved castout processing
Improved DELETE_NAME performance
Restart light with CASTOUT option
Locking enhancements
Index availability and performance
Group buffer pool write performance
Automatic LPL recovery at end of restart
Log record sequence number spin avoidance

Course Format

The course is purely lecture based and contains no practical exercises. A comprehensive Student Guide is supplied which contains detailed documentation of the new version together with many syntax examples where relevant. Delegates will also be able to access a free help-line with technical questions relating to topics covered on the course.