PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
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 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 ----
From: "CSane@EvergreenInvestments.com" 
To: sybperl-l@peppler.org
Sent: Tuesday, October 7, 2008 3:28:08 PM
Subject: Unexpected connects and disconnects at the DB server.


Guys, 

Solaris 
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
logic. 

Any ideas? 

Cory Sane
Member of www.TeamSybase.com
Certified Sybase Associate DBA for ASE 15.0