Hi All
I am trying to enter procedure editor with .pf file.But I am getting the below error.
┌────────────────────────── Error ───────────────────────────┐
│ You have attempted to connect to a database with too many │
│ users connected to it. Retry the connection later, │
│ or increase -n on the server. (5291) │
│ │
│ ────────────────────────────────────────────────────────── │
│ <OK> │
Please help on this.
My paramter file looks like below one.
# test.pf
# SESSION,Session-related parameters
-Bt 500
-D 150
-TB 4
-TM 15
-h 15
-inp 32000
-mmax 8192
-nb 255
-s 90
-l 1000
# -q let's not use this option
-rand 2
-yy 1930
#
-db /users/sytelinedb/SSOEM
-ld simple
# -B 500
# -c 200
#
-db /users/sytelinedb/TEST
-ld symix
#
-db /users/sytelinedb/symglbl
-ld stecglbl
Firstly you might want to find out what database is giving you that error and then check its .lg file (and possibly increase its -n)
What parameters are used for start database?
What values for database startup param -n, -Mn, -Ma, -Mpb?
Hi Below is the parameter file with which I am starting the database.
-n is set to 5 , but no values are set fro -Mn,-ma,-Mpb.
Please suggest us wat values should be set to -n, -Mn, -Ma, -Mpb parameters.
cat TEST.pf
# PF-TYPE = B "TEST Server" no
#
# SESSION,Session-related parameters
# -L 2000
# Temporarily use large locking table
-L 1000000
-t
-TB 4
-TM 15
-inp 5000
-rand 2
-n 5
#
# MAIN,TEST
-db /users/sytelinedb/TEST
-B 300000
-N tcp
-H mpb-dbdev5
-S TEST
Thanks,
Vithal Kattikar
-Mn,-ma,-Mpb, -n are database parameters
please see in the log file of database what their value is