DB2 UDB for z/OS V8: Through the Looking Glass and What SAP Found There

An IBM Redbooks publication

Published 16 December 2003, updated 17 September 2004

cover image

ISBN-10: 0738498505
ISBN-13: 9780738498508
IBM Form #: SG24-7088-00
(234 pages)

More options

Rate and comment

Authors: Paolo Bruni, Tim Bohlsen, Mark Keimig, Peter Mohrholz, Johannes Schuetzner, Thomas Wilson


DB2 UDB for z/OS Version 8 (DB2 V8) introduces a large number of new features that provide for unmatched scalability, availability, performance, and manageability to reliably handle any information needed in SAP solutions. The objective of this IBM Redbooks publication is to identify the new features of DB2 V8 that are particularly beneficial to SAP and to describe how SAP applications can take advantage of these new features. While some of these features can be exploited transparently by the currently available versions of DB2, for some others the next technological release of SAP will be required. The book introduces the new features and provides real-life examples from SAP to demonstrate the usefulness of the new features for SAP and to show how SAP can exploit them.

The considerations within this book apply to the whole spectrum of business solutions within the mySAP Business Suite, such as mySAP ERP and mySAP Supply Chain Management. These solutions share the common technical application platform SAP NetWeaver that includes the SAP Web Application Server and SAP Business Information Warehouse.

While this book specifically investigates the new features of DB2 V8 in the context of SAP, the majority of the considerations also apply to other enterprise packaged applications. The reason for this it that from a database management perspective, these applications have many similarities, such as a strong usage of dynamic SQL and a large number of database objects. For a more general description of the new features of DB2 V8, see DB2 UDB for z/OS Version 8: Everything You Ever Wanted to Know , ... and More, SG24-6079.

Table of contents

Chapter 1. Introduction
Chapter 2. Architecture
Chapter 3. Usability, availability, and scalability
Chapter 4. SAP Business Information Warehouse
Chapter 5. Performance
Chapter 6. Tools and administration
Chapter 7. System point in time backup and recovery
Appendix A. DB2 V8 changes to installation defaults

Follow IBM Redbooks

Follow IBM Redbooks