Deleting marketing experiment data

You can delete obsolete data that is associated with Management Center marketing experiments. This data is deleted by a marketing scheduled job, but you can run this script to ensure any remaining unnecessary records are deleted. A typical value for -days is 2.

Procedure

  1. From the WC_installdir/bin directory, run the following script:
    • DB2
      • LinuxAIXFor IBM i OS operating system ./dbclean.sh -object marketing_log -type obsolete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml db dbname -dbuser user -days daysold -loglevel loglevel
      • Windows dbclean -object marketing_log -type obsolete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -db dbname -days daysold -loglevel loglevel
    • Oracle
      • AIX./dbclean.sh -object marketing_log -type obsolete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -db dbname -days daysold -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password
      • Windows dbclean -object marketing_log -type obsolete -instancexml WC_installdir/instances/instance_name/xml/instance_name.xml -db dbname -days daysold -loglevel loglevel -dbtype oracle -dbuser user -dbpasswd password

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

  2. Examine the WC_installdir/instances/instance_name/logs/DBClean/DBClean.timestamp.log file.