Wrong port identified

#1
HI All,

During monitoring we have identified below ports are using by _Sqlsrv process but in Promon > R&D > 1 > 3 > in Curr users filed it is showing zero.
But we found sql process running on server.
Anything we need to change on parameters.
What went wrong here?

ps -ef | grep _sqlsrv2 | wc -l
10

Progress version : 9.1E
OS version : AIX 5.3

Sv Pend. Cur. Max. Port
No Pid Type Protocol Logins Users Users Users Num

15 85666 Auto tcp 19 0 8 15 13208
16 721446 Auto tcp 30 0 8 15 13213
17 85884 Auto tcp 20 0 8 15 13221
18 520010 Auto tcp 16 0 8 15 13228
19 689742 Auto tcp 20 0 8 15 13233
20 69342 Auto tcp 19 0 8 15 13240
21 12346 Auto tcp 13 0 8 15 13247
22 589476 Auto tcp 25 0 8 15 13253
23 586020 Auto TCP 38 0 0 15 1031
24 108400 Auto TCP 19 0 0 15 1032

25 363602 Auto TCP 4 0 0 15 1033
26 323756 Auto tcp 38 0 8 15 13260
27 429958 Auto tcp 29 0 8 15 13266
28 577112 Auto tcp 31 0 8 15 13271
29 249756 Auto tcp 18 0 8 15 13273
30 478822 Auto tcp 13 0 8 15 13318

-L 64000 # Number of entries in record locking table
-B 8000 # Number of Blocks in database buffer
-n 1050 # Number of users
-Ma 20 # Maximum Clients per Server
-Mn 50 # Maximum servers
-Mi 5 # Min processes on a client server
-minport 13100 # Min Port Number
-maxport 14999 # Max Port Number


-B 46250 # Number of Blocks in database buffer
#-Mi 2 # Min processes on a client server
-Ma 15 # Max number of REMOTE clients per db server
-Mn 35 # Max number of REMOTE client servers
-Mpb 30 # Maximum Servers per Broker
-Mxs 32768 # Shared memory overflow size (override)
-spin 4000 # Number of spin lock retries
-L 128000 # Lock Table entries

proserve /data/prd/prodata -m3 -Mi 3 -Ma 15 -Mn 20 -Mpb 4 -S prodataoi -ServerType SQL
 

Rob Fitzpatrick

ProgressTalk.com Sponsor
#2
We aren't seeing all of your command lines. The "proserve" above is only for your secondary SQL broker. We can't see the command line of your primary broker, though presumably we can see some of its parameters.

The broker parameters that govern client/server activity (e.g. -S, -minport, -maxport, -Mpb, -Ma, -Mi, etc.) are not database-wide. They are broker-specific. They should be set explicitly on each connection broker. It appears you have set -minport and -maxport on your primary broker but you have not set it on your secondary broker. Therefore the SQL broker is using the default values of 1025 and 2000 respectively.

Also, given the size of the minport/maxport range (1900; far larger than -Mpb) and the spacing between the port numbers assigned to the servers, I'd guess that there are other database brokers running on this server with similar minport/maxport settings. This is not a good practice; it makes troubleshooting connectivity issues much more difficult than it needs to be. I suggest you allocate a reasonably-sized range of ports for every broker and specify unique minport/maxport ranges on all connection brokers.
 
#3
Thanks Rob, we will change accordingly
BEFORE that I have doubt, portno's which I mentioned are oracle database port no's but how it is connecting to that port without we are defining any port range in secondary broker.
 

Rob Fitzpatrick

ProgressTalk.com Sponsor
#4
how it is connecting to that port without we are defining any port range in secondary broker.
Every secondary broker has a server port range, defined by -minport and -maxport, whether you specify them or not. If you specify them, you get the range you specify. If you don't specify them, you get their default values: 1025-2000 on Unix or 3000-5000 on Windows.
 
#5
yes Rob they are using default brokers.we will add minport and maxport.

I had a discussion with my leads they suggested us to fine tune these parameters before any connectivity issue comes.

we have defined -n as 1050 based on that what values we need to define for -Ma,Mi , Mn,-Mpb and max/min ports(Range) for primary brokers?
we required 40 SQL connection need to define, so what values we have to set for -Mi -Ma -Mn -Mpb maxport and minport(Range) for SQL brokers?
Please provide your suggestion on above.
 

Rob Fitzpatrick

ProgressTalk.com Sponsor
#6
Before I reply, can you please provide the complete, unadulterated proserve command lines (including .pf files and their contents, if any) of all of the database brokers? I am seeing multiple values for database-wide parameters that should only be specified once, e.g. -B, -L, -Mn. So I don't know what to believe. Or are there multiple databases for this application? Please clarify.
 

Rob Fitzpatrick

ProgressTalk.com Sponsor
#7
Also, please provide the numbers of SQL clients, remote 4GL clients, and self-service 4GL clients that you expect to be able to connect concurrently.
 
Top