Deleting store objects

To delete store objects from the database, use the Database Cleanup utility.

Before you begin

If you are deleting a store, you must close the store first before you delete the store. The mark for delete flag is not supported. You must use the status flag (open/closed/suspended) first, and then use the mark for delete flag. It is the status flag that determines store access.

Procedure

  1. From the WC_installdir/bin directory, run the following script:
    • DB2
      • For IBM i OS operating system   ./dbclean.sh -object store -type specified -db dbname -dbuser user -loglevel loglevel -name storeId -instancexml WC_instance_root/instances/ instance_name/xml/ instance_name.xml
      • AIXLinux
      • Windows dbclean -object store -type specified -db dbname -loglevel loglevel -name storeId -instancexml WC_installdir/instances/ instance_name/xml/ instance_name.xml
    • Oracle
      • AIX ./dbclean.sh -object store -type specified -db dbname -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password -name storeId -instancexml WC_installdir/instances/ instance_name/xml/ instance_name.xml
      • Windows dbclean -object store -type specified -db dbname -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password -name storeId -instancexml WC_installdir/instances/ instance_name/xml/ instance_name.xml

      Use host:port:sid for the database name for example, myhost:1521:mydb.

  2. Examine the WC_installdir/instances/instance_name/logs/DBClean/DBClean.timestamp.log file.