Twitter app idea: Urdu poetry meme

Just hit an idea to write a Twitter bot or a meme that will collect Urdu poetry tweets specified by a hashtag stores it in it’s database. And people who will follow that account will get a poetry tweet daily. Why it’s looking interesting to me because I can’t find such account who shared poetry […]

Read more

Fixing “The transaction log for the database is full” problem in DB2

[IBM][CLI Driver][DB2/AIX64] SQL0964C The transaction log for the database is full. SQLSTATE=57011 The above mentioned error occured when database log file is not large enough for the application to create log files. The solution for this problem is to increase LOGFILSIZ, LOGPRIMARY and LOGSECOND parameters. When you will be going to increase the values for […]

Read more

When you should not use an ORM?

In design circles the importance of ORM is too much discussed. And different ORM implementations are compared with respect to their robustness. Last place where I worked, there was no ORM. Every developer was writing it’s JDBC DAO layer. This thing came in debate many times that why not to use an ORM like popular […]

Read more

How to remove campaign Custom Attributes in Unica Campaign?

That’s pretty simple. But you have to do it in UA_SYSTEM_TABLES database. There is no graphical way to remove campaign Custom Attributes. Put your attribute ID on above placeholders and execute the query. You will not be able to see those fields on Campaign UI.

Read more

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

Fixing “Class has two properties of the same name” exception

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:

Read more

Could not start the IBM Unica Campaign Listener service on Local Computer error

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

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