DB2 9.x LUW (Linux, UNIX, Windows) - Differences

Audience

IT personnel who need to know the new DB2 9.7 LUW facilities and how they might affect them. The emphasis on certain subjects will be adjusted to reflect the audience; for example if the delegates on the course are all applications programmers then less in depth teaching will be given for the UTILITIES part of the course.

Prerequisites

Those attending the course should be confident in using DB2 at previous releases.

Duration

2 days. Hands on.

Course Objectives

The course is designed to instruct those delegates who are fairly confident in designing, writing and testing DB2 applications and now need to know the facilities that are available to them with the new DB2 9.7 release.

Course Content

Introduction Environment/System Changes
XML
Tablespace types
DECFLOAT
BIGINT
VARBINARY
Simple tablespaces

SQL
INTERSECT
EXCEPT
MERGE
TRUNCATE
SELECT from DELETE, UPDATE and MERGE

PERFORMANCE
INSERT
Logging
Index page changes
Append options
Not logged tablespaces
Optimization changes
Optimization support center
Variable length

OTHER
Online schema changes (Database Definition On Demand)
Online table space reorganization
Table cloning
Instead of triggers
Stored procedure changes
OLAP changes
Security changes
Utility changes