Course Title: DB2 Version 8 Differences
Course#: DB02T
Duration: 3 days
Overview:The student will learn what has changed in DB2 Version 8, what has been added in this release, and how the changes affect the activities that are associated with DB2.
Topics:
- 64-bit virtual storage impact
- Unicode impact
- DML SQL enhancements
- Sensitive dynamic cursors
- Multiple row SQL
- Common table expressions
- Recursive SQL
- Sequence objects
- Materialized query tables
- Table-controlled partitioning
- Adding/rotating partitions
- Online schema changes
- Data partitioned secondary indexes
- Utility enhancements
- Catalog table changes
- Command enhancements
Exercises:There are eight exercises in the three day version of this course.
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 8.
Prerequisites:The student should be knowledgeable of the features of the DB2 Data Base Management System that are relevant for data base administration.