II_GCN<inst_id>_PORT value ??

Dennis

unread,

Apr 29, 2013, 1:45:09 PM4/29/13

to

Hi,

The value for II_GCN<inst_id>_PORT reported by ingprenv is not the same
as that reported by the listen2port utility. Is this an issue? There
doesn't seem to be any operational issues with the installation.

The errlog.log file has long since been truncated/rotated since the last
start up, so I can't see what is reported there unless I bounce the system.

Thanks

Dennis

Karl Schendel

unread,

Apr 29, 2013, 5:14:28 PM4/29/13

to Ingres and related product discussion forum

On Apr 29, 2013, at 1:45 PM, Dennis wrote:

> Hi,
>
> The value for II_GCN<inst_id>_PORT reported by ingprenv is not the same
> as that reported by the listen2port utility. Is this an issue? There
> doesn't seem to be any operational issues with the installation.

I'm not sure what listen2port is, but I'm guessing that it translates an
Ingres installation ID / listen ID into a comm server port.

The GCN port is different than a listen port. It's transient, which is
why it's recorded as an Ingres ingprenv variable. It's normal to have
the name server port be different from a comm server port.

Karl

Dennis

unread,

Apr 29, 2013, 7:32:55 PM4/29/13

to

Thanks Karl,

I got the listen2port from
http://community.actian.com/wiki/Ingres_TCP_Ports.

The issue was that we needed to open up a port for a remote support
person and I gave them the port number as reported by ingprenv + 7 and
that didn't work. When I gave the one as reported by listen2port it did
work - which is what prompted the question.

Dennis

Ingres Forums

unread,

Apr 30, 2013, 7:51:34 AM4/30/13

to

If you just increment by 7, you may not get the correct listen-port...
It is little bit more complicated than that.

--
dejan
------------------------------------------------------------------------
dejan's Profile: http://community.actian.com/forum/member.php?userid=13077
View this thread: http://community.actian.com/forum/showthread.php?t=15182

Ingres Forums

unread,

Apr 30, 2013, 5:07:23 PM4/30/13

to

For local communications, the Ingres servers utilize system assigned
port numbers. Servers like the DBMS register their listen ports with
the Name Server (GCN). These addresses can be found in errlog.log or by
using iinamu and the 'show servers' command. You generally don't need
to know these ports.

The Name Server places it's listen port in the symbol table so that
clients and the other servers can use it. You generally don't need to
know this port either.

For remote communications, the communications server (GCC) typically
uses the installation ID to generate a port number. This is the value
returned by listen2port. Since this is a calculated value, it is easy
to use the host name and installation ID on a remote system to calculate
the correct port. The installation ID is the value you would use in a
VNODE to make remote connections.

The JDBC/.NET server, DAS, typically uses the installation ID + 7, II7
for example, so as to avoid conflicts with GCC. Use installation ID + 7
as the port in JDBC and .NET connection strings.

--
thogo01
------------------------------------------------------------------------
thogo01's Profile: http://community.actian.com/forum/member.php?userid=4992

Ingres Forums

unread,

May 2, 2013, 5:06:35 AM5/2/13

to

You can use iigcfid utility for this purpose, e.g. iigcfid iigcn
For detail see
http://docs.actian.com/ingres/10s/command-reference-guide/5204-iigcfid-commanddisplay-server-id?hilite=iigcfid

Thanks - Bilgihan

--
bilgihan
------------------------------------------------------------------------
bilgihan's Profile: http://community.actian.com/forum/member.php?userid=8658