MAJOR coup !

[texxgadget]

Were getting some major hanging idle connections to the db.

Its like the database is having a context storm.

OK simple shell script to produce process status report.

Now we need a program to kill of the idle connections that are over
2 mins old. Tom asked me if I could create a PERL script to do it.

You have to know shell scripting and PERL to get very far in UNIX admin.
I have a familarity with it. Worked part way through the PERL workbook.
I never sat down and did it "cold" without a manual.
I was in a panic.

I fiddled and fiddled and finally got something to work.
With a basic script that did almost nothering but worked, I just
kept adding to it slowly and suddenly i realized, (gasp!)
IVE DONE IT ! I FREAKING FINALLY DID IT!

I can now hold my head up high as a PERL user.

Meanwhile the App server was having a hissy fit.
After I wrote the code, 6 hours later, we reloaded the classfiles
on the server and that made the context storm went away.

I still felt good about the code.

We discussed installing the new database server at Hurricane
Electric (co-lo) early but with this problem fixed, we could wait a while.

Learned how to promote code from dev to production.
(So THATS what "jar" files are...)

Very late night.

Missed starport.