Reference Manual
CHAPTER 2. The Database Server
dbcli6 [switches] server-name
dbcli6w [switches] server-name
Switch |
Description |
|---|---|
-e |
Encrypt all network packets |
-ga |
Automatically shut down after the last connection is closed |
-o filename |
Output messages to a file |
-p packet_size |
Set the maximum network packet size |
-r |
Disable multiple-row fetching |
-s |
Memory for buffers in K |
-tl seconds |
Client liveness timeout in seconds—default is server setting, which defaults to 120 seconds |
-x list |
Comma-separated list of communication links to try, with any parameters |
-z |
Display debugging information |
Compatibility only |
In SQL Anywhere Version 5, the database client executable handled connections from client applications to a network database server. In Adaptive Server Anywhere, no separate executable is required: all connections are handled by a client library. The database client executable for Adaptive Server Anywhere simply creates an ODBC data source (for use by the client library) and then terminates.
-e Encrypt all packets that this client transmits over the network. By default, packets are not encrypted. If you are concerned about the security of network packets, use the -e switch. Encryption does affect performance marginally.
Using the -e switch on the database server command line will encrypt packets for all clients regardless of whether the -e switch is used on the client command line.
-ga Automatically shut down the client after the last connection to a server is closed.
-o filename Output all error messages and debugging messages (see -Z) to a file instead of the console. Normally, there are no messages.
-p packet-size Set the maximum size of communication packets. The default is 512 bytes. The minimum value is 200 bytes. If the specified packet size is larger than that of the database server, the server's packet size is used.
-r Fetch one row per network request. By default, when the database server gets a simple fetch request, it fills one network packet with several rows so that subsequent sequential fetches do not require network traffic. This is often referred to as blocking of fetches. This switch disables multiple-row fetching.
-s Set the memory allowed for buffers, in K. The value must be at least 10 and at most 1000. The default is 100.
-tl seconds (Lower case TL.) A liveness packet is sent periodically across a client/server TCP/IP or IPX communications protocol to confirm that a connection is intact. If the client runs for a liveness timeout period (default 120 seconds) without detecting a liveness packet, the communication is severed. The client forgets about the address of the server and looks it up the next time a connection is made. UNIX clients do not do liveness checking.
If no -tl switch is set, the liveness timeout is controlled by the setting on the server, which defaults to 120 seconds.
Liveness packets are sent at an interval of the (liveness timeout)/4.
-x list Use only the listed communications links (IPX, TCPIP, NetBIOS). The default is to try all communication links supported by the version of dbcli6.
Named Pipes and Windows links are for local communications only.
By default, the Client tries to use IPX, TCP/IP, and then NetBIOS when locating a server. The Client starts slightly faster if unnecessary network drivers are not started.
Additional parameters may be provided, in the format
-x tcpip{PARM1=value1;PARM2=value2;...}
-x "tcpip{PARM1=value1;PARM2=value2;...}"
The quotation marks are required for the UNIX client and server only, and only if more than one parameter is supplied.
For a description of available parameters, see Network communications parameters.
-z Provides diagnostic information on communications links on startup. This is useful if -o is also specified.