Category: Data Pruning/DBClean

7

Why won’t you just die?! (Cleaning DB2 Process in Memory)

It happens. We joke that it doesn’t. Make sure not tell our Oracle or SQL Server counterparts but occasionally DB2 becomes … How do I put this eloquently? Hosed. Snarled. Non-functional. Zombied (think the “Walking Dead” TV show). Dorked. Sometimes there is a memory leak, instance level crash, trap, or OS issue. DB2 just goes into a bad state and...

0

Running DBClean the First Time

This post is specific to WebSphere Commerce. If you’re supporting WebSphere Commerce and you don’t know what dbclean is, get yourself a cup of coffee and start researching. This post does not cover why to run dbclean or what parameters to use with dbclean – search my blog for more posts on that using the search box at the upper...

0

New Builds – Do You Have a Checklist?

In case anyone is wondering why I’m currently just barely managing one post a week, the first and most obvious reason is preparation for Black Friday/Cyber Monday. Retail clients really stress their databases on these days, and a bit of proactive work can go a long way. The other reason is because somehow someone thought it would be a good...

6

Data Pruning – Do You Have a Strategy in Place?

One of my items to check before go-live is to see that data pruning is in place. Yes, before a website my company supports even goes live, I have at least made the attempt to start pruning the data that hasn’t been collected yet.  I saw this video today: http://smarterquestions.org/2012/02/video-marc-hebert-of-estuate-on-cleaning-data-cholesterol-from-the-enterprise/, and thought I’d write a short post inspired by it. Go check it...

2

Mass Cleanup of Guest Users

By special request, I’m going to share some details on how to do a one-time offline clean up of guest users. PLEASE NOTE: Following are suggestions only – it is critical to thoroughly test this before doing  this in production. This is one of the most tested and still most failed changes I do. First off, check out the entry on...

2

DBClean – Stale Guest Orders

This is part of a series focusing on the details of each item that needs to be pruned in a Commerce database. Stale Guest Orders What is it? Also known as abandoned shopping carts, these will just pile up if you don’t prune them. In addition, Guest users will not be deleted if they have any orders, including shopping carts,...

1

DBClean Performance

This is a really complicated topic, largely because dbclean is such a varied tool, and because the data distribution in Commerce databases varries heavily based on how you use it. If you haven’t already, check out my blog entry on dbclean basics. Also, if you’re having performance issues on a specific cleaning area, search my blog for a post on...