DB2 Connection in Cognos

DB2 Connect String: jdbc:db2://localhost:50000/UNICADB


Important: If you are using DB2, the DB2 database name must be in uppercase letters.

Cognos 10.2 startup.sh on Redhat

To get this to work:

1. Ensure that LD_LIBRARY_PATH is set to :/apps/ibm/cognos/c10_64/bin64
2. Ensure that CLASSPATH is set to: /apps/ibm/cognos/c10_64/bin64/jre/7.0/lib/ext/bcprov-jdk14-145.jar
3. Ensure you have source db2profile and that it has 32bit libraries in LD_LIBRARY_PATH

httpd.conf for Cognos

Just add the following lines to httpd.conf:


ScriptAlias /ibmcognos/cgi-bin "/apps/ibm/cognos/c10_64/cgi-bin"

Order allow,deny
Allow from all

Alias /ibmcognos "/apps/ibm/cognos/c10_64/webcontent"

Order allow,deny
Allow from all

Too many open files

If you get too many open files, you might want to do this:

1. vi /etc/sysctl.conf and add in the following to the last line:
fs.file-max = 65536

2. Reboot the server and check using sysctl -p