When you are trying to test the connection to the DB2 database from Cognos configuration and you are getting this error message: XQE-JDB-0004 A problem occurred finding the driver class “com.ibm.db2.jcc.DB2Driver”. This error cause because the Cognos cannot find the DB2 drivers. Solution of this problem is simple. You have to copy files db2jcc.jar and… Read More »
If you are trying to connect DataStage 64bit on Windows to Oracle Database 64bit you probably get error message like this:
|
1 2 |
DataStage was unable to attach to this connector. Error loading connector library ccora11g.dll. %1 is not a valid Win32 application. |
I assume that you have done all prerequisites like set up the environment variables etc. More about prerequisites for Oracle connector in DataStage V11.3 you can find here http://ibm.co/1mu4WGo This error message you… Read More »
If you are getting the error message while running the job:
|
1 |
APT_Communicator::connectTo: connect() failed due to Unix error = 10,061 (Unknown error) on node <HOSTNAME> using ConnectionInfo object 'TCP, connection Host: HOSTNAME (<IP>), TCP port number: 0', RETRYING connect() |
You have to follow these steps to fix the issue: You must ensure that you have in hosts file these two entries
|
1 2 |
127.0.0.1 localhost ::1 localhost |
Next step is try if this commands working fine
|
1 2 |
ping -4 localhost ping -6 localhost |
Set the parameter $APT_USE_IPV4 in DataStage project to True (1) Open… Read More »
In case you want to test your Big Data environment, there is one very simple way, how to do it: Download Wikipedia dump and analyze it with Word Count application. We will focus on the first step – downloading the data and loading it into HDFS. This can be achieved by several ways. Today I’ll… Read More »
Very simple procedure to generate random number in DataStage. Grab a transformer on your canvas and use following code:
|
1 |
Mod(Rand(),MAXNUMBER) |
This code will return you a pseudorandom number in the range from zero to (MAXNUMBER – 1). So for example Mod(Rand(),500) will return number from 0 to 499.
This is a procedure useful not only for DataStage environment. Often you need to delete old logs periodically in order to save disk space. But especially in DataStage, which lacks automatic datasets cleanup is handy to delete old datasets. These may originate from your DataStage Dataset stages, or as a temporary resource from Lookup stage… Read More »