IBM DB2 9 New Features

Overview

Design and deploy integrated enterprise-class business solutions

Enhance productivity, profitability, and efficiency using IBM DB2 9 and the detailed information in this comprehensive resource. Written by experienced IBM data server professionals, IBM DB2 9 New Features covers the technical details of the major new aspects of DB2 9 alongside real-world business uses, syntax examples, and insider tips. Learn how to manipulate and manage XML data using pureXML, automate maintenance tasks, and seamlessly integrate Java, PHP, and Perl scripts. Plus, you'll get vital coverage of the brand-new DB2 Developer Workbench, enhanced .NET developer support, Ruby on Rails, and database security.

• Learn about all the auto-configuration features that make getting DB2 up and running faster than ever before
• Define, share, and validate data using XML and the unique pureXML DB2 Hybrid Storage Engine
• Improve runtime performance and optimize storage with the new DB2 Compression Technology
• Automatically handle DB2 memory allocation using the Self Tuning Memory Manager
• Use Automatic Storage, Autonomic Computing, and a host of other autonomic features that make managing DB2 a snap
• Create dynamic data server blueprints with Rational Data Architect version 6.1
• Incorporate Java applications using the IBM WebSphere Application Server and DB2 data server
• Develop open-source scripts using PHP, Perl, Toad, and Ruby on Rails
• Utilize the DB2 Developer Workbench or exploit the enhanced .NET developer support
• Deploy the latest DB2 security and high availability features

Table of contents

Part I. XML in DB2 New Hybrid Storage Engine
Ch. 1. What is XML?
Ch. 2. When Do I use pureXML?
Ch. 3. pureXML: The DB2 XML Database
Ch. 4. Tuning XML Performance
Part II. Autonomics and Manageability
Ch. 5. Up and Running Enhancements
Ch. 6. Self Tuning Memory Manager
Ch. 7. Automated Storage
Ch. 8. Other Autonomic and Manageability Enhancements
Part III. Application Development
Ch. 9. Rational Data Architect
Ch. 10. DB2 and the .NET Developer
Ch. 11. DB2 and the Java Developer
Ch. 12. DB2 and the Scripting Languages Developer
Ch. 13. DB2 and the XML Developer
Ch. 14. DB2 Developer Workbench
Ch. 15. Other Application Development Topics
Part IV. Security Enhancements
Ch. 16. Label-Based Access Control
Ch. 17. Additional Security Enhancements
Part V. SHARP Enhancements
Ch. 18. Larger Table Space Support
Ch. 19. Larger Object Support
Ch. 20. Raw Compression
Ch. 21. High-Availability Enhancements
Ch. 22. Additional SHARP Enhancements
Index

Biographical note

Paul C. Zikopoulos, BA, MBA, is on the IBM Database Competitive Technology team. He is the coauthor of DB2:The Complete Reference.George Baklarz, B Math, M Sc, is a senior manager in the DB2 Worldwide Pre-sales Support Group.Leon Katsnelson works in the IBM Toronto Lab where he manages a team of IBM DB2 UDB product managers.Chris Eaton is the senior product manager for DB2 Universal Database.