Direct links to fixes
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 number
JR47978
Reported component name
WC BUS EDITION
Reported component ID
5724I3800
Reported release
700
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-10-03
Closed date
2014-03-17
Last modified date
2014-03-17
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYSYL","label":"WebSphere Commerce Enterprise"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
17 March 2014