Tag Archives: AIX

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 After above these steps, add a new DB2 data source in Cognos Configurations. Navigate to IBM Cognos Connection > Launch > IBM Cognos Administration > […]

Read more

How to access remote database from DB2 client?

If you want to access a remote DB2 (v9.7) database from another host that’s running DB2 client. You have to do following things on client machine: Adding remote host in host file Switch user to DB2 user (e.g. db2inst1) Catalog remote node Catalog remote database Adding remote host in host file Open /etc/hosts file and […]

Read more
How to add Netezza ODBC datasource in IBM Unica Campaign?

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 perform operations. We will install Netezza client on the machine where we are running IBM Unica Campaign. And will configure ODBC on this machine. Installing […]

Read more
How to run DB2 store procedure from a shell script via root user?

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 root user have to execute a shell script containing a store procedure of DB2. Create a shell script with following contents. Your every statement will […]

Read more
How to set JAVA_HOME environment variable for root user on AIX?

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 for non root users. You can set those variables in /home/<user>/.profile file. For a root user, setting an environment variable is different. As you will not find […]

Read more
How to install Java 6 (Java6_64.sdk) on AIX 6.1?

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 tar –xvf Java6_64.sdk.6.0.0.385.tar You will have Java6_64.sdk. .sdk file is backup/restore format file 3. Enter following commands to start installation of this format inutoc . […]

Read more
How to create tablespace in DB2 v9.7?

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 the same pagesize of tablespace (that is necessary). But was getting SQLCODE=-104. I also tried with `FILE` tokens giving the sizes too. But was unable […]

Read more