ODBC Stage with an Upsert option

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
Sivatkv
Participant
Posts: 15
Joined: Tue Oct 13, 2009 2:32 am

ODBC Stage with an Upsert option

Post by Sivatkv »

Hi,

We are facing some hang issues with ODBC stage. We have chosen the upsert option in this stage. But, the job goes to a hang state with this option being selected. We need the upsert option to be selected in the stage.

Could any one please let us know the resolution for this?

Thanks,
Siva
Regards,
Siva
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

My guess is locking contention in the target database. Get your DBA to monitor locks.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I would guess so as well. Does this happen if you run the job on a single node?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

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