Direct links to fixes
APAR status
Closed as program error.
Error description
During the shopping flow, shipping mode and calculation usage information is repeatedly queried from the database, even though it rarely changes.
Local fix
Problem summary
USERS AFFECTED: WebSphere Commerce version v7.0 users PROBLEM ABSTRACT: Cache frequently executed SHIPMODE and CALUSAGE queries. BUSINESS IMPACT: Impacts Performance RECOMMENDATION:
Problem conclusion
Two new logical data caches are introduced. The com.ibm.commerce.fulfillment.beansrc.CalculationUsageCache logical data cache caches data from the CALUSAGE table in the WCPromotionDistributedMapCache object cache, and the com.ibm.commerce.productset.commands.util.ProductSetEntitlementH elper logical data cache caches product set entitlement information for a particular user in the WCUserDistributedMapCache object cache. WebSphere Commerce administration and shopping flow code is changed to take advantage of these new logical data caches, as well as to take better advantage of the existing com.ibm.commerce.fulfillment.objsrc.ShippingModeCache and com.ibm.commerce.order.objsrc.OfferCache logical data caches to avoid frequent queries to the SHIPMODE and OFFER tables. New database triggers for the CALUSAGE table are provided in the schema/<database type>/wcs.cacheivl.trigger.sql database script file. The database triggers in the wcs.cacheivl.trigger.sql file should be defined on a production database to allow proper data cache invalidation by the DynaCacheInvalidation scheduler job during propagation of staged database changes to a production database. They can be removed by executing the schema/<database type>/wcs.cacheivl.drop.trigger.sql database script file. This fix also includes fixes for the following APARs: JR42205 IV11834 LI76427 JR43804 JR42644 JR41625 JR41749 JR43900 JR42809 JR42507 JR41832 JR41551 JR41545 ------------------------------------------------------------- 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
JR44391
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
2012-10-16
Closed date
2013-03-07
Last modified date
2013-03-07
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:
07 March 2013