Delete auction objects

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

   • (DB2)

     • AIX|Linux|Solaris|I5/OS|  ./dbclean.sh -object auction -type typename -instancexml WC_installdir/instances/instance/xml/ instance.xml -db dbname -dbuser user -days daysold -loglevel loglevel

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

   • (Oracle)

     ./dbclean.sh -object auction -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 auction -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 settlement_closed to indicate a completed auction record, or retracted to indicate a retracted auction.

   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