Administer >


Database Cleanup utility

The Database Cleanup utility allows you to delete objects from the database. IBM recommends to run the database cleanup periodically, especially if you have changed a lot of information in the database and have unused tables or rows. 

When the Database Cleanup utility deletes an object, the records in the object's tables are deleted to preserve the referential integrity of the database. The Database Cleanup utility deletes records in child tables based on the delete rule of the referential integrity definition in the database schema. Your DBA can set the delete rule to..

If you add new tables, ensure that the referential integrity and delete rule is properly defined. Otherwise, the Database Cleanup utility cannot work with the new tables.

If you are migrating from an existing version of WebSphere Commerce, you can run the Database Cleanup utility after the migration. Remember to evaluate the types of data on the system and how they affect database maintenance; typically, user and order data can be quite large, resulting in large database tables. When you clean the database, this will be time consuming since it can fill up the database transaction log files or potentially lock database tables when the store is running.

If you are running the Database Cleanup utility on a staging server it should only be run on the staglog object. The production-ready database is different from the production database.

The production-ready database only has configuration data without the operation data. Deleting configuration data might cause a cascade delete on the operation data. When the Stage Propagate utility propagates the deletion to the production database, this might cause a cascade delete to the operation data (which to keep).

To clean configuration data, run the Database Cleanup utility on the production database.

Depending on the amount of cleanup required for the database, you should  consider running the DB2 REORGCHK utility prior to running the DBClean to improve performance during the cleanup.

For better performance, ensure that the Database Cleanup is done on the USRTRAFFIC table, accordingly for MEMBER and ADDRESS tables on the WebSphere Commerce database.

To monitor the Database Cleanup utility, refer to the following files:


See also


Related tasks

Configure databases for use with the staging utilities
Clean the database
Delete Sales Assistant statistic objects
Delete staged objects
Delete store objects
Delete user objects
Delete user traffic log objects
Delete vendor objects
Delete address objects
Delete available to promise inventory objects
Delete attachment objects
Delete auction objects
Delete auction log objects
Delete autobid log objects
Delete base item objects
Delete bid log objects
Delete cacheivl objects
Delete calculation code objects
Delete campaign objects
Delete campaign statistic objects
Delete catalog entry objects
Delete catalog group objects
Delete coupon objects
Delete expected inventory record objects
Delete details about expected inventory record objects
Delete forum message objects
Delete fulfillment center objects
Delete inventory code adjustment objects
Delete inventory adjustment objects
Delete specified item information objects
Delete member message relationship objects
Delete message objects
Delete order objects
Delete organization objects
Delete Product Advisor statistic objects
Delete Product Comparison statistic objects
Delete Product Explorer statistic objects
Delete policy objects
Delete product set objects
Delete returned item objects
Delete return reason objects
Delete account objects
Delete calculation rule objects
Delete distributor objects
Delete file upload objects


+

Search Tips   |   Advanced Search