When you install Sybase IQ, several directories may be created. This
section describes the directory structure.
The directories created depend on which options you choose
during installation and which directories already exist in your
Sybase directory (the directory defined by $SYBASE on
UNIX or %SYBASE% on Windows).
By default, Sybase IQ software is installed in a unique subdirectory under the
Sybase directory. This subdirectory is called the installation directory. Other tools
provided with Sybase IQ have unique subdirectories under the Sybase directory. This
section describes only the subdirectory structure for Sybase IQ.
By default, the Sybase IQ directory is IQ-15_4. The location
of IQ-15_4 varies, depending on where you install Sybase IQ. The
IQ-15_4 directory is also referred to by the environment
variable $IQDIR15 on UNIX or %IQDIR15% on Windows.
The Sybase IQ directory holds a number of directories and files:
- Demo directory (%ALLUSERSPROFILE%/SybaseIQ/demo) – Holds the tools required to build the iqdemo database. The iqdemo database files
are iqdemo.db,
iqdemo.iq, iqdemo.iqmsg, and
iqdemo.iqtmp. The demo database itself is not
shipped with Sybase IQ.
- The subdirectory /demo/adata – Holds 15.x data to allow the creation of the 15.x iqdemo database. The
subdirectory /demo/demodata holds Sybase IQ 12.7 data
to allow the creation of an iqdemo database that has the same schema layout
and data as the IQ 12.7 asiqdemo database. Use
/demo/mkiqdemo.bat on Windows and
demo/mkiqdemo.sh on UNIX to create the 15.x iqdemo
database. The iqdemo database can be used to demonstrate problems to
Technical Support.
- Scripts directory (IQ-15_4/scripts) – Holds
some scripts used in examples and when creating catalog objects
like stored procedures. Do not edit these scripts.
If you edit, delete, or move these scripts, the server will not
operate properly.
- Samples directories – The samples directory contains SQL samples and user-defined
function (UDF) samples.
%ALLUSERSPROFILE%/SybaseIQ/samples/sqlanywhere
contains directories of SQL samples. The sqlanywhere/c directory
holds C++ examples that illustrate using ESQL (embedded SQL) and
C with SQL Anywhere®. Because Sybase IQ and SQL Anywhere share common code,
you can modify these examples for use with Sybase IQ. The
%ALLUSERSPROFILES%/SybaseIQ/samples/udf directory
holds sample C++ scalar and aggregate UDFs.
- Executable directories – Hold executables, libraries, help files, and so on. On UNIX, executable
subdirectories include IQ-15_4
subdirectories /bin64, /lib64,
/logfiles, /res, and
/tix. On Windows, these include
IQ-15_4 subdirectories \h,
\install, \java, and
\bin32.