WebSphere Application Server APAR # PQ42166

  Defect # 87669
   
  WebSphere Release: 3.0.2.2

  Original jar:  pq42166-HttpSessionEFIX-1009.jar          
                    
  Abstract:   - Removal of select for update
              - Proactive cleanup of cache
              - Fixes for manual update null ptr's and deadlocks
              - Serializing of invalid threads
              - Database schema change that now allows the "property name"
                (e.g.  putValue ("propertyname", propertyValue) to be up to
                64 characters long.  Also, a Web Application name of up to 
                64 characters is also now supported. 
              - Oracle OCI workaround
              - Oracle runs out of cursors even with auto commit on
              - All fixes in PQ40815 
              
  Note:  This efix is for 3.02.2, however, if the customer is running 
  with an equivalent to the IBM e-network dispatcher (eND) with a sticky port, 
  the fix does not require PTF 2. This efix should be viewed as a cumulative 
  efix and replace any previous 3.02.2 efixes installed for Http sessions.
  Please also review the Http Session Best Practices Guide included in this
  package.            
**********************VERY IMPORTANT NOTE**********************************
THE SESSIONS DATABASE TABLE MUST BE DROPPED BEFORE THIS EFIX IS APPLIED!!!!
***************************************************************************

 Installation:

1. Copy pq42166-HttpSessionEFIX-1009.jar to a directory, such as WebSphere\AppServer\efix
   
2. Add the directory/jar file to the beginning of the admin server's classpath
   in WebSphere\AppServer\bin\admin.config :

 com.ibm.ejs.sm.adminserver.classpath=C:/WebSphere/AppServer/efix/pq42166-HttpSessionEFIX-1009.jar;C:/WebSphere....

3. Restart the WebSphere Application Server.