Course Description

DB2 Version 7 Differences

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

Benefits

The student will learn what has changed in DB2 Version 7, what has been added in this release, and how the changes affect the activities that are associated with DB2.

Audience

Application programmers, data base administrators, system administrators, and systems programmers 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 his / her job responsibilities.

Related IBM Materials

This course is drawn from this IBM manual; access to it in the classroom is desirable but not required:

SC26-9923 - DB2 Version 7 Release Guide

• Impact of Unicode
• New and changed SQL statements and built-in functions
• UNION in views
• Scrollable cursors, sensitive and insensitive
• Migration considerations
• z/OS considerations for buffer pools
• Operational enhancements
• New and revised DB2 commands
• New utilities: COPYTOCOPY, MODIFY STATISTICS, UNLOAD
• New utility usage: EXEC SQL, LISTDEF, TEMPLATE and OPTIONS control statements
• Utility packaging
• New and changed catalog tables, including statistics history table
• Changes in JAVA support
• EXPLAIN, PLAN_TABLE, and DSN_STATEMENT_TABLE changes
• DB2 XML Extender

Exercises

There are four exercises.