DB2 Version 10 Differences

Course Number:  726-TF
Recommended Duration:  4 days

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

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

Prerequisites
The student should be knowledgeable of the features of the DB2 Data Base Management System that are relevant for his/her job responsibilities. This course is drawn from the DB2 Version 10 library IBM manuals; access to them in the classroom is desirable but not required.

Topics

• 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