| |
DB2 9 extends traditional DB2 strengths in many areas like online schema evolution, Unicode, XML, DB2 family SQL, utilities, security and compliance, and 64-bit virtual storage. Optimization improvements include performance-boosting innovations, synergy with IBM System z, and query management enhancements that reduce total cost of ownership.
pureXML for Information On Demand and SOA initiatives
- Rich new hybrid data server support for both relational and pureXML™ storage, with the necessary services to support both data structures.
- Leading-edge standards-based capabilities to enable service oriented architecture (SOA) requirements.
- Database on demand capabilities to ensure that your information design can be changed dynamically, often without database outages.
- Rich new SQL capabilities, including additional data types and built-in functions, expanded SQL commonality with DB2 family, and enriched text handling with functions like caseless comparisons, cultural sort, and index on expression.
- Enhanced support to allow key Business Partners, especially with ERP offerings such as SAP, to continue to push the envelope with capabilities that drive business value to their customers. Specific items include new autonomic features, optimization and availability enhancements, and support for new data types.
- Completely redesigned, cross-platform workstation and Web-based QMF query solution, providing high performance, on demand access to data, reports and interactive data analysis using a rich desktop application or ordinary Web browser.
|
Unparalleled security and resiliency for business critical information
- Increased security and regulatory compliance through implementation of roles, network-trusted contexts, and enhanced auditing.
- Synergy with IBM System z and z/OS in areas that include XML parsing, zIIP, I/O improvements, encryption, IPV6, and Secure Socket Layer (SSL).
- Query management enhancements to make accessing your data even faster and more accurate; indexing improvements that include index on expression, randomization, and larger index page sizes; optimization improvements that provide better data for the optimizer, improved optimization techniques, and better management with optimization services.
|
Reduced Total Cost of Ownership (TCO)
- Enhanced performance, usability, and availability in data sharing environments, including fast replacement of one table with another, ability to alter table space and index logging, and improved ability to rebuild an index online.
- Performance-boosting innovations such as reduced CPU usage for load and reorg utilities and improved performance for varying length data, logging, and insert operations.
- Scalability innovations like table space partitioning by growth, reduced log latch contention, and the ability to create and alter STOGROUP SMS constructs.
- Help manage business-critical information, with fewer planned or unplanned outages with features like online reorganization with no BUILD2 phase, rename column and index, alter index to change page size, and the ability to modify early code without requiring an IPL.
|
Key prerequisites for IBM DB2 9 for z/OS:
|
|  |
Learn how DB2 9 for z/OS with pureXML optimizes SOA initiatives | | |
|
