PK68103; 6.1.0.17: Runtime usage JDBC provider error with DB2 z/OS

Downloadable files


Abstract

When you configure Common Event Infrastructure to use DB2® for z/OS® database as repository, the created data source in IBM® WebSphere® Application Server is based on a JDBC driver

Download Description

PK68103 resolves the following problem:

ERROR DESCRIPTION:

Two problems:

1. If we do not change driver type to 4, the datasource cannot connect successfully.

2. If we don't change the Implementation class name the following error will be raised:

com.ibm.db2.jcc.DB2XADataSource, the event can not be submitted and will show exceptions such as:

[6/13/08 11:04:16:583 CST] 0000003e SystemOut O __Claim1BG_Claim1_situation = 1 [6/13/08 11:04:16:584 CST] 0000003e SystemOut O GenericBG_Generic_situation = 1 [6/13/08 11:04:25:132 CST] 0000003e RegisteredRes EWTRN0063E: An illegal attempt to commit a one phase capable resource with existing two phase capable resources has occurred. [6/13/08 11:04:25:177 CST] 0000003e RegisteredRes EWTRN0086I: XAException encountered during prepare phase for transaction

LOCAL FIX:

PROBLEM SUMMARY:

The data source should be type 2 based drivers only when the Application Server is installed on z/OS systems and the repository is DB2 z/OS. In all other situations that a DB2 z/OS is configured the data source should use a type 4 JDBC driver.

USERS AFFECTED:

IBM WebSphere Application Server users that want to install and configure Common Event Infrastructure (CEI) to use a DB2 on z/OS database as a repository.

PROBLEM DESCRIPTION:

When you configure CEI to use DB2 for z/OS database as a repository, the created data source in WebSphere Application Server is based on a JDBC driver type 2.

RECOMMENDATION:

Users who have CEI configured with DB2 z/OS should check their data source configuration and reconfigure in all cases except the prior description.

PROBLEM CONCLUSION:

The behavior was corrected by getting the information about the operating system where the Application Server is installed on. The result is the usage of type 2 based JDBC providers only in case where Application Server is installed on z/OS and using DB2 on z/OS. If the CEI is using DB2 on z/OS but Application Server is based on a different operating system the Application Server database related resources will use a JDBC type 4 driver based approach.

The fix for this APAR is currently targeted for inclusion in Fix Pack 6.1.0.21.

Please refer to the Recommended Updates page for delivery information:
http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980

Prerequisites

Please download the UpdateInstaller below to install this fix.

URL LANGUAGE SIZE(Bytes)
UpdateInstaller US English 7250000

Installation Instructions

Please review the readme.txt for detailed installation instructions.

URL LANGUAGE SIZE(Bytes)
Readme US English 8432

Download package

Download package
What is Fix Central (FC)?
What is DD?

Download RELEASE DATE LANGUAGE SIZE(Bytes) Download Options
6.1.0.17-WS-WAS-IFPK68103 09-24-2008 US English 20401 FC FTP DD



Technical support

Contact IBM Support using SR (http://www-306.ibm.com/software/support/probsub.html), visit the WebSphere Application Server Support Web site (http://www.ibm.com/software/webservers/appserv/was/support/), or contact 1-800-IBM-SERV(U.S. only).

Problems (APARS) fixed
PK68103

Rate this page:

(0 users)Average rating

Document information


More support for:

WebSphere Application Server
DB Connections/Connection Pooling

Software version:

6.1.0.17

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Software edition:

Base, Developer, Network Deployment

Reference #:

4020588

Modified date:

2008-10-22

Translate my page

Machine Translation

Content navigation