Delete organization objects

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

   • (DB2)

       ./dbclean.sh -object organization -type specified -db dbname -dbuser user -loglevel loglevell -name organizationid -instancexml WC_installdir/instances/instance/xml/ instance.xml

     • Windows: dbclean -object organization -type specified -db dbname -loglevel loglevell -name organizationid -instancexml WC_installdir/instances/instance/xml/ instance.xml

   • (Oracle)

     ./dbclean.sh -object organization -type specified -db dbname -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password -name organizationid -instancexml WC_installdir/instances/instance/xml/ instance.xml

     • Windows: dbclean -object organization -type specified -db dbname -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password -name organizationid -instancexml WC_installdir/instances/instance/xml/ instance.xml

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

   Notes:

   1. For the -type parameter, you can specify organization to indicate any organization record.

   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