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 > [...]
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 [...]
I started to learn JAXB from Vogella tutorial site. I changed the package and project name, and running the example generated following exception. Solution: After some googling I figured out, that I have to move annotation to the getter method. That solves above exception. The Bookstore.java will be look like this:
I was running a successful installation of IBM Unica Campaign on Windows 2003 VM. By some how I have to give a restart to the machine because it was halt. And I was with the following error. Could not start the IBM Unica Campaign Listener service on Local Computer. Error 183: Cannot create a file [...]
From last couple of weeks I was able to write new posts on the blog. That makes me come on the site quite often. I was looking for a fresh theme with more white space and less design. I come up with Toothpaste theme which is freely available on WordPress themes repository. I am loving [...]
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 [...]
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 [...]
Few days ago, I worked on the implementation of setting up IBM Unica Campaign with DB2 on AIX platform. For user tables I used data source of Oracle database by installing Oracle client and data source of DB2 by DB2 Runtime Client. In this activity, I also setup Cognos BI Server and integrated IBM Unica [...]
The installation of IBM InfoSphere Client v8.7 on Windows 7 went very smooth without any warning and error. But while I gave credentials of my host to attach a project I recieved following error: Problem Failed to authenticate the current user against the selected Services Tier The URL [iiop://lpar5:2825] that is used to connect to [...]
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 [...]
