Category: Uncategorized

1

Come Listen to Me on the DB2Night Show on Friday!

I’ve got a spot coming up on the DB2Night Show – a popular db2 webcast. My topic is: “Do what I mean, not what I say! Back-Out Strategies for DB2 Database Changes”. Come and listen!   It’s scheduled for 10 AM Central Time on Friday, December 14th. Sign up using the link on the DB2 Night Show’s page: http://www.dbisoftware.com/db2nightshow/ You...

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