DB2 instructions for Linux

About this task

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

Procedure

  1. 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
  2. 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
  3. 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.