Installation Directory Structure

When you install SAP 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, SAP Sybase IQ software is installed in a unique subdirectory under the Sybase directory. This subdirectory is called the installation directory. Other tools provided with SAP Sybase IQ have unique subdirectories under the Sybase directory. This section describes only the subdirectory structure for SAP Sybase IQ.

By default, the SAP Sybase IQ directory is IQ-16_0. The location of IQ-16_0 varies, depending on where you install SAP Sybase IQ. The IQ-16_0 directory is also referred to by the environment variable $IQDIR16 on UNIX or %IQDIR16% on Windows.

The SAP 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 SAP Sybase IQ.

The subdirectory /demo/adata – Holds 16.x data to allow the creation of the 16.x iqdemo database. The subdirectory /demo/demodata holds SAP 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 16.x iqdemo database. The iqdemo database can be used to demonstrate problems to Technical Support.

Scripts directory (IQ-16_0/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 SAP Sybase SQL Anywhere®. Because SQL Anywhere and SAP Sybase IQ share common code, you can modify these examples for use with SAP 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-16_0 subdirectories /bin64, /lib64, /logfiles, /res, and /tix. On Windows, these include IQ-16_0 subdirectories \h, \install, \java, and \bin32.