DB2 Version 8 Update for Developers Course

Description

This course describes the main changes in DB2 UDB for z/OS Version 8. It is intended for application development staff. Students should have a good knowledge of Version 7.

Duration

1 day

Course Outline

1  Programming Enhancements
 - Scalar Fullselect.
 - Common Table Expressions.
 - Recursive SQL.
 - Multi-Row Fetch and Insert.
 - Positioned Update.
 - Insert within Select.
 - Dynamic Scrollable Cursors.
 - GET DIAGNOSTICS.
 - Special Registers and Session Variables.
 - New Built-In Functions.
 - XML Publishing Functions.
 - SQL Limits.

2  Design Enhancements
 - Unicode Support.
 - Longer Names.
 - Identity Columns and Sequences.
 - Partitioned Tables.
 - Indexes.
 - On-line Schema Changes and Versioning.
 - Security Enhancements.

3  Application Performance Enhancements
 - Materialized Query Tables.
 - Varying Length Index.
 - Backwards Index Scan.
 - Data Mismatch Becomes Stage 1.
 - Table UDF Cardinality.
 - Table UDF Materialized Fetch.
 - Trigger Enhancements.
 - Cost-Based Parallel Sort.
 - Multi-Row Performance.
 - Volatile Tables.
 - REOPT(ONCE).
 - Declared Temporary Tables.
 - Non-Correlated EXISTS.
 - Star Join Enhancements.
 - PLAN_TABLE Changes.

4  Client/Server Enhancements
 - Location Aliases.
 - TCP/IP Member Routing.
 - DRDA Data Stream Encryption.
 - Java Universal Driver.

5  Stored Procedure and UDF Enhancements
 - Failure Management.
 - WLM Enhancements.
 - Java Support.
 - SQL Procedures.
 - Development Center.

6  Utility Enhancements
 - RUNSTATS Extra Statistics.
 - Delimited LOAD/UNLOAD.
 - COPY.
 - REORG REBALANCE.
 - Other REORG Enhancements.

7  Catalog Changes

8  Version 9 Preview