Adding Custom Staging Triggers

This post is focused on WebSphere Commerce, but may have some tidbits for those new to triggers too. Starting Point In WebSphere Commerce, it is not unusual for you to have to add custom staging triggers. It’s not that difficult,…

VARCHAR: Friend or Foe

I read an article from Craig Mullins on “Working with variable data“. The rest of this post is going to assume you’ve read it, so click through and then come back. I’ve seen performance issues caused by VARCHAR before, and…

Parameter Wednesday: DBM CFG – INTRA_PARALLEL

DB2 Version This Was Written For 9.7 Parameter Name INTRA_PARALLEL Where This Parameter Lives Database Manager Configuration How To Check Value $ db2 get dbm cfg |grep INTRA_PARALLEL Enable intra-partition parallelism (INTRA_PARALLEL) = NO OR $ db2 "select name, substr(value,1,16)…

Parameter Wednsday – DBM CFG: DIAGLEVEL

Continuing my trend of attacking some of the simpler parameters first, I’m going to cover DIAGLEVEL this week. DB2 Version This Was Written For 9.7 Parameter Name DIAGLEVEL Where This Parameter Lives Database Manager Configuration How To Check Value >…

What DBAs can do to Reduce Deadlocks

Deadlocking is an application problem. There are only a few things that DBAs can do to reduce deadlocking, and they all require buy-in from the application. Let me repeat that another way. Don’t set the parameters mentioned here without understanding…