DB2 Version 7 to Version 9 Transition

Course Number: 728-TF
Recommended Duration: 5 days

Intended 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.

Objectives
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.

Prerequisites
The student should be knowledgeable of the features of the DB2 Data Base Management System that are relevant for his/her job responsibilities. Classroom access to a set of DB2 Version 9 IBM manuals is desirable but not required.

Topics

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

DB2 Version 7 to Version 9 Transition

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