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
Capabilities to excel at business-critical analytics
Simpler, faster upgrades for faster ROI
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 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