Saturday, March 21, 2009

Murphy's Law


I had a bad day yesterday, things just ain't doing right. Users encountered slowness accessing two of the web systems maintained by our team. One was hosted on Mainframe, the other on Unix and Windows. I was bombarded with phone calls from users, SA, boss, management, etc.

The application running on the Mainframe was obviously not designed to take the load, more CPU MIPS were added, but, it didn't help much. There was simply too may users trying to access the system.

The other one, well, we found that it was due to some DB settings, which set the DB in batch mode during online hours, it slowed system access. One of the application batch scripts was supposed to change the DB settings (e.g. keep buffer) to online mode, but didn't.

The worst things, one of my SA was not at the DC, another one, on 3 weeks leaves (sigh...one more week to go). The other DBA, NE and SA were not familiar with the batch and middleware support. There's gap in the knowledge transfer somewhere, this has to change.

No comments: