MyIP Communication Parameter [ME]

Controls whether the client attempts to determine addressing information.

Usage

TCP/IP, HTTP, HTTPS

Values

String

Description

The MyIP (ME) parameter is provided for computers with more than one network adapter.

Each adapter has an IP address. By default, Sybase IQ uses the first network card it finds. If you want your database server to use more than one network card, specify the address of each card in the MyIP (ME) parameter.

If the keyword NONE is supplied as the IP number, no attempt is made to determine the addressing information. The NONE keyword is intended primarily for clients on operating systems where this operation is expensive, such as machines with multiple network cards or remote access (RAS) software and a network card. It is not intended for use on the server.

On Windows platforms, this option can be used multiple times for machines with multiple IP addresses.

Separate multiple IP addresses with commas. You can optionally append a port number to the IP address, separated by a colon.

When specifying an IPv6 address on a Windows platform, the interface identifier should be used. Unix platforms support both interface identifiers and interface names in IPv6 addresses. The interface identifier is required on Linux (kernel 2.6.13 and later).

See SQL Anywhere 11.0.1 > SQL Anywhere Server - Database Administration > Starting and Connecting to Your Database > Client/server communications > Using the TCP/IP protocol. Note that Sybase IQ does not support the Mac OS X platform.

Example

  • The following Windows command line (entered all on one line) instructs the server to use two network cards, one with a specified port number.

start_iq -x tcpip(MyIP=192.75.209.12:2367,192.75.209.32) 
c:\sybase\IQ-15_3\demo\iqdemo.db
  • The following command line (entered all on one line) instructs the server to use an IPv6 network card.

start_iq -x tcpip(MyIP=fe80::5445:5245:444f) 
"c:\sybase\IQ-15_3\demo\iqdemo.db"
  • The following connection string fragment instructs the client to make no attempt to determine addressing information.

...CommLinks= tcpip(MyIP=NONE)...