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 [...]
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 [...]
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 [...]
