IBM Support

JR46718: CMVC 223735 - Database performance cost during cached browsing with Page layout feature

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The following query coming from this code stack was found to be
    causing higher cost against the database:
    
     SELECT DISTINCT EMSPOT.EMSPOT_ID, EMSPOT.NAME FROM EMSPOT WHERE
    EMSPOT.STOREENT_ID in (?, ?) AND EMSPOT.USAGETYPE = ? AND
    (UPPER(EMSPOT.NAME)=?) ORDER BY EMSPOT.NAME
    
     com.ibm.commerce.marketing.runtime.engine.MarketingEngineCache.
    getEmarketingSpot(MarketingEngineCache.java:3194)
     com.ibm.commerce.marketing.cache.GetMarketingSpotBehaviorCmdImp
    l.getESpot(GetMarketingSpotBehaviorCmdImpl.java:168)
     com.ibm.commerce.marketing.cache.GetMarketingSpotBehaviorCmdImp
    l.performExecute(GetMarketingSpotBehaviorCmdImpl.java:97)
     ...
     com.ibm.ws.cache.servlet.FragmentCacheProcessor.processMetaData
    Generator(FragmentCacheProcessor.java:841)
     com.ibm.ws.cache.servlet.FragmentCacheProcessor.populateFragmen
    tInfo(FragmentCacheProcessor.java:566)
    

Local fix

Problem summary

  • USERS AFFECTED:
     WebSphere Commerce users that are using cached browse with page
    layout feature
    
     PROBLEM ABSTRACT:
     Database performance cost during cached browsing with Page
    layout feature
    
     BUSINESS IMPACT:
     High
    
     RECOMMENDATION:
    

Problem conclusion

  • The fix uses the existing CampaignInitiativeCache to retrieve
    the e-marketing spot instead of the GetMarketingSpot service in
    order to improve performance.
    
     -------------------------------------------------------------
     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

    JR46718

  • 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-05-22

  • Closed date

    2013-08-29

  • Last modified date

    2013-08-29

  • 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:
29 August 2013