Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 4 / 536

Contents
iv
Starting the server on Windows NT ............................................... 26
Starting the server from the NT Start menu ............................ 26
Typing the server startup command........................................ 26
Running the server outside the current session ...................... 27
Using command-line switches........................................................ 28
Naming the server and databases .......................................... 31
Controlling performance from the command line .................... 33
Controlling permissions from the command line ..................... 36
Setting a maximum Catalog page size.................................... 37
Setting up a client/server environment .................................... 38
Starting a server in forced recovery mode .............................. 40
Starting a server from DBISQL................................................ 40
Starting multiple servers or clients on the same machine ....... 41
Monitoring server activity ............................................................... 41
Stopping the database server ........................................................ 43
Who can stop the server? ....................................................... 45
Shutting down operating system sessions .............................. 45
Starting and stopping databases.................................................... 46
Starting the asiqdemo database .................................................... 47
Starting and stopping Sybase Central............................................ 48
Connecting a plug-in ............................................................... 49
Stopping Sybase Central......................................................... 50
Introduction to connections ............................................................ 50
How connections are established............................................ 51
Connection parameters specify connections........................... 52
Connection parameters are passed as connection strings ..... 52
Connection parameters are passed as connection strings ..... 53
Simple connection examples ......................................................... 53
Connecting to a database from DBISQL ................................. 54
Connecting to other databases from DBISQL ......................... 56
Connecting to an embedded database ................................... 57
Connecting using a data source.............................................. 59
Connecting to a server on a network....................................... 60
Using default connection parameters...................................... 61
Connecting from Adaptive Server IQ utilities........................... 62
Working with ODBC data sources.................................................. 63
DSNs and FILEDSNs .............................................................. 64
Creating and editing ODBC data sources ...................................... 65
Configuring ODBC data sources ............................................. 67
Creating a File Data Source ........................................................... 71
Using ODBC data sources on UNIX .............................................. 72
Connection parameters .................................................................. 73
Connection parameter priorities .............................................. 76
How Adaptive Server IQ makes connections ................................. 77