Category: Newbie

1

The DBA Ethos

I am a DBA. No matter what title my company gives me, my primary job is designing, engineering, and supporting DB2 databases. DBAs sometimes have a bad reputation. I was a bit surprised the first time my engineering colleagues told me how lucky we were to have such great involved DBAs. Don’t get me wrong – I know I am...

0

Tips for Using the IBM DB2 Information Center Part 2: Information Structure – System Monitor and Syntax

My goal with this series is to provide some tips and tricks you might not be aware of for finding information in the IBM DB2 Information Center. Check out Part 1 in this series: Tips for Using the IBM DB2 Information Center Part 1: Navigating As I mentioned in Part 1, I started working with IBM DB2 documentation just before...

8

Tips for Using the IBM DB2 Information Center Part 1: Navigating

Note: this post refers to an obsolete version of the IBM DB2 Knowledge center, and therefore many of the links are broken. For details on the current version, see The New IBM DB2 Knowledge Center The IBM DB2 Information Center is a wonderful resource if you know what you’re looking for. Unfortunately, sometimes you do not know exactly what you...

0

Twitter Debates

Twitter debates. I’ve never been in one, nor have I actually heard of them until yesterday. But when @DB2Geek hosted a debate on Tuesday, I decided to pop on and see what it was all about. (Search for hashtag #db2debate). It was fascinating. Did automation steal the role of DBA or minimize it? Will our role never die because of...

0

Domesticating your Blob.

DBA’s have egos. We like to say “Look what I created,” “Check out this huge database I fixed,” or “I McGyver-ed a solution at 3am in a War-Room hyped up on my 8th cup of coffee.” Then the bragging really begins. “I fixed a 1.2 T Data Warehouse!” Which receives a quick response of “Oh yeah? Well my OLTP database...

1

DB2 Basics: Triggers

As with the other entries in my DB2 Basics series, this entry does not cover everything about triggers. Instead, I’m covering the basics and a few important points. DB2 triggers are sometimes over-used and over-complicated. Basically, triggers are actions(SQL) that take place when a triggering action occurs. Triggering Actions For DB2, the valid triggering actions are on a table basis....

6

DB2 Basics: Users, Authentication, and Authorization

This is clearly a broad topic, and this post is intended to serve as an introduction. Authentication The first step in accessing a db2 database is Authentication. Authentication is what tells DB2 that you are who you say you are. Simply put, DB2 does not do authentication. It relies on some other facility to perform authentication. Traditional Authentication Traditionally, DB2...

7

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