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

DB2′s Got Talent 2014 – Search Show #3

The entertainment and education of DB2's Got Talent on the DB2Night Show continues. I recommend watching the download here: http://www.dbisoftware.com/blog/db2nightshow.php?id=4869 Also on that page is an extra discount code for the IDUG North American Technical conference in Phoenix in May - it's even better than the early enrollment discount, so if you are going, check [...]

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 [...]


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 [...]