DB2 for z/OS and WebSphere Integration for Enterprise Java Applications

An IBM Redbooks publication

Published 07 August 2013

cover image

ISBN-10: 0738438391
ISBN-13: 9780738438399
IBM Form #: SG24-8074-00
(638 pages)

More options

Rate and comment

Authors: Paolo Bruni, Zhen Hua Dong, Josef Klitsch, Maggie Lin, Rajesh Ramachandran, Bart Steegmans, Andreas Thiele


IBM DB2® for z/OS® is a high-performance database management system (DBMS) with a strong reputation in traditional high-volume transaction workloads that are based on relational technology. IBM 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 Platform, Enterprise Edition applications. In this IBM® Redbooks® publication, we describe the application architecture evolution focusing on the value of having DB2 for z/OS as the data server and IBM z/OS® as the platform for traditional and for modern applications.

This book provides background technical information about DB2 and WebSphere features and demonstrates their applicability presenting a scenario about 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 about developing applications, monitoring performance, and documenting issues.

DB2 database administrators, WebSphere specialists, and 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 Application Server infrastructure setup
Chapter 6. Developing Java applications with DB2 for z/OS
Chapter 7. Java Platform, Enterprise Edition with WebSphere Application Server and DB2
Chapter 8. Monitoring WebSphere Application Server 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 on IBM Data Studio
Appendix D. IBM 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

Follow IBM Redbooks

Follow IBM Redbooks