Book description
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.
Please note that the additional material referenced in the text is not available from IBM.
Table of contents
- Figures (1/2)
- Figures (2/2)
- Tables
- Examples
- Notices
- Preface
-
Chapter 1: Introduction to DB2 for z/OS and OS/390
- Relational database management systems
- The DB2 Universal Database Family
- Components of DB2 UDB for z/OS and OS/390
- DB2 data structures
- Structured query language (SQL)
- DB2 concepts
- Accessing DB2 from a Java environment
- IBM DB2 Universal Driver for SQLJ and JDBC
-
Using the DB2 Universal Driver for SQLJ and JDBC
- Required environment variable settings
- DB2 Universal Driver stored procedures and metadata
- Binding DB2 Universal JDBC Driver packages with the DB2Binder utility
- DB2T4XAIndoubtUtil utility for DB2 UDB for OS/390 and z/OS Version 7
- Differences between the DB2 Universal Driver and DB2 Legacy Driver
- JDBC 3.0 APIs specific to the DB2 Universal Driver
- Chapter 2: Introduction to WebSphere for z/OS
-
Chapter 3: WebSphere - DB2 environment
- Introduction to the sample scenario setup
- Introduction to DB2 drivers for Java
- Data source definitions in WAS V5
- The IBM DB2 Universal Driver for SQLJ and JDBC
-
Configuring Universal JDBC Driver type 2 connectivity
- Specifying the Universal JDBC Driver provider
- Defining Data Sources under this provider (1/2)
- Defining Data Sources under this provider (2/2)
- Setting/verifying the symbolic environment variables
- Defining DB2 Universal Driver - General properties
- Searching for the package to execute
- Linking to the DB2 libraries
- Creating a new Application Server
- Configuring Universal JDBC Driver type 4 connectivity
- Summary
-
Chapter 4: DB2 and Java architecture guide
- Introduction to J2EE data access architecture
- Servlets and JavaServer Pages
- Enterprise JavaBeans
- Session Beans
- Stateless session Beans
- Stateful session Beans
- Entity Beans
- Bean-Managed Persistence entity Beans
- Container-Managed Persistence entity Beans
- Message-driven Beans
- Session facade pattern
- Stored procedures
- Web services
- SQLJ support
- Java Data Objects
- EJB Beans summary
- Chapter 5: DB2 application development in a WebSphere environment
- Chapter 6: WebSphere - DB2 security
- Chapter 7: SQLJ
- Chapter 8: Transaction management in a WebSphere environment
- Chapter 9: DB2 locking in a WebSphere environment
- Chapter 10: DB2 - WebSphere performance aspects
-
Chapter 11: Sample application
- Introduction
-
MVC model with entity Beans and a session Bean
- Creating entity CMP Beans using JDBC from the imported tables
- Container-managed persistence entity Beans with SQLJ (1/2)
- Container-managed persistence entity Beans with SQLJ (2/2)
- Bean and container-managed persistence entity Bean with SQLJ
- Bean-managed persistence entity Beans with JDBC
- Completing the model with the session Bean (1/2)
- Completing the model with the session Bean (2/2)
- The View component of the MVC model
- Controller component of MVC (1/2)
- Controller component of MVC (2/2)
- The enterprise J2EE application
- Deployment of the EAR file (1/2)
- Deployment of the EAR file (2/2)
- Test of the application
- Appendixes
- Appendix A: Additional material
- Related publications
- Index (1/3)
- Index (2/3)
- Index (3/3)
- Back cover
Product information
- Title: DB2 for z/OS and WebSphere: The Perfect Couple
- Author(s):
- Release date: January 2005
- Publisher(s): IBM Redbooks
- ISBN: None
You might also like
book
DB2 11 for z/OS Technical Overview
IBM® DB2® Version 11.1 for z/OS® (DB2 11 for z/OS or just DB2 11 throughout this …
book
Db2 for z/OS Utilities in Practice
As IBM® continues to enhance the functionality, performance, and availability of IBM Db2®, the utilities have …
book
DB2 UDB for z/OS: Design Guidelines for High Performance and Availability
Conducting business via the Web and remaining open for business 24 hours a day, seven days …
book
推薦システム実践入門 ―仕事で使える導入ガイド
情報化時代が到来し、日常で意思決定をする回数と選択肢の数が急増したことで、推薦システムの需要が高まっています。そのため、昨今では多くのウェブサービスへ新たに推薦システムの導入が検討されることも増えました。本書では、推薦システムの概要から、UI/UX、アルゴリズム、実システムへの組み込み、評価まで紹介し、適切な推薦システムの実装ができるようになります。「実際の仕事に活かす」ことを目的に、著者たちが実務で経験した推薦システムの成功事例や失敗事例を交えながら、実サービスに推薦システムを組み込むという観点を重視した入門的な内容です。