How to connect Cognos 10.2 with DB2 v9.7 data source on AIX?
To access DB2 remote database data source in Cognos you have to do following things on Cognos machine. Install DB2 client Set DB2 envoirnment variables Catalog remote host and database…
How to add Netezza ODBC datasource in IBM Unica Campaign?
This tutorial is about adding Netezza (a data warehouse appliance) ODBC based data source in IBM Unica Campaign. So that you can import tables from data warehouse to Unica and…
How to run DB2 store procedure from a shell script via root user?
If you have used default settings while installing DB2 on AIX. You have created db2inst1 user to use and access DB2. This post is related to the scenario, when a…
How to set JAVA_HOME environment variable for root user on AIX?
If you are following my previous post about installing Java 6 64bit on AIX 6.1 platform, next you have to set JAVA_HOME and PATH variables. If you want to set environment variables…
How to install Java 6 (Java6_64.sdk) on AIX 6.1?
This tutorial is about installation of Java6 64bit on AIX 6.1 platform. 1. Obtain the installer archive for Java6 64bit (Java6_64.sdk.6.0.0.385.tar). 2. Extract the tar file in the same directory…
How to create tablespace in DB2 v9.7?
I was trying to create tablespace in DB2 on AIX. I wanted to have that tablespace in a directory at my operating system. I have also created a bufferpool having…