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.

• •   ./dbclean.sh -object objectname -type objecttype -instancexml instancename -db dbname -commit commitrows -max maxrows -check_object_only yes

  • dbclean -object objectname -type objecttype -instancexml instancename -db dbname -commit commitrows -max maxrows -check_object_only yes

• • ./dbclean.sh -object objectname -type objecttype -instancexml instancename -db host:port:sid -commit commitrows -max maxrows -check_object_only yes -dbtype oracle -dbuser dbuser -dbpasswd dbpassword

  • dbclean -object objectname -type objecttype -instancexml instancename -db host:port:sid -commit commitrows -max maxrows -check_object_only yes -dbtype oracle -dbuser dbuser -dbpasswd dbpassword

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

• • ./dbclean.sh -object user -type registered -instancexml WebSphere/WebSphereCommerce/instances/demo/xml/demo.xml -db CD040302 -commit 500 -max 8000 -check_object_only yes

  • dbclean -object user -type registered -instancexml C:\WebSphere\WebSphereCommerce\instances\demo\xml\demo.xml -db CD040302 -check_object_only yes

• • ./dbclean.sh -object user -type registered -instancexml WebSphere/WebSphereCommerce/instances/demo/xml/demo.xml db host:port:sid -commit 500 -max 8000 -check_object_only yes -dbtype oracle -dbuser johnsmith -dbpasswd mypasword

  • dbclean -object objectname -type registered -instancexml C:\WebSphere\WebSphereCommerce\instances\demo\xml\demo.xml -db host:port:sid -commit 500 -max 8000 s-check_object_only yes -dbtype oracle -dbuser johnsmith -dbpasswd mypasword

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