DB2 Basics: Storage Groups

A storage group is a layer of abstraction between the data in your database and disk. It is only used with Automatic Storage Tablespaces (AST). It allows us to group tablespaces together to live in similar places. Storage groups were first introduced in a roundabout way with automatic storage databases in DB2 8.2. These databases [...]

Quick Tip: Simple Errors on Database Connection

There are a couple of errors that you can get on database connection that simply mean you typed something wrong, but I figure there are people who will search on these errors, so I thought I would share. If you do not already have a database connection, you can get: db2 conenct to SAMPLE DB21034E [...]

STMM Analysis Tool

I mostly like and use DB2's Self Tuning Memory Memory Manager (STMM) for my OLTP databases where I have only one DB2 Instance/Database on a database server. I do have some areas that I do not let it set for me. I've recently learned about an analysis tool - Adam Storm did a presentation that [...]

Three Different Ways to Write the Same Join in SQL

This was really a revelation for me when I took DanL's SQL workshop before the IDUG conference in Phoenix. I started out as a physical or systems DBA at IBM, and until studying for certification, I hardly wrote a statement more complicated than select * from syscat.bufferpools. After being a DBA for probably 5 years [...]

Scrambled Output from db2top

I don't know about you, but I'm pretty addicted to db2top. I started using it way back when it was a download from Alphaworks. It is simply unparalleled for free real-time monitoring for DB2. No, it's not full enough of a feature set to be your only monitoring tool, but I can barely troubleshoot a [...]

An Unfortunate Series of TSAMP Events

A story of fail and recover. Sometimes, I think that I subconsciously knew that something was wrong. I woke up before 5 AM and couldn't get back to sleep for no real reason that I could figure out. I gave up on sleep around 5:15 and went to take a shower. On the way to [...]

Happy Fourth Blogiversary to db2commerce.com!

It has been four years since I started this blog, and two and a half years since I committed to blogging very regularly. Wow, what a ride it has been. Blogging has skyrocketed my career. I'm now not just an IBM Champion, but also an IBM Gold Consultant. I have spoken at two conferences, written [...]

How to Tell When an Index Reorg is Needed

My earlier post on table reorgs covered Reorg's place in a database maintenance cycle and running reorgchk. If you haven't already read it, check it out: How to Tell When a Table Reorg is Needed After the section on tables, REORGCHK output has a section with details on each index for each table that REORGCHK [...]

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

Informational Constraints – Benefits and Drawbacks

One of the most frustrating things a DBA can experience is troubleshooting due to bad data. The client is upset because rows are missing or incorrect data is returned.  The client facing web front end could be displaying gobilty-gook because the data retrieved makes no sense. Resources and energy are burned because of an issue [...]