Category: Newbie

9

DB2 Basics: What is an Index?

Don’t call them indices in the United States – most American DBAs agree that they are ‘indexes’, though either plural form is grammatically acceptable in American English. Indexes are arguably one of the most important aspects of database design. They’re also something that we can pretty easily change and add to over time. Even overly restrictive vendors tend to allow...

11

DB2 Basics: What is an Instance?

I was reviewing my many hundreds of slides that I use when training DBAs, and realized that some of my “Basics” slides might lead to good blog topics. My single most popular blog post ever is “How to Catalog a Database”, which is part of my “Basics” series of slides. While directed at Newbies, I bet any of my more...

3

DB2’s Got Talent – 2013!

This year, I’ll be competing in DB2’s Got Talent again. In 2012, I was voted off the island somewhere between 7th and 10th place. I was really crushed, and hesitated to join the competition again this year until a friend put it in perspective for me. He said: If your son was a freshman in high school and missed the...

3

Technical Conference – It’s a skill builder, not a trip to Vegas.

What is the first thing you think of when someone says “technical conference”? Those who have attended a few technical conferences think of hours of session material, hands on labs, networking events, and coveted swag from the vendor Expo. Those who have not attended a conference may not know what to expect. Managers, who may have been out of the...

2

Getting the Most out of DB2 Support

This post is inspired by an email from a reader. Let me first say that every software support team everywhere is complained about by someone. I’ve dealt with Oracle support, so I appreciate DB2 support all the more. For those of us who work with DB2 every day and have for 5 or 10 years or more, we really do...

3

Installing DB2 Using a Response File

Some friends on Twitter were commenting that db2_install is not just deprecated in DB2 10, but is fully discontinued and not available. Melanie Stopfer mentioned this on her webcast on June 22. I do dozens of installs a year, and most of them are using a response file. The same response file, actually, since a standard starting point makes sense at...

0

Why DB2 Certification is Cool

You may have noticed that I’m down to one new post a week at this point. I have two big excuses. The first is that I had a big go-live last week that required the movement of user data from one WebSphere Commerce database to another on a more recent version of Commerce, a more recent version of DB2(8.2 to...