MC Press Online
Welcome to the MC Press Online!
Need help withour eBooks?
Click here, to go to our main store

  MC Press Online eBookStore  

DB2 11: The Database for Big Data & Analytics
preview of book DB2 11: The Database for Big Data & Analytics
text of book DB2 11: The Database for Big Data & Analytics

DB2 11: The Database for Big Data & Analytics

Publisher: MC Press Online
Publication Date: 2013
Subject: Database: DB2
Number of Pages: 129

Free Preview    Email to Friend   Add to wish list
 Available as: (for format`s description click on its name)
Individual E-Version (PDF) Individual E-Version (PDF) ISBN: 9781583473856  
 Reg.: $
17.99 per N pages
 You Save: 
$4.40 (24%)
 Online  Open CopyPrint    
all time
Printed Edition   see MC Press Online    
About this title
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 (, 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.

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
    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
    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

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
Related titles
Big Data AnalyticsBig Data Analytics
Big Data GovernanceBig Data Governance
DB2 10 for z/OS Database Administration: Certification Study Guide (Exam 612)DB2 10 for z/OS Database Administration: Certification Study Guide (Exam 612)
DB2 10 for z/OS: Cost Savings . . . Right Out of the BoxDB2 10 for z/OS: Cost Savings . . . Right Out of the Box
DB2 10 for z/OS: The Smarter, Faster Way to UpgradeDB2 10 for z/OS: The Smarter, Faster Way to Upgrade
DB2 11: The Ultimate Database for Cloud, Analytics & MobileDB2 11: The Ultimate Database for Cloud, Analytics & Mobile
IBM DB2 for z/OS: The Database for Gaining a Competitive Advantage!IBM DB2 for z/OS: The Database for Gaining a Competitive Advantage!
IBM InfoSphereIBM InfoSphere
IBM Mainframe SecurityIBM Mainframe Security
  Special Offer Code  
Enter your Special Offer Code here:
  Search for  

  Our Products  
Browse all »»
SQL Built-In Functions and Stored Procedures
IBM WebSphere Portal Primer
From Idea to Print, Chapter 01: Before You Begin

If download option is selected, Adobe Acrobat 5.0 or lateris requiredto read our e-books*

*Windows PC, Mac OS9/OSX, and Linux