Target table 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
subrat
Premium Member
Premium Member
Posts: 77
Joined: Tue Dec 11, 2007 5:54 am
Location: UK

Target table error

Post by subrat »

Hi,

I have a simple load job which loading into a WH table. But continuously i am getting error like "job abort because of time out or table deadlock". I have make sure that the array size and transaction size are correct in target table. But still job is failing...


Any suggestion will greatly appreciated.

Thanks
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Post by keshav0307 »

use hash partition on the key columns
Post Reply