Deleting base search space for a category

To delete records of a base search space for a category do the following:

  1. Open a command window, which corresponds to the database that you are using.
  2. Run the following SQL statement:
    iSeries Refer to the WebSphere Commerce Installation Guide for information on how to run the SQL statements against the WebSphere Commerce database.
    1. delete from ICEXPLFEAT where CATGROUP_ID=xxxx
       
    2. delete from ICROOTCAT where CATGROUP_ID=xxxx
      Where, xxxx  is the category reference number for which search space needs to be deleted.