| |
IBM Redbooks > IBM System x
 |
|
|
 DB2 UDB ESE V8 non-DPF Performance Guide for High Performance OLTP and BI
|
This IBM Redbook 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 redbook’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. |
|
|
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 |
|
|
|
|
|
