21
C H A P T E R 2
Running Adaptive Server IQ
About this chapter
Three steps are required for you to start using Adaptive Server IQ:
•
The database server must be started.
•
The database must be started.
•
You must connect to the database.
Adaptive Server IQ gives you great flexibility in performing these three
steps. This chapter explains various options for accomplishing each of
these steps, and gives suggestions for which to choose, depending on your
situation.
With Adaptive Server IQ you will run in a client/server environment, in
which many users can connect to a database server across a network. You
may have multiple databases on a given database server. Likewise, you
may be able to connect to more than one database server. The server
startup and connection options you choose must take into account these
factors.
Starting the database server
The first step in running Adaptive Server IQ is to start the database server.
You can start the server in all of these ways:
•
Type a server startup command at the operating system prompt. See
“Server command lines” on page 22, as well as the section specific to
your operating system.
•
Start the server from the Windows NT Start menu. See “Starting the
server from the NT Start menu” on page 26.
•
Start the server with the Sybase-provided utility,
start_asiq
, that runs
the server as a UNIX background process. See “Starting the server on
UNIX” on page 23.
Summary of Contents for Adaptive Server IQ 12.4.2
Page 1: ...Administration and Performance Guide Adaptive Server IQ 12 4 2 ...
Page 16: ...xvi ...
Page 20: ...Related documents xx ...
Page 40: ...Compatibility with earlier versions 20 ...
Page 118: ...Troubleshooting startup shutdown and connections 98 ...
Page 248: ...Importing data by replication 228 ...
Page 306: ...Integrity rules in the system tables 286 ...
Page 334: ...Cursors in transactions 314 ...
Page 396: ...Users and permissions in the system tables 376 ...
Page 438: ...Determining your data backup and recovery strategy 418 ...
Page 484: ...Network performance 464 ...
Page 500: ...System utilities to monitor CPU use 480 ...
Page 514: ...Characteristics of Open Client and jConnect connections 494 ...
Page 536: ...Index 516 ...