Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 75 / 536

CHAPTER 2 Running Adaptive Server IQ
55
% cp $SYBASE/asiq12/tix/default.tix
This file controls key sequences for DBISQL and improves the command
window display. For more information, see Chapter 6, “Getting Started
with DBISQL” in Introduction to Adaptive Server IQ.
4 Start DBISQL by entering
dbisql -c
"uid=DBA;pwd=SQL;eng=
servername;links=tcpip"
at the command line. Make sure that the value supplied for the servername
is the same server name that was supplied in the
start_asiq command to
start the server.
The –c parameter specifies connection parameters. You can also specify
these parameters in a data source, as described later in this chapter.
Note
links=tcpip
(or
CommLinks=tcpip
) is only required if you use
TCP/IP to connect to the database. If you use the shared memory port to
connect to a local database you can omit the
links
parameter; however,
it is always safer—and required on some platforms—to include complete
network parameters.
To connect to a database on a foreign host, you must add the host. For
example:
dbisql -c "uid=DBA;pwd=SQL;eng=SERV1_asiqdemo;
links=tcpip(host= SERV2)"
If the host was started with a non-default port number (not 2638) then the
port number must be added also. For example:
dbisql -c "uid=DBA;pwd=SQL;eng=SERV1_asiqdemo;
links=tcpip(host=SERV2;port=1234)"
If you prefer, use this alternate form of the links clause, which has the same
result:
links=tcpip(host=SERV2:1234)"
❖
To connect from a Windows NT system
1 Select Start
→ Προγραµσ →
Sybase Adaptive Server IQ 12
→
Interactive SQL, or at the NT command prompt enter
dbisql