IV11834: CMVC 216357 - REDUCE THE NUMBER OF QUERIES RUN FOR GENERIC USER CACHE.

7.0.0.9 for Developer Express
7.0.0.9 for Developer Professional
7.0.0.9 for Developer Enterprise
7.0.0-WS-WCServer-FP009
WebSphere Commerce Version 7.0.0.7 Fix Pack
WebSphere Commerce Version 7.0.0.9 Fix Pack

APAR status

• Closed as program error.

Error description

• Some SQL queries related to generic user (-1002) are not being
  cached.
  
  For example:
  
  The following query should return results for MEMBER_ID -1002,
  but there isn't any cache entry:
  
  SELECT T1.STATE, T1.MEMBER_ID, T1.OPTCOUNTER, T1.TYPE,
  T2.FIELD2, T2.
  REGISTRATIONUPDATE, T2.FIELD3, T2.LASTORDER, T2.LANGUAGE_ID, T2.
  PREVLASTSESSION, T2.SETCCURR, T2.DN, T2.REGISTRATIONCANCEL, T2.
  LASTSESSION, T2.REGISTRATION, T2.FIELD1, T2.REGISTERTYPE, T2.
  PROFILETYPE FROM USERS T2, MEMBER T1 WHERE T1.TYPE = 'U' AND T1.
  MEMBER_ID = T2.USERS_ID AND T1.MEMBER_ID = ?
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce users on v7.0
  
  PROBLEM ABSTRACT:
  Some SQL queries related to generic users are not being cached,
  which is causing performance to degrade.
  
  BUSINESS IMPACT:
  Minimal impact on performance of the site
  
  RECOMMENDATION:
  

Problem conclusion

• The code related to the specific generic data bean has been
  enhanced to allow the SQL queries to be cached.
  -------------------------------------------------------------
  The latest available maintenance information can be obtained
  from the Recommended Fixes for WebSphere Commerce technote:
  http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
  

Temporary fix

Comments

APAR Information

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

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

Fix information

• Fixed component name

  WC COM PROF ED

• Fixed component ID

  5724I4001

Applicable component levels

• R600 PSY

     UP