Up Prev Next
From: "Jason L dot Froebe" <jason at froebe dot net>
Subject: Re: Unexpected connects and disconnects at the DB server.
Date: Oct 7 2008 10:28PM
Could be running an invalid command or something that would cause a disconnect. Put Ribo inbetween the server and the perl script. You should be able to see who disconnects first and why.
Jason L. Froebe
Tech log http://www.froebe.net/blog
MyDatabases (free) magazine: http://froebe.net/blog/category/databases/my-databases/
Froebe Fibers http://www.froebe-fibers.com
The opinions expressed within are the sole rantings of a raving lunatic and in no way reflect the rantings, fits, tantrums, errors, corrections, allocutions, or aimless thoughts of Sybase or its employees or of TeamSybase or ISUG. Any resemblence to reasonable thought, or any official or published opinion of Sybase, TeamSybase or ISUG is merely coincidental, and should be totally ignored.
----- Original Message ----
Sent: Tuesday, October 7, 2008 3:28:08 PM
Subject: Unexpected connects and disconnects at the DB server.
DBD Sybase 1.05
My co-workers code has a single dbh->connect.
(he has a log/timestamp showing where
he only calling it once.)
The sybase sysaudits show repeated login/select/logouts.
The perl code is believed to simply
run multiple prepare/executes.
The logouts are occurring 6 millisecs
after the select statement yet his code does not have any explicit disconnect
Member of www.TeamSybase.com
Certified Sybase Associate DBA for ASE 15.0