Category: Random

Screenshot_072215_080015_PM 0

Calculating PVUs for IBM DB2 on Linux

DBAs do not have to calculate PVUs 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...

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

2

DB2 Naming Standards

Last week, I read this article by Craig Mullins: http://www.sswug.org/articlesection/default.aspx?TargetID=70585. Go read it, this blog entry will still be here when you get back. I have to say that in large part, I agree. I don’t like having differing naming standards for tables and views. And certainly not for aliases. I do like to have a naming standard for constraints...