IBM DATABASE 2 Version 9.1 for z/OS (DB2 9 for z/OS throughout this publication) is the thirteenth release of DB2 for MVS.

It brings improved synergy with the zSeries hardware and more opportunities to drive business value in the following areas:

-- Business insight innovations

- Rich hybrid support for relational and pure XML data.

- Enhanced support for key business partners that allow you to get more from your data in critical business disciplines like ERP.

- A brand new user interface for the Query Management Facility to view and analyze data from either a workstation client or an ordinary Web browser.

-- Cost savings through optimized innovations

- Streamlined security and regulatory compliance through the implementation of roles, network-trusted contexts, and enhanced auditing.

- Performance-boosting innovations such as load and reorg CPU reductions, improved varying length data, logging, and insert performance.

- Query management enhancements to make accessing data even faster and more accurate with indexing improvements.

-- Business resiliency innovations

- Database on demand capabilities to ensure that information design can be changed dynamically, often without database outages.

- DB2 restart improvements enhancing performance usability and availability in data sharing environment.

This book introduces the enhancements made available with DB2 9 for z/OS. It helps you understand the new functions, justify investment in migrating, and plan for exploiting the key new capabilities.

Chapter 1. DB2 9 for z/OS at a glance

Part 1. Subsystem functions

Chapter 2. Synergy with System z

Chapter 3. Scalability

Chapter 4. Availability

Chapter 5. Data sharing

Part 2. Application functions

Chapter 6. SQL

Chapter 7. Application enablement

Chapter 8. XML

Chapter 9. e-business and connectivity

Part 3. Operations and performance

Chapter 10. Security

Chapter 11. Utilities

Chapter 12. Installation and migration

Chapter 13. Performance

Appendix A. DB2 Tools for z/OS