IBM’s DB2 RFE Program
RFE stands for “Request for Enhancement”. IBM has this program for a number of products, but until late 2016, the RFEs for DB2 on LUW were not publicly available to vote on. Now they are, and we’re seeing action on…
Tag Random
In Which Ember Learns Something New About DB2 Transaction Logging, or HP-UX, or Both
There have been a few times in my career when DB2 has blown me away with an ability to stay up when I would have given really good odds that it should be unavailable. It’s been a few years since…
Locking Event Monitors and Compression
UPDATE, 10/21/2015: Please see the comment from IBM at the end stating that despite the information they gave Jim via PMR, this compression does not cause a lack of license compliance even if you are not licensed for compression. Abby…
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…
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…
Why Can’t I Get My Work Done ?!?
I’ve worked for larger companies since I was hired out of college. I’m comfortable there, I know how things roll, and I can work somewhat effectively. However, they all had one thing in common – my workload was dependent on…
Relocating the Instance Home Directory
Sometimes 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…
Journey of a DB2’s Got Talent Winner
I’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…
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…
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…
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…
DB2 Tip: Finding Basic OS Information on DB2 Servers
Usually, there’s an admin (well, lots of them for different clients) I ask when I have basic questions about system configurations, but like all DBAs, sometimes I need to figure it out myself. Enter db2pd -osinfo. The -osinfo option on…