G525 DB2 Version 7 to Version 9 Transition

Course Code: G-525
Recommended Duration: 5 Days

Benefits

The student learns what has changed in DB2 Versions 7 and 8, what has been added in these releases, 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

Classroom access to a set of DB2 Version 9 IBM manuals is desirable but not required.

Major Topics Include

64-bit virtual storage impact
Unicode impact
DML SQL enhancements
Sensitive dynamic cursors
Multiple row SQL
Common table expressions
Recursive SQL
OLAP functions
INSTEAD OF triggers
File reference variables
Native SQL stored procedures
Sequence objects
Materialized query tables
Table-controlled partitioning
Adding/rotating partitions
Online schema changes
Data partitioned secondary indexes
Universal table spaces
Cloning tables
Row change timestamps
New data types
Utility enhancements
Using XML in DB2

Exercises

There are sixteen machine exercises.

Course Description

DB2 Version 7 to Version 9 Transition