JR47978: CMVC 231121 - Queries to the OFFERDESC table are not cached

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.9 Fix Pack

APAR status

• Closed as program error.

Error description

• There is no data cache for queries to the OFFERDESC table.
  

Local fix

Problem summary

• USERS AFFECTED:
   WebSphere Commerce version 7 customers who issue many queries
  to the OFFERDESC table.
  
   PROBLEM ABSTRACT:
   Queries to the OFFERDESC table are not cached
  
   BUSINESS IMPACT:
   Offer description performance affected
  
   RECOMMENDATION:
  

Problem conclusion

• A new logical data cache named
  com.ibm.commerce.order.beansrc.OfferDescriptionCache is defined
  and by default uses the object cache with JNDI name
  services/cache/WCPriceDistributedMapCache.
  
   New database triggers for the OFFERDESC table are added to the
  schema/<databaseType>/wcs.cacheivl.trigger.sql database script
  files.  The schema/<databaseType>/wcs.cacheivl.drop.trigger.sql
  database script file can be used to drop the triggers.
  
   Custom code that uses OfferDescriptionAccessBean objects should
  be changed to use the WCDataCache.newOfferDescriptionAccessBean
  method to obtain access beans that take advantage of the new
  logical data cache.
  
   For more information about the WebSphere Commerce data cache,
  refer to:
   http://pic.dhe.ibm.com/infocenter/wchelp/v7r0m0/topic/com.ibm.c
  ommerce.admin.doc/tasks/tdccdccont.htm
  
   -------------------------------------------------------------
   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 BUS EDITION

• Fixed component ID

  5724I3800

Applicable component levels

• R700 PSY

     UP