DB2 Version 9 Differences

Course Number:  616-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 9.

Course Overview
This course describes the impacts of this major change to DB2, including the support for zIIPs, new kinds of triggers, clone tables, universal table spaces, new data types, and enhancements to utilities and commands.

Objectives
The student will learn what has changed in DB2 Version 9, 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

• New data types

• SQL extension

• INTERSECT and EXCEPT

• TRUNCATE

• MERGE

• INSTEAD OF triggers

• FETCH CONTINUE

• LOB file reference variables

• Native SQL stored procedures

• Universal table spaces

• Clone tables

• Implicit object creation

• Index enhancements

• XML data type and built-in functions

• Utility enhancements

• Performance enhancements