Job running indefintely, works well when re-cretad

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
dsproj2003
Participant
Posts: 21
Joined: Wed Oct 01, 2003 11:53 am

Job running indefintely, works well when re-cretad

Post by dsproj2003 »

Hi,

I have a Parallel job in PX 6.0.

It has one dataset providing input data to a transformer.
I obtain multiple (around 10) datsets as output from transformer.

This jobs runs indefintely.
When the DSEngine is brough down adn brought up again it works good.
Otherwise again after some days this hangs.

On re-creating the same job (identical job) again, it works good.

What could be the problem.

Any pointers are most welcome.

Thanks in advance.

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

Post by ray.wurlod »

I'd suggest you post this to the Parallel Extender forum on DataStageXChange (www.datastagexchange.com), where people who use PX lurk and may be able to provide good responses. Only some of them lurk here as well. [:)]

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
Teej
Participant
Posts: 677
Joined: Fri Aug 08, 2003 9:26 am
Location: USA

Post by Teej »

quote:Originally posted by dsproj2003
[br]Hi,

I have a Parallel job in PX 6.0.

It has one dataset providing input data to a transformer.
I obtain multiple (around 10) datsets as output from transformer.

This jobs runs indefintely.
When the DSEngine is brough down adn brought up again it works good.
Otherwise again after some days this hangs.


Sounds like a corruption with the OSH code. Did you ever try the "Forced Compile" option? Sometimes DataStage would overlook any small changes within the Transform stage (yes, it's a bug), so doing a Forced Compile would get everything all aligned right.

If that doesn't work, please let me know a bit more about what you did before the job hangs -- did you change any values? What do you mean when it hangs? Did it output anything? So on forth.

-T.J.


* * *

... now if this can make breakfast, my life is complete.
Post Reply