PQ93819: WHEN 10 OR MORE DB TABLES ARE JOINED IN QUERY, PMGR6022E RESULTS

 Fixes are available

5.1.1.8: WebSphere Application Server 5.1.1 Cumulative Fix 8 for AIX
5.1.1.8: WebSphere Application Server 5.1.1 Cumulative Fix 8 for Windows
5.1.1.8: WebSphere Application Server 5.1.1 Cumulative Fix 8 for HP-UX
5.1.1.8: WebSphere Application Server 5.1.1 Cumulative Fix 8 for Solaris
5.1.1.6: WebSphere Application Server Version 5.1.1 Cumulative Fix 6
5.1.1.7: WebSphere Application Server Version 5.1.1 Cumulative Fix 7
5.1.1.4: WebSphere Application Server Version 5.1.1 Cumulative Fix 4
5.1.1.8: WebSphere Application Server 5.1.1 Cumulative Fix 8 for Linux



APAR status
Closed as program error.

Error description
Whenever more than 10 tables are accessed in a query or database
SQL, The error PMGR6022E results.
Local fix Problem summary
****************************************************************
* USERS AFFECTED: WebSphere Application Server users of CMP,   *
*                 especially with large FunctionSets           *
****************************************************************
* PROBLEM DESCRIPTION: ConcurrentModificationException is      *
*                      thrown in WSRegistrationHelper when     *
*                      adding a FunctionSet to the HashMap     *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************
A HashMap was used to store FunctionSet information in the
WSRegistrationHelper class.  This was initially reported by a
customer using CMP with sophisticated EJB relationships
involving JOIN of more than 10 tables.  The code was lacking
any synchronization around the HashMap.
Problem conclusion
Added sychronization around puts to the HashMap.  Gets from
the HashMap will now copy a reference to the HashMap, and puts
to the HashMap will clone the HashMap, execute the put, and
swap the clone back in as the active HashMap for subsequent
gets.
Temporary fix Comments
APAR information
APAR number PQ93819
Reported component name WAS NETWRK DEPL
Reported component ID 5630A3601
Reported release 00A
Status CLOSED PER
PE NoPE
HIPER NoHIPER
Special Attention NoSpecatt
Submitted date 2004-09-07
Closed date 2004-10-08
Last modified date 2004-10-08

APAR is sysrouted FROM one or more of the following:

APAR is sysrouted TO one or more of the following:

Modules/Macros
JDBC          

Publications Referenced

Fix information

Applicable component levels
R003 PSY    UP
R00A PSY    UP
R00H PSY    UP
R00I PSY    UP
R00P PSY    UP
R00S PSY    UP
R00W PSY    UP
R103 PSY    UP
R10A PSY    UP
R10H PSY    UP
R10I PSY    UP
R10P PSY    UP
R10S PSY    UP
R10W PSY    UP


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > General
Operating system(s):
Software version: 00A
Software edition:
Reference #: PQ93819
IBM Group: Software Group
Modified date: Oct 8, 2004