Deleting obsolete user behavior data collected for marketing activities

You can delete user behavior data that has not changed for a specified number of days. If you have Web or Dialog activities that use this data, do not run this script. The script can potentially delete data that is associated with active activities. In most cases, run the script to delete data for customers who are inactive. For example, to delete data for customers who have not been to the site for a year, set the -days value to 365.

Procedure

  1. From the WC_installdir/bin directory, run the following script:
    • DB2
      • For IBM i OS operating systemAIXLinux ./dbclean.sh -object marketing_userbehavior -type obsolete -instancexml WC_installdir/instances/instance_name/xml/ instance_name.xml db dbname -dbuser user -days daysold -loglevel loglevel
      • Windows dbclean -object marketing_userbehavior -type obsolete -instancexml WC_installdir/instances/instance_name/xml/ instance_name.xml -db dbname -days daysold -loglevel loglevel
    • Oracle
      • AIX./dbclean.sh -object marketing_userbehavior -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_userbehavior -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.