Enabling interim fix JR44939

Interim fix JR44939 improves Marketing Data Cache invalidation during stagingprop utility execution.

If you install JR44939, WebSphere Commerce does not have to clear the entire CampaignInitiativeCache, which can improve performance. If you use e-Marketing Spot JSP caching based on activity behavior, then you can drop the database triggers that were created to run WCR+CampaignInitiativeCache invalidation.
Note: If you have JSP pages that do not use e-Marketing Spot JSP caching based on activity behavior, then do not complete this procedure. Those JSP pages need the WCR+CampaignInitiativeCache invalidation.

Before you begin

Procedure

  1. From a command prompt, connect to the database with a proper user ID and password.
  2. Drop the following database triggers.
    • rivi_ems
    • rivu_ems
    • rivd_ems
    • rivi_dma
    • rivu_dma
    • rivd_dma