DSXchange

Suggest you google for "Abnormal end unit of work condition occurred", there seems to be many DB2 resources out there for that issue.

Good.

:idea: I would suggest no-one ever does any automatic reset immediately after a job finishes, even if it aborts. What my scripts always do is check the job being requested to run before anything is actually run for several conditions: 1. The job actually exists 2. The job is not already running 3. T...

Patch? There would be no 'patch' involved here. When you reran it, did it go into 'maintenance mode'? Did you go back and check all of the optional plugins?

No, they don't. What does it actually say when you validate? And I don't believe I've ever seen an official grammar reference. Others may know.

What does it not like about it? Right-click on the red derivation and select 'Validate Derivation'.

You sure it's the read? What happens if you replace the OE stage and write to a sequential file instead?

OK, consider it ignored.

Is what I posted the "command" you disabled?

Your post is marked as a Windows server, hence my mention of a batch file. In the future, it would be best if you set that to UNIX so you get the proper advice.

What comes next after that in the script? Are you doing a "-run -mode RESET" afterwards?

No job gets reset all by itself. What exactly are you doing with dsjob? Are you using it in a batch file? Running it standalone? Regardless, can you post the complete syntax you are using? A Job Activity stage in a Sequence job can be set to 'Reset if Required then Run' but it does the reset before ...

No... it only gets reset when you reset it. You did say you're doing that unconditionally, did you not?

What precisely do you mean by 'ignore the warning messages'?

It's an 'all or nothing' afair, use "-warn 0" to allow unlimited warnings regardless of origin.

Probably help to share your 'abort', don't you think?

There is an INDEX hint to force Oracle to use the index you specify. Seems like worst case you could use that.

If you really think you need that other output format, I'm assuming you'll need to run the completed XML through some kind of 3rd party 'pretty print' / reformatting utility.