DB2® for z/OS® is a high-performance DBMS, with a very strong reputation in traditional high-volume transaction workloads based on relational technology. WebSphere® Application Server is Web application server software that runs on most platforms with a Web server and is used to deploy, integrate, execute, and manage Java 2 Platform, Enterprise Edition (J2EE) applications. In this IBM® Redpaper™ Redbooks® publication we discuss the application architecture evolution focusing on the value of having DB2 for z/OS as the data server and z/OS as the platform for traditional and for modern applications.
The book provides background technical information on DB2 and WebSphere features and demonstrates their applicability presenting a scenario on configuring WebSphere Version 8.5 on z/OS and type 2 and type 4 connectivity (including the XA transaction support) for accessing a DB2 for z/OS database server taking into account high availability requirements.
We also provide considerations on developing applications, monitoring performance, and documenting issues.
DB2 data base administrators and WebSphere specialists as well as Java application developers will appreciate the holistic approach of this document.
Table of contents
Chapter 1. Application development with DB2 for z/OS
Chapter 2. Accessing DB2 for z/OS from WebSphere applications
Chapter 3. DB2 configuration options for Java client applications
Chapter 4. DB2 infrastructure setup
Chapter 5. WebSphere infrastructure setup
Chapter 6. Considerations when developing Java applications with DB2 for z/OS
Chapter 7. JEE with WebSphere Application Server and DB2
Chapter 8. Monitoring WebSphere applications
Chapter 9. Error handling and problem determination
Appendix A. DB2 administrative task scheduler
Appendix B. Configuration and workload
Appendix C. Setting up a WebSphere Application Server test environment in IBM Data Studio
Appendix D. OMEGAMON XE for DB2 performance database
Appendix E. SMF 120 records subtypes 1, 3, 7, and 8
Appendix F. Sample IBM Data Server Driver for JDBC and SQLJ trace
Appendix G. External user defined functions
Appendix H. ClientInfo dynamic web project
Appendix I. Additional material
These pages are Web versions of IBM Redbooks- and Redpapers-in-progress. They are published here for those who need the information now and may contain spelling, layout and grammatical errors.
This material has not been submitted to any formal IBM test and is published AS IS. It has not been the subject of rigorous review. Your feedback is welcomed to improve the usefulness of the material to others.
IBM assumes no responsibility for its accuracy or completeness. The use of this information or the implementation of any of these techniques is a customer responsibility and depends upon the customer's ability to evaluate and integrate them into the customer's operational environment.