Contents

About the Authors

Introduction by Surekha Parekh

DB2 11 for z/OS: Unmatched Efficiency for Big Data and Analytics

by Julian Stuhler, Triton Consulting

DB2 11 for z/OS: The Database for Big Data and Analytics

Efficiency

CPU Reductions

zEC12 Exploitation

Application Compatibility

Transparent Archiving

Temporal Data Enhancements

Global Variables

Variable Arrays

Java Stored Procedure Enhancements

pureXML Enhancements

Optimizer and Query Performance Improvements

Data Sharing Performance Enhancements

Utility Enhancements

Other Efficiency Enhancements

Resilience

Extended Log Record Addressing: Current Issues

Extended Log Record Addressing: DB2 11 Enhancements

Enhanced Dynamic Schema Change

BIND/REBIND Enhancements

Security Enhancements

Other Resilience Enhancements

Business Analytics

SQL Aggregation Improvements

IBM DB2 Analytics Accelerator Enhancements

Hadoop and Big Data Support

QMF 11

Other Enhancements for Analytics Workloads

Upgrading to DB2 11

DB2 Version Prerequisites

Other Prerequisites

Upgrade Timing

Upgrade Process and Impact

DB2 11 Customer Case Studies

BMW Group

Stadtwerke Bielefeld GmbH

JN Data

Improved Query Performance in DB2 11 for z/OS

by Terry Purcell

Predicate Indexability

Duplicate Removal

Hash Join and Sparse Index

Page Range Screening and Indexing for Partitioned Table Spaces

RUNSTATS Enhancements

Additional Performance Improvements

Summary

IBM DB2 Utilities and Tools with DB2 11 for z/OS

by Haakon Roberts

How DB2 for z/OS Can Help Reduce Total Cost of Ownership

by Cristian Molaro

Business Needs and DB2 TCO

DB2 and TCO

Reducing TCO Through Synergy with System z

DB2 Synergy with System z

Reducing TCO Through CPU Savings

DB2 10 CPU Savings and Performance Improvements

DB2 10 Performance Expectations

DB2 11 CPU Savings and Performance Improvements

DB2 11 Performance Expectations

Specialty Engines

DB2 10 and Specialty Engines

DB2 11 and Specialty Engines

Estimating zIIP Savings

Special Considerations for High zIIP Utilization

DB2 and zAAP on zIIP

Reducing TCO with Better Performance

Identifying Better Performance Opportunities

Getting Better Performance with REBIND

DB2 Plan Management

DB2 11 APREUSE(WARN) Enhancement

DB2 11 RELEASE(DEALLOCATE) Optimization

DB2 11 Application Compatibility and APPLCOMPAT

Case Study: Performance Benefits of REBIND

DB2 EXPLAIN At a Glance

DB2 10 High-Performance DBATs

Reducing TCO Through Storage Savings

DB2 Data Compression

DB2 Managed Disk Space Allocation

Case Study: Combined Effects of Data Compression and DB2 Managed Disk Space Allocation

Index Compression

Reducing TCO with Faster Analytics

IBM DB2 Analytics Accelerators

Leverage Legacy QMF Objects

Reducing TCO with Improved Scalability

DB2 10 Throughput Enhancements

DB2 Storage and Scalability

Data Sharing Member Consolidations

Conclusion