DSXchange

Hi, We have one parallel job which runs on monthly basis and extracts source data (100 mn records approx) and applying a lookup on that data with 2 reference tables, one is having 5 fields and other one is having 15 fields and propogating all 20 fields along with main stream fields into target table...

Yes i executed the dsenv also before triggeringthe DS job:

cd `cat /.dshome`
. ./dsenv

And after that the 'dsjob - run' command.

I tried executing the job individually from command line also but again the same issue persists.

Will the userid anyhow cause a problem in the job execution, because the job execution at unix level is through different user while when i run the job from director client it is through other user.

The long-running shell script inturn calls other datastage jobs lying in other DS project and always returns zero.

Hi ArndW,

yesterday the job was completed without any issue but today after facing the problem when i resetted the job then only i got these phantom logs.

Hi Ray,

I did not make any change into the script & DS job, yesterday it ran fine. I tried to check the variables also but they are pretty much fine, i mean all the variables are acepting values properly but script gives the error while trying to trigger the datastage sequencer job.

I have not made any changes in the script as well as in the datastage job. when i run the job thru script, nothing is available in the director because the script not at all triggeres the job. These are the logs of the yesterday`s completed run : sqRunMainFlow..JobControl (@Coordinator): Summary of ...

Hi ArndW, Thanks for the reply. In the morning when i reset the job this is what the log is saying: From previous run DataStage Job 95 Phantom 8630 DataStage Phantom Finished. Also, This is the command i am using for running the job: ${DSHOME}/bin/dsjob -run -wait -jobstatus -param pEmailLst=${Email...

I would like to make one more point here that when i try to run the same job through datastage client, it is working properly.

Hi All, I am trying to trigger the datastage jobs through unix shell script & untill yesterday all the jobs were running fine but today when i tried to execute the same job through same shell script i am getting error. This is the error messge i am receiving after executing the script: Status co...

Thanks chulett,

I basically created separate sequencer for each of the shell script & called according to my requirment & i got what i wanted to do.

Hi All, Thanks for the reply.

Yes i already tried using sequencer activity in between but even then, no parallel execution of scripts.

The design is like :

one DS job -> Sequencer -> 3 links each one having Execute_Command.

I hope the design is clear now.

Hi All, I am having a requirement wherein i have to execute 3 shell scripts in parallel after one of the parallel job gets completed. So for that, I have created one sequencer where i have attached the parallel job & after that i have attached 3 Eecute_Command stage for executing 3 shell scripts...

One more info. i want to share, when i use ODBC stage instead of netezza stage as a lookup , then it runs fine.

Thanks for all of your replies,

Yes i have checked with my DBA , none of the table is getting locked. I want to let you know one more thing that this is not long running job, as the data is very less generally 10000-11000 records and sometimes even 1 or 2 records.