Posted by: Mark Fontecchio
db2, mainframe, z/OS
IBM announced last week that it will start a beta program for DB2 version 10 for z/OS on March 12.
Here are some features of DB2 10 for z/OS, straight from the announcement letter:
- CPU reductions for all workloads.
- Five to 10 times more concurrent users on a single subsystem by avoiding memory constraints.
- Greater concurrency for data management, data definition, and data access, including DDL, BIND, REBIND, PREPARE, utilities, and SQL.
- Additional online changes for data definitions, utilities, and subsystems.
- Improved security with improved granularity for administrative privileges, data masking, and audit capabilities.
- Temporal or versioned data to understand system and business times at the database level.
- pureXML™ and SQL enhancements to improve portability from other database solutions.
- Productivity improved for database administrators, application programmers, and systems administrators.
- Enhancements in QMF™ Classic Edition that allow greater interoperability with other programs as well as features that improve queries, forms, certain commands, diagnostics, performance, and resource control. QMF Enterprise Edition provides even more value, including support for QMF-based dashboards and visually rich page-based reports; enhanced QMF security model for access control and personalization; support for HTML, PDF, or Flash QMF report and dashboard output formats; and a QMF metadata layer simplifies content authoring.
You need at least a z890 or later running z/OS V1.10 or later to take part in the beta program. The announcement letter does not say when DB2 10 for z/OS will be generally available, or how much it will cost, or when DB2 8 will go out of service.
Trevor Eddolls at Mainframe Update has written about the DB2 10 beta program, paraphrasing IBM claims “that compared to previous DB2 versions, some customers can achieve a 5% to 10% out-of-the-box CPU savings for traditional workloads and up to 20% out-of-the-box CPU savings for non-traditional workloads.” Eddolls continues:
IBM also suggests that productivity improvements in DB2 10 for database and system administrators can drive additional operational efficiencies and cost savings. Synergy with other System z platform components reduces CPU use by leveraging the latest processor improvement,s larger amounts of memory, solid-state disk and z/OS enhancements.
Willie Favero, an IBM software specialist, wrote about the new DB2 features in his IT Toolbox blogas well. Here’s what Favero had to say on performance improvements for DB2 10 for z/OS:
A few examples of the performance stuff you get in DB2 10 at no “cost” (no changes to applications), and this list is far from including everything, are: parallel index update at insert, index list prefetch, LOB streaming between DDF and DB2, faster single row retrievals through open/fetch/close chaining, high performance database access threads (DBATs), SQL procedure language performance improvements, improved SQL runtime efficiency, and more…