DB2 UDB V8 and WebSphere V5. Performance Tuning and Operations Guide2004

This IBM® Redbook helps you design, develop, operate, monitor, and tune DB2® UDB V8 and WebSphere® Application Server (WAS) V5 based applications in UNIX® and Windows® environments. It also covers using DB2 Connect™ in a WAS environment.

This book is organized as follows:

• Chapter 1, "Introduction" on page 1, talks about the IBM On Demand operating environment and its roadmap, key areas of performance, and guidelines to tune them. We also discuss the process of performance tuning and recognize the limits of performance tuning in the system.

• Chapter 2, "Overview of WebSphere Application Server V5" on page 19, provides a brief overview of Java™ 2 platform Enterprise Edition (J2EE), including J2EE architecture, standard services provided by J2EE, application components and their corresponding containers, platform roles, as well as the benefits derived from adoption of J2EE. We also provide an overview of the WebSphere Application Server (WAS) V5.0.2, which is the premier J2EE and Web services technology-based application platform, and offers one of the first production-ready application servers for the deployment of enterprise Web services solutions for dynamic e-business on demand™.

• Chapter 3, "Overview of DB2 UDB V8" on page 47, covers the design of DB2 UDB V8. This chapter gives you a brief overview of DB2 UDB and discusses topics like the product family, the architecture, and the tools. With this knowledge you are prepared to understand the following parts of the publication where we discuss performance tuning and problem determination on DB2 UDB.

• Chapter 4, "DB2 UDB V8 and WAS V5 integrated environment" on page 75, discusses the topology selection in the WebSphere Application Server and DB2 UDB integrated environment that implements the multi-tier application model, and how WebSphere Application server interacts with DB2 UDB.

• Chapter 5, "Operational setup" on page 117, discusses the general steps to get DB2 UDB V8 and WebSphere Application Server V5 working together to serve specific business and application requirements. The new DB2 EJB sample application named "AcessEmployee" is introduced in detail to let you have a starting point to show you how DB2 UDB V8 and WebSphere Application Server V5 fit together. In addition, we also discuss the available JDBC drivers shipped with DB2 UDB V8 and the differences between those drivers.

• Chapter 6, "WebSphere Application Server V5 performance tuning" on page 169, discusses tuning an existing WebSphere environment for performance and J2EE application best practices for performance. Performance tuning methodology and guidelines are also provided. We also cover the Performance Monitoring infrastructure (PMI) and performance tuning and monitoring tools found in WebSphere Application Server V5.

• Chapter 7, "Monitoring and tuning of DB2 UDB V8" on page 237, covers performance tuning on DB2 UDB. It starts with the setup of a new project and the gathering of information about the project and the system. We show what to think of during the development phase, as well as the things to be done when the system is up and running. Learn how to monitor the system and how to use the tools provided by DB2 UDB for tuning and maintaining your system.

• Chapter 8, "DB2 UDB V8 and WAS V5 integrated performance" on page 287, provides a description of the components that have an important performance impact in a WebSphere Application Server and DB2 UDB integrated environment, and offers some best-practices guidelines for their usage.

• Chapter 9, "Integrated troubleshooting" on page 337, describes some common methods of diagnosing the problems related to DB2 UDB and/or WebSphere Application Server using diagnostic log files and traces. Also to further elaborate the understanding we have covered problem scenarios where you will learn the problem determination methodology and mechanisms to resolve those problems.

The team that wrote this redbook

This redbook was produced by a team of specialists from around the world working at the International Technical Support Organization, San Jose Center.

Figure 1: A. Paulsen, Kang Yong Ying, Whei-Jen Chen, Peter Z. He, Sunminder S Saini

Whei-Jen Chen is a Project Leader at the International Technical Support Organization, San Jose Center. She has extensive experience in application development, database design and modeling, and DB2 system administration. Whei-Jen is an IBM Certified Solutions Expert in Database Administration and Application Development as well as an IBM Certified IT Specialist.

Peter Z He is a Software Developer with the DB2/WebSphere Solution Integration Team at the IBM Toronto Lab. Peter has been working extensively with DB2 and WebSphere technologies. He designed and led the development of the IBM Video Central software and the DB2 V81 J2EE sample application, Access Employee. He also participated in the development of DB2 Content Manager V8, Rational® ClearCase®, and WebSphere Commerce, and provided System architecture, J2EE application design, and DBA consulting to customers. He holds a Ph.D. from York University and is a DB2 Certified Solutions Expert.

Kang Yong Ying is a Senior IT Specialist from the Technical Sales Support, IBM China. He has extensive experience in database software for distributed platforms and also familiar with WebSphere Application Server products. He is also an IBM Certified Advanced Technical Expert-DB2 for Clusters. His areas of expertise include DB2 UDB administration and troubleshooting, as well as Business Intelligence solution implementation.

Andreas Paulsen is a DB2-certified IT Architect working for the DB2 Software Services Organization in Berlin, Germany. He worked as a Consultant for middleware solutions for the Informix® Company (before acquired by IBM), and previously he developed database solutions in two other companies on Informix databases. Currently he is working on migration projects to bring databases from competitors to DB2 UDB. His knowledge also includes WebSphere and ETL processes. Andreas holds a Masters degree in Computer Science from the Technical University of Berlin.

Sunminder S Saini is an Advisory IT Specialist from the e-Business Software Center, IBM Software Group, IBM India. He has seven years of experience in the enterprise applications and distributed environment. He is certified for DB2 UDB Administration, Managing and Optimizing-Informix Dynamic Server, WebSphere Application Server, and WebSphere Studio Application Developer. His areas of expertise include DB2 UDB/Informix and WebSphere administration. He has written extensively on DB2 UDB Administration for Linux, Windows, and UNIX.

We would like to thank the following people for their contributions to this project:

Grant HutchisonRahul KitchluYongli An IBM Toronto Laboratory

Curt Cotner IBM Silicon Valley Laboratory

Jerry Yang IBM Business Consultanting Services

Angelo Sironi IBM Software Group - Italy

Emma Jacobs International Technical Support Organization, San Jose Center

Julie Czubik International Technical Support Organization, Poughkeepsie Center