Consultor Eletrônico



Kbase P9345: Get error (748) and Try a larger -n but can still not connect with more clients
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   10/16/2008
Status: Verified

GOAL:

Why you receive the message 748 when you tried to connect x users if you have defined -n x?

GOAL:

Why I can connect only 20 users if I define -n 100, for example?

GOAL:

Error 748 and remote connections ( -n -Ma -Mn )

GOAL:

What is the default database parameters -Mn is 4 and -Ma 5?

GOAL:

Why can I only connect 20 users when I define -n 100 ?

GOAL:

How to calculate the parameters -n -Ma -Mn

GOAL:

Why do I receive error (748) when connecting x users if I have defined -n bigger than x?

FIX:

Mn specifies the maximum number of remote servers at a broker can start. Ma specifies maximum number of clients each remote servers can service. By default -Mn is 4 and -Ma 5, this gives 20, which means, maximum 20 remote users can connect to database. If more remote users attempt to connect to the database, error 748 will be received. Example:
If you define your database startup parameters like this

proserve sports -N tcp -S prosv04 -n 6 -Mn 2 -Ma 2

User Control:

Usr Name Type Wait Trans PID Sem Srv Login Time

0 ebo BROK -- 0 0 24801 3 0 10/27/99 09:26
1 ebo SERV -- 0 0 24811 4 0 10/27/99 09:28
2 ebo SERV -- 0 0 24815 5 0 10/27/99 09:28
3 ebo MON -- 0 0 24819 6 0 10/27/99 09:30
6 REMC -- 0 438 0 5 2 10/27/99 09:29
7 REMC -- 0 437 0 4 1 10/27/99 09:29
8 REMC -- 0 436 0 5 2 10/27/99 09:28
9 REMC -- 0 435 0 4 1 10/27/99 09:28

RETURN - repeat, U - continue uninterrupted, Q - quit:

At this point you cannot connect news remote clients because you already use your two servers (SERV) and yours four remote clients (REMC)
You receive the following message: Error:
The server or the system has no more resources. Try a larger -n (748)

But you can connect more self service client

User Control:

Usr Name Type Wait Trans PID Sem Srv Login

Time

0 ebo BROK -- 0 0 24801 3 0 10/27/99 09:26

1 ebo SERV -- 0 0 24811 4 0 10/27/99 09:28

2 ebo SERV -- 0 0 24815 5 0 10/27/99 09:28

3 ebo MON -- 0 0 24819 6 0 10/27/99 09:30

4 ebo &nbsp.; SELF -- 0 0 24849 7 0 10/27/99 09:32

5 ebo SELF -- 0 0 24878 8 0 10/27/99 09:33

6 REMC -- 0 438 0 5 2 10/27/99 09:29

7 REMC -- 0 437 0 4 1 10/27/99 09:29

8 REMC -- 0 436 0 5 2 10/27/99 09:28

9 REMC -- 0 435 0 4 1 10/27/99 09:28


RETURN - repeat, U - continue uninterrupted, Q - quit:

This example show how is possible to connect 2 additional self service clients after the message 'increase -n' WITHOUT modify the -n
parameter.

Why? Because the 'SELF' services clients use the -n parameter but the 'REMC' remote clients, use the -Mn to define the number of servers and -Ma to define the number of clients per server.

After this, if you try to connect additional clients SELF, you receive
the message: Error:
The server or the system has no more resources. Try a larger -n (748)
Because you have yours 6 clients ( -n6 ) 4 REMC + 2 SELF.

The message related to the error 748 is:
You may wait until someone logs out, or restart the server with a larger -n parameter if that is possible for your operating system. In addition, the machine the PROGRESS server is running on may have run out of processes or semaphores. In this case it may be possible to reconfigure the machine to provide more processes at a time and to provide more semaphores.

If you work in remote client mode you need to verify the -Ma and -Mn parameters..