DB2 UDB z/OS v8 Features and Migration Course

This course covers a Technical Introduction to the following NEW Features of DB2 UDB for z/OS Version 8
>DB2 support for 64 bit storage
>Increased Number Of Partitions & new function
>More Complex Join statements
>SQL enhancements
>Dynamic Scrollable Cursors
>Multi-row FETCH and INSERT
>GET DIAGNOSTICS statement
>Recursive SQL
>Sequence Objects
>Scalar full select
>Select statement in an insert statement
>Fundamentals and implementation of Unicode
>Delimited LOAD and UNLOAD
>Data Partitioned Secondary Index (DPSI)
>Performance enhancements
>Index Support functions
>Volatile Tables
>New functions for Visual Explain
>Installing / Migrating DB2 UDB for z/OS Version 8
>Changes to the DB2 Catalog
>Materialized Query Tables
>Common Table Expression

Upon completion of this course, the participant will be able to:
> Describe the DB2 support for 64 bit storage
> Discuss the support provided for an Increased Number Of Partitions and New Partitioned Table         Function
> Describe the new features allowing more Complex Join Statements
> Describe Unicode in DB2 for z/OS
> Relate the implications of Volatile Tables
> Describe the new functions for Visual Explain
> Describe the process of installing, migrating and fall back DB2 UDB for z/OS Version 8
> Describe the changes to the DB2 catalog

Day 1
Why 64-bit Addressing (128 Petabytes)?

V8 – CM, ENFM, NFM - modes

SQL Changes
225 Tables in a Join
Common Table Expression / WITH
Scalar Full Select
Distinct, Distinct, Distinct
Final Table / Input Sequence
Select To Verify Insert
Identity / Sequence
Dynamic SQL – CLOB
Materialized Query Tables
Triggers

Partition Table Changes
CL(ustering) vs. P(artition)ED vs. P(artition)ING
SI - DPSI – NPI
INDEX-controlled partitioning vs. TABLE-controlled partitioning
ADD partition, ROTATE partition, Alter Partition BOUNDARY, REBALANCE partition

Application Programming Changes
Dynamic Scrollable Cursors
Fetch into ARRAY / Insert from ARRAY
GET DIAGNOSTIC
UNICODE – Code Pages – Code Points

DB2 catalog Changes

Day 2
Additional Technical Topics - System
New Functions
Multiple Level Security (MLS)
Stored Procedures
Networking
New DB2 Limits
True Variable Length Column Index
Performance (V7 vs V8) – mismatch data types & string length, transitive closure, join column sequence
Cost Based Parallel Sort
Volatile Tables
Star Join
Dynamic Temporary Tables ON COMMIT DROP
Miscellaneous Features

Additional Technical Topics - Performance
Backward Index Scan
Other Perform Items – REOPT(ONCE) vs REOPT(ALWAYS)
IN List predicate pushdown
Plan_Table Changes – V6, V7, V8
Visual Explain
UDF Table Function – CARDINALITY

Additional Technical Topics - Utilities
LOAD / UNLOAD delimited
RUNSTATS – Distributes Stats on non-index cols
REORG / REBUILD – Scope Pending

Hands-On Workshop - Using DB2 UDB for Windows to "practice" using the latest Application Features of DB2 UDB for z/OS Version 8

Six months of experience using DB2 UDB for z/OS Version 7 is recommended.
Read / reviewed the IBM publication What's New DB2 UDB for z/OS Version 8 and / or DB2 Version 8 – Announcement Letter Overview.