DB2 Version 6 Differences

Course Number:  601-TF
Recommended Duration:  3 days

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

Course Overview
This course presents what is new and different in Version 6 of DB2.  Included are such topics as: new built-in functions, schema; user-defined functions; SQL Procedures Language; stored procedures enhancements; triggers; BLOBs, CLOBs, and DBCLOBs; REXX language support, and much more.

Objectives
The student will learn what has changed in DB2 Version 6, what has been added in this release, 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.

Topics

• New Built-in Functions

• Direct row access

• Optimization hints

• PLAN_Table changes

• Schema, Distinct types, User-defined functions

• DSNTEP2 changes

• Predictive governing and other performance enhancements

• Stored Procedures Enhancements

• SQL Procedures Language

• Catalog table changes

• Increased limits

• BLOBs, CLOBs, and DBCLOBs

• Triggers

• Utility enhancements

• REXX language support

• Java

• DB2 extenders

• DB2 UDB Server features