[Info-Ingres] Unable to make outbound connections all of a sudden

[Karl & Betty Schendel]

At 4:23 AM -0800 2/8/07, steveg15 wrote:
>[snip]



>Whilst the fault is present you cannot access IPM (except with -s) or
>iinamu. Even when you first re-start Ingres, although you can start
>IPM you cannot access the "Server" option?

Sounds like the Name Server is getting hosed somehow.  Is it
running?  Can you connect to the DBMS server directly?
(find out what the port number for the dbms server is, by
looking in errlog.log if necessary, and
export II_DBMS_SERVER=portnumber
sql some-database
locally on the aix box.)

If you can connect to the DBMS server directly, it sounds like a
stuck name server.  It's not immediately clear to me why
the name server would be hanging, but it is odd that this started
all of a sudden.

Am I right in thinking that existing connections are OK, it's
just that no new ones can be made when this happens?

It does sound as if something changed on at least some of the
clients, such that you're burying one of the comm servers instead
of using them all.  I don't see how that would be related to the hang.
(GCC/GCN is not my area of expertise though.)

Karl