Front cover -- Contents -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Introduction -- 1.1 IBM On Demand era -- 1.1.1 The IBM On Demand operating environment -- 1.2 Why DB2 UDB and WebSphere -- 1.3 Key areas of performance -- 1.3.1 Hardware -- 1.3.2 Operating system -- 1.3.3 Application Server and WebServer -- 1.3.4 Database manager -- 1.3.5 Application programs -- 1.4 Performance tuning guidelines -- 1.4.1 Initial efforts always pay -- 1.4.2 Tune the identified constraints -- 1.4.3 Change one parameter at a time -- 1.4.4 Consider the entire system -- 1.4.5 Hardware upgradation -- 1.4.6 Follow performance tuning process and proper documentation -- 1.5 Process of performance tuning -- 1.5.1 Developing a performance-improvement process -- 1.5.2 Performance-tuning limits -- Chapter 2. Overview of WebSphere Application Server V5 -- 2.1 Java 2 Enterprise Edition (J2EE) overview -- 2.1.1 J2EE platform roles -- 2.1.2 J2EE benefits -- 2.1.3 Application components and their containers -- 2.1.4 Standard services -- 2.1.5 J2EE packaging -- 2.2 WebSphere Application Server V5 product family -- 2.3 WebSphere Application Server runtime architecture -- 2.3.1 WAS Version 5 base runtime architecture -- 2.3.2 WAS Version 5 Network Deployment runtime architecture -- 2.3.3 Architectural features -- 2.4 WebSphere Application Server V5 tools -- 2.4.1 Tools for installing, upgrading, and migrating -- 2.4.2 Tools for assembling applications -- 2.4.3 Tools for deploying and administering -- 2.4.4 Tools for monitoring and tuning -- 2.4.5 Tools for troubleshooting -- 2.5 WAS V5.0.2 and Supported J2EE APIs -- 2.5.1 What is new in WebSphere Application Server V5.0.2 -- 2.5.2 Supported J2EE APIs in WAS 5.0.2 -- Chapter 3. Overview of DB2 UDB V8 -- 3.1 DB2 UDB product family.

3.1.1 DB2 Everyplace® -- 3.1.2 DB2 Express -- 3.1.3 DB2 UDB Personal Edition (PE) -- 3.1.4 DB2 UDB Workgroup Server Edition (WSE) -- 3.1.5 DB2 UDB Enterprise Server Edition (ESE) -- 3.2 DB2 architecture overview -- 3.2.1 Process model -- 3.2.2 Memory model -- 3.2.3 Storage model -- 3.2.4 Key performance-related areas -- 3.3 Tools -- 3.3.1 IBM DB2 UDB Performance Expert for Multiplatforms -- 3.3.2 IBM DB2 UDB Recovery Expert for Multiplatforms -- 3.3.3 IBM DB2 High Performance Unload for Multiplatforms -- 3.3.4 IBM DB2 UDB Table Editor for Multiplatforms -- 3.3.5 IBM DB2 UDB Web Query Tool for Multiplatforms -- Chapter 4. DB2 UDB V8 and WAS V5 integrated environment -- 4.1 WebSphere session manager -- 4.1.1 HttpSession interface -- 4.2 Enterprise JavaBeans -- 4.2.1 EJB overview -- 4.3 Typical application flow -- 4.4 Topology selection -- 4.4.1 Selection criteria -- 4.4.2 Performance and scalability -- 4.4.3 Single machine topology -- 4.4.4 Separating the HTTP server -- 4.4.5 Separating the DB2 UDB server -- 4.4.6 Separating the Web container and the EJB container -- 4.4.7 Vertical scaling -- 4.4.8 Horizontal scaling with clusters -- 4.4.9 Session persistence considerations -- 4.4.10 Topology selection summary -- 4.5 How WebSphere Application Server works with DB2 UDB Server -- 4.5.1 J2EE Connector architecture -- 4.5.2 JDBC resources -- 4.5.3 DB2 JDBC providers -- 4.6 DB2 connectivity to z/OS and S/390® -- 4.6.1 Type 2 connectivity from a non-z/OS platform -- 4.6.2 Type 4 connectivity from a non-z/OS platform -- 4.6.3 DB2 UDB for z/OS and OS/390 as a DRDA application requester -- 4.6.4 Application on z/OS connecting DB2 UDB for Multiplatforms -- Chapter 5. Operational setup -- 5.1 Environment setup -- 5.1.1 Installation planning -- 5.1.2 Products' installation briefing -- 5.1.3 Using DB2 for z/OS and OS/390 as the Data Source for WAS.

