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
-
From the WC_installdir/bin
directory, run the following script:
-
- ./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
- dbclean -object marketing_userbehavior -type obsolete -instancexml WC_installdir/instances/instance_name/xml/ instance_name.xml -db dbname -days daysold -loglevel loglevel
-
- ./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
- 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
.
-
- Examine the WC_installdir/instances/instance_name/logs/DBClean/DBClean.timestamp.log file.