Oracle job load 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
mandyli
Premium Member
Premium Member
Posts: 898
Joined: Wed May 26, 2004 10:45 pm
Location: Chicago

Oracle job load error

Post by mandyli »

Hi

We are seeing one of the job strange issues. The job is reading data from Dataset and Update into Oracle using Oracle connector stage. The same job ran fine for more than 3.5 mill. But now the same job getting error after some rows got updated.

After some time getting SIGNINT error. I asked DBA to run collect stats and index for target update table.

IS there any issue with Dataset or config file?

Thanks
Man
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You mean SIGINT and I would involve support for something like that.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

SIGINT can be thrown/caught if the job is stopped by an operator, and can also be the way that section leaders kill player processes when certain kinds of abort occur. Please check your job log for any other errors.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Yah, or that. At least then you'd have more information to give to support. :wink:
-craig

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