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.
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.
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.
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.
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. Everything was reactionary, even our planned work. That automation script I wanted to write will have to wait. Performance tuning or capacity analysis …. I don’t have time. I know this SQL doesn’t do everything you want Mr. Client, but it will have to be close enough because a competing team needs me.
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’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.
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.
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. Just figuring out what makes up IOD is a bit intimidating. Ian has been to IOD a number of times, and has a lot of good tips and tricks. Keep an eye out for Ian’s guest blog next week – on October 15th. You won’t be disappointed!
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.