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

How to Tell When a Table Reorg is Needed

Reorgs are one critical piece of both performance maintenance and maintaining how much disk space is used. In my first blog entry in this series, DB2 Basics: What is a Reorg, I talked about some purposes of reorgs. In this entry, I'm going to talk about how to determine what kind of reorg is needed [...]

IDUG 2014 North American Technical Conference

Wow, overall, the conference ran so smoothly this year. I saw very few issues. The sessions were well clustered by track and all located in a small area. It was nearly always clear where to go and what was going on. My hat is off to the IDUG Conference Planning Committee - I cannot imagine [...]

What does a Commit mean in DB2?

Database management systems have the concept of a commit. This concept has to do with grouping sets of actions together such that they all succeed or fail as a group. This represents the A in the famous ACID properties of a transaction system. The A stands for Atomicity - meaning that a transaction may consist [...]

Relocating the Instance Home Directory

Sometimes you just have to think out of the box. Sometimes there isn’t an answer on google. Sometimes you have to bend the laws of physics to get the answer. Sometimes you get lucky. I had a problem, I desperately needed to relocate where my instance was physically installed and move it from one filesystem [...]