JR56935: RuleBasedCategoryEvalutionCmd performance issue when a change in RBSC rule results in removal of large number of catalog entries

APAR status

• Closed as program error.

Error description

• When a change to a Rule Based Sales Category (RBSC) rule results
  in the removal of large number of catalog entries, the process
  to remove these entries takes a significant amount of time, and
  might result in a transaction timeout.
  

Local fix

• Manually remove the CATGPENREL entries for the RBSC for which
  you want to change.
  

Problem summary

• USERS AFFECTED:
  WebSphere Commerce Version 7 Feature Pack 8/Fix Pack 9.
  
  PROBLEM ABSTRACT:
  RuleBasedCategoryEvalutionCmd performance issue when a change in
   RBSC rule results in removal of large number of catalog entries
  
  BUSINESS IMPACT:
  Impacts performance, as a business user will need to wait a long
   time until the changes to the RBSC can be seen.
  
  RECOMMENDATION:
  

Problem conclusion

• Query was optimized under new template
  "IBM_Delete_RemoveCatalogGroupToCatalogEntryRelationsForProductA
  ndSKUsList".
  
  See the readme file associated with the iFix for details on the
  steps to perform the customization.
  
  If the new template is found, the removal of catalog entries
  from the RBSC will be handled in sets of 1000 at a time.
  Additionally, JDBC batching is applied to the transaction.
  
  If the new template is not found, the original template is used.
  

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