Delete base item objects


To delete base item objects, which contain information about a general family of merchandise with the same name and description:

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

    (DB2)

      •   ./dbclean.sh -object baseitem -type obsolete -instancexml WC_installdir/instances/instance/xml/ instance.xml -db dbname -dbuser user -loglevel loglevel

      • Windows: dbclean -object baseitem -type obsolete -instancexml WC_installdir/instances/instance/xml/ instance.xml -db dbname -loglevel loglevel

    • (Oracle)

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

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

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

    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