About this Course

This course introduces the attendee to the new SQL, optimization and application features of DB2 11 for z/OS

As with prior releases, DB2 delivers a large number of new features, functions, and enhancements with many specific to the developers.

Audience Profile

This course is intended for application developers, database administrators, DB2 system programmers and application architects.

At Course Completion

Upon successful completion of this course, the student will be able to:

• Understand the new SQL Features of DB2 11
• Understand the new SQL Optimization Features of DB2 11
• Be ready to implement and support these features in applications

Prerequisites

Experience developing, administering or supporting applications that use a previous release of DB2 for z/OS.

Course Outline

1. SQL Enhancements

• Recap of SQL Groupings
• New SQL Grouping Sets
• Online Schema Changes
• Global Variables
• SQL Compatibility
• Temporal Table Views
• GTT Improvements
• SQL PL Improvements
• XML Improvements

2. DB2 11 Optimization Features

• More Stage 1 Predicates
• Distinct/Group By Improvements
• Page Range Screening for joins
• New APREUSE (Warn)
• Extended Log Record Addressing
• RUNSTATS enhancements
• More hash join support
• Enhanced Case expressions to support indexability
• More predicate pushdown