The landscape of today's business is being shaped by the mountains of data we are producing. This rapid growth in the volume, variety, and velocity of data is due to the explosion of smart devices, mobile applications, cloud computing, and social media. Much of the growth has been in unstructured data; however, by 2020, Internet business transactions-business-to-business and business-to-consumer-are predicted to reach 450 billion per day. Smart organizations are seeking innovative ways to turn this explosion of data, called big data, into actionable insights.
Find out why DB2 for z/OS is the database of choice for big data and analytics by top businesses around the world. This book explores the features that make DB2 11 the ideal database for big data and business-critical analytics in the new era of computing. It is packed with rich information about DB2 11 features and business benefits, including:
Even more out-of-the-box CPU savings
Enhanced resiliency
Capabilities to excel at business-critical analytics
Simpler, faster upgrades for faster ROI
About authors
Cristian Molaro — Cristian Molaro is an independent DB2 specialist and an IBM Gold Consultant. He was recognized by IBM as an IBM Champion in 2009, 2010, and 2011. His main activity is focused on DB2 for z/OS administration and performance. Cristian has presented many papers at numerous international conferences and local user groups in Europe and North America. He is coauthor of five IBM Redbooks related to DB2, including the recent DB2 10 for z/OS Performance Topics, and he serves on the IDUG EMEA Conference Planning Committee.
Surekha Parekh — Surekha Parekh is IBM's World-Wide Marketing Program Director. She has more than 25 years' experience in B2B Market Management across a broad range of IT products and solutions with proven results. Surekha currently leads the Marketing for DB2 for z/OS globally and is responsible for market strategy, planning, and execution of tactics in IBM. A successful campaign and brand manager, Surekha has led several IBM global campaigns, including the 30th Anniversary of DB2. She is particularity customer-focused and understands the importance of Customer Relationship Management. Surekha also leads the Social Media Strategy for Information Management on System z. In this role, she has built several loyal social media communities for IBM on LinkedIn, Twitter, Google+, and Facebook, with over 10,000 members. Surekha also developed "The World of DB2" community (www.worldofdb2.com), a dedicated DB2 online community with over 3,000 members. Based in Warwick, United Kingdom, Surekha is a passionate marketer and a member of Chartered Marketers. She represents IBM on the International DB2 User Group (IDUG) committee and is currently the IDUG Marketing Chair.
Terry Purcell — Terry Purcell is a Senior Technical Staff Member with the IBM Silicon Valley Lab, where he is lead designer for the DB2 for z/OS Optimizer. Terry has two decades of experience with DB2 in database administration and application development as a customer, consultant, and DB2 developer.
Contents
CONTENTS About the Authors Introduction by Surekha Parekh
DB2 11 for z/OS: Unmatched Efficiency for Big Data and Analytics by Julian Stuhler, Triton Consulting DB2 11 for z/OS: The Database for Big Data and Analytics Efficiency CPU Reductions zEC12 Exploitation Application Compatibility Transparent Archiving Temporal Data Enhancements Global Variables Variable Arrays Java Stored Procedure Enhancements pureXML Enhancements Optimizer and Query Performance Improvements Data Sharing Performance Enhancements Utility Enhancements Other Efficiency Enhancements Resilience Extended Log Record Addressing: Current Issues Extended Log Record Addressing: DB2 11 Enhancements Enhanced Dynamic Schema Change BIND/REBIND Enhancements Security Enhancements Other Resilience Enhancements Business Analytics SQL Aggregation Improvements IBM DB2 Analytics Accelerator Enhancements Hadoop and Big Data Support QMF 11 Other Enhancements for Analytics Workloads Upgrading to DB2 11 DB2 Version Prerequisites Other Prerequisites Upgrade Timing Upgrade Process and Impact DB2 11 Customer Case Studies BMW Group Stadtwerke Bielefeld GmbH JN Data
Improved Query Performance in DB2 11 for z/OS by Terry Purcell Predicate Indexability Duplicate Removal Hash Join and Sparse Index Page Range Screening and Indexing for Partitioned Table Spaces RUNSTATS Enhancements Additional Performance Improvements Summary
IBM DB2 Utilities and Tools with DB2 11 for z/OS by Haakon Roberts
How DB2 for z/OS Can Help Reduce Total Cost of Ownership by Cristian Molaro Business Needs and DB2 TCO DB2 and TCO Reducing TCO Through Synergy with System z DB2 Synergy with System z Reducing TCO Through CPU Savings DB2 10 CPU Savings and Performance Improvements DB2 10 Performance Expectations DB2 11 CPU Savings and Performance Improvements DB2 11 Performance Expectations Specialty Engines DB2 10 and Specialty Engines DB2 11 and Specialty Engines Estimating zIIP Savings Special Considerations for High zIIP Utilization DB2 and zAAP on zIIP Reducing TCO with Better Performance Identifying Better Performance Opportunities Getting Better Performance with REBIND DB2 Plan Management DB2 11 APREUSE(WARN) Enhancement DB2 11 RELEASE(DEALLOCATE) Optimization DB2 11 Application Compatibility and APPLCOMPAT Case Study: Performance Benefits of REBIND DB2 EXPLAIN At a Glance DB2 10 High-Performance DBATs Reducing TCO Through Storage Savings DB2 Data Compression DB2 Managed Disk Space Allocation Case Study: Combined Effects of Data Compression and DB2 Managed Disk Space Allocation Index Compression Reducing TCO with Faster Analytics IBM DB2 Analytics Accelerators Leverage Legacy QMF Objects Reducing TCO with Improved Scalability DB2 10 Throughput Enhancements DB2 Storage and Scalability Data Sharing Member Consolidations Conclusion
Cristian Molaro —
Surekha Parekh —
Terry Purcell —
