Home Page Icon
Home Page
Table of Contents for
Tables
Close
Tables
by Andreas Thiele, Bart Steegmans, Rajesh Ramachandran, Maggie Lin, Josef Klitsch,
DB2 for z/OS and WebSphere Integration for Enterprise Java Applications
Front cover
Figures
Tables
Examples
Notices
Trademarks
Preface
Authors
Now you can become a published author, too!
Comments welcome
Stay connected to IBM Redbooks
Chapter 1. Application development with DB2 for z/OS
1.1 Mainframe and DB2 for z/OS
1.2 The System z platform
1.2.1 Using System z technology to reduce complexity
1.2.2 Business integration and resiliency
1.2.3 Managing the System z platform to meet business goals
1.2.4 Security
1.3 Programming languages
1.3.1 Language Environment
1.3.2 Java
1.3.3 Business application languages
1.4 Integrated application and database on z/OS
1.4.1 Data consolidation on the System z platform
1.4.2 Data consolidation and integration of the applications on z/OS
1.5 The synergy between z/OS and DB2 for z/OS
1.5.1 How DB2 for z/OS uses the System z platform
Chapter 2. Accessing DB2 for z/OS from WebSphere applications
2.1 Application server infrastructure
2.2 Related products
2.2.1 WebSphere Application Server Community Edition
2.2.2 WebSphere eXtreme Scale
2.2.3 Rational Application Developer for WebSphere Software V8.5
2.3 Core concepts of WebSphere Application Server
2.3.1 Applications
2.3.2 Containers
2.3.3 Application servers
2.3.4 Profiles
2.3.5 Nodes, node agents, and node groups
2.3.6 Cells
2.3.7 Deployment manager
2.4 Server configurations
2.5 Clusters and high availability
2.5.1 Vertical cluster
2.5.2 Horizontal cluster
2.5.3 Mixed cluster
2.5.4 Mixed-node versions in a cluster
2.5.5 Dynamic cluster
2.5.6 Cluster workload management
2.6 Database access from WebSphere Application Server
2.6.1 JDBC driver types
2.6.2 Concept of JDBC providers
2.6.3 Concept of data sources
2.6.4 WebSphere Application Server connection pooling
2.6.5 WebSphere connection pooling combined with sysplex workload balancing for JDBC type 4 connectivity
2.6.6 WebSphere Application Server prepared statement cache
2.6.7 Trusted context support in WebSphere Application Server
2.6.8 Transaction Isolation Level support in WebSphere Application Server
2.6.9 Transactions in WebSphere Application Server
2.7 WebSphere Application Server - DB2 high availability configuration options
2.7.1 WebSphere Application Server - DB2 for z/OS recommended high availability configuration when using JDBC type 4 connectivity
2.7.2 WebSphere Application Server - DB2 z/OS recommended high availability configuration when using JDBC type 2 connectivity
Chapter 3. DB2 configuration options for Java client applications
3.1 The DB2 configuration
3.1.1 Configuring the TCP/IP network
3.1.2 Configuring the DB2 subsystems
3.2 IBM Data Server Drivers and Clients
3.2.1 Connectivity options for IBM Data Server Driver for JDBC and SQLJ
3.2.2 Limited block fetch extended to the JCC type 2 drivers
3.3 High availability configuration options
3.3.1 How to make your client application sysplex aware
3.3.2 The difference between connections and transports
3.3.3 What JCC client properties need to be changed
Chapter 4. DB2 infrastructure setup
4.1 z/OS related setup
4.1.1 Parallel Sysplex
4.1.2 Automatic Restart Manager policy
4.1.3 WLM configuration
4.1.4 Resource Recovery Services
4.1.5 z/OS resource planning
4.1.6 External storage configuration
4.1.7 UNIX System Services file system configuration
4.1.8 Monitoring infrastructure
4.1.9 WebSphere Application Server and DB2 security
4.2 Monitoring strategy
4.3 DB2 for z/OS configuration
4.3.1 DB2 connectivity installation parameters
4.3.2 Enabling DB2 dynamic statement cache
4.3.3 Locking and accounting setup
4.3.4 Buffer pool configuration
4.3.5 DB2 for z/OS Distributed Data Facility
4.3.6 High Performance DBATs
4.3.7 IBM Data Server Driver for JDBC and SQLJ
4.3.8 JDBC type 2 DLL and the SDSNLOD2 library
4.3.9 Bind JDBC packages
4.3.10 UNIX System Services command line processor configuration
4.3.11 Using the TestJDBC Java sample
4.3.12 DB2 security considerations
4.3.13 Trusted context
4.3.14 Trusted context application scenarios
4.3.15 DayTrader-EE6 application using JDBC connections
4.3.16 Data Web Service servlet with trusted context AUTHID switch
4.3.17 Using DB2 profiles
4.3.18 Using profiles to optimize and monitor threads and connections
4.3.19 Configure thread monitoring for the DayTrader-EE6 application
4.3.20 Using profiles to keep track of DRDA client levels
4.3.21 Using profiles to disable idle thread timeout at application level
4.3.22 Using profiles for remote connection monitoring
4.3.23 SYSPROC.ADMIN_DS_LIST stored procedure
4.3.24 DB2 real time statistics
4.3.25 Using RTS to obtain COPY, REORG and RUNSTATS recommendations
4.4 Tivoli OMEGAMON XE for DB2 Performance Expert for z/OS
4.4.1 Extract, transform, and load DB2 accounting FILE and statistics information
4.4.2 Extract, transform and load DB2 accounting SAVE information
4.4.3 Querying the performance database tables
4.4.4 Additional information
4.5 DB2 database and application design considerations
Chapter 5. WebSphere Application Server infrastructure setup
5.1 Configuring WebSphere Application Server Network Deployment on z/OS
5.2 Configuring WebSphere Application Server for JDBC type 4 XA access
5.2.1 Defining a DB2 JDBC XA provider
5.2.2 Defining environment variables at the location of the IBM Data Server Driver for JDBC and SQLJ classes for JDBC type 4 connectivity
5.2.3 Defining a JDBC type 4 XA data source
5.3 Configuring WebSphere Application Server for JDBC type 2 access
5.3.1 Defining a DB2 JDBC provider
5.3.2 Defining environment variables to the location of the IBM Data Server Driver for JDBC and SQLJ classes for JDBC type 2 connectivity
5.3.3 Defining a JDBC type 2 data source
5.3.4 Configuring a subsystem ID on the data source
5.4 Configuring WebSphere Application Server for sysplex workload balancing
5.5 Configuring client information in WebSphere Application Server
5.5.1 Setting client information on a data source
5.5.2 Setting client information by using extended data source properties
5.5.3 Setting DB2 client information in a WebSphere Java application
5.6 Configuring the prepared statement cache in WebSphere Application Server
5.7 Configuring the J2C authentication alias
5.8 Configuring connection pool sizes on data sources in WebSphere Application Server
5.9 Enabling trusted context for applications that are deployed in WebSphere Application Server
5.10 Configuring the JCC properties file in WebSphere Application Server
5.11 Configuring data source properties (webSphereDefaultlsolationLevel, currentPackagePath, pkList, and keepDynamic)
5.11.1 websphereDefaultIsolationLevel
5.11.2 currentPackagePath
5.11.3 pkList
5.11.4 keepDynamic
Chapter 6. Developing Java applications with DB2 for z/OS
6.1 Drivers for Java applications
6.2 Dynamic SQL
6.3 Static SQL
6.4 PureQuery optimization
6.5 DB2 support for Java stand-alone applications
6.5.1 Alternatives for setting the JDBC driver parameters
6.5.2 Java batch considerations with DB2
6.5.3 Portability
6.5.4 Sample Java SE stand-alone application with JPA and DB2
6.6 JDBC applications in managed environments
6.6.1 Data source connection tests on z/OS
6.7 Coding practices for a good DB2 dynamic statement cache hit ratio
6.7.1 Eligible SQL statements for caching
6.7.2 SQL comments considerations
6.7.3 Conditions for prepared statement reuse
6.7.4 Literal replacement
6.8 Locking
6.8.1 Isolation level
6.8.2 Lock avoidance
6.8.3 Optimistic locking
Chapter 7. Java Platform, Enterprise Edition with WebSphere Application Server and DB2
7.1 Java Platform, Enterprise Edition with WebSphere Application Server and DB2
7.2 Implementation version of JPA inside WebSphere Application Server
7.2.1 The goals of the Java Persistence API
7.2.2 OpenJPA and JDBC interaction
7.2.3 Agile JPA development with a WebSphere Application Server embeddable EJB container and DB2
7.2.4 Use of alternative JPA persistence providers
7.2.5 Usage of Non-JTA data sources
7.2.6 Data source resource definition in applications
7.2.7 Definition of the IBM DB2 Driver in WebSphere Application Server V8.5 Liberty Profile
7.2.8 LOB streaming
7.2.9 XML JPA column mapping
7.3 Preferred practices of Java Platform, Enterprise Edition and DB2
7.3.1 Using resource references
7.3.2 Providing a JDBC driver in your application libraries
7.3.3 Resetting the database for each test run
7.3.4 Optimizing generated SQL from persistence frameworks
7.4 Known issues with OpenJPA 2.2 and DB2
Chapter 8. Monitoring WebSphere Application Server applications
8.1 Performance monitoring
8.1.1 Continuous monitoring
8.1.2 Detailed monitoring
8.2 Correlating performance data from different sources
8.2.1 Using client information strings for correlating data
8.2.2 Using client information strings to classify work in WLM and RMF reporting
8.2.3 Other techniques to segregate/correlate work
8.3 Monitoring from WebSphere Application Server
8.3.1 Using SMF 120 records
8.3.2 WebSphere Application Server Performance Monitoring Infrastructure
8.4 Monitoring from the DB2 side
8.4.1 Which information to gather
8.4.2 Creating DB2 accounting records at a transaction boundary
8.4.3 DB2 rollup accounting
8.4.4 Analyzing DB2 statistics data
8.4.5 Analyzing DB2 accounting data
8.4.6 Monitoring threads and connections by using profiles
8.5 Using the performance database
8.5.1 Querying aggregated JDBC type 2 accounting information
8.5.2 Querying aggregated JDBC type 4 accounting information
8.5.3 Using RTS to identify DB2 tables that are involved in DML operations
8.6 Monitoring from the z/OS side with RMF
8.6.1 Workload activity when using a type 4 connection
8.6.2 Workload activity when using a type 2 connection
Chapter 9. Error handling and problem determination
9.1 Error handling
9.1.1 Basic error message
9.1.2 SQLCA formatting
9.1.3 Multiple SQL error handling
9.2 Correlating DB2 and WebSphere Application Server information
9.3 Common tools for problem determination
9.3.1 Application log
9.3.2 IBM Data Server Driver for JDBC and SQLJ trace
9.3.3 DB2 commands
9.4 Typical problem scenario: Deadlock
9.4.1 Analyzing the Servant log and DB2 MSTR job log
9.4.2 Analyzing the deadlock trace record
9.4.3 Identifying the application and SQL statements
9.4.4 Getting more information from the record trace
Appendix A. DB2 administrative task scheduler
A.1 Implementation
A.2 Administrative scheduler operation
A.3 Using ADMT for DB2STOP, DB2START, and statistics monitoring
A.4 Additional information
Appendix B. Configuration and workload
B.1 Configurations
B.2 The DayTrader application workload
B.3 Using the DayTrader application
Appendix C. Setting up a WebSphere Application Server test environment on IBM Data Studio
C.1 Installing WebSphere Application Server Developer Tools into IBM Data Studio
Appendix D. IBM OMEGAMON XE for DB2 performance database
D.1 Introduction
D.2 Creating the performance database
D.3 Extracting, transforming, and loading accounting and statistics data
D.4 Sample query for application profiling
D.5 Using the UDF for application profiling
D.6 Additional information
Appendix E. SMF 120 records subtypes 1, 3, 7, and 8
E.1 Server activity record: Subtype 1
E.2 Server interval record: Subtype 3
E.3 WebContainer activity record: Subtype 7
E.4 WebContainer activity record: Subtype 8
Appendix F. Sample IBM Data Server Driver for JDBC and SQLJ trace
Appendix G. External user-defined functions
G.1 UDF GRACFGRP
G.2 UDF BIGINT
Appendix H. ClientInfo dynamic web project
H.1 The ClientInfo dynamic web project
H.2 Accessing the ClientInfo.war file from your workstation
H.3 Installing the ClientInfo web application
H.4 Starting the ClientInfo web application
H.5 Testing the ClientInfo web application
H.6 Testing the ClientInfoJDBC30API servlet
H.7 Testing the ClientInfoJDBC40 servlet
H.8 Testing the ClientInfoWSAPI servlet
H.9 Testing the ClientInfoWLM servlet
Appendix I. Additional material
Locating the web material
Using the web material
Related publications
IBM Redbooks
Other publications
Online resources
Help from IBM
Back cover
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Figures
Next
Next Chapter
Examples
Tables
2-1 List of sections describing the JDBC type 4 implementation steps 65
2-2 List of sections describing the JDBC type 2 implementation steps 76
3-1 IBM Data Server Drivers and Clients comparison 88
3-2 IBM Data Server Client Packages: Latest downloads (DB2 10) 88
3-3 Java client Sysplex property definitions 94
4-1 clientApplicationInformaton 111
4-2 RRSAF reason codes 117
4-3 Requirements for pooled threads 139
4-4 Buffer pool configuration 151
4-5 Profile table filter criteria 182
4-6 Profile attributes 183
6-1 Equivalency of JDBC and DB2 isolation levels 309
6-2 Correlation of data source scope with the test connection JVM 328
6-3 Impact of CURRENTDATA option 334
8-1 Setting client information through Data Server Driver only methods 363
8-2 Client properties that are set by the driver when using a type 4 connection to DB2 for z/OS 364
8-3 Client properties that are set by the driver when using a type 2 connection to DB2 for z/OS 365
9-1 IBM Data Server Driver for JDBC and SQLJ trace levels 465
D-1 FILE accounting table DDL and load statements 530
D-2 SAVE accounting table DDL and load statements 530
D-3 Statistics table DDL and load statements 531
H-1 ClientInfo servlet functionality 574
H-2 URLs for testing the ClientInfo servlet applications 581
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset