We have moved to www.dataGenX.net, Keep Learning with us.

Monday, November 17, 2014

DataStage Error - Cannot authenticate user

When you attempt to start one of the InfoSphere DataStage and QualityStage Administrator clients, the following message is displayed:
Failed to authenticate
the current user against the selected Domain:  Invalid user name (username)
or password.
There are several possible causes of this problem.
  • The user name is invalid.
  • The password is invalid or has expired.
  • The user has no suite user role.
  • Credential mapping is required, but has not been defined for this user.
  • The user has no DataStage role or has the incorrect DataStage role.

Friday, November 14, 2014

Linux Shell session setup for DataStage Command Line

To setup Linux Shell for Datastage command line is very important if you are a DataStage Developer and want to work hassle free on DataStage Command Line.

Follow below steps to setup your profile ---

a) First, we will create .dshome file which is containing the path of DS Engine. If you know what it is, good, create a file in root dir with DS Engine path
otherwise execute below scripts to do it by itself

Thursday, November 13, 2014

Now We are on Google Groups

Thanks guys for your overwhelming support and interest. Now, we are on Google Groups for some more topics and discussion.

Please Join

Like the Facebook Page & join Group

For WHATSAPP group , drop a msg to 91-88-00-906098

Sunday, November 09, 2014

TimeStamp Comparison in Linux

Comparing Date, Time or TimeStamp is tricky thing in Linux. This is how you can achieve this -

By converting date to Seconds
$ date +%s
the above command will current time in seconds since 1970-01-01 00:00:00 UTC

if you have time in string form you can use below command to convert them like -

Friday, November 07, 2014

DataStage Error - Client logins fail with Error: 39125

DataStage client logins fail with error: 39125: the directory you are connecting to either is not a uv account or does not exist.

This error usually indicates that one of the 6 files required to make a UniVerse account is missing from the directory of the DataStage project which has the problem or that the user does not have permission to access these files. Those 6 files/directories are:

Wednesday, November 05, 2014

Read Sequential File with SCHEMA file

In Datastage, Schemas are an alternative way for you to specify column definitions for the data used by parallel jobs. You do not need to define any column and data format for reading a file. We are using this method when we needed a generic job for scenario like reading multiple files having different metadata defined.

Here, I am going to show you how to read the seq file with help of schema

A. Design

I am using below design to demonstrate this functionality, I am reading the data and dumping it to another file with different format.