DSXchange

This sort of behaviors is observed quite a number of times, one of the reason that would result in the peculiar behavior is, when you abort the job from the director, it my not have been terminated, the process must be still running at the background on the unix server. So is the reason that it is g...

I have a sequence job which is callling 3 jobs in sequence. I have specified a OK condition on the first job activity trigger. When trying to run the sequence, the first job is finishing with warnings and even the sequence finishes with warnings ( It doesnt run the other two jobs in the sequence tho...

While extracting the data from the source give an GROUP by clause so that the data coming out of the ODBC is in sorted order, Do Not partition the data at any further stages, do your normal transformation and load.

This should improve the throughput.


Regards,

In Unix we have some thing called as file descriptor. with that we can achieve your requirement. exec 3<firstInputfile exec 4<secondInputfile while not EOF do read <&3 Var1 read <&4 Var2 echo Var1 >> Resultant File echo Var2 >> Resultant File done recently we have come across this situation ...

Before passing the values to the filter stage, populate a column, with the output of the SQL query, then filter on the temporarily created column, which has the resultant of the SQL query.


At a later stage just drop the temporarily created column.

The best way would be DataBase | ChangeCapture ---------------> NewDataSet ^ | DataSet DataBase would be the one where we are tyring to load the data. Dataset is the file which you are tyring to load. New dataset will have the values which are present on the DataSet but not loaded into the DataBase ...

This is the complete message i got from the Director.

node_db2node: Warning: the following libraries failed to load: "V52S0_TestJob"

Thanks

Hi, With the Error log it is clear that the connection to data base was not established the reasone for that could be 1) Authentication(make sure the user name and password are correct they are case sensitive...) 2) Wrong Server name Please make sure that the connection to the data base has been est...

HI,

"V52S0...................." then followed by it the program name is printed in the warnings message like

node_db2node: Warning: the following libraries failed to load: "V52S0_TestJob"

Hope this helps you

Thanks

Hi All, The warning from the datastage Director log is as follows Could not load "V52S0...................." What are these "Vnnn" warnings what does the V stand from and what does the No signify... because in different situation i am getting different No's.....If some one has so...

HI, The modify operator keeps field "Field-Name" which is not present in the output interface. Initially I though that the job must be having the modify stage where in which this problem is coming up, but unfortunately there is no such stage in the job, it is a simple extract job where in ...

One more warning from the Px job.

"Could not send close message (shared memory)"
Did any one of you come across this warning before, if yes how did you resolve it.

One of my Px job has given this warnings
"main_program: Accept timed out retries = 8"
Did any one of you come across this warning before, if yes how did you resolve it.

As this is a old log message I don't have any additional Information.