Deleting marketing activity statistics

You can delete statistics that are associated with Management Center marketing activities (Web, Dialog, and Email activities) that are deleted.

Procedure

  1. From the WC_installdir/bin directory, run the following script:
    • DB2
      • For IBM i OS operating systemAIXLinux   ./dbclean.sh -object marketing_activity -type markedfordelete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -db dbname -dbuser user -loglevel loglevel
      • Windowsdbclean -object marketing_activity -type markedfordelete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -db dbname -loglevel loglevel
    • Oracle
      • AIX ./dbclean.sh -object marketing_activity -type markedfordelete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -db dbname -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password
      • Windows dbclean -object marketing_activity -type markedfordelete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -db dbname -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password
  2. Examine the WC_installdir/instances/instance_name/logs/DBClean/DBClean.timestamp.log file.