DB2 for z/OS and WebSphere: The Perfect Couple

An IBM Redbooks publication

Published 18 January 2005

cover image

ISBN-10: 0738491861
ISBN-13: 9780738491868
IBM Form #: SG24-6319-00
(332 pages)

More options


Authors: Bart Steegmans, Carsten Block, John De Dominicis, Sean Lee, Chao-Lin Liu, Egide Van Aerschot


DB2 for z/OS is a high performance DBMS, with a very strong reputation in high volume transaction workloads based on relational technology. WebSphere Application Server is a transaction monitor based on object-oriented technology, very much in sync with the J2EE standard. Can we marry the object world and relational world to create a high-volume, high-performance end-to-end OLTP environment? The answers can be found in this IBM Redbooks publication.

This book gives a broad understanding of the installation, configuration, and use of the IBM DB2 Universal Driver for SQLJ and JDBC in a DB2 for z/OS and OS/390 Version 7, and DB2 for z/OS Version 8 environment, with IBM WebSphere Application Server for z/OS for z/OS Version 5.02. It describes both type 2 and type 4 connectivity (including the XA transaction support) from a WebSphere Application Server on z/OS to a DB2 for z/OS and OS/390 database server.

This publication also demonstrates the advantages of SQLJ in a DB2 environment, the SQLJ support in the IBM application development tool WebSphere Studio Application Developer, as well as the SQLJ support for Enterprise JavaBeans using container-managed persistence.

Table of contents

Chapter 1. Introduction to DB2 for z/OS and OS/390
1.1 Relational database management systems
1.2 The DB2 Universal Database Family
1.3 Components of DB2 UDB for z/OS and OS/390
1.4 DB2 data structures
1.5 Structured query language (SQL)
1.6 DB2 concepts
1.7 Accessing DB2 from a Java environment
1.8 IBM DB2 Universal Driver for SQLJ and JDBC
1.9 Using the DB2 Universal Driver for SQLJ and JDBC
Chapter 2. Introduction to WebSphere for z/OS
2.1 Java 2 Enterprise Edition (J2EE) overview
2.2 WebSphere Application Server architecture
2.3 WebSphere Application Server administration
2.4 The WebSphere family
2.5 WAS 5.0.2 features and J2EE support
Chapter 3. WebSphere - DB2 environment
3.1 Introduction to the sample scenario setup
3.2 Introduction to DB2 drivers for Java
3.3 Data Source definitions in WAS v5
3.4 The IBM DB2 Universal Driver for SQLJ and JDBC
3.5 Configuring Universal JDBC Driver type 2 connectivity
3.6 Configuring Universal JDBC Driver type 4 connectivity
3.7 Summary
Chapter 4. DB2 and Java architecture guide
4.1 Introduction to J2EE data access architecture
4.2 Servlets and JavaServer Pages
4.3 Enterprise JavaBeans
4.4 Session Beans
4.5 Stateless session Beans
4.6 Stateful session Beans
4.7 Entity Beans
4.8 Bean-Managed Persistence entity Beans
4.9 Container-Managed Persistence entity Beans
4.10 Message-driven Beans
4.11 Session facade pattern
4.12 Stored procedures
4.13 Web services
4.14 SQLJ support
4.15 Java Data Objects
4.16 EJB Beans summary
Chapter 5. DB2 application development in a WebSphere environment
5.1 JDBC and SQLJ application programming comparison
5.2 JDBC application programming concepts
5.3 SQLJ application programming concepts
5.4 Preparing JDBC and SQLJ applications for execution
5.5 Impact of different DB2 bind options on Java applications
5.6 Special registers
Chapter 6. WebSphere - DB2 security
6.1 Introduction to authentication, authorization, and auditing
6.2 DB2 auditing
Chapter 7. SQLJ
7.1 Writing SQLJ versus JDBC applications
7.2 Profile customization
7.3 Application design
7.4 SQLJ in WebSphere Studio Application Developer
7.5 Deployment to WebSphere Application Server
7.6 Summary
Chapter 8. Transaction management in a WebSphere environment
8.1 What transactions are
8.2 WebSphere transaction management
8.3 WebSphere resources and transaction support
8.4 DB2 as a transaction manager
8.5 DB2 as a resource manager
8.6 Considerations for two-phase commit processing
Chapter 9. DB2 locking in a WebSphere environment
9.1 DB2 locking
9.2 Transaction isolation
9.3 WebSphere transaction-related deployment descriptors
9.4 Container-managed persistence generated SQL
Chapter 10. DB2 - WebSphere performance aspect
10.1 Recommended hardware and software configuration
10.2 WebSphere Application Server connection pooling
10.3 DB2 and JDBC
10.4 WLM classification of WAS and its impact on DB2
10.5 Tuning the storage for z/OS and the Java Virtual Machine
Chapter 11. Sample application
11.1 Introduction
11.2 MVC model with entity Beans and a session Bean
11.3 The View component of the MVC model
11.4 Controller component of MVC
11.5 The enterprise J2EE application
11.6 Deployment of the EAR file
11.7 Test of the application

Follow IBM Redbooks

Follow IBM Redbooks