ServerPort parameter (PORT)

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.

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. The client broadcasts to every port that is specified on the ServerPort parameter to find the server.

The database server always listens on port 2638, even if you specify a different port using a network communication parameter. 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-15_2\demo\iqdemo.db
    

    Port number 2638 is now taken.

  2. Attempt to start another database server:

    start_iq -x tcpip c:\sybase\IQ-15_2\demo\iqdemo2.db
    

    This fails with an error Server failed to start. Possible cause: - port number invalid or already in use, as the port is currently allocated.

    If the -z switch is used as well, the console also displays the error Couldn't bind to specified address.

  3. Start another database server, assigning a different port number to it:

    start_iq -x "tcpip(ServerPort=2639)" c:\sybase\IQ-15_2\demo\iqdemo2.db
    

    This should succeed 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 this low a port number, you may want to start a server that listens on an alternate port, such as 8080:

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