Calculating PVUs for IBM DB2 on Linux

DBAs do not have to calculate PVUs(Processor Value Units) often. Many times there is a system administrator or someone else who might do this for us. Or if you’re buying everything from IBM, then they’re likely to calculate it. You may also easily be able to get the information you need from your hardware vendor and skip right to the last section on converting the hardware details into PVUs.… Read the rest

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.… Read the rest

Continue reading »

Relocating the Instance Home Directory

Krafick_HeadshotSometimes 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 to another.… Read the rest

Continue reading »

Journey of a DB2’s Got Talent Winner

Krafick_HeadshotI’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 I have developed with Ember and what seemed to be a harmless conversation in January of this year.… Read the rest

Continue reading »

DB2 Basics: Quotation Marks

This blog entry may be a little on the basic side, but some of my most basic entries are some of my most popular ones.

DB2 has a number of special characters, for which there are rules of use. Both the single quotation mark and the double quotation marks are special characters.… Read the rest

Continue reading »

A Tale of Two Connections


It was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness, it was the epoch of belief, it was the epoch of incredulity, it was the season of Light, it was the season of Darkness, it was the spring of hope, it was the winter of despair, we had everything before us, we had nothing before us, we were all going direct to Heaven, we were all going direct the other way–in short, the period was so far like the present period, that some of its noisiest authorities insisted on its being received, for good or for evil, in the superlative degree of comparison only.

Read the rest Continue reading »

A New Guest Blogger is Coming!

I’ve asked another IBM Champion for Information Management – Ian Bjorhovde – to write a guest blog entry on IOD (IBM’s Information On Demand conference for 2013). The conference is in Las Vegas at the beginning of November. This is the first year I am attending IOD, and I am used to the smaller atmosphere of IDUG.… Read the rest

Continue reading »