Installation Directory Structure

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_3. The location of IQ-15_3 varies, depending on where you install Sybase IQ. The IQ-15_3 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_3/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 SQL Anywhere and Sybase IQ 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_3 subdirectories /bin64, /lib64, /logfiles, /res, and /tix. On Windows, these include IQ-15_3 subdirectories \h, \install, \java, and \bin32.