JR57304: Provide ability to disable data cache invalidation for delta di-buildindex

APAR status

• Closed as program error.

Error description

• If you are frequently running delta index to make small changes
  to the catalog, then you might end up having frequent queries
  from the search server to the database, which causes performance
   issues.
  
  By default, di-buildindex (DataImportProcessorMain) registers
  the following cache invalidation entries regardless of the delta
   changes.
  
  WCT+CATGRPREL+?
  WCT+CATGRPDESC+?
  WCT+CATGROUP+?
  WCT+SRCHATTR+?
  

Local fix

• Manually delete entries from CACHEIVL database table to avoid
  over cache invalidation.
  

Problem summary

• USERS AFFECTED:
  WebSphere Commerce Version 7 and Version 8.
  
  PROBLEM ABSTRACT:
  Provide ability to disable data cache invalidation for delta
  di-buildindex
  
  BUSINESS IMPACT:
  High CPU usage on Search server when frequent catalog updates
  are made.
  
  RECOMMENDATION:
  

Problem conclusion

• Introduced a flag, -skipInvalidation <true|false>, to
  di-buildindex command line option to disable generating
  invalidation entries in the CACHEIVL table for the following:
  
  WCT+CATGRPREL+?
  WCT+CATGRPDESC+?
  WCT+CATGROUP+?
  WCT+SRCHATTR+?
  

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