Blogs

Advancing Big Data and Analytics Capabilities

IBM announces IBM DB2 11 for z/OS to enhance data management capabilities with speed, simplicity, and savings

IBM recently announced the launch of IBM® DB2® Version 11 for z/OS® data management for business-critical transactions and analytics that offers speed, simplicity, and savings. DB2 11 for z/OS is designed to deliver innovative, enhanced continuous availability, scalability, and security for business-critical information.

Deep integration between DB2 and IBM System z® hardware helps facilitate simple, rapid upgrades that dramatically decrease upgrade testing and operating risk, enhance application compatibility features, and help improve access path stability. In addition, it is designed to deliver System z qualities of service with data warehousing, analytics, and big data. DB2 Version 11 for z/OS helps to significantly improve data analytics through highly cost-effective group and roll-up functions, easily and efficiently integrate Apache Hadoop and operational data, and offer increased synergy with the IBM DB2 Analytics Accelerator.

In parallel with the launch of DB2 Version 11 for z/OS, IBM Data magazine offers links to a cornucopia of resources that enable readers to really dig in and discover more about this advanced mainframe data management technology.

 

Industry voices

 

  Higher availability, performance, lower CPU consumption amongst other new features were the benefits perceived by Banco do Brazil with DB2 11 for z/OS. During our testing with DB2 11 we noticed improved performance, along with stability.

—Paulo Sahadi, IT Executive, Banco do Brasil
 
 
We have seen some incredible performance results with DB2 11, a major reduction of CPU time, 3.5 percent before REBIND, and nearly 5 percent after REBIND. This will significantly bring down our operating costs.

—Conrad Wolf, Golden Living
 
DB2 11 continues to raise the standard for availability, allowing object changes online and rebinding packages in use. This lets us deliver the highest availability solutions for our customers!

—Frank Peterson, JN Data
 

 

Expert blogs

Visit the IBM Mainframe Insights blog page, where you can read recent postings by IBM System z professionals that focus on key aspects to the DB2 Version 11 for z/OS announcements.

  • Mark Simmonds, senior product marketing manager, big data for System z, shares his insights on many key elements of the DB2 Version 11 for z/OS announcements in his posting, “What you did not know about big data on System z.”
  • Patricia Zakhar, senior manager, data warehousing on System z, offers her perspective on the many advantages organizations across a wide range of industries can gain using DB2 Analytics Accelerator for z/OS Version 4.1 technology. Read her posting, “Big Data on System z equals advantages for all industries.”

 

Informative white papers

Several white papers are available for taking a deeper dive into DB2 Version 11 for z/OS features, capabilities, and technical information.

  • How DB2 11 for z/OS Can Help Reduce Total Cost of Ownership: Total cost of ownership (TCO) is a financial estimate that helps organizations determine total cost of deploying an asset, such as a database, over its lifecycle, which in the case of databases includes software, hardware, and training. This white paper offers guidelines, orientation, and information about the elements that occur in the TCO of a DB2 for z/OS environment. Explore ways to improve DB2 TCO in existing environments by first understanding the context of business needs and how DB2 for z/OS can help.
  • DB2 11 for z/OS: Unmatched Efficiency for Big Data and Analytics: Get a high-level overview of the major new features available in DB2 11 for z/OS from an IT executive’s perspective. This white paper emphasizes the underlying business value that the recent release of this data management system can deliver.
  • Business-Critical Real-Time Analytics—IBM DB2 11 for z/OS: Explore how analytics can provide enhanced insight into business data and help improve performance. Storing data on DB2 for z/OS and then collecting, reporting, and analyzing that data directly from DB2 enables organizations to achieve enhanced outcomes cost-effectively and with reduced risk to security and compliance.
  • Improved Query Performance in IBM DB2 11 for z/OS: DB2 Version 11 for z/OS data management is designed to enhance performance while maintaining the stability and reliability that many organizations have grown accustomed to from their mainframe environments. DB2 Version 11 offers significant advancements to help improve plan management, runtime optimizations, and new access path choices.
  • DB2 11 for z/OS ESP:* This International DB2 User Group (IDUG)–based user technical perspective offers highly valuable insight on DB2 Version 11.


  • * Access to this white paper requires IDUG membership.

 

