DB30 - DB2 Version 11 Transition - 2 Days


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.

View Dates

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.

On-site course enquiry (from £165 pp per day)

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.


Availability

Course Enquiry