smndl@msa3b.UUCP (Sharon Mandell) (04/11/91)
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 | ***************************************************************************
rpburry@ncs.dnd.ca (Paul Burry) (04/12/91)
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