Real-world case studies

Customer successes with DB2 for z/OS provide practical, real-world examples of the technology in action. BMW Group and JN Data offer two such cases.

 

BMW Group Develops Ecofriendly Innovation for Smart Drivers
 
  JN Data Gets the Early Adopter Advantage
Established in 1916 and headquartered in Munich, Germany, BMW Group is one of the world’s largest and most successful car manufacturers. The organization operates in 150 countries and employs more than 107,000 people.
 
BMW Group wanted to develop sustainable and smarter driving strategies in line with the market’s requests. The company knew that any difficulties in managing the mountain of data created by these innovations would mean risking loss of business opportunities.
 
It implemented DB2 11 for z/OS technology that offers optimized management of information and workload cost-effectively. The company also plans to leverage the latest-generation IBM zEnterprise® EC12 mainframe.
 
This solution enables BMW Group to develop and launch innovative strategies for green and smart driving. It also supports constant workload increase, 24/7; helps reduce processing workload by 8–13 percent; and helps reduce processor usage.
  JN Data provides IT operations and engineering services to large Danish financial institutions. Growing both organically and through acquisition, the company also provides financial solutions to 15 Danish banks.
 
Corporate acquisition has helped JN Data to double its client base, placing huge demands on its busy IT staff. Like its counterparts in many other organizations, JN Data’s technical support staff never seem to have enough hours in the day.
 
JN Data joined the Early Support Program for DB2 11 to take advantage of advanced technical functionality. For example, the ability to interrupt persistent threads, introduction of 10-byte LRSN/RBA log addresses, and automatic cleanup of pseudo-deleted index entries can increase system administrator productivity.
 
This solution offers significant processor savings, enabling added workload to be processed without additional processor investments, and it can save time for administrators.

 

And even more resources

Check out these other resources for more information on DB2 Version 11 for z/OS.

  • Webcast Replay: System z Events
  • The webcast, “DB2 11 for z/OS – Even more cost savings, faster upgrades, and enhanced analytics,” provides a complimentary overview of DB2 11 for z/OS features and how they enable simpler and faster upgrades than ever before, reduce costs, and enhance overall performance. This webcast is presented by several DB2 for z/OS subject-matter experts.
     

  • IBM eBook: DB2 11 for z/OS – The Database for Big Data and Analytics
  • By Cristian Molaro, Surekha Parekh, Terry Purcell, and Julian Stuhler
    Many organizations are looking for opportunities to reduce costs at the same time they are trying to gain a competitive advantage. DB2 11 for z/OS and DB2 Analytics Accelerator for z/OS enable organizations to exploit in-memory analytics, an approach to querying data when it resides in a computer’s RAM rather than querying data that is stored on physical disks. In-memory analytics significantly shortens query response times, allowing business intelligence (BI) and analytic applications to support fast business decisions. Download this ebook to learn more.
     

  • And visit the developerWorks website to access the following three recent videos on best practices for DB2 for z/OS.
  Steps to investigate CPU performance on release migration

Presenter: John Campbell
 
  DB2 for zOS data sharing for
tuning group buffer pools


 
Presenter: John Campbell
 
  Best practices for optimal access path selection during migration

Presenter: Tom Beavin
 
This best practices presentation discusses methodologies and techniques to investigate a processor performance regression across a release migration to quantify it and determine the cause. Normalizing results is also an imperative in a real-world environment to compare results between DB2 releases. Discover what to look for, how to go about the comparison, and get specifics on using statistics and accounting to trace workload indicators. In a data sharing environment, tuning group buffer pools is an important activity for keeping systems running smoothly. This web-based lecture goes through the functions and features of group buffer pools, explains the processes involved in tuning, and offers a series of reports and explains how to interpret key metrics for tuning group buffer pools. Access path regressions can be puzzling and can take much effort to diagnose. This best practices presentation helps attendees understand how to prevent them when migrating to a new release of DB2. It explains what is necessary to capture on the current DB2 system prior to migration and offers tips on what information is needed and how to model production environments.