Announcing DISCOVER.DB2

When I was in my early thirties, I was diagnosed with a learning disability. This really put my learning style into perspective. Teaching myself via a book was incredibly hard, and still is in some ways. Where I thrived was with hands on labs and engaging speakers.

Continue reading »

Establishing a DB2 JDBC Connection

Recently I was forced outside my comfort zone and asked to vet various open source BI tools. I was a report developer in a past life, a database administrator supporting datamarts at various employers, and even supported Cognos backend databases. I thought my past experience gave me an edge when it came to evaluating BI tools.

Continue reading »

The Role of a DB2 DBA and of the DB2 Consultant

This blog post was inspired by a DM on Twitter. A follower asked me for ideas on how to best interact with developers and how much expertise to give away. This is a big question with a vast array of correct answers. It is also a subject on which I have a lot of opinions that are wholly mine and do not belong to any employer, past or present.

Continue reading »

IBM’s October Conference – WoW, not World of Warcraft!

I’ll once again be attending IBM’s October Conference in Las Vegas. I can remember when it was focused on DB2, and the year they started calling it Information on Demand (IoD). Then they changed it to Insight, and this year it’s normally called World of Watson (WoW), though I’ve seen some references to it as “Insight at World of Watson”. Maybe I’ll understand what that’s all about after the conference.

Continue reading »

Playing With CLPPLUS

I’ve played with the clpplus at least once before, but have generally thought of it as a tool created to satisfy those coming from Oracle and looking for Oracle-like features. One of the features I actually liked about Oracle in the class and certification tests that I took for it was the ability to specify values for an SQL statement stored in a file on execution. When I lamented the fact that DB2 doesn’t have this feature on twitter, @idbjorh was quick to remind me that such functionality is indeed available using CLPPLUS.

Continue reading »