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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.