Sybase ADAPTIVE SERVER IQ 12.4.0 User Manual

Page 18

Advertising
background image

Using a .odbc.ini file

Adaptive Server IQ 12.4.0

18

Release Bulletin for Digital UNIX

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:

1

The directory specified by the ODBCHOME environment variable

2

The directory specified by the HOME environment variables

3

The 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>?

Advertising