Enabling interim fix JR57116

JR57116 provides the ability to invalidate specific cache objects that are in the WCPriceDistributedMapCache.

Before you begin

Install the interim fix for JR57116.

Procedure

  1. From a command prompt, connect to the production database with a proper user ID and password.
  2. Drop the existing database triggers by invoking the following SQL script.
    • WebSphere Commerce DeveloperWCDE_installdir/schema/dbtype/wcs.cacheivl.drop.trigger.sql
    • WC_installdir/schema/dbtype/wcs.cacheivl.drop.trigger.sql
    dbtype is the database type, for example, db2 or oracle.
  3. Add the existing and new database triggers by invoking the following SQL script.
    • WebSphere Commerce DeveloperWCDE_installdir/schema/dbtype/wcs.cacheivl.trigger.sql
    • WC_installdir/schema/dbtype/wcs.cacheivl.trigger.sql