JR47546: CMVC 230194 - Adding the cache for inventory configuration.

APAR status

• Closed as program error.

Error description

• Without caching, we have to query database table INVCNF each
  time to retrieve DOM inventory cache configuration, causing
  unnecessary performance overhead.
  

Local fix

Problem summary

• USERS AFFECTED:
   WebSphere Commerce users on v7.0 who use DOM inventory.
  
   PROBLEM ABSTRACT:
   Adding the cache for inventory configuration.
  
   BUSINESS IMPACT:
   The DOM inventory performance will be impacted.
  
   RECOMMENDATION:
  

Problem conclusion

• This fix provides WAS distributed cache to cache the DOM
  inventory configuration data.
  
   There are mainly two scenarios for caching the INVCNF data.
  
   1: Set the config LoadAllConfigrationData in
  WCDir/xml/config/com.ibm.commerce.inventory-fep/wc-admin-compone
  nt.xml as true:
  
         <_config:property name="LoadAllConfigrationData"
  value="true"/>
  
   In this case, all the entries in the table INVCNF will be
  loaded into the cache, so that when getting INVCNF data, it will
  read from cache only. This is the highly recommended as it will
  drastically improve performance for reading inventory
  configuration by totally avoiding database access. This option
  is applicable when the number of INVCNF records is not big, say,
  less than one thousand.
  
   2: Set that value as false. In this case, it will not load all
  the data first, only when resolving INVCNF for one catentry, it
  will cache the resolved result into the cache, so that when next
  time querying INVCNF for the same catalog entry, database access
  can be avoided. This is the alternative option when there are
  too many INVCNF records to be loaded into memory.
  
   Also, when the data in INVCNF table is changed, go to the
  Administration Console to update the
  InventoryConfigurationRegistry, this will reload the cache when
  LoadAllConfigrationData is true, and clear the cache when
  LoadAllConfigrationData is false.
   -------------------------------------------------------------
   The latest available maintenance information can be obtained
  from the Recommended Fixes for WebSphere Commerce technote:
   http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WC BUS EDITION

• Fixed component ID

  5724I3800

Applicable component levels

• R700 PSY

     UP