DB2 10 for z / OS: Cost Savings . . . Right Out of the Box - Softcover

Beulke, Dave; Miller, Roger; Parekh, Surekha; Stuhler, Julian

Softcover

ISBN 10: 1583473610 ISBN 13: 9781583473610

Verlag: MC Press, LLC, 2010

Inhaltsangabe

Providing expert knowledge about the features in the new release of DB2 for z/OS, this extensive guide details the innovations of DB2 10’s SQL and pureXML enhancements—which increase productivity, enhance performance, and simplify application ports. DB2 for z/OS continues to be the undisputed leader in total system availability, scalability, security, and reliability at the lowest cost per transaction. This resource focuses on the features and functions of DB2 10 for IT, including improving operational efficiencies and reducing costs, as well as covering innovations in resiliency for business-critical information, rapid application and warehouse deployment for business growth, and enhanced business analytics and mathematical functions with QMF.

Über diesen Titel

Über die Autorinnen und Autoren

David Beulke is a DB2 consultant, author, and instructor, with extensive expertise in database performance, data warehouses, and Internet applications. He is currently a member of the IBM DB2 Gold Consultant program. He lives in Alexandria, Virginia. Roger Miller is a DB2 for z/OS technical evangelist, architect, and designer who has worked on many facets of DB2. He lives in San Jose, California. Surekha Parekh is IBM&;s worldwide marketing program director for DB2 for z/OS and leads the social media strategy for information management on System z. She is the coauthor of DB2 10 for z/OS: The Smarter, Faster Way to Upgrade and The Business Value of DB2 for z/OS: IBM DB2 Analytics Accelerator and Optimizer. Julian Stuhler is a principal consultant with Triton Consulting, a UK-based company specializing in the provision of DB2 consultancy, education, software, and managed services to clients throughout Europe.

David Beulke is a DB2 consultant, author, and instructor, with extensive expertise in database performance, data warehouses, and Internet applications. He is currently a member of the IBM DB2 Gold Consultant program. He lives in Alexandria, Virginia. Roger Miller is a DB2 for z/OS technical evangelist, architect, and designer who has worked on many facets of DB2. He lives in San Jose, California. Julian Stuhler is a principal consultant with Triton Consulting, a UK-based company specializing in the provision of DB2 consultancy, education, software, and managed services to clients throughout Europe.

Auszug. © Genehmigter Nachdruck. Alle Rechte vorbehalten.

DB2 10 for z/OS

The Smarter, Faster Way to Upgrade

By John Campbell, Cristian Molaro, Surekha Parekh

MC Press

Copyright © 2011 IBM
All rights reserved.

ISBN: 978-1-58347-361-0

Contents

About the Authors, 
Preface, 
Why Read This Book?, 
Introduction, 
Hear What Our Customers Are Saying About DB2 10 for z/OS, 
PART I: Planning for IBM DB2 10 for z/OS by John Campbel, 
Executive Summary, 
Introduction, 
Highlights of the Beta Test, 
Performance and Scalability, 
Accounting Trace Class 3 enhancement, 
Availability, 
Other Issues, 
Incompatible Changes, 
Migration and Planning Considerations, 
Security Considerations When Removing DDF Private Protocol, 
Items Planned for Post-GA Delivery, 
Summary, 
PART II: Gaining the Financial Benefits of DB2 10 for z/OS by Cristian Molaro, 
Introduction, 
Why Performance Matters, 
DB2 10 for z/OS Performance and Cost Savings, 
Building the DB2 10 for z/OS Business Case, 
Some Invaluable Performance Benefits of DB2 10, 
Notes, 
Acknowledgements, 

CHAPTER 1

Planning for IBM DB2 10 for z/OS Upgrade

by John Campbell

Executive Summary

In the spring of 2010, DB2 10 for z/OS was released to 24 worldwide customers for beta testing. The evaluation focused on regression testing, "out-of-the-box" performance, and additional performance and scalability, as well as other new functions.

Customer experience and feedback about the program have been mainly positive, and most customers who were involved in the program plan to start migration to DB2 10 for z/OS in 2011. An incremental improvement was observed in the effectiveness of the program, in terms of the quality of the issues and problems found, relative to the respective programs for DB2 Version 8 and Version 9. Some customers did very well with regression and new function testing; others provided only limited qualification about what they did and what they achieved.

