This is a Technical Introduction course for Programmers, Analysts, Team Leads, Managers, Database Administrators who need an "appreciation" and "understanding" of the new "Application" features of DB2 for z/OS Version Nine.

Prerequisites

Six Month of experience using DB2 UDB for z/OS Version 8 is recommended.

Reading the IBM publication What's New DB2 UDB for z/OS Version Nine and / or DB2 Version Nine - Announcement Letter Overview would provide a solid foundation for this course.

Course duration

1 day

Course outline

A. DB2 Version Nine System Changes - Overview

B. Application SQL Changes pureXML New Data Types - bigger BINARY, VARBINARY, BIGINT, DECFLOAT INSTEAD OF triggers INTERSECT and EXCEPT TRUNCATE Statement MERGE Statement Native SQL Stored Procedures Optimistic Concurrency Control Automatic Object Creation Skip Locked Data REOPT (AUTO)

C. Hands-On Workshop Topics pureXML New Data Types - bigger BINARY, VARBINARY, BIGINT, DECFLOAT INSTEAD OF triggers INTERSECT and EXCEPT TRUNCATE Statement MERGE Statement