DSXchange

I am trying to perform Delete statement on DB2 (on mainframe).

Job Design.

Dataset -> Xfmr -> DB2 CONNECTOR

I am deleting based on PK ID. I am getting a message as mentioned below.

The execution of the query will not be atomic because the database server does not support atomic operations for non-insert queries

The job is taking forever and not deleting any records. How can I solve the issue.

I would suggest talking to your DBA. Here is an explanation of that error.

It is solved as there is FK relationship on the table to itself and it is entering loop. That FK is not indexed. But after indexing it it is resolved.