Webshere Commerce - Data Cache (Part 2) - Enabling and configuring distributedMap

 There are two ways to configure data cache

• By creating cacheinstance.properties
• By configuring on application server.  This is discussed below
  

  Step By Step setup:

• Step 1: Click on Object Cache instances
  

• Step 2: Click New

• Step 3: Get the distributed Map you want configure (here)
• Step 4: Here i am setting properties for a single JVM . JNDI has to be services/cache/distributedMapName ( you will get that from Step 3)
  

Well so far we configured the distributedMap on server. CacheIVL is the table that holds the data cache we are talking about. For that to happen.

For data to be loaded into cacheIVL we need to set up few triggers. These triggers are available at
<WCD>\schema\db2\wcs.cacheivl.trigger.sql

For catalog we have to take enable triggers civd_c21,civu_c21,civi_c21 . These triggers will monitor CATENTRY table for delete,update and insert respectively.

Though we set distributeMap and triggers, There are still few questions popping out that is asking me - Why DynaCacheInvalidation schedule job which is running every 10 min by default is not deleting entries in cacheivl?
- How to i find if WC set up is success and taking from cache instead of regular query.

Note: To examine of view the cached object in cache monitor. Install Websphere Extended Cache Monitor

Reference: IBM WC Task
Verifying data in table.