DBA Ignorance , complacency and arrogance experiment

11 June,2012 by Jack Vamvas

I’m reading “Savages” by Don Winslow – it’s a stripped down thriller about drug cartels. How does this relate to DBAs?

 There’s a passage where the main characters , Chon and Ben – apply some self criticism.

 There system is :




 Two  will get you three.

 An interesting idea , applied in the right context , can yield some insight into the inner workings of the IT professionals mind.

 I applied this system to reviewing some High Priority problems as an experiment.

 Which of these (either one or combination) characteristics existed that may have contributed to either : a) create the situation or b) delay the resolution  . ?

In the last week , here are the top five reasons based  on this analysis. Of course , Database Server problems can be complex – sometimes out of the control of the DBA. Database Servers are part of a large IT ecosystem.

 1) Couldn’t restore the backup from last night , as the Operations team hadn’t rerun the a failed backup  

2) Disk drive filled – on the data drive

3) A developer logged on to a Production system and dropped a table.

4) The Backup &  Restore software couldn’t restore a database with multiple files , due to a bug . Operations were aware of the bug and had been very slow in applying the fix pack

5)REORG job still running at start of business time – killing performance



Author: Jack Vamvas(http://www.dba-db2.com)


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on DBA Ignorance , complacency and arrogance experiment

Comments are moderated, and will not appear until the author has approved them.

dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright