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

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

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

IBM InfoSphere Client v8.7: Failed to authenticate the current user against the selected Services Tier

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

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

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

Related Posts Plugin for WordPress, Blogger...