Tag Random

DB2 Commands: db2relocatedb

I’m pretty proficient with a redirected restore. As a first or second year DBA, I remember being afraid of their voodoo, but I even at one point wrote a redirected restore script (on DB2 7 or 8) that would do…

Coming Next Week: A Guest Blogger!

I’ve been thinking about having guest bloggers for a while now. The advantage to me is that I get some help with generating content, which takes hours a week of my time. The advantage to my readers is that you…

Why DB2 Certification is Cool

You may have noticed that I’m down to one new post a week at this point. I have two big excuses. The first is that I had a big go-live last week that required the movement of user data from…

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…