Deleting base item objects

To delete base item objects, which contain information about a general family of merchandise with the same name and description objects from the database, use the Database Cleanup utility.

Procedure

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

    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.