Known Issues for Installation and Configuration

Descriptions of known issues and workarounds for SAP Sybase IQ installation.

Installer issues
CR#	Description
691250	Wrong link to IBM XL C/C++ Runtime Environment for AIX, V10.1 – The Installing the IBM XL C/C++ Redistributable Libraries topic in the Installation and Configuration Guide includes an incorrect link to IBM XL C/C++ Runtime Environment for AIX, V10.1. The correct link is https://www-304.ibm.com/support/docview.wss?uid=swg24019829
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 SAP 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. The formula also works for systems with fewer CPUs, for example, on 2-core systems. To set hard and soft limits, add the following lines to /etc/security/limits.conf: sybase soft nproc 7712 -- The soft limit allows for 2 servers on the 64-core system plus 1024 default. sybase hard nproc 16384 -- Powers of 16 work well for kernel and engine settings. (1024 * 16) is rounded up for extra space. You can increase the soft limit, but the hard limit is the threshold for the value unless raised by a privileged user limit. To set limits for all users instead of the sybase user, replace sybase with ``, for example: soft nproc 7712 * hard nproc 16384 Set the process number limit in the shell script of the user who starts servers, for example: For the tcsh or C (csh) shell: limit maxproc 7712 For the bash or Korn (ksh) shell: ulimit –u 7712 Reboot your machine. 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 Reboot your machine.
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 SAP Sybase IQ, including the SAP Sybase IQ installer. Workaround – These libraries are required to install SAP Sybase IQ on Red Hat Enterprise Linux 6: libXext-devel.i686 libXtst-devel.i686 If you start the SAP Sybase IQ installer in GUI mode without installing these libraries, the installer generates an exception and fails.
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.
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`.
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	Installer returns "Permission denied" error on Red Hat – The 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	Installer returns error "No filesystem could mount root" on Red Hat – The 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.
641873, 652690, 652696, 652866, 643106	Do not install SAP Sybase IQ16.0 into the same directory as older Sybase products – Installing Sybase SAP Sybase IQ16.0 into the same directory with older SAP Sybase Products may render some or all of these products unusable. Workaround – Install SAP Sybase IQ16.0 into a different directory than the one you use for older products.