If you set the connect_limit in CBF to 256 - do you really get 256
connections available to you, or are part of those used up by internal
system connections?

Ii have Ingres II 2.0 patch 9599 on AIX.

I recently got message E_GC2214_MAX_IB_CONNS GCC server has exceeded max
inbound connections. Am I correct in saying that increasing the
connect_limit would correct this issue?

Thanks, teisha

Teisha Winkler
EDS - Lordstown Complex

There's also a connect_limit in the DBMS configuration as well as the GCCs.



Make sure the DBMS limit can handle the the total connections from all GCCs
if

you have more than one running.



Andre

_____

From: info-ingres-admin (AT) cariboulake (DOT) com
[mailto:info-ingres-admin (AT) cariboulake (DOT) com] On Behalf Of Winkler, Teisha
Sent: Thursday, September 15, 2005 2:22 PM
To: info-ingres (AT) cariboulake (DOT) com
Subject: [Info-ingres] Connect Limit





If you set the connect_limit in CBF to 256 - do you really get 256
connections available to you, or are part of those used up by internal
system connections?

Ii have Ingres II 2.0 patch 9599 on AIX.

I recently got message E_GC2214_MAX_IB_CONNS GCC server has exceeded max
inbound connections. Am I correct in saying that increasing the
connect_limit would correct this issue?

Thanks, teisha

Teisha Winkler
EDS - Lordstown Complex

Hi Teisha,

You are correct with regards to the connect_limit for the dbms, but the
error you are encounting is ...

E_GC2214_MAX_IB_CONNS GCC server has exceeded max inbound connections

Is related to the users/sessions that connect over ingres net.
If you look at the 'Net Server' in CBF you will see inbound_limit
(default 64 connections) check that parameter and if majority of all
the sessions connecting to the database is via Ingres/NET then i would
probably make the inbound_limit and connect_limit to be the same.

Hope this helps.
m00n.