Job continues to run but stops processing

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
kmoorer
Premium Member
Premium Member
Posts: 7
Joined: Mon Aug 20, 2007 12:50 pm
Location: Phila PA

Job continues to run but stops processing

Post by kmoorer »

We are converting from version 7.5.2 to 8.5.
We have exported all jobs from 7.5.2, imported into 8.5 & compiled.

Let's preface that this job is in production in version 7.5.2 with no problems.

The job in question reads 3 sequential files each with a transform
then into a join (left outer).
Each file has a sort on the link going into the join with all 3 files go into a join.

This join is a left outter. About 7 million rows.

One link is 3 million, the other 2 links 2million each.

The job starts fine and gets to a certain point and just stops. It doesn't abort, it just doesn't do anything. We let it run overnight with no progress.

Any suggestions would be helpful.
Kevin Moorer
Elisabete
Participant
Posts: 17
Joined: Mon Jan 03, 2011 7:55 am
Location: Odivelas

Re: Job continues to run but stops processing

Post by Elisabete »

Hello,
you have made any change in tables (database) without commit?
kmoorer
Premium Member
Premium Member
Posts: 7
Joined: Mon Aug 20, 2007 12:50 pm
Location: Phila PA

Re: Job continues to run but stops processing

Post by kmoorer »

No changes to anything.
Just exported from 7.5.2, imported into 8.5,
compiled and started testing pointing to same database & tables.
Kevin Moorer
FranklinE
Premium Member
Premium Member
Posts: 739
Joined: Tue Nov 25, 2008 2:19 pm
Location: Malvern, PA

Post by FranklinE »

What sort of Warning messages have you found in the Director output? It may be from our style of error handling :wink: but I've sometimes found important information in Info messages near the otherwise ambiguous Warning messages.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson

Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
Post Reply