Administer > Database Cleanup utility


Examples: Deleting objects

The following are examples of deleting user objects from the database tables using optional parameters from the Database Cleanup utility.

Here is the same example, with sample values (instead of variables):

If you are deleting a store, close the store first, before deleting it.  The markfordelete flag is not supported.  You must use the status flag (open/closed/suspended) first, and then use the markfordelete flag. It is the status flag that determines store access.  


Related concepts

Database Cleanup utility


Related tasks

Configure databases for use with the staging utilities

Set the PATH environment variables for WebSphere Commerce utilities

Clean the database

Add a configuration to the Database Cleanup utility

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

Related reference

Dbclean utility script

Database Cleanup utility objects


+

Search Tips   |   Advanced Search