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.

For information about how to install an interim fix, see

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