JR49888: Delta index very slow due to huge entries in CACHEIVL

7.0.0.9 for Developer Express
7.0.0.9 for Developer Professional
7.0.0.9 for Developer Enterprise
7.0.0-WS-WCServer-FP009

APAR status

• Closed as program error.

Error description

• Delta index takes a long time to complete and the root cause is:
  11000+ entries inserted in CACHEINVL table, this slows delta
  index performance.  In CACHEIVL table, there are a lot of
  entries with 'CategoryDislpay:storeId:categoryId:xxxxxx:xxxxxx'
  where categoryId is not valid.
  

Local fix

• Update the cache invalidation template for catalog entry in
  wc-component.xml file to not include category level variables
  

Problem summary

• USERS AFFECTED:
   Business user
  
   PROBLEM ABSTRACT:
   delta index very slow due to huge entries in CACHEIVL
  
   BUSINESS IMPACT:
   Full invalidation or manual invalidation required
  
   RECOMMENDATION:
  

Problem conclusion

• The code logic has been corrected to remove deep category cache
  invalidation upon updating any catalog entry.
  
  
   -------------------------------------------------------------
   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 DEV ED W

• Fixed component ID

  5724I3900

Applicable component levels

• R700 PSY

     UP