DB2 Version 9 adds significant performance improvements to reduce total cost of ownership. Costs are also reduced by automating DBA and system administration functions. This course is designed for those already familiar with DB2 and planning to migrate to Version 9 of DB2. The course also covers migration from Version 8. Many functional and operational enhancements such as universal tablespaces, clone table support, and automated buffer management are introduced which can decrease or eliminate outages and human intervention. New functions, new utilities and existing utility enhancements, reliability, scalability, and availability are discussed. Detailed examples of new features are presented and each section ends with review questions to re-enforce key points. Although the migration path to Version 9 is similar to the migration path to version 8, new fallback features have been added and the entire Version 9 migration process is discussed in detail.
Students should be familiar DB2 concepts and features of DB2 Version 7 and Version 8.
2 Days/Lecture & Lab
This course is designed for system and database administrators, developers, application designers and other individuals who need an introduction to the new features of DB2 Version 9 should attend this class. Anyone migrating from other UDB platforms will also benefit from this class
- Version 9 Overview
- Performance Improvements
- Functional Enhancements
- Operational Enhancements
- New Functions
- New Utilities and Utility Enhancements
- System Administration Considerations
- Migration Considerations