G526 DB2 Version 9 Differences

Course Code: G-526
Recommended Duration: 3 Days

Benefits

The student learns 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, systems administrators, 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 knowledgeable of the features of the DB2 Data Base Management System that are relevant for his/her job responsibilities.

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

Major Topics Include

New data types
SQL extensions
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

Exercises

There are nine machine exercises.

Special Note

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

Course Description

DB2 Version 9 Differences