increase -n on the server

[sureshp]

Hi,

im getting below err while trying to connect to the server

You have attempted to connect to a database with too many
users connected to it. Retry the connection later,
or increase -n on the server. (5291)

the below is the content of my .pf file

-cpinternal 620-2533
-cpstream 620-2533
-cpcoll thai-old
-cprcodein 620-2533
-L 1000000
-c 250
-Ma 3
-Mn 1
-spin 50
-semsets 1
-n 70

though only 10 users connected to it, i get this err often.

please help

 

[TomBascom]

What version of Progress? What OS?

Are you sure that that is your .pf file? It's not a very sensible one if it is.

You're using -Ma and -Mi but no -S? And no -Mn?

No -B?

-spin 50 is a highly unusual setting. And probably way too low. I've never found settings less than 2,000 to be very useful. ("1" is a way to simulate a Workgroup license.)

-L is crazy high. You have a coding problem that should be solved if you really need that value.

Are you starting a BIW, an AIW, WDOG and one or more APWs?

Perhaps there are also command line parameters or there is an additional .pf file?

What about the client startup parameters?

-Ma 3 combined with the default -Mn of 4 would limit you to 12 remote client connections. But that would only occur if there is a -S somewhere and if your clients are connecting with -S.

How is it that you know there are only 10 users?

 

[ramyapriyacsit]

Suresh,
are you not restarting the admin DBs as well after increasing -n ?

 

[tamhas]

You might want to take a look at what promon says about how many users there are when this happens.