DSXchange

@ray,

Thanks for the correction ..Job log doesn't have any additional messages

I know its hard to some one to suggest with our proper information ..I will update with any findings

Thanks

@oracledba, Below is the design in my Sequencer for three 3 jobs JobAcvtivity 1 >UVActivity>JA2 >JA3 >Notification Activity JA1 is used for generating DATE and using in UVA is input for JA2 Message SEQ010_MASTER..JobControl (DSWaitForJob): JA1 1 has finished, status = 1 (Finished OK) SEQ010_MASTER.....

Hi, I got the following error message and sequencer is getting aborted .jobs are not triggered Attempting to Cleanup after ABORT raised in job SEQ010_MASTER..JobControl Job SEQ010_MASTER aborted. Made a copy of this sequencer and re-compiled all jobs and the Sequencer ..But still the jobs are not tr...

Hi All, As part of my testing for the jobs ,I realized that there is some difference in my output record counts when I Join two input data streams 1.LeftOuter Join ---53000 out put count 2.Lookup Stage (Condition for failure -Continue)-150000 output count I am in the process of figuring out why ther...

@Chulett,

Agree with you ..too much information not necessary

@Chulett, Reason for PUT : Currently, customer is using windows script (mentioned in original) to place the file.The proposed process is to replace it with unix shell script executed by datastage process . Reason for GET:(testing purpose only) As part of my testing the ftp connection ,I am trying to...

@Chulett, FTP stage is not working for this scenario as this mail box location (file and folder system is different). #!/usr/bin/bash #------------------------------------------------------------------------------------ # Name : FTP.sh #---------------------------------------------------------------...

@Thank you Chulett I am not sure how a Mail box location is different from a ftp server . But with the current process , the customer is using windows script for placing the file in ftp mail box location put "\\psoft8\output\FILE.TXT"%ABC%FILE From the windows command prompt ,I am able to ...

@PaulVL Thanks for the response. Option 1 :I am testing with the FTP Stage gave me following error FTP_Enterprise: processing failed for output connection 1: exit status = 255. FTP_Enterprise I checked the ftp connection with the given credentials using windows command prompt ftp xxx.yyy.com connect...

Hi All, I have a current Process that runs "windows script " for the file movement that needs to changed to a "DataStage Process (Using shell script )" Source :Text file is getting generated as part of Datastage Jobs processes and resides in a shared drive . Target :ftp hostname ...

We had a parameter set which is in almost all our jobs and we dont need it anymore, is there a way this can be deleted from all the jobs without going into each individual jobs?

Ray, Thanks for the response. When i meant Job (B) i have about 100 of these , none of these jobs are recognised by the routine in Job(A). This morning i took a random sample of 10 jobs , compiled them and tried to run Job(A), it failed all 10 times even after recompiling all Jobs. But when i save t...

I have a job(A) with a server routine that calls Job(B) , Job(A) was working fine until a couple of days ago and now its aborting saying Job(B) cant be found. When i save and compile Job(B) then Job (A) is working again and calls Job (B) properly...any thoughts on what might have happened? Job (B) i...

I am deleting records based on a where clause

Hi Guru's

I am using a DB2 connector stage which has a before sql to delete data, as the array size option in this stage cannot be used for before sql , transaction logs are getting filled up, Is there any other way i can do this delete by committing after every few thousand records?