Michael Turner Limited

DB2 Version 8 Update Course

Description

This course describes the main changes in DB2 UDB for z/OS Version 8. It is intended for DBAs, systems programmers, and operations staff. Students should have a good knowledge of Version 7.

Duration

2 days

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 Changes.
 - BACKUP and RESTORE SYSTEM.
 - REPAIR.

7  Operational Changes
 - 64-bit Support.
 - More Log Datasets.
 - Log Striping.
 - Control Interval Sizes.
 - Smart Extent Sizes.
 - Command Changes.
 - DSNZPARM Changes.
 - Instrumentation Enhancements.

8  Data Sharing Enhancements
 - Performance Enhancements.
 - Improved LPL Recovery.
 - Restart Light Enhancements.
 - IMMEDWRITE Changes.

9  Installation and Migration
 - Prerequisites.
 - Unicode Setup.
 - Compatibility Mode.
 - Enabling New Function Mode.
 - New Function Mode.

10 Catalog Changes

11 Version 9 Preview