DB2 Version 7 Update Course

Description

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

Duration

2 days

Course Outline

1 Programming Enhancements
 - Row Value Expressions.
 - Union Everywhere.
 - Scrollable Cursors.
 - Fetch First n Rows.
 - Self-Referencing Update and Delete.
 - New and Changed Functions.
 - Precompiler Services.

2 Design Enhancements
 - Enhanced Management of Constraints.
 - Identity Column Enhancements.
 - SQL Scalar Functions.
 - UNICODE Support.
 - REXX Support.
 - Java Support.
 - Index Advisor.

3 Application Performance Enhancements
 - IN-List Index Parallelism.
 - Correlated Subquery Transformation.
 - MIN/MAX Changes.
 - Join Column Mismatch.
 - VARCHAR Index Only Access.
 - Fewer Sorts for ORDER BY.
 - Plan Table Changes.
 - Star Join.
 - SQL Performance Analyzer.

4 Client/Server Enhancements
 - Global Transactions.
 - Security Enhancements.
 - Network Monitoring Enhancements.
 - DB2 Connect Connection and Transaction Pooling.
 - XML Extenders.

5 Stored Procedures Enhancements
 - COMMIT and ROLLBACK.
 - SQL Procedures.
 - Java Procedures and UDFs.

6 Utility Enhancements
 - Dynamic Utilities.
 - Unload Utility.
 - EXEC SQL and Cross Loader
 - Load Partition Parallelism.
 - On-line Load Resume.
 - On-line Reorg Enhancements.
 - Copytocopy Utility.
 - Recover Changes.
 - Statistics History.
 - New Utility Packaging.

7 Operational Changes
 - On-Line DSNZPARM Change.
 - SET LOG SUSPEND/RESUME.
 - Critical Log Read Error Retry.
 - Time Interval Checkpoint Frequency.
 - Long Running UR Warnings.
 - Consistent Restart Enhancements.
 - Asynchronous Preformat.
 - Partition Datasets Parallel Open.
 - Command Changes.
 - Security Changes.
 - Trace Changes.
 - DB2 PM Changes.
 - VSAM Data Striping.

8 Data Sharing Enhancements
 - CF Name Class Queues.
 - Group Attach.
 - IMMEDWRITE.
 - Restart Light.
 - Persistent CF Structure Sizes.

9 Features and Tools
 - DB2 Management Client Tools.
 - Database Administration Tools.
 - Performance Management Tools.
 - Recovery and Replication Tools.
 - Application Management Tools.

10 Installation and Migration
 - Migration from V5 or V6.
 - Data Sharing Migration.

11 Catalog Changes

12 Version 8 Preview