| Course Code: |
RT 531 |
| Course Abstract: |
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) |
| Audience: |
This course is designed for individuals who are Programmers, Analysts, Team Leads, Managers, Database Administrators who need an "appreciation” and "understanding” of the new "Application" features of DB2 for z/OS v9. |
| Duration: |
1 day |
| Learning Outcomes: |
Upon completion of this course, the participant will be able to:
> 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) |
| Course Topics: |
DB2 Version Nine System Changes – Overview
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)
Hands-On Workshop Topics
pureXML
New Data Types - bigger BINARY, VARBINARY, BIGINT, DECFLOAT
INSTEAD OF triggers
INTERSECT and EXCEPT
TRUNCATE Statement
MERGE Statement |
| 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 v9 and / or DB2 v9 – Announcement Letter Overview would provide a solid foundation for this course. |