deadlock error

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
suse_dk
Participant
Posts: 93
Joined: Thu Aug 11, 2011 6:18 am
Location: Denmark

Post by suse_dk »

As mentioned by Kryt0n...

Make sure you have indices on your sql sever table otherwise you will get deadlocks...
_________________
- Susanne
Top
sush26283
Participant
Posts: 68
Joined: Thu May 20, 2010 11:55 am

Re: deadlock error

Post by sush26283 »

SURA wrote:Earlier you can't use more than on SQL Server EE stage at the same job to load the data. For that IBM provided a fix in DS 8.5 and that is resolved, still having this issue and the problem is, it may not happen for all the run. It is a bug. If you can, please raise a PMR with IBM.

DS User
true, its not happening with all the jobs, because all the jobs have the same structure and not too much of data, most of them ran fine, but then there are few which keep running into the error. And the only thing that seems to work is the execution mode= sequential at the target table
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”