Unexpected connects and disconnects at the DB server.

[email protected] Tue, 7 Oct 2008 16:28:08 -0400

Newsgroups	gmane.comp.lang.perl.modules.dbi.sybase
Message-ID	<OF74310E8A.8BC3166D-ON852574DB.006F7679-852574DB.00707045@evergreeninvestments.com>

<br><font size=2 face="sans-serif">Guys,</font>
<br>
<br><font size=2 face="sans-serif">Solaris</font>
<br><font size=2 face="sans-serif">DBD Sybase 1.05</font>
<br>
<br><font size=2 face="sans-serif">My co-workers code has a single dbh-&gt;connect.
</font>
<br><font size=2 face="sans-serif">(he has a log/timestamp showing where
he only calling it once.)</font>
<br>
<br><font size=2 face="sans-serif">The sybase sysaudits show repeated login/select/logouts.</font>
<br><font size=2 face="sans-serif">The perl code is believed to simply
run multiple prepare/executes.</font>
<br>
<br><font size=2 face="sans-serif">The logouts are occurring 6 millisecs
after the select statement yet his code does not have any explicit disconnect
logic.</font>
<br>
<br><font size=2 face="sans-serif">Any ideas?</font>
<br><font size=2 face="sans-serif"><br>
Cory Sane<br>
Member of www.TeamSybase.com<br>
Certified Sybase Associate DBA for ASE 15.0</font>