Hope to see you at the IDUG North American Technical Conference in Phoenix, Arizona – May 12-16!

DB2’s Got Talent 2014 – Search Show #2

I continue to be amazed how much I can learn from 4-minute presentations. I should be used to it by now. There were some excellent presentations this week. I very much enjoyed Prasad’s presenetation. He described the problem he was trying to solve well, covered alternate methods, and obviously researched the topic well, providing some [...]

Using the IBM_DB Ruby gem with DB2

I am currently working on learning Ruby. I have always been a Perl fanatic, but a new build framework that my company is using requires me to use Ruby. Whee, a chance to learn something new! I am a geek. In Perl, I never used the DBI due to the issues that I had with [...]

Ember Crooks: IBM Gold Consultant

I am proud to announce that IBM has named me as an IBM Gold Consultant!! What is a Gold Consultant? IBM's mission statement for the Gold Consultant program: The IBM Gold Consultant Program is for Independent Consultants who deliver superior consulting services to IBM clients, with demonstrated technical leadership, vast industry experience, market knowledge and [...]

Installing a DB2 Component After the Rest of DB2 is Installed

It doesn't happen as often as it used to, but it is still possible that you might miss installing a custom install component when you install DB2 and need to go back and install it later. I recently had to do this with the APPLICATION_DEVELOPMENT_TOOLS feature, and thought I'd share the experience and how to [...]

DB2′s Got Talent 2014 Kick-Off

Friday was the first search episode of DB2's Got Talent on the DB2Night show. I was thrilled to have an opportunity to step in as a guest judge for Klaas, who was traveling and unable to participate. It was really neat to be on the other side of the competition. I very much enjoyed the [...]

Detailed Analysis of Individual Performance Metrics

Sometimes the things we studied in college are actually useful. As much as I hated my statistics professor, I still learned a lot that I frequently use. Maybe I don't do many multiple regression problems these days, but I use standard deviation a lot. It is a concept that every DBA or really any IT [...]

The Danger of FETCH FIRST ROW ONLY

There are a a vast array of things you can do in SQL. But just because you can doesn't always mean that you should. I recently ran into an interesting situation with FETCH FIRST ROW ONLY. The day after new code was deployed, a production database system that usually runs with 40% CPU utilization or [...]

Activities vs. Requests

This started as a conversation with a couple of DBA friends when we were playing with MONREPORT.DBSUMMARY. That's a pretty nifty way to get a quick look at a number of performance parameters, AND to limit the time period covered by the report. But the thing we noticed and were talking about is the difference [...]

Automatic Storage Tablespaces (AST): Compare and Contrast to DMS

I am late to the party on Automatic Storage. Yes, it has been out for a while, but I have not used it in depth. Coming from a complex data warehouse environment, only vendors and tools used automatic storage. It was quick, easy to set up, and required minimum DBA involvement. Being a container snob [...]

DB2′s Got Talent 2014

One of the highlights of 2013 for me was winning third place in the DB2's Got Talent competition. If you're a long time reader, you may remember me begging for votes the last two years in March. But this contest is for those who are newer to presenting about DB2 topics in the larger DB2 [...]