You must install the correct operating system patches required to run Sybase IQ. Sybase recommends that you update your operating system with the latest maintenance release and the patch level recommended by the manufacturer.
Sybase IQ is tested with the latest patches available at build time. For minimum operating system and patch level requirements, see the Sybase IQ Release Bulletin.
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 start-up 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 can 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 that prevents a single memory allocation from crossing the 2GB boundary.