Skip to main content

DB2 for z/OS and WebSphere: The Perfect Couple

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.


Published on 18 January 2005

  1. .PDF (4.8 MB)

Share this page:   

ISBN-10: 0738491861
ISBN-13: 9780738491868
IBM Form #: SG24-6319-00

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

    menu icon


    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


    Others who read this also read