|
|
sybperl-l Archive
Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: max DBPROCESS problem
Date: Jan 9 2001 7:03PM
jimmy mcdonald writes:
> hello,
>
> when using sybperl to connect to sybase i get errors in
> my web logs that say:
>
> Maximum number of DBPROCESSes already allocated.
>
> since this is in my web logs, i believe this is
> being generated by sybperl.
It probably is - but I think this is a symptom of not closing
connections properly. Check your code to make sure that you close
connections properly (i.e. that the $dbh or $dbproc variable is
correctly undef'ed when the script exits, or that you check for an
existing connection before opening a new one.)
> according to the sybase tech i spoke with, he
> believes that the max number of connections is 25.
>
> he said that if you had a c program you could define
> it something like this:
>
> int maxprocesses = 100;
> dbsetmaxprocs (&maxprocesses)
>
> is there any way to do something similar in sybperl?
If you have a recent version of sybperl you can say (surprise!)
dbsetmaxprocs(100);
but this may have to be done before any connections are opened (I'm
not sure - I haven't checked the docs lately)
Michael
--
Michael Peppler - Data Migrations Inc. - mpeppler@peppler.org
http://www.mbay.net/~mpeppler - mpeppler@mbay.net
International Sybase User Group - http://www.isug.com
Sybase on Linux mailing list: ase-linux-list@isug.com
|
