PK90170: REDUCE ACCESS TO THE DATABASE DURING INVALIDATION IF USING MULTI-SCHEMA ROWS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This apar will reduce access to the database during invalidation
  if using multi-schema rows.  This will improve performance.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: IBM WebSphere Application Server users       *
  *                 using session persistence who configured     *
  *                 multi-rows schema                            *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Optimization of the number of sql       *
  *                      queries to database during http         *
  *                      session invalidation processing.        *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Whenever http session database persistence is configured,
  during invalidation processing the session manager needs to
  fetch the session from the backend database.  In a multi-row
  persistence configuration this was being done through multiple
  queries.  Through this APAR we have optimized the number of
  queries.
  

Problem conclusion

• This APAR optimized the performance of session
  invalidation in multi-rows configuration.  The number
  of queries invalidating the session has been optimized to a
  minimal number.
  
  APAR PK90170 is currently targeted for inclusion in Service
  Level (Fix Pack) 7.0.0.5 of WebSphere Application Server V7.0.
  
  Please refer to URL:
  //www.ibm.com/support/docview.wss?rs=404&uid=swg27006970
  for Fix Pack availability.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  PK71265

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

Modules/Macros

• BBGUBINF BBOUBINF
  

Fix information

• Fixed component name

  WEBSPHERE FOR Z

• Fixed component ID

  5655I3500

Applicable component levels

• R700 PSY UK48201

     UP09/07/27 P F907

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.