The Business Value of DB2 for z/OS: IBM DB2 Analytics Accelerator and Optimizer

by John Campbell, Namik Hrle, Ruiping Li, Surekha Parekh, Terry Purcell

Overview

Celebrating the 30th anniversary of the first release of DB2, this book highlights the important milestones, capabilities, and impacts of the database management software for IBM’s mainframe operating system. Special focus is given to IBM DB2 Analytics Accelerator, covering the key design and operational aspects that enable IBM DB2 for z/OS clients to benefit from faster performance, reduced CPU usage, and lower costs. The second half of the book discusses performance enhancements and cost-saving measures in the version 10 release and is rich with hints and tips for a successful upgrade. A special section on query performance and IBM DB2 Optimizer illustrates how DB2 10 addresses customer issues such as reducing total cost of ownership while maintaining stability and reliability. The final section is a collection of case studies in which DB2 10 for z/OS customers share their migration experiences and articulate the business benefits they are seeing since upgrading to the new release.

Product Details

ISBN-13:	9781583473818
Publisher:	MC Press, LLC
Publication date:	05/28/2013
Pages:	144
Product dimensions:	6.00(w) x 9.00(h) x 0.40(d)

About the Author

John Campbell is an IBM distinguished engineer and one of IBM’s foremost authorities for implementing high-end database and transaction-processing applications. He is the coauthor of DB2 10 for z/OS. Namik Hrle is an IBM distinguished engineer and a member of the IBM Academy of Technology. He works in the IBM Boeblingen Development Laboratory in Germany as the chief information management technologist. Ruiping Li is a senior software engineer in DB2 for z/OS development at the IBM Silicon Valley Lab. She lives in San Francisco. 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. 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. He lives in Springfield, Illinois.

Table of Contents

About the Authors iii

Foreword Don Haderle vii

Introduction Surekha Parekh ix

30 Years of Innovation xi

The Vision of DB2 xix

Revolution in IBM DB2 Performance: IBM DB2 Analytics Accelerator Namik Hrle Ruiping Li Wolfgang Hengstler 1

Abstract 1

Objectives 1

Introduction 2

What Is Business Analytics? 2

How Business Analytics Can Help Your Organization 3

Key Design and Operational Features 6

Query Execution Process Flow 8

DB2 Analytics Accelerator Content Maintenance 9

DB2 Analytics Accelerator Table Definition and Deployment 10

High-Performance Storage Saver 10

Connectivity Options 10

Disaster Recovery Considerations 10

Query Acceleration Criteria 12

Query Acceleration Control Knobs 12

EXPLAIN Function 13

System-Scope Instrumentation 16

Thread-Scope Instrumentation 17

DB2 Analytics Accelerator Administrative Stored Procedures 17

DISPLAY ACCELerator Command 18

Performance Considerations 19

The PureData System for Analytics S-Blade, Based on Netezza Technology 21

Applying Data Stream Processing to DB2 Queries 22

Comparing PureData System for Analytics Appliance Models 23

Minimizing Disk Failures 23

Minimizing S-Blade Failures 23

Summary 23

DB2 10 for z/OS Query Optimization Update Terry Purcell 27

Access Path Management 28

DB2 10 Takes Plan Management to the Next Level 32

Predicate Processing and Runtime Optimizations 38

Sort Performance Enhancements 51

New Choices for the Query Optimizer 52

Improving Parallelism Efficiency and Removing Limitations 57

Improving the Inputs to the Query Optimizer 61

Summary 65

Planning for IBM DB2 10 for z/OS Upgrade John Campbell 66

Highlights of the Beta Program Testing 67

Performance and Scalability 70

Availability 86

Other Issues 88

Incompatible Changes 90

Migration and Planning Considerations 91

Items Planned for Post-GA Delivery 104

When Should You Migrate to DB2 10 for z/OS? 107

Summary 108

DB2 10 for z/OS Case Studies

Kela Invests in Improving Service Delivery for Finland's Citizens 110

Primerica Improves Efficiency and Gains More Flexibility 112

GAD Upgrades Database Systems to Boost Power and Productivity 115

DB2 10 for z/OS Eases Workload Consolidation for Bankdata and JN Data 119

Bank Hapoalim Improves Efficiency, Reduces Tape Usage by 25 Percent 121