Unmatched Efficiency for Big Data and Analytics

Overview

DB2 11 is the latest version of DB2 for z/OS and contains several major improvements designed to support ever-increasing data and transaction volumes. Most customers can expect to see net DB2 CPU savings of up to 10% in their complex OLTP and update-intensive batch workloads when compared to DB2 10 and up to 40% for query workloads. New productivity features will reduce the effort required by developers and support staff to deliver robust DB2 applications.

IBM continues to expand DB2’s formidable scalability and resilience to better support transactional workloads while significantly improving the integration with specialised analytics processing platforms. The end result is a hybrid solution which is capable of efficiently supporting very diverse workloads in a highly cost effective manner.

Key Benefits & Improvements

DB2 11 for z/OS delivers a number of significant business benefits including:

Efficiency

  • CPU Reductions
  • zEC12 Exploitation
  • Application Compatibility
  • Temporal Data Enhancements
  • pureXML Enhancements
  • Optimiser and Query Performance Improvements
  • Data Sharing Performance Enhancements
  • Utility Enhancements

Resilience

  • Extended Log Record Addressing Improvements
  • Enhanced Dynamic Scheme Change
  • BIND/REBIND Enhancements
  • Security Enhancements

Business Analytics

  • SQL Aggregation Improvements
  • IBM DB2 Analytics Accelerator Enhancements
  • Hadoop and Big Data Support

Upgrade to DB2 11 - Technical Pre-requisites

A number of conditions must be met in order to upgrade to DB2 11. These are summarised below:

DB2 10 New Function Mode. Customers must be running DB2 10 in New Function Mode in order to begin the upgrade process. Direct upgrades from earlier releases are not supported.

Hardware Requirements. DB2 11 requires a zEC12, z196 or z10 server supporting z/Architecture.
Some DB2 11 features such as 2GB page frames are only supported when running on a zEC12 server. DB2 11 is also expected to require increased real storage for a given workload when compared to DB2 10 for z/OS.

System Software Requirements. DB2 11 requires z/OS V1.13 or higher. Some of the features also require z/OS Security Server (RACF) V1.13.

Application Requirements. The new DB2 11 Application Compatibility feature removes the usual requirement for application code to be altered to address incompatible changes. Although the code will still have to be changed at some point in the future, this is no longer a pre-requisite for upgrading to the new release.

DB2 11 does not support packages bound prior to DB2 9, so these will need to be rebound in preparation for the upgrade. However, the plan management features introduced in DB2 10 should significantly reduce the effort and risk associated with this activity.

Download the white paper

To enquire about this service please complete the form below.