Deleting base item objects

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

  1. Type the following:
    • DB2
      • AIXi5/OSiSeriesSun Solaris Operating EnvironmentLinux./dbclean.sh -object baseitem -type obsolete -instancexml instancename -db dbname -dbuser user -loglevel loglevel
      • Windowsdbclean -object baseitem -type obsolete -instancexml instancename -db dbname -loglevel loglevel
    • Oracle
      • AIXSun Solaris Operating Environment./dbclean.sh -object baseitem -type obsolete -instancexml instancename -db dbname -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password
      • Windowsdbclean -object baseitem -type obsolete -instancexml instancename -db dbname -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password

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

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

Feedback