How to write interfaces for ipv6 on IQ?

[former_member232292]

Dear Sir,

As we know -- for ASE, we can write the interfaces like --

srvname

master tcp ether 192.168.160.129 5000
query tcp ether 192.168.160.129 5000

master tcp ether fd77:55f:5a64:52a:202:5445:5245:444f

query tcp ether fd77:55f:5a64:52a:202:5445:5245:444f

But we can't write 2 lines of "-x" in the cfg file -- Is there any way to support both IPv4 and IPv6 for IQ at same time? Thanks

Regards

Eisen

[former_member232292]

Hi, Claude

Thanks a lot. I read that -- But now I'm looking for is -- how to make IQ listen on both IPv4 and IPv6 together just like ASE does... 🙂

[claude]

Hello Eisen,

Regarding your question, here's what I found

IPv6 support in SAP Sybase IQ

On IPv6-enabled computers, the network database server listens by default on all IPv4 and IPv6 addresses. IPv6 is not supported on Windows CE.

Usually no changes are required to the database server start line to use IPv6. In a case where specifying an IP address is required, the database server and the client libraries both accept IPv4 and IPv6 addresses. For example, if a computer has more than one network card enabled, it probably has two IPv4 addresses and two IPv6 addresses. For IPv6 addresses that include a port number, you must enclose the address in either square brackets or parentheses. If you want the database server to listen on only one of the IPv6 addresses, you can specify an address in the following format:

iqsrv16 -x tcpip(MyIP=fd77:55f:5a64:52a:202:5445:5245:444f) ...

Similarly, if a client application needs to specify the IP address of a server, the connection string or ODBC data source can contain the address, in the following format:

...HOST=fd77:55f:5a64::444f;...

Each interface is given an interface identifier, which appears at the end of an IPv6 address. For example, if ipconfig.exe lists the address fd77:55f:5a64::444f, the interface identifier is 7. When specifying an IPv6 address on a Windows platform, the interface identifier should be used. On Unix, you can specify either an interface identifier or an interface name (the interface name is the name of the interface reported by ifconfig). For example, the interface name is eth1 in the following IPv6 address: fd77:55f:5a64::444f;. An interface identifier is required when specifying IPv6 addresses on Linux (kernel 2.6.13 and later). This requirement affects values specified by the following:

Example

Suppose ipconfig.exe lists two interfaces, one with the identifier 1 and the other with the identifier 2. If you are looking for a database server that is on the network used by interface number 2, you can tell the client library to broadcast only on that interface:

LINKS=tcpip(BROADCAST=ff02::1%2)

The IPv6 link-local multicast address is ff02::1.

For more Information.

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc01771.1601/doc/html/saiq-...