Course Description

DB2 Version 9 Differences

This course: course objectives; course outline;
DB2 curriculum; Topic list; Course list; Home page

Benefits

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.

Audience

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

Prerequisites

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

Related IBM Materials

This course is drawn from the DB2 Version 9 library IBM manuals; access to them in the classroom is desirable but not required

• 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

Machine Exercises

There are nine machine exercises.

Note

While not recommended, this class can be taught as a lecture-only class, omitting the exercies. Depending on topic selection, this can reduce the duration of the class from three to two days.