You have attempted to connect to a database with too many u

Posted by vithal.kattikar@hgst.com on 11-Aug-2015 06:39

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

All Replies

Posted by Libor Laubacher on 11-Aug-2015 06:44

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)

Posted by Valeriy Bashkatov on 11-Aug-2015 06:47

What parameters are used for start database?

What values for database startup param -n, -Mn, -Ma, -Mpb?

Posted by vithal.kattikar@hgst.com on 11-Aug-2015 06:54

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

Posted by gdb390 on 11-Aug-2015 07:01

-Mn,-ma,-Mpb, -n are database parameters

please see in the log file of database what their value is

This thread is closed