IBM Support

JR53335: Improved caching for contract pricing

Subscribe

You can track all active APARs for this component.

 

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 number

    JR53335

  • Reported component name

    WC BUS EDITION

  • Reported component ID

    5724I3800

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-05-12

  • Closed date

    2015-06-16

  • Last modified date

    2016-04-12

  • 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"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]

Document Information

Modified date:
12 December 2021