ServerPort Communication Parameter [PORT]

In the case of the database server, the ServerPort option designates the port number on which to communicate using TCP/IP. In a data source, the ServerPort option informs the client of the port or ports on which database servers are listening for TCP/IP communication.

Usage

TCP/IP (all platforms), HTTP, HTTPS

Values

Integer

Default

The default value for TCP/IP is 2638. The default value for HTTP is 80. The default value for HTTPS is 443.

Description

The Internet Assigned Numbers Authority has assigned the IQ database server port number 2638 to use for TCP/IP communications. However, applications are not disallowed from using this reserved port, and this may result in an addressing collision between the database server and another application.

The client broadcasts to every port that is specified on the ServerPort parameter to find the server. If ServerPort is unspecified, the default port 2638 is used.

The database server uses the port number specified in ServerPort for TCP/IP connections. If ServerPort is unspecified, the default port 2638 is used. Hence, applications can connect to the database server without specifying a port number. An exception is the HP-UX operating system, on which the server does not listen on port 2638 if it is started on another port.

By default, the database server listens on the standard HTTP and HTTPS ports of 80 and 443, respectively.

Example

  1. On Windows, start an IQ network server:

    start_iq -x tcpip c:\sybase\IQ-16_0\demo\iqdemo.db

    Port number 2638 is now taken.

  2. Attempt to start another database server:

    start_iq -x tcpip c:\sybase\IQ-16_0\demo\iqdemo2.db

    The default port being allocated, the server starts on another port.

  3. Start another database server on port 2639:

    start_iq -x "tcpip(ServerPort=2639)" c:\sybase\IQ-16_0\demo\iqdemo3.db

    This succeeds as long as 2639 is not a reserved port and no other application has allocated it.

  4. If another web server on your machine is already using port 80 or you do not have permission to start a server on such a low port number, start a server that listens on an alternate port, such as 8080:

    start_iq -xs http{port=8080} -n server3 web.db