Tag Random

DB2 Naming Standards

Last week, I read this article by Craig Mullins: Go read it, this blog entry will still be here when you get back. I have to say that in large part, I agree. I don’t like having differing naming…

Rest In Peace, Adam Schneider

When you go to conferences, you tend to develop a group of friends that you hang out with and compare notes with and spend your evenings chatting with. As a blogger, I also spend time and energy trying to help…

The DBA Ethos

I am a DBA. No matter what title my company gives me, my primary job is designing, engineering, and supporting DB2 databases. DBAs sometimes have a bad reputation. I was a bit surprised the first time my engineering colleagues told…

Quick Tip: db2look and Triggers

Just a quick tip today. I’ve been dealing quite a lot with triggers lately, and found the -td option on db2look very useful. I hadn’t had cause to use it before, but it has now become part of my default…

Twitter Debates

Twitter debates. I’ve never been in one, nor have I actually heard of them until yesterday. But when @DB2Geek hosted a debate on Tuesday, I decided to pop on and see what it was all about. (Search for hashtag #db2debate).…

A New Version of DB2 Announced!

IBM announced on April 3rd a new version of DB2. I tend to be stuck a few versions back due to what WebSphere Commerce certifies with, but I’m constantly learning about and drooling over new versions. I think many DBAs…

The Basics of Code Pages in DB2

You’ve got your database code page set as UTF-8, what more do you need to know, right? DB2 automatically handles all that conversion stuff for you, right? I’ve been dealing with significant amounts of data using UTF-8 characters that differ…