D
durgaprasad m
Guest
We had issue with our Mfg/pro application "server has no more resources" .Database is up and running fine but application we are not able to connect. Some times user able to connect to application for 5 mins after that user facing same issue. In promon it shows user 108 users. Promon > 5:Activity> 25 Servers, 108 Users (1 Local, 107 Remote, 1 Batch),4 Apws .pf file -n 1050 # Number of users -Ma 20 # Maximum Clients per Server -Mn 50 # Maximum servers -Mi 5 # Min processes on a client server Progress verison : 9.1E Unix O/S: Aix 5.3 In database log file we found below error. 10:44:19 BROKER 0: No servers are available. Try again later. (1154) 10:44:36 BROKER 0: No servers are available. Try again later. (1154) 10:44:59 BROKER 0: No servers are available. Try again later. (1154) I would like to know whether we need to Change -Ma -Mn and -Mpb parameter values? proserve .../prd/db1 -m3 -Mi 3 -Ma 15 -Mn 20 -Mpb 4 -S prdreyoi -ServerType SQL Are we good with these values?
Continue reading...
Continue reading...
