Known Issues for Installation and Configuration

Descriptions of known issues and workarounds for Sybase IQ installation.

Installer issues
CR#	Description
690606	RH 6.x default setting for max user processes may be too low for starting Sybase IQ servers – Red Hat 6.x introduced a change that affects the number of threads that the Sybase IQ engine can start. By default, Red Hat 5.x set the limit dynamically based on the machine configuration. (For example, an 8-core system would set the limit at 256693.) In Red Hat 6.x, this limit is hard-coded to 1024 regardless of system size. This change particularly affects systems with high CPU per core counts and systems where the same user account starts multiple IQ servers. Workaround 1 – Calculate the number of threads needed. For each server started by any single user, use the following formula to calculate the number of threads IQ allocates: numThreads = 604 + 50(numCPUs - 4) + numConnections + 3 For an 8-core system with 100 users, the `numThreads` is 543 threads per server. For a 64-core system with 100 users, the `numThreads` is 3343 threads per server. Add the following lines to /etc/security/limits.conf: sybase soft nproc 7710 -- 2 servers on the 64-core system plus 1024 default sybase hard nproc 16384 -- rounded up for extra space To set limits for all users instead of the sybase user, replace sybase with ``, for example: soft nproc 7710 * hard nproc 16384 Add the following line to the .cshrc file of the user who starts servers: limit maxproc 7710 Workaround 2 – Return to Red Hat 5.x behavior by commenting out the following line in the file /etc/security/limits.d/90-nproc.conf: #* soft nproc 1024
684311	Install on RH 6.0 fails with java stack trace – Red Hat Enterprise Linux 6 requires 32-bit compatibility libraries to support Java-based applications in Sybase IQ, including the Sybase IQ installer. Workaround – These libraries are required to install Sybase IQ on Red Hat Enterprise Linux 6: libXext-devel.i686 libXtst-devel.i686 If you start the Sybase IQ installer in GUI mode without installing these libraries, the installer generates an exception and fails.
665300	Installer stops responding on some UNIX-like platforms – On some UNIX-like operating systems, a network resource may cause the installer to stop responding and return the error "syntax error near unexpected token 'fi'." The df command also stops responding in this situation. Workaround – Identify the network file system (NFS) mounts that may have problems: strace -e statfs, statfs64 df Use the umount command to unmount an identified NFS mount: umount -l <path> Repeat the above steps until there are no more NFS mounts that have stopped responding. Note: The umount command requires root permission. If umount unmounts the NFS, you may have to restart your machine.
664968, 669802	IQ installer returns "Permission denied" error on Red Hat – The IQ installer may return this error on Red Hat, when the installation DVD has been automatically mounted: ./setup.bin: /bin/sh: bad interpreter: Permission denied Workaround – Remount the installation media and run the installation again: Unmount the installation media. Manually mount the DVD drive: Use one of the following commands to remount the drive: mount -t iso9660 /dev/hda /mnt/cdrom mount -o exec /dev/cdrom /media Start the installation using the new mounted directory /mnt/cdrom.
655963	IQ installer returns error "No filesystem could mount root" on Red Hat – The IQ installer may return this error on Red Hat when installing on IBM P6 and P7 machines: rhel6 install error: No filesystem could mount root, tried: iso9660 Workaround – Follow the steps on http://www.ibm.com/developerworks/forums/thread.jspa?threadID=357314 and re-install.
668842	Incorrect value for Start Sybase Control Center in response file – Creating a response file for unattended or silent installation with the GUI installer sets an incorrect value for the `START_SCC_SERVER` property in the Start Sybase Control Center code block. Workaround – An incorrect `START_SCC_SERVER` property looks like this: #Start Sybase Control Center #--------------------------- START_SCC_SERVER=\"\",\"No\" <---- wrong value START_SCC_SERVER_1= START_SCC_SERVER_2=No START_SCC_SERVER_BOOLEAN_1=0 START_SCC_SERVER_BOOLEAN_2=1 The `START_SCC_SERVER` property should look like this: #Start Sybase Control Center #--------------------------- START_SCC_SERVER=No START_SCC_SERVER_1= START_SCC_SERVER_2=No START_SCC_SERVER_BOOLEAN_1=0 START_SCC_SERVER_BOOLEAN_2=1 To correct the error, change the `START_SCC_SERVER` property to `START_SCC_SERVER=No` or `START_SCC_SERVER=Yes`.
669678	Uninstaller stops responding – Clicking the Previous button after the installer indicates that All items were successfully deleted causes the uninstaller to hang. Workaround – Do not try to return to a previous screen after the installer deletes your files. Click Done to complete the uninstall process.
641873, 652690, 652696, 652866, 643106	Do not install Sybase IQ 15.4 into the same directory as older Sybase products – Installing Sybase IQ 15.4 into the same directory with older Sybase Products may render some or all of these products unusable. Only Adaptive Server Enterprise 15.5 and Sybase IQ 15.4 can share the same $SYBASE directory. Workaround – Install Sybase IQ 15.4 into a different directory than the one you use for older products.