Hi All,
Thanks for the valuable replies. But, I forgot to mention that the table is DB2 z/OS which is catalog in DB2 environment and i am loading it using DB2 connector stage.
The fatal mentioned is with respect to DB2 connector stage while loading MF table. I had tried all the options that are discussed above and no luck with job execution. It aborts with the same error as mentioned in the begining of the post.
Few observations are:
1. Primary Keys are defined on the Table.
2. Job still aborts when setting Auto commit as Off.
3. Have executed with single node in sequential and parallel but no luck.
As per the IBM documentation,
Insert then update: Writes data to the target table; runs the INSERT statement first, and if the INSERT fails with a duplicate key violation, runs the UPDATE statement.
But, in my case when INSERT statement fails UPDATE statement is not been executed and hence job aborts.
Can any one please share further updates on it?
Thanks in advance.