Administer > Database Cleanup utility > Clean the database
Delete message objects
Procedure
- From the WC_INSTALL/bin directory, run the following script:
- ./dbclean.sh -object message -type obsolete -instancexml WC_INSTALL/instances/instance/xml/ instance.xml -db dbname -dbuser user -days daysold -loglevel loglevel
- dbclean -object message -type obsolete -instancexml WC_INSTALL/instances/instance/xml/ instance.xml -db dbname -days daysold -loglevel loglevel
- . dbclean.sh -object message -type obsolete -db dbname -days daysold -loglevel loglevel -dbtype oracle -instancexml WC_INSTALL/instances/instance/xml/ instance.xml -dbuser user -dbpasswd password
- dbclean -object message -type obsolete -db dbname -days daysold -loglevel loglevel -dbtype oracle -instancexml WC_INSTALL/instances/instance/xml/ instance.xml -dbuser user -dbpasswd password
Use host:port:sid for the database name. For example, myhost:1521:mydb.
Note: For details on the syntax and parameters for the dbclean script, see Database Cleanup utility script.
- Examine the WC_INSTALL/instances/instance/logs/DBClean/DBClean. timestamp.log file.
Related concepts
Related reference
Database Cleanup utility objects