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.

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