You must install the correct service pack
required to run Sybase IQ. See the Sybase IQ Release
Bulletin for system requirements and required service packs.
In order to use the full available process virtual memory, you need to modify the boot.ini file to enable 4GT. Only the following platforms support this capability:
Windows 2000 Advanced Server
Windows 2000 Datacenter Server
Windows Server 2003, Standard Edition
Windows Server 2003, Enterprise Edition
Windows Server 2003, Datacenter Edition
Windows XP Professional
Simply add the /3GB parameter to the startup lines. For example:
[boot loader] timeout=5 default=multi(0)disk(0)rdisk(0) partition(1)\WINNT [operating systems] multi(0)disk(0)rdisk(0) partition(1)\WINNT="Microsoft Windows 2000 Professional" /fastdetect /3GB
Setting Sybase IQ cache sizes with 4GT support allows the size of the main and temporary caches to be increased up to a combined total of 2GB.
With Windows platforms that support 4GT, a Sybase IQ process may extend beyond the 2GB address space boundary, up to a total of 3GB. However, the total size of the two IQ buffer caches cannot exceed 2GB. This is due to the Windows restriction of not allowing a single memory allocation to cross the 2GB boundary.
Before you install Sybase IQ, make sure you have enough disk space, RAM, and swap space for the installation.
To install and run Sybase IQ 12.6 on Windows, you need:
System requirement |
Recommendation |
|---|---|
Disk space to install and run Sybase IQ |
163MB free disk space on the drive where Sybase IQ system files will be located |
Disk space for Software Developer’s Kit (Open Client) 12.5.1 |
119MB free disk space |
Disk space for databases |
Site dependent |
RAM |
512MB |
Swap space |
At least 1GB dedicated to Sybase IQ |
The table lists minimum requirements. For larger numbers
of active users, you will need more resources.
Sybase Central Java Edition is a graphical administration tool for managing certain Sybase products, including IQ databases. When you install Sybase IQ, you also install the Sybase IQ plug-in, which enables Sybase Central to manage IQ databases. Table 1-3 lists requirements for installing and running Sybase Central Java Edition as a Windows client.
System requirement |
Recommendation |
|---|---|
Processor |
Pentium 200Mhz or greater |
Disk space for Sybase Central Java Edition |
89MB free disk space |
RAM for Sybase Central Java Edition |
48MB |
Resolution |
800x600x256 |
The recommended minimum swap space to run Sybase IQ is at least 1GB.
Certain operations may cause the memory used by Sybase IQ to grow dynamically. Changing the way Sybase IQ uses buffers can dramatically change the way it uses memory. See the chapter “Managing System Resources” in the Sybase IQ Performance and Tuning Guide for more information about buffers.
Depending upon the load on the system where the Sybase IQ executable is running, the amount of system swap required may sometimes exceed the suggested minimum. Insufficient swap space may result in the system supporting fewer users, and large processes that cannot acquire sufficient swap space may be prematurely killed by the operating system. See your operating system documentation for information about extending swap space.
