G528 DB2 Version 10 Differences

Course Code: G-528
Recommended Duration: 4 Days

Benefits

The student learns what has changed in DB2 Version 10, what has been added in this release, and how the changes affect the activities that are associated with DB2.

Audience

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 10.

Prerequisites

The student should be knowledgeable of the features of the DB2 Data Base Management System that are relevant for his/her job responsibilities.

Related IBM Materials

This course is drawn from the DB2 Version 10 library IBM manuals; access to them in the classroom is desirable but not required.

Major Topics Include

SQL scalar functions
SQL table functions
Variable precision timestamps
Timestamps with time zones
Temporal tables and versioning
Hash access
Concurrent access resolution
Security enhancements: SECADM, system DBADM, SQLADM, DATAACCESS, and ACCESSTTRL authorities
Row and column access control
XML enhancements
Utility changes / improvements
Performance enhancements
Command changes
Catalog changes

Exercises

There are nine machine exercises, and one optional machine exercise.

Special Note

Although not recommended, this class can be taught as a lecture-only class, omitting the exercises. Depending on topic selection, this can reduce the duration of the class from four to three days.

Course Description

DB2 Version 10 Differences