Enabling interim fix JR56935

JR56935 fixes RuleBasedCategoryEvalutionCmd performance issues when you update RBSC rules, which results in removal of large number of catalog entries.

Before you begin

Install the interim fix.
For information about how to install an interim fix, see

Procedure

  1. Go to the workspace_dir/WC/xml/config/com.ibm.commerce.catalog-ext directory.
  2. Create a file named wc-query-utilities.tpl.
  3. Add the following text to the TPL file. 
    <!-- ================================================================================================= 
	Execute during catalog entry reparent. Use to delete old catalog group to catalog entry relations
	to a product and SKUs of a product and PDKs of a DK.
	@param catGroupId The catalog group id 
	@param catalogId The catalog id for the new relations	
	@param catEntryId The catalog entry Id 
=========================================================================== -->
BEGIN_SQL_STATEMENT
	name=IBM_Delete_RemoveCatalogGroupToCatalogEntryRelationsForProductAndSKUsList
	base_table=CATGPENREL
	sql=
	DELETE FROM CATGPENREL WHERE CATGROUP_ID = ?catGroupId? AND CATALOG_ID IN (?catalogId?)	AND 
	CATENTRY_ID IN (SELECT CATENTRY_ID FROM CATENTRY WHERE CATENTRY_ID IN (?catEntryId?)
	UNION ALL SELECT CATENTREL.CATENTRY_ID_CHILD FROM CATENTREL WHERE CATENTREL.CATENTRY_ID_PARENT IN ( ?catEntryId? ) AND CATRELTYPE_ID IN ('PRODUCT_ITEM', 'DK_PDK'))
		
END_SQL_STATEMENT
  4. Deploy the template file to the WebSphere Application Server.