Category: Random

Jim 5

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. But sometimes you need that fourth ingredient:...

Screenshot_072215_080015_PM 6

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...

sqlplus 1

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...

4

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. Everything was reactionary, even our planned work. That automation script...

4

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. The DB2 Knowledge Center lists what DB2 considers...

5

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,...

0

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. Just figuring out...