SQL Server instructions for Linux

Procedure

  1. Define the ODBCINI, LD_LIBRARY_PATH JVM variable to Cognos® Server. Add this variable to JVM environment variable list as follows:
    1. Log into the WebSphere® Application Server Integrated Solutions Console of the Cognos BI Server.
    2. Click Servers > Server Types > WebSphere application servers.
    3. Click the link of the Cognos server.
    4. Click JAVA and then select Process Management > Process definition > Environment Entries.
    5. Add or edit entries as needed, such as: 
       ODBCINI=/root/.odbc.ini
         LD_LIBRARY_PATH =Cognos_BI_install_path/bin64: /opt/Progress/DataDirect/Connect_for_ODBC_71/lib/
    6. Restart the Cognos BI Server.
  2. Follow the same steps as previously described to add an additional entry: 
    LD_PRELOAD = /usr/lib64/libfreebl3.so
  3. Make sure the ODBCINI, LD_LIBRARY_PATH environment variable is set before building a cube.
    • Run the following commands first before manually running the script to build cube. For example:
      export ODBCINI=/root/.odbc.ini
       export LD_LIBRARY_PATH =/opt/Progress/DataDirect/Connect_for_ODBC_71/lib/
    • Use the following command to edit the cron jobs to set the ODBCINI, LD_LIBRARY_PATH on Linux™, LIBPATH on AIX® 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 ODBCINI=/root/.odbc.ini:export LD_LIBRARY_PATH =/opt/Progress/DataDirect/Connect_for_ODBC_71/lib/: /opt/IBM/Cognos/metricsmodel/daily-refresh.sh
05 00 * * 0 export ODBCINI=/root/.odbc.ini:export LD_LIBRARY_PATH =/opt/Progress/DataDirect/Connect_for_ODBC_71/lib/: /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh