PQ52868: J2EE APPLICATION RUNS OUT OF DB2 CONNECTIONS (THREADS). | |||||||||||||||||||||||||||||||||||||||||
![]() |
|||||||||||||||||||||||||||||||||||||||||
![]() 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 is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: UQ58586 Modules/Macros
|
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
(C) Copyright IBM Corporation 2000, 2006. All Rights Reserved.