Newsgroups: comp.databases
Path: utzoo!utgpu!cunews!netfs.dnd.ca!ncs.dnd.ca!rpburry
From: rpburry@ncs.dnd.ca (Paul Burry)
Subject: Re: Sybase on RS/6000
Message-ID: <1991Apr12.024246.9674@ncs.dnd.ca>
Keywords: Sybase, sockets, RS/6000
Organization: Dept. of National Defence, Ottawa.
References: <1597@msa3b.UUCP>
Date: Fri, 12 Apr 91 02:42:46 GMT

I apologize in advance for the post, my reply by email was bounced back...

In article <1597@msa3b.UUCP> smndl@msa3b.UUCP (Sharon Mandell) writes:
|I am trying to run a test against Sybase running on an RS/6000. The client 
|program is running on PCs and is pretty simple...opens a connection to the 
|database, does a bunch of selects, some inserts, closes connection then exits. 
|Note: Only one DBPROC per client program is used. 
|
|At about the 20th client, we start failing to make connections. I can no longer
|run isql on the server machine either. The messages in the Sybase error log 
|say there's no more room in the socket table.
|
|server: Failed to open virtual socket table for new connections
|kernel: nopen: no room in socket table
|
|When the server started there was also a message about not using 2000 file
|descriptors, but only 1024, which is the internal limit. Is this part of the
|problem?
|
|Is there anything one can do about this? Is there some configuration parameter
|in Sybase or AIX one can modify to increase the socket table size? I can't
|believe I'm going to be limited to 20 users!
|
|Thanks for any help!
|-- 
|***************************************************************************
|| Sharon Mandell              |       ..!gatech!nanovx!msa3b!smndl or     |
|| Dun & Bradstreet Software   |       gt5519c@prism.gatech.edu            |
|***************************************************************************

Lookup the Sybase stored procedure "sp_configure".  I believe there is a
parameter that limits the number of active sessions and that the default
configuration uses a value of about 25.

Sorry I could be more help, my documentation is at work.

Paul

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Paul Burry			
Voice: (613)-991-7325		Internet: rpburry@ncs.dnd.ca
Fax:   (613)-991-7323		UUCP:	  ..!{uunet,cunews}!ncs.dnd.ca!rpburry