SAP Knowledge Base Article - Preview

3392430 - IQ server start failure when 'MYIP' is defined to a designated IP -- SAP IQ

Symptom

IQ server can not start due to mount point issue. 
"MYIP" is not using the designated IP Address

 % start_iq -x "tcpip(MYIP=110.xxx.xx.56;Port=7654)" Demo.db
 
it does not pick up the designated IP address. Followings are the error examples.
 
 % ... -x tcpip{MYIP=110.xxx.xx.56;port=7654}
 
  Server failed to start
  Possible cause: - Port number invalid or already in use 
  Checked the port number is free.
  
 % start_iq -x tcpip{MYIP=110.xxx.xx.56:7654} servername
 
  Database server stopped at ....
  240112 Error TCPIP port options
  Server failed to start 
 
 % start_iq -x tcpip{MYIP=110.xxx.xx.56:Port=7654} servername
 
  DBSPAWN ERROR: -85
  Communication error
  Server failed to start
  Possible cause: - Port number invalid or already in use 


Read more...

Environment

SAP IQ16.1 SP04.XX

Keywords

CR828462, 828462, Myip ,  , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , 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.