"DB2 11 is a unique hybrid solution that is capable of efficiently supporting very diverse workloads in a highly cost-effective manner."
DB2 11 for z/OS is the latest release of IBM's flagship RDBMS. The new release had a tough act to follow; the significant "out of the box" CPU savings and scalability enhancements delivered by DB2 10 for z/OS made it the fastest-adopted DB2 release in the product's history. However, I'm pleased to say that DB2 11 has a lot to offer IT managers from a business value perspective.
DB2 11 builds upon the considerable CPU reductions that DB2 10 provided, with no application change required to exploit many of the savings. 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.
Big Data Integration
As a result of the big data 'revolution' many new tools and products have been brought to market to enable organisations to gain actionable insight from large amounts of unstructured data. These new technologies have gone a long way to help organisations deal with their Big Data challenges. However, they have also introduced some new challenges for organisations wishing integrate the analysis of big data with core operational information.
DB2 11 for z/OS has introduced some highly significant new features to allow DB2 and Hadoop/Infosphere BigInsights to work together and better leverage each platform's respective strengths. This allows data to flow in both directions, so that DB2 queries can incorporate Hadoop results and Hadoop queries can incorporate DB2 operational data. These new integration capabilities allow organisations to more easily and efficiently combine the results of big data analysis with up-to-date operational data and significantly increases the practical value of any insights obtained.
Staff costs consume an ever increasing proportion of the overall IT budget and so productivity is becoming ever more important in order to maintain cost effectiveness. DB2 11 includes some major enhancements which will significantly reduce the effort required by developers and support staff to deliver robust and efficient DB2 applications. These include transparent archiving, XML XQuery support, reduced housekeeping requirements and improved dynamic schema change capabilities. These improvements will deliver bottom-line cost savings for the business.
Improved Time To Value
DB2 11 allows the customer to upgrade more quickly than was previously possible and therefore begin to exploit all the benefits of the new release much earlier.
This has been achieved in a couple of ways. Firstly, DB2 11 no longer requires customers to make all applications compatible with the new release prior to upgrading, allowing any required changes to be deferred until a suitable change slot. The new release also provides additional information to help identify exactly which application code needs to be changed. This cuts down on the amount of pre-requisite work required and allows the upgrade to be scheduled more quickly. Secondly, DB2 11 reduces the operational impact of the upgrade process itself, making it easier for customers to perform the upgrade during a quiet period without significantly impacting application availability.
DB2 11 is proving to be a worthy successor to the popular release, DB2 10. The additional CPU savings possible with DB2 11 are expected to match or even exceed those within DB2 10 for some types of workload. IBM has also expanded the scalability and resilience of the product to better support transactional workloads, while significantly improving the integration with specialised processing platforms such as InfoSphere BigInsights and the IBM DB2 Analytics Accelerator. The end result is a unique hybrid solution that is capable of efficiently supporting very diverse workloads in a highly cost-effective manner.
More details of the new features in DB2 11 for z/OS can be found in the white paper DB2 11 for z/OS: Unmatched Efficiency for Big Data and Analytics.