DB2® instructions for AIX
Procedure
-
Make sure that 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.
- Run the following command first before manually running the script to build the
cube:
export LC_ALL=en_US.ISO8859-1
- Use the following command to edit the cron jobs to set the locale for scheduled PowerCube
generation tasks:
For example, change both daily-refresh.sh and weekly-rebuild.sh cron jobs from:crontab -e
To:05 00 * * 1-6 /opt/IBM/Cognos/metricsmodel/daily-refresh.sh 05 00 * * 0 /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh
05 00 * * 1-6 export LC_ALL=en_US.ISO8859-1; /opt/IBM/Cognos/metricsmodel/daily-refresh.sh 05 00 * * 0 export LC_ALL=en_US.ISO8859-1; /opt/IBM/Cognos/metricsmodel/weekly-rebuild.sh
- Run the following command first before manually running the script to build the
cube:
- Optional:
Copy libdb2.a from the lib32 folder under
<db2client_home_directory>, and paste it to
<transformer_installation_directory>/bin folder.
Note: Cognos® Transformer is a 32-bit application, but the DB2® client is 64-bit. This incompatibility can cause issues when Transformer accesses the database. Associated errors that might occur are: UDA-SQL-0569 Unable to unable to load driver manager library (liddb2.a(shr.o) And cannot load module shr.o. To resolve this problem, copy the 32-bit compatible library that is provided by the DB2® client to the Transformer location.