PQ52868: J2EE APPLICATION RUNS OUT OF DB2 CONNECTIONS (THREADS).

 A fix may be available

Obtain the fix for this APAR



APAR status
Closed as program error.

Error description
When running a global transaction that creates 100+ threads,
the threads available to DB2 get used up since there is no
thread sharing.  This is using the tx-Required transaction
policy.
Local fix
Set db2.connpool.max.size=500.  CTHREAD=700 and IDBACK=500 in
DB2.  This allowed the transaction to complete and maxed out
at 264 threads used by DB2.
Problem summary
****************************************************************
* USERS AFFECTED: All users of WebSphere Application Server    *
*                 V4.0 for z/OS and OS/390.                    *
****************************************************************
* PROBLEM DESCRIPTION: Customer reported running out of DB2    *
*                      connections running a transaction that  *
*                      made several calls to CMP beans.        *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
An application that calls a session bean that uses tx required
as a transaction attribute and calls several CMPs that have the
same transaction attribute eventually stops working when it runs
out of DB2 threads.  The customer sees from 200-300 connections
made.  Each CMP entity bean was using 2 connections per
transaction.  When the customer increased the max connections
setting to 500, the number of connections did not grow much
beyond 300.
Problem conclusion
The fix in this APAR will allow the CMP entity beans to share
DB2 connections.  This will only reduce connections used by the
CMP beans.

APAR PQ52868 is associated with SERVICE LEVEL W400050 of
WebSphere Application Server V4.0 for z/OS and OS/390.
Temporary fix Comments
APAR information
APAR number PQ52868
Reported component name WASKBASE
Reported component ID 5655A9801
Reported release 400
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Submitted date 2001-09-27
Closed date 2001-10-26
Last modified date 2001-12-03

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:
UQ58586

Modules/Macros
BBOUBINF BBOZ0812 BBOZ0813      

Fix information
Fixed component name WASKBASE
Fixed component ID 5655A9801

Applicable component levels
R400 PSY UQ58586    UP01/11/02 P F111

  Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server for z/OS
Operating system(s):
Software version: 400
Software edition:
Reference #: PQ52868
IBM Group: Software Group
Modified date: Dec 3, 2001