Sybase IQ 12.4.0 Server User Manual


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