Db2 Version 7 to Version 9 Transition

PT20422
Summary
The student learns what has changed in Db2 Versions 7 and 8, what has been added in these releases, and how the changes affect the activities that are associated with Db2.
Prerequisites
Before taking this course, students should be knowledgeable of the features of the Db2 Data Base Management System that are relevant for his/her job responsibilities.
Duration
5 Days/Lecture & Lab
Audience
This course is designed for application programmers, data base administrators, systems administrators, and systems programmers who will be involved in migrating, developing, maintaining, or enhancing systems that will operate under Db2 Version 9.
Topics
64-bit virtual storage impact
  • Unicode impact
  • DML SQL enhancements
  • Sensitive dynamic cursors
  • Multiple row SQL
  • Common table expressions
  • Recursive SQL
  • OLAP functions
  • INSTEAD OF triggers
  • File reference variables
  • Native SQL stored procedures
  • Sequence objects
  • Materialized query tables
  • Table-controlled partitioning
  • Adding/rotating partitions
  • Online schema changes
  • Data partitioned secondary indexes
  • Universal table spaces
  • Cloning tables
  • Row change timestamps
  • New data types
  • Utility enhancements
  • Using XML in Db2

Related Scheduled Courses