HI team,
Today we faced below issue during that time database and application are up and running fine.
Data stage team are connecting to our database they found this error on their jobs log.
Error: J_aps_rey_ps_mstr..TR: |J_aps_rey_ps_mstr..PS_MSTR: DSD.BCIConnect connecting to REY, call to function SQLConnect failed.?SQLSTATE=60, DBMS.CODE=-20225?[DataStage][SQL Client][ODBC][DataDirect][ODBC 20101 driver][ODBC Socket][IBM(DataDirect OEM)][ODBC 20101 driver][20101]Exceeding permissible number of connections|
Please help how to resolve this error.
I think we need to increase -Mpb parameter for SQl connection.
W e dont have primary broker assigned to this database.
How much we need to setup the -Mpb value for both primary and secondary brokers.
Progress Version : 9.1e
OS version : IBM AIX 5.3
test.pf file
#-------------------------------------------------------
# OVERRIDE database broker parms for test
#-------------------------------------------------------
# MAX USERS = Ma*Mn = 180
#-------------------------------------------------------
-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
-Mxs 32768 # Shared memory overflow size (override)
-spin 4000 # Number of spin lock retries
-L 128000 # Lock Table entries
SQl broker :
more reyoi.sh
proserve /progdata/prd/db1/tes -m3 -Mi 3 -Ma 15 -Mn 20 -Mpb 4 -Ststreyoi -ServerType SQL
21:36:02 BROKER 3: No SQL servers are available. Try again later. (8839)
21:36:04 BROKER 3: No SQL servers are available. Try again later. (8839)
21:36:05 BROKER 3: No SQL servers are available. Try again later. (8839)
21:36:06 BROKER 3: No SQL servers are available. Try again later. (8839)
21:36:07 BROKER 3: No SQL servers are available. Try again later. (8839)
21:36:08 BROKER 3: No SQL servers are available. Try again later. (8839)
21:36:09 BROKER 3: No SQL servers are available. Try again later. (8839)
Today we faced below issue during that time database and application are up and running fine.
Data stage team are connecting to our database they found this error on their jobs log.
Error: J_aps_rey_ps_mstr..TR: |J_aps_rey_ps_mstr..PS_MSTR: DSD.BCIConnect connecting to REY, call to function SQLConnect failed.?SQLSTATE=60, DBMS.CODE=-20225?[DataStage][SQL Client][ODBC][DataDirect][ODBC 20101 driver][ODBC Socket][IBM(DataDirect OEM)][ODBC 20101 driver][20101]Exceeding permissible number of connections|
Please help how to resolve this error.
I think we need to increase -Mpb parameter for SQl connection.
W e dont have primary broker assigned to this database.
How much we need to setup the -Mpb value for both primary and secondary brokers.
Progress Version : 9.1e
OS version : IBM AIX 5.3
test.pf file
#-------------------------------------------------------
# OVERRIDE database broker parms for test
#-------------------------------------------------------
# MAX USERS = Ma*Mn = 180
#-------------------------------------------------------
-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
-Mxs 32768 # Shared memory overflow size (override)
-spin 4000 # Number of spin lock retries
-L 128000 # Lock Table entries
SQl broker :
more reyoi.sh
proserve /progdata/prd/db1/tes -m3 -Mi 3 -Ma 15 -Mn 20 -Mpb 4 -Ststreyoi -ServerType SQL
21:36:02 BROKER 3: No SQL servers are available. Try again later. (8839)
21:36:04 BROKER 3: No SQL servers are available. Try again later. (8839)
21:36:05 BROKER 3: No SQL servers are available. Try again later. (8839)
21:36:06 BROKER 3: No SQL servers are available. Try again later. (8839)
21:36:07 BROKER 3: No SQL servers are available. Try again later. (8839)
21:36:08 BROKER 3: No SQL servers are available. Try again later. (8839)
21:36:09 BROKER 3: No SQL servers are available. Try again later. (8839)