DSXchange

As far as I know, the IBM certification is only available for Enterprise Edition and NOT server edition

You can cutomize the trigger to make it..Finished Ok or Finished with Warnings..Or you canjust mention that the Job 3 should be triggerred if none of the previous of FAILED You can do this by making the trigger custom conditional..and setting expression as <JobActivityName>.$JobStatus <> 1 Hope this...

See if you can open any stage in a server job. If the problem is only with jobs/routines properties in a sequencer that it could be because of Service Pack 2.I faced the same problem some time back. I am using Server Edition 7.5 and after Service Pack 2 was installed on my machine, I could nt open p...

They agreed to schedule the job to run at regular intervals to check the presence of the file. :D

Thanks for all the responses..I think I will be able to tackle this now !

In that case, I think we would be re-running the job but that would not be an everyday activity. I just want to explore if there's any way at all to run a never ending loop which keeps looking for a file. Initially I was think thinking of scheduling this job to run at regular intervals to look for t...

My jobs should be triggered if I get a file in a particular directory. For that I should be writing a file-watcher job that is always running and looking periodically for files. Once the file is there it should trigger the main sequencer. As per my company policy I cant use crontab or any other sche...

Stages in DataStage can be classified as active and passive stages.. Stages like Transformer which accept an input and perform some transformations and then move the data to some stage are active stages Where as stages like IPC, Sequential file which dont actually do any processing are passive stages.

I used following command to delete reject files with 0 size.. #------------------------------------------------------------------------------ # Deleting the Reject files of size =0 #------------------------------------------------------------------------------ find $REJECTDIR/ -size 0c -exec rm -f {...

Please see if the below code helps..I am doing something sinilar in a server routine... inrec=Trim(Arg1) len1=LEN(inrec) len2=len1-2 file1=inrec[len2,3] if (file1 = 'zip' or file1 = 'ZIP') then ucom1 ='unzip /pathname' ucom1=CATS(ucom1,inrec) ucom1=CATS(ucom1," -d pathname") CALL DSExecute...

I doing something exactly what you need..to check a job's status..if aborted/stopped..then reset..see if the code below helps.. * Check XXX JOBSTATUS. If the status is abort then reset the job before running haddrr1 = DSAttachJob("XXX", DSJ.ERRFATAL) Status = DSGetJobInfo(haddrr1, DSJ.JOBS...

Since nothing in the job/database design has changed and the performance has been dropped, not sure changing job/database will help.

10 G is not sufficient to process large amount of data.

Just wanted to know, how where you supplying the user id, was it a parameter or was it hard-coded...

Check the free space/current activities at unix. I faced this issue, the problem was that because there were many activities going on the unix box there was not much space left.