E-Business Software delivers 64-bit virtual addressing.

Press Release Summary:

DB2 Universal Database® (UDB) for z/OS® v8 delivers compatibility for e-business application leadership through synergy with eserver zSeries and z/OS. This enables users to expand and extend applications in e-business environment. Features include online schema evolution for data availability; database management flexibility with variable-length indexes and up to 4096 partitions and data partitioning for indexes; and DB2 Query Management Facility on demand.

Original Press Release:

IBM DB2 UDB for z/OS, V8 Delivers 64-Bit Virtual Addressing


DB2 Universal Database® (UDB) for z/OS® continues to deliver rich function for scalable and highly available data for your enterprise-scale e-business applications. Combine the power and capacity of IBM eserver zSeries®, the high performance and high availability of the z/OS operating system, and this enriched version of DB2® to expand and extend your applications in the increasingly competitive e-business environment.

· 64-bit virtual addressing that exploits the capacity and processing power of zSeries servers and z/OS operating system
· Extensive enhancements to SQL
· Usability and portability enhancements through major catalog changes:
- Improvements in long object names
- Unicode for worldwide support and improved SQL compatibility.
· DB2 family compatibility for portability of transaction applications from UNIX® and Microsoft(TM) Windows(TM) environments
· Enhanced data availability through online schema evolution
· Database management flexibility with:
- Indexing enhancements
- Variable-length indexes
- Up to 4096 partitions and data partitioning for indexes
· Utility enhancements:
- System-level point-in-time backup and recovery
- Automatic restart of utilities
- Greater DB2 family compatibility through support for load and unload with delimited data
· DB2 Query Management Facility (QMF(TM)) on demand feature, which includes:
- Support for DB2 UDB V8, including DB2 Cube Views, long names, Unicode, and enhancements to SQL
- Drag-and-drop building of OLAP analytics, SQL queries, pivot tables, and other business analysis and reports
- Visual data "appliances," such as executive dashboards, that offer unique, visually rich, interactive functionality and interfaces specific to virtually any type of information task
- Database explorer for easily browsing and identifying database assets and other objects they may reference
- QMF for WebSphere® , allowing ordinary Web browsers to become "zero maintenance" thin clients for visual on demand access to enterprise DB2 business data

With this release, DB2 QMF is offered in several simplified editions, enabling you to more easily apply its DB2 QMF on demand information strategy to single or multiple database and end-user platforms.

For more information and the most current news regarding DB2 UDB for z/OS, visit:


Key prerequisites

· z/OS V1R3 Base Services (5694-A01), or later, executing in 64-bit addressing mode
· Any processor that supports z/Architecture(TM)

Planned availability date

March 26, 2004

At a glance

DB2 UDB for z/OS, V8 delivers power, flexibility, and DB2 Family compatibility for e-business application leadership through synergy with zSeries and z/OS.

· Enhanced capacity through 64-bit virtual addressing for DB2 and Internal Resource Lock Manager (IRLM)

· Schema evolution for enhanced data availability

· DB2 Family compatible SQL for transaction processing

· Reengineered catalog including Unicode data format and long name support

· Major indexing and partitioning enhancements

· Major utility enhancements DB2 QMF V8 delivers:

· OLAP with DB2 Cube Views

· Drag and drop queries and analytics

· Executive dashboards

· DB2 V8 long name and other support

· Enabled for WebSphere Application Server

· Simplified packaging for easier ordering

For ordering, contact:
Your IBM representative, an IBM Business Partner, or the Americas Call Centers at 800-IBM-CALL Reference: LE001

More from Machinery & Machining Tools

All Topics