Sybase IQ 12.4.0 installation instructions Using a .odbc.ini file, Stopasiq utility

Models: IQ 12.4.0

1 52
Download 52 pages 23.29 Kb
Page 18
Image 18

Using a .odbc.ini file

Adaptive Server IQ 12.4.0

If Adaptive Server IQ does not detect the presence of an ODBC driver manager, it will use ~/.odbc.ini for data source information. Otherwise, it will query the driver manager for data source information.

9.1.9 Using a .odbc.ini file

The following corrections apply to “Using ODBC data sources on UNIX,” in

Chapter 2 of the Adaptive Server IQ Administration and Performance Guide.

When creating a .odbc.ini file on any UNIX system, you must use the long form of each identifier, as follows:

[My Data Source]

EngineName=myserver

CommLinks=tcpip

UserID=dba

Password=sql

The database server looks for the .odbc.ini file in:

1The directory specified by the ODBCHOME environment variable

2The directory specified by the HOME environment variables

3The path

The database server ignores the ODBC_HOME, ODBC_INI and ODBCINI environment variables.

9.1.10 stop_asiq utility

The stop_asiq utility is new for version 12.03.1. Use this command to shut down an Adaptive Server IQ server and close all user connections to it.

When you issue the stop_asiq command, Adaptive Server IQ lists Adaptive Server IQ processes for your user ID and asks if you want to stop them. For example:

express@janed> stop_asiq

Checking system for ASIQ 12

Servers ...

The

following 1

process(es)

were found.

UID

PID PPID

C

STIME

TTY

TIME CMD

janed 6331 1 1 14:42:21 pts/1 0:19 asiqsrv12 @/express1/users/janed/sybase/asiq12/demo/asiqdemo.cfg /express1/user

Do you want to stop the above process(es) <Y/N>?

18

Release Bulletin for Digital UNIX

Page 18
Image 18
Sybase IQ 12.4.0 installation instructions Stopasiq utility, Using a .odbc.ini file Adaptive Server IQ