The execution of the query will not be atomic

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
anu123
Premium Member
Premium Member
Posts: 143
Joined: Sun Feb 05, 2006 1:05 pm
Location: Columbus, OH, USA

The execution of the query will not be atomic

Post by anu123 »

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.
Thank you,
Anu
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
anu123
Premium Member
Premium Member
Posts: 143
Joined: Sun Feb 05, 2006 1:05 pm
Location: Columbus, OH, USA

Re: The execution of the query will not be atomic

Post by anu123 »

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.
Post Reply