Delete catalog entry objects

To delete catalog entry objects:

1. From the WC_installdir/bin directory, type the following:

   • (DB2)

     ./dbclean.sh -object catentry -type typename -instancexml WC_installdir/instances/instance/xml/ instance.xml -db dbname -dbuser user -days daysold -loglevel loglevel

     • Windows: dbclean -object catentry -type typename -instancexml WC_installdir/instances/instance/xml/ instance.xml -db dbname -days daysold -loglevel loglevel

   • (Oracle)

     • AIX|Solaris|./dbclean.sh -object catentry -type typename -instancexml WC_installdir/instances/instance/xml/ instance.xml -db dbname -days daysold -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password

     • Windows: dbclean -object catentry -type typename -instancexml WC_installdir/instances/instance/xml/ instance.xml -db dbname -days daysold -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password

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

   Notes:

   1. For the -type parameter, you can specify without_orderitems to indicate catalog entries which are not referenced to any order item or without_orderitems_iitems to indicate catalog entries which are not referenced to any order item or interest list item.

   2. For details on the syntax and parameters for the dbclean script, see Database Cleanup utility script.  

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

 

Related Concepts

Database Cleanup utility