Course Description

DB2 Version 5 to Version 7 Transition for Data Base Administrators

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

Benefits

The student will learn what has changed in DB2 Versions 6 and 7, what has been added in these releases, and how the changes affect the activities that are associated with DB2.

Audience

Data base administrators who will be involved in migrating, developing, maintaining, or enhancing systems that will operate under DB2 Version 7.

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 these IBM manuals; access to them in the classroom is desirable but not required:

SC26-9013 - DB2 Version 6 Release Guide

SC26-9923 - DB2 Version 7 Release Guide

• Schemas, Distinct types, and User-defined functions
• Data definition extensions
• Partition rebalancing
• New data types: ROWIDs, Identity columns, and LOBs
• Triggers
• View definition extensions
• Unicode implications
• New and revised DB2 commands
• New utilities: CHECK LOB, REBUILD INDEX, COPYTOCOPY, MODIFY STATISTICS, UNLOAD
• New utility usage: EXEC SQL, LISTDEF, TEMPLATE and OPTIONS control statements
• Enhanced utilities and utility packaging
• Stored procedure enhancements
• Declared global temporary tables
• Scrollable cursors and other new cursor facilities
• DB2 Extenders: Image, Audio, Video, Text, and XML

Exercises

There are eight exercises.