DB2 for OS/390 and z/OS Powering the World's e-business Solutions

DB2 for OS/390 and z/OS Powering the World's e-business Solutions

by Paolo Bruni, Kosta Gerontzos, Gareth Jones, Kyung Soon Um
Released June 2001
Publisher(s): IBM Redbooks
ISBN: 9780738422541

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

This IBM Redbooks publication provides an understanding of the environment required to access DB2 for OS/390 and z/OS
Version 7 for use with an Internet Web server.

More and more customers worldwide are using DB2 technology on the S/390 platform to implement a wide variety of mission-critical business applications. The Web is used to enhance DB2's role as a true enterprise database server. This book provides a brief introduction and overview of Internet concepts and terminology to offer a perspective for DB2 users. A broad understanding of several application and middleware solutions including Web servers, Java applications and applets using SQLJ or JDBC, and Net.Data is provided. Coding and implementation examples of alternative solutions are discussed. Additionally, XML functions and the DB2 XML Extender implementation are documented in easy "how-to" steps. The scenarios can help to demonstrate how DB2 data can be leveraged via the Web to deliver a competitive advantage.

This book is particularly useful for planners, architects, or implementers in any organization with a requirement to extend the use of DB2 for OS/390 and z/OS data via Web applications.

Table of contents

  1. Figures
  2. Tables
  3. Examples
  4. Preface
    1. The team that wrote this redbook
    2. Special notice
    3. IBM Trademarks
    4. Comments welcome
  5. Chapter 1: Introduction
    1. DB2 UDB for OS/390 and z/OS database server
      1. The e-business architecture
      2. The Web application servers
    2. Summary of conclusions
  6. Chapter 2: e-business with DB2 for OS/390 and z/OS
    1. S/390 and z/Series platform
    2. DB2: The database server for e-business
      1. DB2 data sharing
      2. SQL Stored Procedures and the Stored Procedure Builder
      3. TCP/IP support
      4. Accessing DB2 data from Web applications
      5. Java stored procedures
      6. Global transactions
      7. Security enhancements
      8. Unicode
      9. Network monitoring enhancements
  7. Chapter 3: Data access models for the Web and DB2
    1. Methods for accessing DB2 data
      1. Directly from a client using one of the DB2 tools
      2. Through a Web browser communicating with a Web server
    2. Two tier architecture access models
      1. Server side processing
      2. Checkpoint — Server side processing
      3. Net.Data
    3. Building the picture — Client side processing
      1. JavaScript
      2. Applets
    4. Application server environments
      1. WebSphere Application Server
      2. Servlets
      3. JSP
      4. Web Query Tool
    5. DB2 Extenders
    6. The final picture for two tier architectures
    7. Three tier architectures
      1. DB2 Connect Enterprise Edition
    8. The final picture for three tier architectures
    9. SOAP and WSDL — A new environment
    10. Considerations and combinations
    11. Conclusion
  8. Chapter 4: The Web server environment
    1. HTTP server
    2. WebSphere Application Server
      1. WebSphere Application Server configuration
      2. Enabling DB2 for the WebSphere Application Server
      3. How to run the servlets
      4. Advanced configuration to access relational database
    3. VisualAge for Java
      1. Overview and benefits with Version 3.5
      2. Database access with VisualAge for Java
      3. Conclusion
  9. Chapter 5: Net.Data
    1. Basic architecture
      1. Net.Data Version 7 enhancements
    2. Implementing Net.Data
      1. Two tier implementation
      2. Three tier implementation
    3. Net.Data features
      1. General features
      2. DB2 features
      3. Web features
      4. Application features
      5. High performance features
      6. Features conclusion
    4. Runtime flow control
    5. Anatomy of a Net.Data macro
    6. Generating and executing Net.Data
    7. Net.Data prerequisites
    8. Installation
      1. Obtaining Net.Data for OS/390
      2. Product documentation
      3. Net.Data Web server and application server requirements
      4. Net.Data configuration
    9. Running the Net.Data installation verification program
      1. The CGI IVP
      2. The FastCGI IVP
      3. The GWAPI IVP
      4. The servlet IVP
      5. The tsql.dtw sample macro
      6. Net.Data implementation recommendations
  10. Chapter 6: DB2 Connect
    1. Overview
      1. Editions of DB2 Connect
      2. DB2 Connect Version 7
    2. DB2 Connect three tier configuration
      1. DB2 Connect correlations
      2. Using the Command Window
      3. Using the Client Configuration Assistant (1/2)
      4. Using the Client Configuration Assistant (2/2)
      5. Verifying the definition in the directory
    3. Configuring DB2 Run-Time Client in a three tier
      1. Using the Command Window
      2. Using the Client Configuration Assistant
  11. Chapter 7: Developing DB2 Web applications with Java
    1. Java overview
    2. Java Virtual Machine
    3. Java tools
    4. Java connectivity
      1. JDBC (1/2)
      2. JDBC (2/2)
      3. SQLJ (1/2)
      4. SQLJ (2/2)
      5. Comparing JDBC and SQLJ
      6. SQLJ and JDBC performance considerations
    5. Java and stored procedures
      1. Setting the system environment (1/2)
      2. Setting the system environment (2/2)
      3. Preparing compiled Java stored procedures (1/2)
      4. Preparing compiled Java stored procedures (2/2)
      5. Runtime environment
      6. Common errors
    6. Applets and servlets
    7. Accessing DB2 data from the Web using DB2 Connect
      1. Using a Java application
      2. Using a Java applet
      3. Using a Java servlet
  12. Chapter 8: XML and DB2 XML Extender
    1. XML theory
      1. XML and HTML
      2. What can XML offer us that HTML cannot?
      3. What is XML?
      4. XML and XSL — A big benefit
      5. Power of tags
      6. XML modeling
      7. Database versus XML
      8. XML and EDI
      9. New languages
      10. XML delivers simple efficiency
    2. XML syntax and form
    3. Some XML syntax
      1. Document Type Definition
      2. XML hierarchical format
    4. XML schemas
    5. Extensible, extensible, extensible
    6. XML related technologies
      1. XSL
      2. XSLT
      3. XPath
      4. XPointer
      5. XLink
      6. Namespaces
    7. XML APIs
      1. DOM
      2. SAX
      3. JAXP
      4. JDOM
    8. XML and Java
    9. A new Web model — Web Services
      1. SOAP
      2. UDDI
      3. WSDL
    10. DB2 XML Extender — Why do we need it?
      1. Database argument
      2. DB2 XML Extender features
    11. Architecture
      1. SQL and RDB node mapping, composition and decomposition
    12. What is the XML Extender?
    13. XML Extender enablement
      1. Software and environmental prerequisites and options
      2. XML Extender data sets
      3. Enabling the XML Extender
    14. The XML Extender sample applications
      1. What the sample applications do
      2. Store an XML document in an XML column
      3. Composing an XML document from DB2 data
      4. Testing XML document validation
      5. Document decomposition
      6. Sample program TESTS2X
      7. XML Extender administration
      8. The XML Extender administration wizard
    15. The XML Extender administration support tables
      1. The DTD reference table
      2. The XML usage table
    16. Good XML publications
    17. XML Extender service information
  13. Chapter 9: Security
    1. TCP/IP Security
      1. Cryptography
      2. Firewalls
      3. Virtual private network
      4. Secure Sockets Layer
      5. Lightweight Directory Access Protocol
      6. DB2 and Kerberos authentication
  14. Appendix A: Additional Web solutions
    1. Web Query tool
    2. DB2 Table Editor
    3. IBM WebSphere Host On-Demand
  15. Appendix B: Sample Java programs
    1. JDBC stored procedure sample program
    2. SQLJ stored procedure sample program
    3. JDBC client application program for UNIX and Windows
    4. SQLJ client application program for OS/390
    5. SQLJ sample Java application
    6. SQLJ Java applet sample program
    7. Sample HTML to run SQLJ applet
  16. Appendix C: Additional material
    1. Locating the Web material
    2. Using the Web material
      1. System requirements for downloading the Web material
      2. How to use the Web material
  17. Related publications
    1. IBM Redbooks
      1. Other resources
    2. Referenced Web sites
    3. How to get IBM Redbooks
      1. IBM Redbooks collections
  18. Special notices
  19. Glossary (1/3)
  20. Glossary (2/3)
  21. Glossary (3/3)
  22. Abbreviations and acronyms
  23. Index (1/2)
  24. Index (2/2)
  25. Back cover

Product information

  • Title: DB2 for OS/390 and z/OS Powering the World's e-business Solutions
  • Author(s): Paolo Bruni, Kosta Gerontzos, Gareth Jones, Kyung Soon Um
  • Release date: June 2001
  • Publisher(s): IBM Redbooks
  • ISBN: 9780738422541