“Unexpected System Error” in DataStage Sequence Job

Today I was running into a mysterious error in DataStage as I was running a sequence job.  Things seemed to be going well until one of my Fact jobs at the end of the sequence reported “Aborted” in DataStage Director.  Looking into the log for this job revealed a rather vague error message: [StageName] DB2 […]

DataStage Range Lookup Failure – What Gives?

I just spent the majority of my morning trying to figure out why in the world my range lookup kept failing.  Hopefully this will save you some time in troubleshooting your range lookup failures.  To cut right to the chase, my resolution involved sorting my reference source prior to doing the lookup.  Adding a sort […]