Hi all,

I would like to share here one of my recent experience and would like
to thanks Obnoxio The Clown for his excellent script "DBPING". Recently
our web application and security team have migrated new web &
application server into production. Every thing went all right. Web
team has got some sort of monitoring process in place, which does a
dummy login to database server every 15 mins. They mentioned that every
night connections are being dropped out between 10:15 PM to 5AM.

I started looking at online log but nothing suspicious there. Looked at
cron jobs, nothing suspicious.

Then I used OTC's DBPING, which is an excellent piece of work. I
slightly modified that script to include date and time & threshold
value to check and put "####" for those responses which meet threshold
criteria so that I can easily identify from DBPING log file.

Now I have been able to identify some of the issues with database
server during that point in time.

Well done OTC.

OTC: does this get an OBN?

<hariog@yahoo.com> wrote in message
news:1157348555.001302.183060@74g2000cwt.googlegro ups.com...
> Hi all,
>
> I would like to share here one of my recent experience and would like
> to thanks Obnoxio The Clown for his excellent script "DBPING". Recently
> our web application and security team have migrated new web &
> application server into production. Every thing went all right. Web
> team has got some sort of monitoring process in place, which does a
> dummy login to database server every 15 mins. They mentioned that every
> night connections are being dropped out between 10:15 PM to 5AM.
>
> I started looking at online log but nothing suspicious there. Looked at
> cron jobs, nothing suspicious.
>
> Then I used OTC's DBPING, which is an excellent piece of work. I
> slightly modified that script to include date and time & threshold
> value to check and put "####" for those responses which meet threshold
> criteria so that I can easily identify from DBPING log file.
>
> Now I have been able to identify some of the issues with database
> server during that point in time.
>
> Well done OTC.

No worries, hariog, the usual fiver will be winging its way to you
shortly. )


hariog@yahoo.com said:
> Hi all,
>
> I would like to share here one of my recent experience and would like
> to thanks Obnoxio The Clown for his excellent script "DBPING". Recently
> our web application and security team have migrated new web &
> application server into production. Every thing went all right. Web
> team has got some sort of monitoring process in place, which does a
> dummy login to database server every 15 mins. They mentioned that every
> night connections are being dropped out between 10:15 PM to 5AM.
>
> I started looking at online log but nothing suspicious there. Looked at
> cron jobs, nothing suspicious.
>
> Then I used OTC's DBPING, which is an excellent piece of work. I
> slightly modified that script to include date and time & threshold
> value to check and put "####" for those responses which meet threshold
> criteria so that I can easily identify from DBPING log file.
>
> Now I have been able to identify some of the issues with database
> server during that point in time.
>
> Well done OTC.
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>


--
Bye now,
Obnoxio

"... no bill is required as no value was provided."
-- Christine Normile

Doug Lawry said:
> OTC: does this get an OBN?

No, just a fiver. )

--
Bye now,
Obnoxio

"... no bill is required as no value was provided."
-- Christine Normile