John Campbell - DB2 10 for z/OS: The Smarter, Faster Way to Upgrade

DB2 10 for z/OS: The Smarter, Faster Way to Upgrade

By John Campbell, Cristian Molaro, and Surekha Parekh

First Edition----list-style-type: upperroman

First PrintingOctober 2011

2011 IBM. All rights reserved.

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

The following terms are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both: IBM, CICS, DB2, DB2 Connect, Distributed Relational Database Architecture, Domino, Flashcopy, IMS, Lotus, MVS, OS/390, Parallel Sysplex, pureXML, Redbooks, System p, System x, System z, WebSphere, z10, z/OS, and z/VSE.

Java and all Java-based trademarks and logos are trademarks or registered trademarks of Oracle and/or its affiliates.

Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both.

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

MC Press Online, LLC

Corporate Offices

P.O. Box 4886

Ketchum, ID 83340-4886 USA

For information regarding sales and/or customer service, please contact:

MC Press

P.O. Box 4300

Big Sandy, TX 75755-4300 USA

Toll Free: (877) 226-5394

For information regarding permissions or special orders, please contact:

ISBN: 978-1-58347-345-0

John Campbell () is an IBM Distinguished Engineer reporting to the Director for z/OS Development at the IBM Silicon Valley Lab. He has extensive experience of DB2 in terms of systems, database, and applications design. John specializes in design for high performance and data sharing. He is one of IBMs foremost authorities for implementing high-end database/transaction-processing applications.

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 (

PART I: Planning for IBM DB2 10 for z/OS
by John Campbel

PART II: Gaining the Financial Benefits of DB2 10 for z/OS
by Cristian Molaro

We hope you enjoy our second book on DB2 10 for z/OS, which brings a focus on migration planning and financial benefits.

As you know, DB2 10 is the most significant release IBM has shipped in more than a decade, and we have focused our efforts in this release around three clear themes:

• Cost savings to our customers
• Simplifying database management with more automation
• Providing proven technology

The objective of this book is to help customers plan their migration strategy effectively and efficiently by providing the right information, facts, and guidance. The knowledge youll find in these pages will ensure not only that you are adopting IBM best practices but also that you will reap the cost savings and business benefits of DB2 10. We believe the guidance and direction captured here will help our customers gain competitive advantages by doing more with less more business insight, more performance, and more operational efficiency with less cost.

The launch of this book is timely, with support for IBM DB2 for z/OS Version 8 retiring in April 2012. For the first time in the history of DB2 for z/OS, customers can skip a level and not only take advantage of features in DB2 9 but also realize the immediate cost savings in DB2 10. Upgrading to the latest version of database software can be a time-consuming, expensive, and confusing process. Deciding whether you are the right candidate to skip a release is a difficult decision unless you have access to the right information, facts, and guidance to help you make that judgment. This book will help simplify some of these decisions.

For the first time in the history of DB2 for z/OS, customers can skip a level and not only take advantage of features in DB2 9 but also realize the immediate cost savings in DB2 10.

This book is segmented into two parts:

• Planning for DB2 10 for z/OS upgrade
• Gaining the financial benefits of DB2 10 for z/OS

Part I focuses on the planning stage of upgrading to IBM DB2 10 for z/OS. This section will help customers plan their migration strategy effectively and efficiently and will help support a successful upgrade.

Part II focuses on providing insight into how the performance benefits of DB2 10 for z/OS can positively impact your costs. One objective of this section is to give you valuable information that leads to a more in-depth analysis of your organizations opportunities to gain the most out of DB2 10.

I want to make sure you are all aware of our virtual community, The World of DB2 for z/OS (http://db2forzos.ning.com), which is available 24x7 and currently has more than 800 members. This site is a one-stop shop and hosts a collection of online resources, including webcasts, whitepapers, blogs, virtual chats, videos, and much more. Complementing this resource is IDUG, the independent DB2 user community (http://www.idug.org), which hosts conferences in Asia Pacific, Australasia, EMEA, and North America each year. Both of these communities are free and open to all interested parties. They are a great way to meet like-minded individuals, have fun, and at the same time grow and develop your DB2 skills.

I would like to thank John Campbell and Cristian Molaro for writing this fantastic book. I thank you as well, and I hope you enjoy the book. Please do not hesitate to contact me directly if I can be of help to you in any way.

Surekha Parekh
World-Wide Marketing Program Director
IBM DB2 for z/OS
October 2011