SQL Server instructions for AIX

Procedure

  1. Make sure the locale is set to: en_US.ISO8859-1 or en_US.ISO8859-15.
    The locale setting is required by Cognos® Transformer for building powercube. Execute the following command first before manually running the script to build cube.
    export LC_ALL=en_US.ISO8859-1
  2. Define LIBPATH on AIX®, JVM variables 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
               LIBPATH=Cognos_BI_install_path/bin64: /opt/Progress/DataDirect/Connect_for_ODBC_71/lib/
    6. Restart the Cognos BI Server.
  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 LIBPATH=/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 LC_ALL=en_US.ISO8859-1: export ODBCINI=/root/.odbc.ini:export LIBPATH=/opt/Progress/DataDirect/Connect_for_ODBC_71/lib/:/opt/IBM/Cognos/metricsmodel/daily-refresh.sh
      05 00 * * 0 export LC_ALL=en_US.ISO8859-1: export ODBCINI=/root/.odbc.ini:export LIBPATH=/opt/Progress/DataDirect/Connect_for_ODBC_71/lib/:/opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh