How You Can Look Up the Gateway Listen Address in the Error Log
The format for the listen address is different on Microsoft Windows than it is for UNIX. For example:
Windows
NN\MSSQL\dd8
UNIX
42843
There are two two ways to discover the listen address of a gateway server:
• From the error log
• By using the Ingres Name Service Management Utility (iinamu)
To find the listen address in the error log
1. Open the error.log file.
2. Locate the gateway startup entries.
For example:
WANSH02-MAINVM ::[NN\MSSQL\18c , EAMSSQL , 396]: Mon Jul 12 14:54:36 2010: Copyright (c) 2011 Actian Corporation. All Rights Reserved., Gateway Server start-up, build Thu Jul 8 15:10:10 MDT 2010
WANSH02-MAINVM ::[NN\MSSQL\18c , EAMSSQL , 396]: Mon Jul 12 14:54:36 2010: Connect limit is unlimited
WANSH02-MAINVM ::[NN\ORACLE\2f0 , EAORACLE, 752]: Mon Jul 12 14:57:21 2010: Copyright (c) 2011 Actian Corporation. All Rights Reserved., Gateway Server start-up, build Thu Jul 8 15:07:05 MDT 2010
WANSH02-MAINVM ::[NN\ORACLE\2f0 , EAORACLE, 752]: Mon Jul 12 14:57:21 2010: Connect limit is unlimited
The bracketed information follows this format:
[listen_id, gw_type, pid]
To find the listen address using the Ingres Name Service Management Utility
Note: The gateway must be running to use iinamu to find the listen address.
1. Start iinamu.
For more information, see "iinamu Command—Administer the Name Server" in the Ingres Command Reference Guide.
2. At the IINAMU prompt, enter the following command:
show gateway
where gateway is one of the following gateway types: MSSQL, ORACLE, DB2UDB, INFORMIX, SYBASE, RDB, or RMS.
The utility responds with the listen address of the gateway.
Last modified date: 08/22/2022