DB2 for z/OS and OS/390 : ready for Java / Bart Steegmans ... [et al.].

Format:

Book

Contributor:

Steegmans, Bart.

International Business Machines Corporation. International Technical Support Organization.

Series:

IBM redbooks.

IBM redbooks

Language:

English

Subjects (All):

Java (Computer program language).

IBM Database 2.

Physical Description:

xxiv, 334 p. : ill.

Edition:

1st ed.

Place of Publication:

[S.l.] : IBM, International Technical Support Organization, 2003.

Language Note:

English

Contents:

Front cover

Contents

Figures

Tables

Examples

Notices

Trademarks

Preface

The team that wrote this redbook

Become a published author

Comments welcome

Summary of changes

December 2004

Part 1 Introduction

Chapter 1. A brief history of Java

1.1 From toaster to the enterprise

1.1.1 Java and the consumer electronics revolution

1.1.2 Accessing the data

1.1.3 The rise of the Internet server

1.1.4 The Internet and the enterprise

1.2 Java and the z/OS and OS/390 platforms

Chapter 2. An introduction to Java 2 Enterprise Edition

2.1 The three technology editions for the Java 2 platform

2.2 Java 2 Platform, Enterprise Edition

2.3 Java 2 features

2.3.1 Object-oriented programming

2.3.2 Primitive data types

2.3.3 Garbage collection

2.3.4 Removal of pointers

2.3.5 No more GOTOs

2.3.6 Java Virtual Machine

2.4 Java application environments

2.4.1 Stand-alone Java applications

2.4.2 Java applets

2.4.3 Java Servlets

2.4.4 JavaServer Pages

2.4.5 JavaScript

2.4.6 Java Beans

2.4.7 Enterprise Java Beans

Chapter 3. Accessing DB2 from Java

3.1 JDBC basics

3.1.1 JDBC driver types

3.1.2 The IBM DB2 Universal Driver for SQLJ and JDBC

3.2 Different ways to connect to a DB2 for z/OS and OS/390

3.2.1 Direct (T2) connection to a local DB2 subsystem

3.2.2 Using the Type 4 driver to talk to a local DB2 for z/OS and OS/390

3.2.3 Type 4 connectivity from a non-z/OS platform

3.2.4 Type 2 connectivity from a non-z/OS platform

3.2.5 DB2 for z/OS and OS/390 as a DRDA Application Requester

3.2.6 IBM z/OS Application Connectivity to DB2 for z/OS and OS/390

3.3 Developing a Java application using JDBC

3.3.1 Connecting to a database

3.3.2 Using the DriverManager interface

3.3.3 Connecting using the DataSource API.

3.4 Accessing data using SQLJ

3.5 Using JDBC or SQLJ

3.5.1 SQLJ is easier to code

3.5.2 SQLJ catches errors sooner

3.5.3 SQLJ is faster

3.5.4 SQLJ provides better authorization control

3.5.5 SQLJ is more predictable and reliable

3.5.6 SQLJ allows for better monitoring

3.5.7 SQLJ Tooling

3.5.8 Use JDBC for flexible SQL statements

3.5.9 SQLJ/JDBC interoperability

3.6 Summary

Part 2 Prerequisites and setup

Chapter 4. Products and levels - Now and soon

4.1 Products and levels

4.1.1 Now

4.1.2 Soon

Chapter 5. Setup

5.1 DB2 for OS/390 and z/OS V7

5.1.1 Installing DB2 SQLJ/JDBC support

5.1.2 Installing the Universal Driver on a z/OS or OS/390 platform

5.1.3 Required DB2 for z/OS changes to enable the Universal Driver

5.2 Workload Manager (WLM)

5.3 Unix System Services

5.3.1 Setting up a USS session

5.3.2 Setting up the JDBC/SQLJ environment variables

5.4 DB2 Universal Driver - Setup for a Windows environment

5.5 WSAD setup

5.5.1 Using the data perspective

5.6 WebSphere for z/OS datasource setup

5.6.1 Log onto the WAS Administrative Console

5.6.2 Setting up system variables

Part 3 Putting it all together

Chapter 6. Getting started with JDBC

6.1 Creating the project

6.1.1 Loading the JDBC driver

6.1.2 Establishing the connection

6.1.3 Preparing an SQL statement for execution

6.1.4 Populating parameter markers

6.1.5 Executing the statement

6.1.6 Processing the result set

6.1.7 Cleaning up resources

6.2 Running the Hello application from WSAD

6.2.1 Creating the launch configuration

6.2.2 Setting up the classpath

6.2.3 Troubleshooting

6.3 Running the Hello application from Unix System Services

6.3.1 Exporting to a shared file system

6.3.2 Exporting via FTP

6.3.3 Running the program.

6.4 Running a Java program from a Windows command prompt

6.4.1 Compile the Java program (javac)

6.4.2 Run the Java program (java)

6.5 Debugging the application on the workstation

6.6 Remote debugging

Chapter 7. JDBC revisited

7.1 INSERT, UPDATE and DELETE statements

7.1.1 INSERT

7.1.2 UPDATE

7.1.3 DELETE

7.2 NULL handling

7.3 Examining result sets

7.4 Database metadata

7.4.1 Information about the JDBC driver

7.4.2 Information about the database server

7.4.3 Information about database objects

