DB2 instructions for Linux

About this task

This procedure applies to RedHat Linux™ 6 64-bit systems.

Procedure

Set the LD_PRELOAD variable to the JVM environment variable list of the Cognos® server. The environment variable LD_PRELOAD needs to be set every time after a Linux system restart. To enable this, add this variable to JVM environment variable list as follows:
1. Start server1 of the WebSphere® Application Server where you deployed the Cognos BI.
2. Log into the administrative console of the WebSphere Application Server.
3. Navigate to Servers > Server Types > WebSphere application servers.
4. Click the cognos_server link.
5. Click JAVA and then select Process Management > Process definition > Environment Entries.
6. Click New to add the following entry: LD_PRELOAD = /usr/lib64/libfreebl3.so
Make sure LD_PRELOAD is set to: /usr/lib/libfreebl3.so before building cube.
Run the following command first before manually running the script to build cube:
```
export LD_PRELOAD=/usr/lib/libfreebl3.so
```
Use the following command to edit the cron jobs to set the LD_PRELOAD for scheduled cube generation tasks:
```
crontab -e
```
For example, change both daily-refresh.sh and weekly-rebuild.sh cron jobs from:
```
05 00 * * 1-6 /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
05 00 * * 0 /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh
```
to
```
05 00 * * 1-6 export LD_PRELOAD=/usr/lib/libfreebl3.so; /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
05 00 * * 0 export LD_PRELOAD=/usr/lib/libfreebl3.so; /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh
```
Note: Be careful about the path of the libfreebl3.so file. In the earlier step, the 64bit libfreebl3.so in /usr/lib64/ folder is used when installing Cognos components. In this step, the 32-bit version in lib folder should be used.