After the early stages of planning and execution, it is often difficult for customers to sustain the effort required during a six-month period, due to competing business and technical priorities. People, hardware, and time are usually constrained to varying degrees. As of the end of the beta program, no customers were in "true, business production."

The release of DB2 10 for z/OS provides many opportunities for price/performance and scalability improvements. But there is a tradeoff in terms of some increased real storage consumption. Customers need to carefully plan, provision, and monitor their real storage consumption.

The new, 64-bit SQL runtime can provide generous, 31-bit virtual storage constraint relief in the DB2 DBM1 address space. This support provides enhanced vertical performance scalability of an individual DB2 subsystem or DB2 member. It also opens opportunities for further price/performance improvement, through greater use of persistent threads running with the BIND option RELEASE(DEALLOCATE), DB2 member consolidation, and LPAR consolidation.

Introduction

This paper focuses on the planning stage of migrating to IBM DB2 10 for z/OS. The key points of emphasis are:

[check] Make sure everyone is educated as to what is needed to ensure project success.

[check] Production of a detailed project plan, communicated to all involved, is crucial for success.

[check] Some preparation can occur very early, in terms of understanding, obtaining, and installing the prerequisites.

The release of DB2 10 for z/OS was announced on February 9, 2010, and began shipping on March 12, 2010. It was the largest beta test program in the history of DB2 for z/OS.

The information in this paper is drawn from the lessons learned in cooperation with 24 of IBM's largest customers, representing a variety of industries and countries around the world. An extended beta test program started in Q3 2010 and lasted for six months. The program also included 73 parties in vendor programs.

These customers were looking mainly for 31-bit virtual storage constraint relief in the DBM1 address space and all opportunities for price/performance improvement. Other areas of interest included:

• Regression testing (Be sure to approach regression testing in the order in which you plan to move to production.)

• "Out-of-the-box" performance

• Additional performance improvements

• Scalability enhancements

• New functions

Stages of migration

The primary stages of migration to a new version are:

1. Planning

" Early stages:

• Making the decision to migrate

• Determining what can be gained

• Planning for prerequisites

• Avoiding incompatibilities

• Planning performance and storage

• Assessing available resources

2. Migration

3. Implementation of the new improvements

Needed application changes can be made over a longer period to make the migration process easier and less costly. Plans for monitoring virtual and real storage resource consumption, as well as performance, are necessary. An early health check, communication of the required changes, and staging of the work will make the project go much more smoothly.

Highlights of the Beta Test

DB2 10 for z/OS delivers great value by reducing CPU resource consumption in most customer cases. IBM internal testing and early beta customer results revealed that, depending on the specific workload, many customers could achieve "out-of-the-box" DB2 CPU savings of up to 10 percent for traditional OLTP workloads and up to 20 percent for specific new workloads (e.g., native SQL procedures), compared with running the same workloads on DB2 9 for z/OS.

The objective of providing and proving generous, 31-bit virtual storage constraint relief in the DBM1 address space was achieved by the end of the program. This achievement is significant in terms of the enhanced vertical scalability of an individual DB2 subsystem or DB2 member of a data sharing group. We are confident that customers can scale up, in practical terms, the number of active threads by 5 to 10 times to meet their demands.

Further opportunities for price/performance improvement are made possible through the use of persistent threads with the BIND option RELEASE(DEALLOCATE). Examples of using persistent threads include protected ENTRY threads with Customer Information Control System (CICS®), Wait For Input (WFI) regions with Information Management System/Transaction Manager (IMS/TM), and high-performance database access threads (DBATs) for incoming Distributed Data Facility (DDF) workloads.

Another goal was to improve INSERT performance, particularly in the area of universal table spaces (UTS). We wanted to ensure that insert performance for UTS was equal to, or better than, the classic table space types, such as segmented and partitioned. This goal was achieved in most cases.

Hash access was good, provided we hit the smaller-than-expected "sweet spot." Results for complex queries were also good.

Provided users chose the correct value, the performance of inline large objects (LOBs) was also impressive. Support for inline LOB column values has the potential to save even more on performance by avoiding indexed access to the auxiliary table space. However, it is important to note that the value...

Details zur Ausgabe

• Verlag: MC Press, LLC
• Erscheinungsdatum: 2010
• Sprache: Englisch
• ISBN 10: 1583473610
• ISBN 13: 9781583473610
• Einband: Taschenbuch
• Auflage: 1
• Anzahl der Seiten: 94
• Kontakt zum Hersteller: Nicht verfügbar
• Verantwortliche Person: Nicht verfügbar