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
-
From a command prompt, connect to the production database with a proper user ID and
password.
-
Drop the existing database triggers by invoking the following SQL script.
- WCDE_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.
-
Add the existing and new database triggers by invoking the following SQL script.
- WCDE_installdir/schema/dbtype/wcs.cacheivl.trigger.sql
- WC_installdir/schema/dbtype/wcs.cacheivl.trigger.sql