Distributed Functions of DB2 for z/OS and OS/390

When DB2’s Distributed Data Facility (DDF) was announced in the late eighties, it was looked at by many people as a nice gadget, but not something anybody would use in a real OLTP production environment. Distributed database access and DB2’s DDF have come a long way since. DDF is now a full-function transaction monitor, using a highly efficient database interoperability protocol (DRDA) equipped with thread pooling and connection management that allows it to support very large networks.

In this IBM Redbook we describe how to set up your DDF environment, and how to deploy the DDF capabilities in different configurations, including how to develop applications that access distributed databases.

We also describe a set of more advanced features, such as thread pooling, and high availability distributed configurations, in a DB2 data sharing environment. We also demonstrate the advantages of using HiperSockets with DB2 for z/OS and OS/390 and DB2 Connect for zLinux.

As performance and problem analysis are very important in today’s production environments with applications demanding subsecond response times and zero down time, the publication also discusses the traces available to you to do performance monitoring and problem determination.

We hope that after reading this publication you will have a better view of a wide range of functions that DDF has to offer, and say "Wow, I had no idea that I could do all of this with DDF!"

Part 1. Distributed database architecture and configurations

Chapter 1. Architecture of DB2 distributed systems
1.1 Before you start
1.2 Introduction
1.3 DRDA
1.4 Client-server topology
1.5 Distributed data topology
1.6 DRDA architecture
1.7 Implementation of DRDA in the DB2 UDB family
1.8 Implementation of DRDA by non-IBM products
1.9 DB2 for z/OS and OS/390 DDF Architecture
1.10 Architecture of DB2 Connect
1.11 Architecture of DB2 clients

Chapter 2. Distributed database configurations using DB2 for z/OS and OS/390
2.1 Introduction
2.2 DB2 UDB for z/OS both as an AR and AS
2.3 DB2 Connect AR and DB2 UDB for z/OS and OS/390 AS
2.4 DB2 Connect EE AR on zLinux - DB2 UDB for z/OS as AS
2.5 DB2 UDB for z/OS AR - DB2 UDB for Multiplatforms AS
2.6 DB2 UDB for z/OS AR - Any (DB2) DRDA AS
2.7 JDBC (type 4 driver) as AR

Part 2. Setup and configuraton

Chapter 3. Installation and configuration
3.1 DB2 system configuration
3.2 VTAM setup
3.3 TCP/IP setup
3.4 WLM setup
3.5 DB2 Connect setup
3.6 Character conversion
3.7 Restrictions on the use of local datetime formats

Chapter 4. Security
4.1 Security requirements for DRDA today
4.2 Security implications of switching from SNA to TCP/IP
4.3 Guidelines for basic DRDA security setup over TCP/IP
4.4 DRDA security requirements for an application server
4.5 Encryption options
4.6 Identifying a user from an application server
4.7 Addressing dynamic SQL security concerns

Part 3. Application programming

Chapter 5. Application programming
5.1 Coding for distributed data
5.2 Program preparation
5.3 Coordinating updates and two-phase commit
5.4 Migrating from DB2 PP to DRDA
5.5 Considerations when using DB2 Connect
5.6 Sample application

Chapter 6. Connection pooling
6.1 Types of connection pooling
6.2 Thread monitoring
6.3 Practical tests to demonstrate pooling techniques
6.4 Considerations for typical usage scenarios

Part 4. Performance and problem determination

Chapter 7. Performance Analysis
7.1 Application flow in distributed environment
7.2 Architecture components
7.3 System architecture topics
7.4 Application related topics
7.5 Checking settings in a distributed environment

Chapter 8. Problem determination
8.1 Introduction
8.2 An understanding of the n-tier message communication
8.3 Traces - An overview
8.4 How to enable traces
8.5 DB2 for z/OS and OS/390 tracing capabilities
8.6 Step-by-step performance analysis

Part 5. Advanced topics

Chapter 9. HiperSockets
9.1 HiperSockets--An introduction
9.2 What HiperSockets are
9.3 Performance benefits of using HiperSockets

Chapter 10. High availability options
10.1 High availability aspects of DRDA access to DB2 for z/OS
10.2 DB2 failover without Sysplex Distributor
10.3 DB2 failover with Sysplex Distributor
10.4 TCP/IP failure with Dynamic VIPA
10.5 Recommendations for common deployment scenarios

Part 6. Appendixes

Appendix A. Sample application
Appendix B. Sample JCL for PE reporting
Appendix C. Sysplex failover test programs
Appendix D. Getting started with IPCS CTRACE formatting
Appendix E. Additional material

Publish Date
30 June 2003

Rating:
(based on 14 reviews)

Rate this book

Author(s)
Bart Steegmans
Neale Armstrong
Cemil Cemiloglu
Srirengan Venkatesh Kumar
Satoru Todokoro

ISBN
0738453188

IBM Form Number
SG24-6952-00

Number of pages
372

CD-ROM