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 them.… Read the restContinue reading »
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 the last time that happened, and this was an interesting lesson in transaction logging.… Read the restContinue reading »
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 Rosmarin said, “Hard work, determination and talent are key for any successful venture.… Read the restContinue reading »
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 restContinue 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 restContinue reading »
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 whoever screamed the loudest or the fire of the day.… Read the restContinue reading »
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 needed to relocate where my instance was physically installed and move it from one filesystem to another.… Read the restContinue reading »
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 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 restContinue 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 restContinue reading »
A Tale of Two Connections
… Read the rest Continue reading »
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.
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 restContinue reading »
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 db2pd can give you some of the basic information on OS configuration without having to know or google OS level commands to find it.… Read the restContinue reading »