Deleting organization objects

You can use the Database Cleanup utility to delete organization objects when the objects are no longer required.

Procedure

  1. From the WC_installdir/bin directory, run the following script:
    • DB2
      • For IBM i OS operating systemAIXLinux ./dbclean.sh -object organization -type specified -db dbname -dbuser user -loglevel loglevell -name organizationid -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml
      • Windowsdbclean -object organization -type specified -db dbname -loglevel loglevell -name organizationid -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml
    • Oracle
      • AIX./dbclean.sh -object organization -type specified -db dbname -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password -name organizationid -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml
      • Windowsdbclean -object organization -type specified -db dbname -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password -name organizationid -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml

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

    Notes:
    • For the -type parameter, you can specify organization to indicate any organization record.
  2. Examine the WC_installdir/instances/instance_name/logs/DBClean/DBClean.timestamp.log file.