Overview
Describe the new features and enhancements of DB2 UDB for z/OS Version Nine. Evaluate the usefulness of the new features and enhancements of DB2 UDB for z/OS Version Nine.
This course cover a Technical Introduction to the following NEW SQL Features of DB2 UDB for z/OS Version Nine, including the following - 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)
LEARNING OBJECTIVES
As a result of this class, the attendee will be able to discuss the capabilities of EACH of the following -
- 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)
Audience
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
|
|
