Relocating the Instance Home Directory

Sometimes you just have to think out of the box. Sometimes there isn’t an answer on google. Sometimes you have to bend the laws of physics to get the answer. Sometimes you get lucky. I had a problem, I desperately needed to relocate where my instance was physically installed and move it from one filesystem [...]

Upcoming Sessions at IDUG 2014 – Phoenix, Arizona

Are you ready yet? Have you started to throttle your work for the week, arrange a backup, even packed a bag? The 2014 IDUG Technical Conference is only a week away. Ember did a fantastic job on her IDUG write-up, so I am not going to duplicate her effort. However, I do want to relay [...]

DB2 Basics: What is a Reorg?

This is the first in a series of blog entries on reorgs. I was talking with a friend recently, and he pointed out that I only have a few articles on reorgs, and they're very specific to complicated parts of reorg. I have scripted my own reorgs and made a point of educating myself on [...]

IDUG NA Technical Conference in Phoenix – May 2014

I'm so excited! The IDUG North American Technical Conference is less than a month away. Much like Melanie Stopfer mentioned in her blog entry on IDUG, this is one of MY favorite weeks of the year. There's something about the IDUG conference. I have been to IBM's DB2-related conference (which they're now calling IBM Insight), [...]

Ember on DB2Night Show on April 18th!

Thanks to a late cancellation on the DB2Night Show, I'll be presenting on Friday, April 18. I'll be talking about why low-cardinality indexes negatively impact performance. It is the same topic as my developerWorks article, but I think it comes across better in a presentation format. It's a really detailed topic, and I really enjoy [...]

DB2 Basics: Capitalization

When does case matter in DB2? Well, it doesn't unless it does. Nice and clear, huh? Text must be in the correct case whenever it is part of a literal string. Things that you have to enclose in single quotes are case sensative. select * from table where col1='text' is different from select * from [...]

Journey of a DB2′s Got Talent Winner

I've been encouraged by a few to tell my story. How I was encouraged into DB2's Got Talent 2014, what it was like, decisions I made on the fly, any advice, and what I learned from my experience. To tell you how I won, I have to go back and tell you of the friendship [...]

Last Chance to Vote in DB2′s Got Talent!

Have you enjoyed posts from this blog? Have they helped you? Now is your chance to pay it forward. Go vote in DB2's Got Talent and help YOUR favorite competitor win. I'm voting for Michael (a guest blogger here at db2commerce.com), but go watch the last show to see how really outstanding all of your [...]

IBM DB2 Certification – A Comprehensive Guide as of Today

Edited on 6/25/2014 to reflect the formerly missing tutorials on the IBM sites Nearly every DB2 conference I go to has me thinking about DB2 certification. That is probably because most conferences include free or reduced cost certification testing. I have covered this topic before, so feel free to check out the blog entries on [...]