Fix (APAR):  JR28918

Status:  Fix

Release:  6.0.2.3,6.0.2.2

Operating System:  AIX,HP-UX,Linux,Solaris,Windows

Supersedes Fixes:  

CMVC Defect:  JR28918

Byte size of APAR:  6646

Date: 2008-04-14

Abstract:  Receive a "result set closed" error when a get DB connection occurs under high load.

Description/symptom of problem:  
 
JR28918 resolves the following problem:

ERROR DESCRIPTION:                                              
"result set closed" error occurs when a get DB connection under 
high load because selector/Business rule share Database         
connection. This will cause problem under high load with        
multi-thread.                                                   

LOCAL FIX:                                                      
None.                                                           

PROBLEM SUMMARY

USERS AFFECTED:
WebSphere Process Server 6.0.2 users.

PROBLEM DESCRIPTION:
Receive a "result set closed" error
when a get DB connection occurs under
high load.


RECOMMENDATION:
None

"result set closed" error occurs when a get DB connection
under high load because selector/Business rule share Database
connection. This will cause problem under high load with
multi-thread.

PROBLEM CONCLUSION:                                             
Applying this interim fix will resolve the issue.               


Directions to apply fix:  
Download and follow Update Installer installation instructions.  The Update Installer can be downloaded from the following link:
http://www.ibm.com/support/docview.wss?rs=180&uid=swg21205991

1) Copy the pak file to the directory maintenance in the UpdateInstaller directory

2) Shutdown WebSphere Process Server. It is important that you perform a controlled and complete shutdown of the server to ensure that all transactions have completed, before installing the fix.

3) Run the UpdateInstaller and follow the prompts.

4) Restart WebSphere Process Server.

Directions to remove fix:  
NOTE:  FIXES MUST BE REMOVED IN THE REVERSE ORDER IN WHICH THEY WERE APPLIED.  DO NOT REMOVE A FIX UNLESS  ALL FIXES APPLIED AFTER IT HAVE FIRST BEEN REMOVED.  YOU MAY REAPPLY ANY REMOVED FIX.

Example:  If your system has fix1, fix2, and fix3 applied in that order and fix2 is to be removed, fix3 must be removed first, then fix2 may be removed

1) Shutdown WebSphere Process Server. It is important that you perform a controlled and complete shutdown of the server to ensure that all transactions have completed, before installing the fix.

2) Follow the Fix instructions that are packaged with the Fix Installer on how to uninstall and reinstall the Fix.

3) Restart WebSphere Process Server.

Directions to re-apply fix:  
1) Shutdown WebSphere. It is important that you perform a controlled and complete shutdown of the server to ensure that all transactions have completed, before installing the fix.

2) Run the UpdateInstaller and follow the instructions. The Update Installer can be downloaded from the following link:
http://www.ibm.com/support/docview.wss?rs=180&uid=swg21205991

3) Restart WebSphere Process Server.

Additional Information: