DB2 Version 7 Differences
- Recommended Duration:
- 2 Days
- Version
- DB2 Version 7.
- Benefits
- The student will learn what has changed in DB2 Version 7, 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, system administrators, and systems programmers who will be involved in migrating, developing, maintaining, or enhancing systems that will operate under DB2 Version 7.
- Prerequisites
- The student should be knowledgeable of the features of the DB2 Database Management system that are relevant for his/her job responsibilities.
- Major Topics
-
- Impact of Unicode
- New and changed SQL statements and built-in functions
- UNION in views
- Scrollable cursors, sensitive and insensitive
- Migration considerations
- z/OS considerations for buffer pools
- Operational enhancements
- New and revised DB2 commands
- New utilities: COPYTOCOPY, MODIFY STATISTICS, UNLOAD
- New utility usage: EXEC SQL, LISTDEF, TEMPLATE and OPTIONS control statements
- Utility packaging
- New and changed catalog tables, including statistics history table
- Changes in JAVA support
- EXPLAIN, PLAN_TABLE, and DSN_STATEMENT_TABLE changes
- DB2 XML Extender
- Exercises
- There are four machine exercises.