DBClean – Junk OrderItems

You may also like...

8 Responses

  1. Mikael Hase says:


    Wouldn’t dbclean with object order and type markfordelete accomplish this? The SQL statement is
    delete from orderitems where orders_id in (select orders_id from orders where type=’BIN’ and status=’J’)

    Running “select (1) from orderitems where orders_id in (select orders_id from orders where type=’BIN’ and status=’J’)” yields the same result on my system as your count(*) statement.



  2. Ankur says:

    I am thinking on scheduling the dbclean script on my ecommerce setup. Currently I have accomplished this using the Crontab and shell script but is there any way to schedule it using the scheduler in WebSphere.

  3. rak says:


    Are you aware of a default list of WCS v7 tables that are included in the dbclean.sh utility? I read its not included in the dev toolkit, but surely someone must have it online?

    I cant find it anywhere.

    PS: Great info you have here on your site!

    • Ember Crooks says:

      You have to invoke dbclean to specify the objects you want to delete. There is no default list of things that are cleaned for you. There are default delete statements for dozens of different areas that you can run dbclean for in the CLEANCONF table in your Commerce database. Many consultants have a list of default cleaning areas that they suggest starting with, and others simply depend on how the Commerce database is being used.

  1. April 7, 2011

    […] Pruning junk ORDERITEMS is also one of the more critical data pruning areas. […]

  2. September 15, 2011

    […] Junk Orderitems (see DBCLEAN – Junk Orderitems) […]

Leave a Reply

Your email address will not be published. Required fields are marked *