Delete distributor objects

1. From the WC_installdir/bin directory, type the following to first delete contract objects:

   • (DB2)

     • AIX|Linux|Solaris|I5/OS|./dbclean.sh -object contract -type obsolete -instancexml WC_installdir /instances/ instance /xml/ instance .xml -db dbname -dbuser user -dbpasswd password

     • Windows: dbclean -object contract -type obsolete -instancexml WC_installdir /instances/ instance /xml/ instance .xml -db dbname -dbuser user -dbpasswd password

   • (Oracle)

     . dbclean.sh -object contract -type obsolete -instancexml WC_installdir /instances/ instance /xml/ instance .xml -db dbname -dbtype oracle -dbuser user -dbpasswd password

     • Windows: dbclean -object contract -type obsolete -instancexml WC_installdir /instances/ instance /xml/ instance .xml -db dbname -dbtype oracle -dbuser user -dbpasswd password

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

2. From the WC_installdir/bin directory, type the following to delete fulfillment objects:

   • (DB2)

     ./dbclean.sh -object fulfillment_center -type obsolete - instancexml WC_installdir /instances/ instance /xml/ instance .xml db dbname -dbuser user -dbpasswd password

     • Windows: dbclean -object fulfillment_center -type obsolete -instancexml WC_installdir /instances/ instance /xml/ instance .xml -db dbname -dbuser user -dbpasswd password

   • (Oracle)

     . dbclean.sh -object fulfillment_center -type obsolete -instancexml WC_installdir /instances/ instance /xml/ instance .xml -db dbname -dbtype oracle -dbuser user -dbpasswd password

     • Windows: dbclean -object fulfillment_center -type obsolete -instancexml WC_installdir /instances/ instance /xml/ instance .xml -db dbname -dbtype oracle -dbuser user -dbpasswd password

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

3. From the WC_installdir/bin directory, type the following to delete store objects:

   • (DB2)

     • AIX|Linux|Solaris|I5/OS|. dbclean.sh -object store -type markedfordelete -instancexml WC_installdir /instances/ instance /xml/ instance .xml -name storeID -db dbname -dbuser user -dbpasswd

     • password

   • Windows: dbclean -object store -type markedfordelete -instancexml WC_installdir /instances/ instance /xml/ instance .xml -name storeID -db dbname -dbuser user -dbpasswd password

4. (Oracle)

   . dbclean.sh -object store -type markedfordelete -instancexml WC_installdir /instances/ instance /xml/ instance .xml -name storeID -db dbname -dbtype oracle -dbuser user -dbpasswd password

   • Windows: dbclean -object store -type markedfordelete -instancexml WC_installdir /instances/ instance /xml/ instance .xml -name storeID -db dbname -dbtype oracle -dbuser user -dbpasswd password

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

5. Examine the WC_installdir/instances/ instance/logs/DBClean/DBClean. timestamp.log file.

 

Related Concepts

Database Cleanup utility