Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

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
MyDatabases (free) magazine:
Froebe Fibers

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 ----
From: "" 
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

Any ideas? 

Cory Sane
Member of
Certified Sybase Associate DBA for ASE 15.0