Category: Maintenance

7

Why won’t you just die?! (Cleaning DB2 Process in Memory)

It happens. We joke that it doesn’t. Make sure not tell our Oracle or SQL Server counterparts but occasionally DB2 becomes … How do I put this eloquently? Hosed. Snarled. Non-functional. Zombied (think the “Walking Dead” TV show). Dorked. Sometimes there is a memory leak, instance level crash, trap, or OS issue. DB2 just goes into a bad state and...

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

14

Runstats – What and Why

On looking over my previous posts, I found no fewer than 25 of them that mentioned runstats. But I wanted to cover runstats in a different level of detail. With this post, I aim to answer 2 questions – What is runstats? and Why should you run runstats? What Runstats is a utility. That’s why we say “run runstats”. You...