7.5 Positioned UPDATE and DELETE

7.5.1 Positioned UPDATE

7.5.2 Positioned DELETE

7.6 Large objects (LOBs)

7.7 Scrollable cursors

7.8 A complete example: Poor man's SPUFI

Chapter 8. Getting started with SQLJ

8.1 Creating the source file

8.2 Running the Hello application from WSAD

8.2.1 Creating the launch configuration

8.2.2 Specifying command line parameters

8.3 Running the Hello application from Unix System Services

8.4 Running the Hello application from MVS batch

Chapter 9. The SQLJ program preparation process

9.1 Program preparation in other languages

9.2 Overview of the SQLJ program preparation process

9.2.1 The SQLJ translator

9.2.2 More about profiles

9.3 The DB2 profile customizer

9.3.1 Isolation levels

9.3.2 Why online checking is good for you

9.4 The DB2 profile binder

9.5 The DB2 profile printer

9.6 Preparing an application to use static SQL

9.6.1 Preparing SQLJ programs to use static SQL through WSAD

9.6.2 Doing it yourself - Manual program preparation for static SQLJ

9.6.3 Running your sqlj program locally on a DB2 for z/OS system

9.6.4 In summary

Chapter 10. SQLJ tutorial and reference

10.1 The basic syntax of SQLJ statements

10.1.1 Executable statements

10.1.2 Iterator declarations.

10.2 Host variables and expressions

10.3 Null values

10.4 Data type mapping

10.5 Queries, iterators, and the assignment statement

10.5.1 Using positioned iterators

10.5.2 Using named iterators

10.5.3 SQLJ iterators versus cursors

10.5.4 Holdable iterators

10.5.5 Positioned UPDATE and DELETE

10.5.6 Calling stored procedures

10.6 Connection contexts

10.6.1 Setting up and using an implicit connection context

10.6.2 Why the connection context is important

10.6.3 Declaring a context class

10.6.4 Creating an instance of the context class

10.6.5 Specifying which connection instance to use

10.6.6 Using more than one context class

10.6.7 Summary of ConnectionContext methods

10.7 Execution contexts

10.8 Interoperability between JDBC and SQLJ

10.8.1 Converting a JDBC result set into an SQLJ iterator

10.8.2 Converting an SQLJ iterator into a JDBC result set

Chapter 11. SQLJ revisited

11.1 Introduction

11.2 Creating the Employee class

11.2.1 Implementing attributes, accessors, and constructors

11.2.2 Implementing the constructor to create new employees

11.2.3 Implementing the insert() method

11.2.4 Creating a test driver

11.2.5 Verifying that the program worked

11.2.6 Implementing the findByPrimaryKey() method

11.2.7 Implementing the delete() method

11.2.8 Implementing the update() method

11.2.9 Implementing the findAll() method

11.2.10 Working with LOB data: The getPicture() and setPicture() methods

Chapter 12. The DB2 Universal Driver

12.1 What the DB2 Universal Driver for SQLJ and JDBC is

12.2 Setting connection properties in the URL

12.3 Functionality enhancements

12.3.1 Scrollable cursor support

12.3.2 Batch updates

12.3.3 Improved security for DB2 authentication

12.3.4 Improved Java SQL error information.

12.3.5 Java API for Set Client Information (SQLESETI)

12.3.6 Java API for application monitoring

12.3.7 Native DB2 server SQL error messages

12.3.8 Multiple open cursors

12.3.9 SAVEPOINT support

12.3.10 Auto-generated keys

Chapter 13. Performance topics

13.1 General performance recommendations

13.1.1 Use static SQL wherever possible

13.1.2 Turn auto commit off

13.1.3 Only retrieve/update columns as needed

13.1.4 Store numbers as numeric data types

13.1.5 Use DB2 built-in functions

13.1.6 Release resources

13.2 JDBC recommendation

13.3 SQLJ performance considerations

13.3.1 Use matching data types

13.3.2 Use positioned iterators, not named iterators

13.3.3 Always customize with online checking enabled

13.3.4 Check explain tables

13.3.5 Rebind packages regularly

13.4 System-level performance tuning

13.4.1 Tune the JVM heap size

13.4.2 Get the latest code and maintenance

13.4.3 Turn on DB2 dynamic statement caching

Chapter 14. Error handling and diagnosis

14.1 Basic error handling

14.2 SQLCODE and SQLSTATE

14.3 Cleaning up resources

14.4 DB2 specific error handling

14.5 Tracing

14.5.1 Turning on tracing in the program

14.5.2 Turning on tracing using connection properties

Part 4 Accessing DB2 from Web applications

Chapter 15. Using Servlets to access DB2

15.1 Creating the project

15.2 Creating the EmployeeList Servlet

15.2.1 Implementing the doGet() method

15.2.2 Testing the Servlet

15.2.3 Displaying the employee list

15.3 Running the completed EmployeeList Servlet

15.4 Creating the EmployeeDetail Servlet

15.5 Creating the EmployeePic Servlet

15.6 Putting it together

15.6.1 Modifying the EmployeeList Servlet

15.6.2 Modifying the EmployeeDetail and EmployeePic Servlets.

15.6.3 Using EmployeePicServlet from EmployeeDetailServlet.

Notes:

"December 2003."

Includes bibliographical references and index.

OCLC:

137342136