What a Server Installation Does

A typical installation installs the server and other components into a parent directory on the host machine.

Directory Variables

Sybase IQ uses environment variables that point to different installation directories.

Sybase IQ Directory Variables.
Variable Description

%SYBASE%

Points to the parent installation directory. This variable is set by the installer.

%IQDIR15%

Points to the Sybase IQ installation directory. This variable is set by the installer.

%ALLUSERSPROFILE%

Points to the Windows local resources directory. The location of Sybase IQ local resources depends on the Windows version:
  • On Windows XP, these resources are located in the C:\Documents and Settings\All Users\SybaseIQ directory.
  • On Windows 7, these resources are located in the C:\ProgramData\SybaseIQ directory.

Parent Installation Directory

The %SYBASE% directory contains the files, scripts, and other objects required to support the server.

Sybase IQ Parent Installation Directory.

Directory

Contents

charsets

Character sets available for use with Adaptive Server Enterprise.

collate

Collation sequences available for use with Adaptive Server Enterprise.

ini

Various configuration files.

IQ-15_4

Subdirectories, scripts, and property files required to run Sybase IQ server.

jConnect-7_0

JDBC 4.0 compliant driver for Sybase IQ.

jre

Java runtime environment.

jutils-3_0

Version 3.0 Java-based utilities, including Ribo, a Tabular Data Streams utility.

locales

Language modules for system messages and date/time formats.

log

Installation log files.

OCS-15_0

Open Client tools and utilities.

SCC-3_2

Sybase Control Center startup and configuration files.

Shared

Objects and libraries shared by other components, including Sybase Central and the Java Runtime Environment (JRE).

Sybase_Install_Registry

Server registry file that holds information related to the installed products. Do not modify.

sybuninstall

Subdirectories for scripts that uninstall IQ and SySAM.

SYSAM-2_0

SySAM licenses and utilities. This directory contains three subdirectories: bin, licenses, and log.

ThirdPartyLegal

Third party license terms and agreements.

Product Installation Directory

%IQDIR15% is a %SYBASE% subdirectory that contains the files, scripts, and other objects required to run the server.

Product Installation Directory.

Directory

Contents

Assembly

ADO.NET and .NET assembly files.

Bin32

Libraries required for 32-bit compatibility.

Bin64<platform>

Utilities you use to start and manage your server.

demo

A readme that identifies the location of the demo database and other local resources.

install

Installation history file.

java

Different JAR files.

logfiles

Sybase IQ writes log files to this directory.

lsunload

Local Store Unload utility.

Scripts

Sample scripts and stored procedures.

SDK

Subdirectories for various language utilities.

SNMP

Definitions for Simple Network Management Protocol servers.

support

A Web page with links to online resources.

Sysam

Local SySAM configuration information.

unload

Various unload scripts, files, and utilities.

Local Resources Directory

The %ALLUSERSPROFILE% directory contains local resources, including the demo database, server logs, and utilities.

Directory

Contents

demo

Sample data and scripts for the demo database.

logfiles

Server log files.

samples

Sample scripts, drivers, and utilities.