Skip to main content

DB2 UDB ESE V8 non-DPF Performance Guide for High Performance OLTP and BI

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.


Published on 18 April 2004

  1. .PDF (4.9 MB)

Share this page:   

ISBN-10: 0738498807
ISBN-13: 9780738498805
IBM Form #: SG24-6432-00

Authors: Nagraj Alur, Peter Farrell, Philip Gunning, Saeid Mohseni and Swaminaathan Rajagopalan

    menu icon


    This IBM Redbooks publication provides detailed information on implementing high performance OLTP and BI applications in DB2 UDB ESE V8 environments involving AIX and Windows 2000 platforms. It is aimed at a target audience of DB2 application developers and database administrators (DBAs).

    We provide an overview of the architecture of a DB2 UDB V8 non-DPF environment from a performance perspective, and describe key performance drivers in OLTP, BI, and mixed workload environments.

    This book’s primary focus is a single partition (non-DPF) environment, and we provide best practices to achieve optimal application and system performance in OLTP, BI, and mixed workload environments.

    Finally, we discuss some of the commonly encountered problems faced by a DBA when managing a DB2 environment, and describe techniques for problem diagnosis using typical problem scenarios.

    Table of Contents

    Chapter 1: Introduction to performance management

    Chapter 2: DB2 UDB architecture overview

    Chapter 3: Application design and system performance considerations

    Chapter 4: Command and utility considerations

    Chapter 5: Operating system considerations

    Chapter 6: Problem determination scenarios

    Appendix A: DB2 UDB ESE Version 8 performance enhancements

    Appendix B: Workloads used in the scenarios


    Others who read this also read