Category: Performance


Locks – Timeout vs. Deadlock

So questions in this area most often come from DBAs from other RDBMS’s or from developers. I’ll probably write other posts on locks, but here are the basics on deadlocks vs. timeouts. Why we get them confused at all Ah the wisdom that went into grouping these under a single error code with different return/reason codes. For whatever reason, both...


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...


The Least you can do for DB2 Performance

I suspect there are some sites out there where a “set-it-and-forget-it” approach is taken for DB2 related performance. Many clients we go into don’t even realize the need for having a DBA. Depending on site size, that may work for a while. I take an active and proactive role in performance for any client I can. There are some nifty...