Managing Ever-Increasing Amounts of Data with IBM DB2 for z/OS: Using Temporal Data Management, Archive Transparency, and the DB2 Analytics Accelerator

An IBM Redbooks publication

Published 25 September 2015, updated 20 October 2015

cover image

ISBN-10: 0738440965
ISBN-13: 9780738440965
IBM Form #: SG24-8316-00
(204 pages)

Authors: Mehmet Cuneyt Goksu, Claire McFeely, Craig McKellar, Xiao Hui Wang


IBM® DB2® Version 11.1 for z/OS® (DB2 11 for z/OS or just DB2 11 throughout this book) is the fifteenth release of DB2 for IBM MVS™. The DB2 11 environment is available either for new installations of DB2 or for migrations from DB2 10 for z/OS subsystems only.

This IBM Redbooks® publication describes enhancements that are available with DB2 11 for z/OS. The contents help database administrators to understand the new extensions and performance enhancements, to plan for ways to use the key new capabilities, and to justify the investment in installing or migrating to DB2 11.

Businesses are faced with a global and increasingly competitive business environment, and they need to collect and analyze ever increasing amounts of data (Figure 1). Governments also need to collect and analyze large amounts of data. The main focus of this book is to introduce recent DB2 capability that can be used to address challenges facing organizations with storing and analyzing exploding amounts of business or organizational data, while managing risk and trying to meet new regulatory and compliance requirements.

This book describes recent extensions to DB2 for z/OS in V10 and V11 that can help organizations address these challenges.

Table of contents

Part 1. Temporal data management
Chapter 1. Temporal data management overview
Chapter 2. System-period temporal tables
Chapter 3. Application-period temporal tables
Chapter 4. Bitemporal tables
Chapter 5. Additional considerations

Part 2. IBM DB2 archive transparency
Chapter 6. DB2 archive transparency overview
Chapter 7. DB2 archive transparency concepts
Chapter 8. Case study: Using archive transparency

Part 3. DB2 Analytics Accelerator
Chapter 9. DB2 Analytics Accelerator overview
Chapter 10. DB2 Analytics Accelerator High Performance Storage Saver overview
Chapter 11. Case study: Using the DB2 Analytics Accelerator

Part 4. Creating an integrated solution
Chapter 12. Case study: Combining DB2 temporal data management with the DB2 Analytics Accelerator
Chapter 13. Case study: Combining archive transparency with the DB2 Analytics Accelerator

Follow IBM Redbooks

Follow IBM Redbooks