ASA Database Administration Guide
Running the Database Server
Some common options
Any communication between a client application and a database server requires a communications protocol. Adaptive Server Anywhere supports a set of communications protocols for communications across networks and for same-machine communications.
By default, the database server starts up all available protocols. You can limit the protocols available to a database server using the -x
option. On the client side, many of the same options can be controlled using the CommLinks (LINKS) connection parameter.
For more information on running the server using these options, see Supported network protocols.
The personal database server (dbeng9.exe) supports the following protocols:
Shared memory This protocol is for same-machine communications, and always remains available. It is available on all platforms.
TCP/IP This protocol is for same-machine communications only, from TDS clients, Open Client, or the jConnect JDBC driver. You must run TCP/IP if you wish to connect from Open Client or jConnect.
For more information on TDS clients, see Adaptive Server Anywhere as an Open Server.
Named Pipes This protocol is provided on Windows NT only. Named Pipes is for same machine communications for applications that wish to run under a certified security environment.
The network database server (dbsrv9.exe) supports the following protocols:
Shared memory This protocol is for same-machine communications, and always remains available. It is available on all platforms.
SPX This protocol is supported on all platforms except for UNIX.
TCP/IP This protocol is supported on all platforms.
Named Pipes This protocol is supported on Windows NT only. Named Pipes is for same machine communications for applications that wish to run under a certified security environment.
You can instruct a server to use only some of the available network protocols when starting up, using the -x
option. The following command starts the asademo database using the TCP/IP and SPX protocols:
dbsrv9 -x "tcpip,spx" path\asademo.db
Although not strictly required in this example, the quotes are necessary if there are spaces in any of the arguments to -x
.
You can add additional parameters to tune the behavior of the server for each protocol. For example, the following command (typed all on one line) instructs the server to use two network cards, one with a specified port number.
dbsrv9 -x "tcpip{MyIP=192.75.209.12:2367,192.75.209.32}" path\asademo.db
For more information about available network communications parameters that can serve as part of the -x
option, see Network communications parameters.