SAP Knowledge Base Article - Preview

2689602 - dblocate utility can not detect the correct IP address - SAP IQ

Symptom

When the user specifies an IP address other than eth0 using the MyIP option, dblocate utility can not detect the correct IP address.

In addition, this problem has an impact on IQ Cockpit.
IQ Cockpit use dblocate utility.
Due to this problem IQ Cockpit can not log in to the IQ server used MyIP.

ex:

Repro machine has 2 network interfaces.

eth0: 192.168.0.100
eth1: 192.168.1.100

And, IP address returned from this host name is eth0.

iqdemo.cfg include "MyIP" option. MyIP set eth1 address.

-x tcpip{MyIP=192.168.1.100;port=2638}

IQ Server open the listener on '192.168.1.100.' only.

I. 08/27 14:41:10.409910 Database server started at Mon Aug 27 2018 14:41
I. 08/27 14:41:10.410398 Trying to start SharedMemory link ...
I. 08/27 14:41:10.413929 SharedMemory link started successfully
I. 08/27 14:41:10.414064 Trying to start TCPIP link ...
I. 08/27 14:41:10.515353 Starting on port 2638
I. 08/27 14:41:10.516665 Starting TCPIP listener on IP address 192.168.1.100:2638
I. 08/27 14:41:10.518059 Starting UDP listener on IP address 0.0.0.0:2638
I. 08/27 14:41:10.519747 Looking for server with name iqdemo
I. 08/27 14:41:10.519790 Sending broadcast to find server
I. 08/27 14:41:10.519828 Using broadcast address of: 0.0.0.0
I. 08/27 14:41:15.529709 Server not found (no reply received)
I. 08/27 14:41:15.529864 TCPIP link started successfully
I. 08/27 14:41:15.531397 Now accepting requests

But dblocate utility not returned correct ip address

$ dblocate -n
SQL Anywhere Server Enumeration Utility Version 17.0.9.1115

Server Name Address
----------- -------
iqdemo 192.168.0.100:2638 <--- Not correct!!

1 servers found


Read more...

Environment

  • SAP IQ 15.x
  • SAP IQ 16.x
  • SAP SQL Anywhere 16.0
  • SAP SQL Anywhere 17.0
  • SAP IQ Cockpit 
  • Unix/Linix platform

Product

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP SQL Anywhere 16.0 ; SAP SQL Anywhere 17.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4 ; SAP Sybase SQL Anywhere 12.0

Keywords

SAP IQ, IQ, tcp, MyIP, dblocate, cockpit , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.