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
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