Deleting separate search space for a category

To delete records of a separate 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 statements:
    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 ICTPRICES where STOREID=storeId AND (CATENTRY_ID in (select CATENTRY_ID from CATGPENREL where CATGROUP_ID=xxxx) or CATENTRY_ID in (select CATENTRY_ID_CHILD from CATENTREL , CATGPENREL where CATENTRY_ID_PARENT=CATENTRY_ID and CATGROUP_ID=xxxx))
    3. delete from ICROOTCAT where CATGROUP_ID=xxxx
    4. drop table ICTxxxx
    5. drop table ICTDESCxxxx
    6. drop view ICVxxxx_NULL
      where, xxxx is the category reference number and storeId is the store reference number associated with the category.