dbms port

[koli1980]

Does anybody know how can I find DBMS port on IngressII 2.5/0011 (int.w32/00)
9247

Thanks in advance

[Divya]

You can check for code "E_SC051D" in %II_SYSTEM%\ingres\files\errlog.log. It has the port for DBMS and is in the following format-

hostname::[AA\INGRES\ae4 , ffffffff]: Wed Oct 01 13:48:46 2008
E_SC051D_LOAD_CONFIG Finished loading configuration parameters for configuration '(DEFAULT)'of server type 'DBMS'.

For Network port, you can refer to code "E_GC2815". It is in the following format-
E_GC2815_NTWK_OPEN Network open complete for protocol WINTCP, port AA (16904).

[ivlbi01]

Another option is to use "iinamu". From the command prompt, as ingres user type iinamu, and then "show".

C:\>iinamu
Ingres NAME SERVICE MANAGEMENT UTILITY --
-- Copyright (c) 1989, 1999 Computer Associates Intl, Inc.
IINAMU> show

[koli1980]

I don't understand which number is the port in that line
I am sorry but I don't have a clue about ingres and servers actually
I am just trying to find this port because we have a problem i our bank and there are no technitians at this time here

Thanks a lot

[koli1980]

i got a reply like "II\INGRES\c84"
Does this mean that c84 is teh DBMS port?

Many thanks for your help guys

[Divya]

Yes, that would be the port.

An example showing the DBMS port is shown below:

*ingstart* shows -
---------------------
Starting DBMS Server (default)...
II_DBMS_SERVER = DD\INGRES\1ac8
---------------------

---------------------
IINAMU> show
INGRES * DD\INGRES\1ac8 (sole server)
---------------------

*errlog.log* shows -
---------------------
hostname::[DD\INGRES\1ac8 , ffffffff]: Wed Oct 01 14:34:42 2008
E_SC051D_LOAD_CONFIG Finished loading configuration parameters for configuration '(DEFAULT)' of server type 'DBMS'
---------------------

In this case, "1ac8" is the DBMS port.
Hope this helps.

[koli1980]

Thanks a lot Divya. We are trying to manage the server here becouse it is down and it shold be up by tomorrow before the customers get to the bank. I will let you know about the results.

[koli1980]

ok, the problem is that branch users cannot connect to the ingress server. We tried to connect localy to it (from the intranet) and we didn't succeed. Te server seems to be running normaly. What do you think the proble should be?

Any help please?

Thanx

[Divya]

Sure. You can always raise an issue with support via http://servicedesk.ingres.com or call us at any of the following numbers -
http://www.ingres.com/support/contacts.php
You would just need to have valid support contract for any technical assistance via means listed above.

[Divya]

I just read your last update. It is possible that either the DBMS got de-registered or you ran the maximum limit of allowable inbound/ outbound connections.
If all ingres processes are running normally, we need to know the error that you see when users can't connect.