JR53335: Improved caching for contract pricing

APAR status

• Closed as program error.

Error description

• Contract pricing involves issuing queries to database tables
  such as CONTRACT, TRDDESC, TERMCOND, and PSETADJMNT.  Caching
  the query results can help improve performance.
  

Local fix

Problem summary

• USERS AFFECTED:
  WebSphere Commerce users on Version 7 or Version 8.
  
  PROBLEM ABSTRACT:
  Improved caching for contract pricing
  
  BUSINESS IMPACT:
  Potentially slow performance for pricing calls such as
  GetContractUnitPriceCmdImpl
  
  RECOMMENDATION:
  

Problem conclusion

• This fix introduces new logical data caches:
  
  com.ibm.commerce.contract.beansrc.ContractCache
  and com.ibm.commerce.contract.beansrc.TradingDescriptionCache
  by default cache their data in the object cache with JNDI name
  services/cache/WCContractDistributedMapCache.
  
  com.ibm.commerce.contract.beansrc.ExtendedTermConditionCache.buy
  er
  by default caches its data in the object cache with JNDI name
  services/cache/WCUserDistributedMapCache.
  
  com.ibm.commerce.taxation.beansrc.TaxCategoryCache
  and
  com.ibm.commerce.taxation.beansrc.TaxCategoryDescriptionCache
  by default cache their data in the object cache with JNDI name
  services/cache/WCSystemDistributedMapCache.
  
  A new database trigger is available to invalidate cache entries
  that rely on data from the PSETADJMNT table.  After installing
  this fix, the database triggers defined in the schema/<db
  type>/wcs.cacheivl.trigger.sql file should be dropped and
  re-created. For information about re-creating triggers see:
  WebSphere Commerce Version 7:
  http://www-01.ibm.com/support/knowledgecenter/SSZLC2_7.0.0/com.i
  bm.commerce.admin.doc/tasks/tssprodadbtriggers.htm
  
  WebSphere Commerce Version 8:
  http://www-01.ibm.com/support/knowledgecenter/SSZLC2_8.0.0/com.i
  bm.commerce.admin.doc/tasks/tssprodadbtriggers.htm
  

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