Cristian Molaro - DB2 11 The Database for Big Data & Analytics

DB2 11: The Database for Big Data and Analytics

Cristian Molaro, Surekha Parekh, Terry Purcell, and Julian Stuhler

First Edition

First PrintingOctober 2013

Copyright 2013 IBM. All rights reserved.

Every attempt has been made to provide correct information. However, the pub-lisher and the author do not guarantee the accuracy of the book and do not assume responsibility for information included in or omitted from it.

Please be aware that the actual programming techniques, algorithms and all numerical parameters used in examples given in this work are subject to change at some future date either by a new version of DB2, a new release, a small programming enhancement (SPE) or a programming temporary fix (PTF).

The information contained in this document has not been submitted to any format review and is distributed on an as is basis without any warranty either express or implied. The use of this information or the implementation of any of these techniques is a customer responsibility and depends on the customers ability to evaluate and integrate them into the customers operational environment. While each item may have been reviewed for accuracy in a specific situation, there is no guarantee that the same or similar results will be obtained elsewhere. Customers attempting to adapt these techniques to their own environments do so at their own risk.

The following terms are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both: IBM, AIX, BigInsights, CICS, DB2, DRDA, FlashCopy, IMS, InfoSphere, iSeries, OMEGAMON, Optim, OS/390, pureXML, QMF, RACF, SPSS, System z, System z9, System z10, Tivoli, WebSphere, z/OS, z9, z10, zArchitecture, and zEnterprise. Netezza is a registered trademarks of IBM International Group B.V., an IBM Company. A current list of IBM trademarks is available on the Web at http://www.ibm.com/legal/copytrade.shtml.

Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both. Microsoft, Excel, SQL Server, Windows, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both. Java, Oracle, and all Java-based trademarks and logos are trademarks or registered trademarks of Oracle and/or its affiliates. UNIX is a registered trademark of The Open Group in the United States and other countries. Other company, product, or service names may be trademarks or service marks of others.

Printed in Canada. All rights reserved. This publication is protected by copyright, and per-mission must be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or likewise.

MC Press offers excellent discounts on this book when ordered in quantity for bulk purchases or special sales, which may include custom covers and content particular to your business, training goals, marketing focus, and branding interest.

Sales and Customer Service:

(208) 629-7275 ext. 500

Corporate Offices:

MC Press Online, LLC

3695 W. Quail Heights Court

Boise, ID 83703-3861 USA

www.mc-store.com

ISBN: 978-1-58347-385-6

Cristian Molaro() is an independent DB2 specialist and IBM Gold Consultant focused on DB2 for z/OS administration and performance. He was recognized as an IBM Champion in 2009, 2010, 2011, 2012, and 2013. Cristian has presented papers at several international conferences and local user groups in Europe and North America and is coauthor of eight IBM Redbooks related to DB2, including DB2 11 for z/OS Technical Overview. A recipient of the merit badge Platinum IBM Redbook Author, Cristian is part of the IDUG EMEA Conference Planning Committee and chairman of the DB2 LUW User Group BeLux. He was recognized by IBM as Top EMEA Consultant at the IDUG EMEA 2011 DB2 Tech Conference in Prague.

Julian Stuhler() is a Principal Consultant with Triton Consulting, a U.K. company providing DB2 consultancy, education, software, and managed services to clients throughout Europe. He has more than 25 years of relational database experience, working for clients in the insurance, telecom, banking, financial services, and manufacturing sectors. Julian has lectured widely on DB2 subjects, in both the United Kingdom and Europe, and he won the Best Overall Speaker award at the 2000 IDUG European Conference. Julian coauthored an IBM Redbook on Java stored procedures and contributes frequently to industry publications such as IDUG Solutions Journal and Database Journal. Julian is an IBM DB2 Gold Consultant, Past-President of the IDUG Board of Directors, and an IBM Champion.

Surekha Parekh() is IBMs World-Wide Marketing Program Director for DB2 for z/OS. She also leads the Social Media Strategy for Information Management on System z. Surekha is responsible for market strategy and planning of DB2 on System z and for building social media communities for Information Management System z. Based in Warwick, United Kingdom, Surekha is a passionate marketer with proven results. She has more than 27 years of business experience and is passionate about Information Management. Surekha represents IBM on the IDUG committee. IDUG is an independent DB2 user group with more than 16,000 members in more than 100 countries.

Terry Purcell() is a Senior Technical Staff Member, DB2 Development, 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.

by Surekha Parekh

I joined the DB2 business in 2008, just after the launch of IBM DB2 9 for z/OS. A lot has changed in the World of Data since then. In fact, a lot has changed in the world of business and information technologyand the changes are going to continue.

There has been an enormous explosion of data: 90 percent of the worlds data has been created over the past two years! We have also seen a rapid growth in the volume, variety, and velocity of data due to the explosion of smart devices, mobile applications, cloud computing, and social media. New technology innovations, hunger for data, and the thirst for business analytics signal that we are entering a new era of computingSmarter Computingthe era of Insight for Discovery.

Every second, there are

• 684,478 items shared on Facebook
• 100,000 tweets
• 2 million Google search queries
• 1 new member joining LinkedIn
• 58 hours of video uploaded to YouTube

Much of this data growth has been in unstructured data; however, IDC estimates that by 2020, business transactions on the Internetbusiness-to-business and business-to-consumerwill reach