5.1.4 Installation troubleshooting -- 5.2 Creating and configuring DB2 JDBC Provider -- 5.2.1 The steps to create and configure DB2 JDBC Providers -- 5.3 Creating and configuring DB2 Data Source -- 5.3.1 The steps to create and configure DB2 Data Source -- 5.4 DB2 EJB sample application setup -- 5.4.1 DB2 Enterprise JavaBean (EJB) sample application -- 5.4.2 Application installation & resource configuration -- 5.4.3 Using DB2 for z/OS as the Data Source -- Chapter 6. WebSphere Application Server V5 performance tuning -- 6.1 Performance Monitoring Infrastructure -- 6.1.1 Performance data organization -- 6.1.2 Performance data classification -- 6.1.3 Enabling PMI service -- 6.2 Performance monitoring and analysis tools -- 6.2.1 Tivoli Performance Viewer -- 6.2.2 Enabling JVMI facility -- 6.2.3 Monitoring an application -- 6.2.4 PMI request metrics -- 6.2.5 Log Analyzer -- 6.2.6 Other monitoring facilities -- 6.2.7 Developing your own monitoring applications -- 6.3 WebSphere Application Server tuning -- 6.3.1 WebSphere Queuing Network -- 6.3.2 Configuring WebSphere Application Server queues -- 6.3.3 Using Performance Advisors -- 6.3.4 JVM memory tuning -- 6.3.5 Application assembly considerations -- 6.3.6 Other considerations -- 6.3.7 Application best practice for performance -- Chapter 7. Monitoring and tuning of DB2 UDB V8 -- 7.1 Tools for monitoring and tuning -- 7.1.1 Snapshot monitor -- 7.1.2 Event monitor -- 7.1.3 Explain utilities -- 7.1.4 DB2 Diagnostic Log (DB2DIAG.LOG) -- 7.1.5 Health Center/Memory Visualizer -- 7.1.6 Design Advisor -- 7.1.7 Configuration Advisor -- 7.2 Application tuning -- 7.2.1 Database design -- 7.2.2 SQL tuning -- 7.2.3 Stored procedures -- 7.2.4 Declared global temporary tables -- 7.2.5 Concurrency -- 7.3 System tuning -- 7.3.1 Tuning the buffer pools -- 7.3.2 Table management -- 7.3.3 Index management.

7.3.4 Prefetcher -- 7.3.5 Cleaner -- 7.3.6 Sort heap -- 7.3.7 Locking -- 7.3.8 Logging -- 7.3.9 Tablespace -- Chapter 8. DB2 UDB V8 and WAS V5 integrated performance -- 8.1 WebSphere data sources -- 8.1.1 Connection pooling -- 8.1.2 Prepared statement cache -- 8.1.3 Monitoring WebSphere application on DB2 UDB server -- 8.1.4 Tuning WebSphere DataSources -- 8.1.5 Best practices -- 8.2 Persistent session -- 8.2.1 Enable database persistence -- 8.2.2 Session management tuning -- 8.2.3 Using larger DB2 page size for database persistence -- 8.2.4 Single vs. multi-row schemas in database persistence -- 8.2.5 What is written to the persistent session database -- 8.2.6 Invalidating sessions -- 8.2.7 Session performance best practices -- 8.3 Enterprise JavaBeans -- 8.3.1 EJB performance considerations -- 8.4 Application considerations for performance in database access -- Chapter 9. Integrated troubleshooting -- 9.1 Problem determination methodology -- 9.2 Diagnostic information collection and analysis -- 9.2.1 DB2 UDB V8 diagnostic information collection and analysis -- 9.2.2 WAS V5 diagnostic information collection and analysis -- 9.3 Problem determination scenarios -- 9.3.1 Connectivity scenario -- 9.3.2 Concurrency scenario -- 9.3.3 High I/O consumption scenario -- 9.3.4 High CPU utilization scenario -- Appendix A. Trade3 application -- Introduction -- Trade3 application deployment -- Web Performance Tool -- Related publications -- IBM Redbooks -- Other publications -- Online resources -- How to get IBM Redbooks -- Help from IBM -- Index -- Back cover.