Deleting contract objects

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

    • WC_installdir /instances/ instance /xml/ instance .xml -db dbname -dbuser user -loglevel loglevel

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

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

    • dbclean -object contract -type obsolete -instancexml WC_installdir /instances/ instance /xml/ instance .xml -db database -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password

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

    1. For the -db parameter, specify one of three database tables: productset, tradeposn, or trading.

    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 - - -