DB2 11: The Ultimate Database for Cloud, Analytics & Mobile

Building on the previously published DB2 11: The Database for Big Data and Analytics, published in 2013, this book is particularly for new and existing DB2 for z/OS customers and users who want to learn as much as they can about the new software version before migrating their organizations to DB2 11 for z/OS. The guide begins with a technical overview of DB2 11 features and explains how the new functions in DB2 11 can help enterprise customers address the challenges they face with the explosion of data and information. There has been rapid growth in the variety, volume, and velocity of data due to the increase of smart devices, mobile applications, cloud computing, and social media, and many of the enhancements in DB2 11 are focused on enabling enterprise customers to respond to these market opportunities in a cost-effective way. The next part of the book is a detailed discussion for helping customers plan their DB2 11 migration strategy. This section also shares experiences of people who have already upgraded to DB2 11 and participated in IBM's Early Support Program. A third section of the book addresses one of the most common obstacles that prevents customers from migrating to a new release: the need to implement any code changes required due to application incompatibilities. With DB2 11's "application compatibility" support, such applications can now continue to run under the new release until those changes can be implemented, removing them as an upgrade dependency.
1301469028
DB2 11: The Ultimate Database for Cloud, Analytics & Mobile

Building on the previously published DB2 11: The Database for Big Data and Analytics, published in 2013, this book is particularly for new and existing DB2 for z/OS customers and users who want to learn as much as they can about the new software version before migrating their organizations to DB2 11 for z/OS. The guide begins with a technical overview of DB2 11 features and explains how the new functions in DB2 11 can help enterprise customers address the challenges they face with the explosion of data and information. There has been rapid growth in the variety, volume, and velocity of data due to the increase of smart devices, mobile applications, cloud computing, and social media, and many of the enhancements in DB2 11 are focused on enabling enterprise customers to respond to these market opportunities in a cost-effective way. The next part of the book is a detailed discussion for helping customers plan their DB2 11 migration strategy. This section also shares experiences of people who have already upgraded to DB2 11 and participated in IBM's Early Support Program. A third section of the book addresses one of the most common obstacles that prevents customers from migrating to a new release: the need to implement any code changes required due to application incompatibilities. With DB2 11's "application compatibility" support, such applications can now continue to run under the new release until those changes can be implemented, removing them as an upgrade dependency.
16.95 Out Of Stock
DB2 11: The Ultimate Database for Cloud, Analytics & Mobile

DB2 11: The Ultimate Database for Cloud, Analytics & Mobile

DB2 11: The Ultimate Database for Cloud, Analytics & Mobile

DB2 11: The Ultimate Database for Cloud, Analytics & Mobile

Paperback

$16.95 
  • SHIP THIS ITEM
    Temporarily Out of Stock Online
  • PICK UP IN STORE

    Your local store may have stock of this item.

Related collections and offers


Overview


Building on the previously published DB2 11: The Database for Big Data and Analytics, published in 2013, this book is particularly for new and existing DB2 for z/OS customers and users who want to learn as much as they can about the new software version before migrating their organizations to DB2 11 for z/OS. The guide begins with a technical overview of DB2 11 features and explains how the new functions in DB2 11 can help enterprise customers address the challenges they face with the explosion of data and information. There has been rapid growth in the variety, volume, and velocity of data due to the increase of smart devices, mobile applications, cloud computing, and social media, and many of the enhancements in DB2 11 are focused on enabling enterprise customers to respond to these market opportunities in a cost-effective way. The next part of the book is a detailed discussion for helping customers plan their DB2 11 migration strategy. This section also shares experiences of people who have already upgraded to DB2 11 and participated in IBM's Early Support Program. A third section of the book addresses one of the most common obstacles that prevents customers from migrating to a new release: the need to implement any code changes required due to application incompatibilities. With DB2 11's "application compatibility" support, such applications can now continue to run under the new release until those changes can be implemented, removing them as an upgrade dependency.

Product Details

ISBN-13: 9781583474013
Publisher: MC Press, LLC
Publication date: 02/01/2015
Pages: 112
Product dimensions: 6.00(w) x 9.00(h) x 0.40(d)

About the Author


John Campbell is an IBM distinguished engineer reporting to the director for z/OS development at the IBM Silicon Valley Lab. He specializes in design for high performance and data sharing and is one of IBM’s foremost authorities for implementing high-end database and transaction-processing applications. He is a coauthor of The Business Value of DB2 for z/OS: IBM DB2 Analytics Accelerator and Optimizer and DB2 10 for z/OS: The Smarter, Faster Way to Upgrade. Chris Crone is a distinguished engineer with the IBM DB2 for z/OS development team, where he has worked for 25 years. He is the team lead for the RDS Execution Engine team and has been working on improving the performance and scalability of DB2 for z/OS. Gareth Jones is a member of IBM’s DB2 for z/OS SWAT Team. He previously worked for IBM’s strategic outsourcing division and in BetaWorks. They both live in San Jose, California. Surekha Parekh is IBM’s worldwide marketing program director. She has more than 25 years of experience in B2B market management and leads the marketing for DB2 for z/OS globally. She is a coauthor of The Business Value of DB2 for z/OS: IBM DB2 Analytics Accelerator and Optimizer, DB2 10 for z/OS: The Smarter, Faster Way to Upgrade, and DB2 11: The Database for Big Data & Analytics. Jay Yothers is an IBM DB2 for z/OS architect. He has been part of the DB2 development organization since the very first release of DB2 and has designed and developed many key features of DB2 for z/OS. He has been awarded more than 20 patents for his work in DB2 for z/OS. He lives in San Jose, California.

