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

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

Overview

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.

Product Details

ISBN-13:	9781583473610
Publisher:	MC Press, LLC
Publication date:	11/01/2010
Pages:	104
Product dimensions:	5.90(w) x 8.90(h) x 0.30(d)

About the Author

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.

Table of Contents

About the Authors iii

Preface Surekha Parekh vii

Why Read This Book? viii

Introduction Roger Miller 1

DB2 10 for z/OS: A Smarter Database for a Smarter Planet Julian Stuhler 7

Executive Summary 7

Section I Introduction 9

Section II DB2 10: A Smarter Database 10

Efficiency 10

Resilience 34

Growth 41

Business Analytics 47

Section III Upgrading to DB2 10 51

Skip Migration 51

DB2 V8 Support 53

Section IV DB2 10 Customer Case Studies 55

Case Study #1 Banco do Brasil 55

Case Study #2 BMW Group 56

Section V Summary 58

Appendix: DB2 9 Review 59

Notes 65

DB2 10 for z/Os: CPU Savings...Right Out of the Box Dave Beulke 67

Executive Summary 67

Section I Performance Availability 70

Many Performance Enhancements 70

New and Improved Online Schema Changes 75

INCLUDE Non-Unique Columns Within a Unique Index 77

New Hash Space and Access Method 77

DB2 Catalog Enhancements 78

Section:II Scalability, Simplification, Security 79

Full 64-bit Runtime Environment Exploited 79

Plan Stability: Package Presevation 79

RUNSTATS Improvements and Auto Stats 80

Improved and Finer-Grained Access Control 80

Section III Application Enablement 82

pureXML Enhancements 82

Temporal Queries and Their Business Advantages 84

Timestamp, TIME ZONE, and Other Data Type Enhancements 86

Access to Currently Committed Data 87

SQL Compatibility Improvements 88

Section IV Data Warehousing 91

Support for Temporal Tables and Versioning 91

OLAP Functionality Built Directly into DB2 91

Advanced business Analystics 92

Section V Reduced Total Cost of Ownership 93

Useful UrLs 94

Editorial Reviews

"This book covers all the great features and functions that the IBM team has worked so hard to provide in this release of DB2 10 for z/OS. The focus was on delivering business value and ensuring customers would be able to realize immediate benefit from the new release."  —Rick Bowers, director of DB2 for z/OS, IBM



"This book helps explain the core benefits of DB2 for z/OS and enables customers and partners to quickly learn about the latest enhancements in DB2 10 and exploit this new technology to gain competitive edge."  —Surekha Parekh, World-Wide DB2 for z/OS marketing manager, IBM

From the Publisher