Administer > Database Cleanup utility > Clean the database

Delete contract objects

Procedure

1. From the WC_INSTALL/bin directory, run the following script:
   
   

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

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

   
   

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

   • dbclean -object contract -type obsolete -instancexml WC_INSTALL/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_INSTALL/instances/ instance/logs/DBClean/DBClean.timestamp.log file.

Example

./dbclean.sh -object contract -type obsolete -demo.xml WebSphere/WebSphereCommerce/instances/demo/xml/demo.xml 
    db host:port:sid -commit 500 -max 8000 -check_object_only yes -dbtype oracle -dbuser johnsmith -dbpasswd mypasword

Related concepts

Database Cleanup utility

Related tasks

Configure databases for use with the staging utilities

Set the PATH environment variables for WebSphere Commerce utilities

Clean the database

Add a configuration to the Database Cleanup utility

Related reference

Dbclean utility script

Database Cleanup utility objects

Examples: Deleting objects

+

Search Tips   |   Advanced Search