DB2 Version 8 Differences

Course Number:  615-TF
Recommended Duration:  3 days

Intended Audience
Application programmers, data base administrators, system administrators, and systems programmers who will be involved in migrating, developing, maintaining, or enhancing systems that will operate under DB2 Version 8.

Course Overview
This course describes the impacts of this major change to DB2, including the use of Unicode in the catalog tables, support for XML, and extensions to stored procedures.

Objectives
The student will learn what has changed in DB2 Version 8, what has been added in this release, and how the changes affect the activities that are associated with DB2.

Prerequisites
The student should be knowledgeable of the features of the DB2 Data Base Management System that are relevant for data base administration.

Topics

• 64-bit virtual storage impact

• Unicode impact

• DML SQL enhancements

• Sensitive dynamic cursors

• Multiple row SQL

• Common table expressions

• Recursive SQL

• Sequence objects

• Materialized query tables

• Table-controlled partitioning

• Adding/rotating partitions

• Online schema changes

• Data partitioned secondary indexes

• Utility enhancements

• Catalog table changes

• Command enhancements