Table of Contents

About the Authors iii

Introduction Surekha Parekh ix

DB2 11 for z/OS: Technical Overview John Campbell Gareth Jones 1

DB2 11 Performance Expectations 2

Performance Expectations for OLTP and Batch 2

Performance Expectations for Queries 3

DB2 11 Performance Expectations Summary 4

Performance Highlights 4

ESP Customer Feedback 6

DB2 11 Performance Improvements in More Detail 7

No REBIND Required 7

REBIND Required-With or Without APREUSE 13

REBIND Required-Without APREUSE 15

DBA or Application Programmer Effort Required 16

DB2-Related Enhancements in z/OS 2.1 17

Buffer Pool Enhancements 18

Query Performance and Management Improvements 19

Optimizer Externalization of Missing or Conflicting Statistics 19

APREUSE(WARN) 20

DPS1 Improvements 21

Availability Improvements 21

Extended RBA and LRSN 21

BIND, REBIND, DDL, and Online REORG Break-in with Persistent Threads 22

Online Schema Changes 23

RAS Improvements 24

Autonomic Index Pseudo-Delete Cleanup 25

Reduction of Overflow Rows and Indirect References 26

DDF Enhanced Client Information Fields 27

Data Sharing Improvements 27

Security Enhancements 29

Utility Enhancements 30

Analytics Improvements 31

Temporal Data Enhancements 31

Transparent Archive Query 32

New Analytics Features 32

Integration with Big Data 33

New Application Features 33

Mobile Application Support 34

Easier DB2 Version Upgrade with Application SQL Compatibility 34

DB2 11 for z/OS: Migration Planning and Early Customer Experiences John Campbell Gareth Jones 37

DB2 11 Major Themes 38

DB2 11 for z/OS: Migration Planning and Early Customer Experiences 37

DB2 11 Major Themes 38

CPU Savings 38

Enhanced Resiliency and Continuous Availability 38

Enhanced Business Analytics 39

Simpler, Faster DB2 Version Upgrades 39

ESP Highlights 40

DB2 11 Early Support Program Customer Feedback 40

Migration Considerations 42

Prerequisites: Hardware and Software 42

Customer Quotes from the DB2 11 Early Support Program 43

Prerequisites: DB2 Connect 44

Pre-Migration Planning 46

Important Preparation 46

Preparing Your Current DB2 10 NFM for Migration to DB2 11 CM 47

DB2 11 Migration Overview 48

Migration and Fallback Paths 49

APPLCOMPAT: Application Compatibility 49

Availability 51

BIND/REBIND/DDL/Online REORG Break-in with Persistent RELEASE(DEALLOCATE) Threads 51

Persistent Thread Break-in: ESP Customer Testing Experiences 53

Improved Control When Altering Partition Limit Keys 54

Drop Column 55

Utility Enhancements 55

REORG Enhancements 55

RUNSTATS and RTS Enhancements 58

RECOVER Enhancements 59

Performance and Scalability 59

Performance Enhancements: No REBIND Needed (CM) 60

Performance Enhancements Requiring REBIND 61

Performance Enhancements Requiring DBA or Application Effort (NFM) 62

DB2 Lab Performance Measurement Summary 63

Example of Customer Performance Testing 63

Automatic Pseudo-Deleted Index Entry Cleanup 66

Performance Enhancements 69

Q Replication Log Filtering 69

Archive Transparency 69

Optimizer Enhancements 69

GROUP BY Grouping Sets 69

Extended LRBA/LRSN 70

Other Performance Recommendations 75

Performance Summary 76

Other Enhancements 76

Remove Package Security Vulnerabilities 76

Archive Transparency 77

For More Information 77

DB2 11 Resources 78

DB2 10 Migration to DB2 11 and Application Compatibility Chris Crone Jay Yothers 79

Migration Prerequisites 79

Modes of Migration 81

Functional Availability 82

Optional Migration Processing 84

The Essentials of Migration 85

Application Compatibility in DB2 11 for z/OS 85

Description of the Problem 85

Impact to Customers 86

Solution Requirements 86

Solution 87

Solution Details 88

Interaction with NFM 88

Identifying Applications That Need to Be Examined 88

New Reserved Words 89

New Reserved Word Solution 90

Pre-Migration Planning 90

What's Not Part of This Solution 91

Summary 91

Case Studies

BMW Group Develops Eco-Friendly Innovation for Smart Drivers with IBM 93

JN Data Gets the Early Adopter Advantage for Its Growing Business 97

From the B&N Reads Blog

Customer Reviews