DSXchange

I have a parallel job with the following design

Dataset----->surrogatekey------>target DB2 table

I am using DB sequence as surrogate key generator.The user with which the job ran was not access to the particular DB sequence.So the job got fatal error.But instead of aborting the job it has been finished with warning.

We've seen this posted before - fatal in the log, job doesn't abort - but I don't recall ever seeing a good reason for it. Me, I'd ping your official support provider and let us know what they say.

For information,

I get the same kind of behavior using an Oracle Enterprise to retrieve data (getting a "table or view does not exists"), and the job abort in some cases, but mostly continues and finish, even with this "Fatal" error.

Eric

Is there extra patch that needs to be installed to avoid this situation

Again... official support provider.

What's really needed is a change in mindset. In server jobs a Fatal error always causes the job to abort. In parallel jobs this is not necessarily the case - the controlling process (section leader or conductor) makes a decision about whether the other players, other nodes, can continue to execute.