Category: Uncategorized

3

DB2 Errors: SQL0204N name is and undefined name

This is a new format for me – Focusing on a single error message I’ve seen recently and probably frequently. It’s a short entry for this one. I’m not sure of the value of this. I can get most of this from the info center. But I think about when I search on things in other areas and want something...

8

DB2 Commands: db2relocatedb

I’m pretty proficient with a redirected restore. As a first or second year DBA, I remember being afraid of their voodoo, but I even at one point wrote a redirected restore script (on DB2 7 or 8) that would do a redirected restore of a PeopleSoft database with hundreds of containers, changing the paths in a predictable way on a...

10

10 Minute Triage: Assessing Problems Quickly (Part 2)

(For Part 1 of this series, please click 10 Minute Triage: Assessing Problems Quickly, Part 1). One of my favorite commercials is from a motor oil company. The scene begins with a man who is sleeping soundly. His slumber ends abruptly when he is physically grabbed by the collar, shoved on a treadmill  and forced to run in an all...

16

10 Minute Triage: Assessing Problems Quickly (Part 1)

To eliminate any confusion – I am not Ember. Ember is a little shorter, with a big smile, and glasses. I was lucky enough to meet her through a mutual friend at the IDUG 2012 Conference in Denver just a few weeks ago. After enough networking events and sessions, we found we had similar technical backgrounds and began swapping stories....

0

Coming Next Week: A Guest Blogger!

I’ve been thinking about having guest bloggers for a while now. The advantage to me is that I get some help with generating content, which takes hours a week of my time. The advantage to my readers is that you get a different point of view and writing voice. I met Mike two different ways. First, he’s the social media...

0

Parameter Wednesday: DB2 Registry DB2_SKIPDELETED

DB2 Version This Was Written For 9.7 Parameter Name DB2_SKIPDELETED Where This Parameter Lives DB2 Registry (db2set) How To Check Value > db2set -all |grep DB2_SKIPDELETED [i] DB2_SKIPDELETED=YES [DB2_WORKLOAD] OR > db2 “select substr(reg_var_name,1,32) name, substr(reg_var_value,1,16) value, level, is_aggregate, substr(aggregate_name,1,32) aggregate_name from SYSIBMADM.reg_variables where reg_var_name=’DB2_SKIPDELETED’ with ur” NAME VALUE LEVEL IS_AGGREGATE AGGREGATE_NAME ——————————– —————- —– ———— ——————————– DB2_SKIPDELETED YES I...

0

DB2 Commands: db2level

DB2 “commands” are not available via SQL. They are separate commands that when we had a shelf of books instead of the Info Center were available in the “Command Reference”. Many of them are also in ~/sqllib/bin, though there can be other locations. Some are very simple while others are much more complicated. What db2level Does db2level is a command...

0

db2val: Validating your Install

This is a duplicate re-post, trying to deal with facebook link sharing issues. I’m constantly discovering new features. You’d think at this point that I’d know the contents of the /opt/IBM/db2/V9.7/bin directory by heart. Especially since I intentionally went through everything in there when deciding on one of the topics for the db2Night Show’s DB2’s Got Talent competition. But today when...

0

DB2 Version 10

There are certainly more authoritative souces on 10 than me, but having just come from the conference and learned at least enough to get certified, I thought I’d share. They seem to be pushing the big data/data warehousing angle, which I find a bit annoying as a OLTP DBA, because I think there are some good/interesting features for OLTP/e-commerce too....

4

IDUG NA Tech Conference wrap-up

Well, I managed to have my first week since December with no post last week. I was litterally doing something at the conference from 8 AM to 10 PM every day, and trying to fit regular work in the gaps. Ah, but what a conference it was. So much great information, ideas, and new connections. On a personal level, I...