DB2 UDB V8 and WebSphere V5 Performance Tuning and Operations Guide

An IBM Redbooks publication

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

Published 12 March 2004

cover image

ISBN-10: 0738498211
ISBN-13: 9780738498218
IBM Form #: SG24-7068-00
(440 pages)

More options

Rate and comment

Authors: Whei-Jen Chen, Peter Z He, Kang Yong Ying, Andreas Paulsen, Sunminder S Saini


This IBM Redbooks publication discusses the integrated environment of DB2 UDB and WebSphere Application Server (WAS), including design considerations, best practices, operation, monitoring, and performance tuning.

We provide an overview of the architecture and main components of both WebSphere Application Server V5.0.2 and DB2 UDB V8. We introduce their key application and system performance tuning parameters.

We discuss the general steps to get DB2 UDB V8 and WAS V5 working together. We also discuss the available JDBC drivers shipped with DB2 UDB V8 and their differences. The steps to set up DB2 for z/OS as the data source using DB2 Connect is also included.

We describe the performance tuning tools, methodology, guidelines, and the application performance best practices for DB2 UDB, WAS, and the DB2 UDB/WAS integrated environment. Finally, we present some common methods of diagnosing the problems related to DB2 UDB and/or WebSphere Application Server. We provide some problem scenarios where you will learn the problem determination methodology and mechanisms to resolve such problems.

Table of contents

Chapter 1. Introduction
Chapter 2. Overview of WebSphere Application Server V5
Chapter 3. Overview of DB2 UDB V8
Chapter 4. DB2 UDB V8 and WAS V5 integrated environment
Chapter 5. Operational setup
Chapter 6. WebSphere Application Server V5 performance tuning
Chapter 7. Monitoring and tuning of DB2 UDB V8
Chapter 8. DB2 UDB V8 and WAS V5 integrated performance
Chapter 9. Integrated troubleshooting
Appendix A. Trade3 application

Others who read this publication also read

Follow IBM Redbooks

Follow IBM Redbooks