DB2 Version 5 to Version 7 Transition for Data Base Administrators

Course Number:  614-TF
Recommended Duration:  3 days

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

Course Overview
Many installations skipped DB2 Version 6 and went (or are going) right from Version 5 to Version 7; this course provides a fast track update to the essential changes introduced in this transition, from the perspective of DB2 DBAs.

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

Prerequisites
The student should be knowledgeable of the features of the DB2 Data Base Management System that are relevant for data base administration.

Topics

• 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