Job Freeze..
Moderators: chulett, rschirm, roy
Job Freeze..
Hi All,
I am running server job and my job is freezing at certain point,
can somebody tell me why this happen,
i got this message in log file,
CopyOfJ_NTWX_FACT_ORDER_DETAILS..LC_MERGE_ROWS: DSD.StageRun Active stage starting, tracemode = 0.
Thnaks.
I am running server job and my job is freezing at certain point,
can somebody tell me why this happen,
i got this message in log file,
CopyOfJ_NTWX_FACT_ORDER_DETAILS..LC_MERGE_ROWS: DSD.StageRun Active stage starting, tracemode = 0.
Thnaks.
What do you mean freezing? Is the designer client freezing or the job is hanging? What additional messages do you get in the log file? Reset the job and see if you have any messages "From previous run ..."
Need more info on design as well.
Need more info on design as well.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Hi,
I did not try for that,
actually this job is design by another person,
and i cannt change in it,so here the design,
18 hash files----> link collector---->a single hash file.
my job ,every time freeze at this point and its shows blue link and there is not a single warning or fatal error.
so reply me thanks.
I did not try for that,
actually this job is design by another person,
and i cannt change in it,so here the design,
18 hash files----> link collector---->a single hash file.
my job ,every time freeze at this point and its shows blue link and there is not a single warning or fatal error.
so reply me thanks.
Dont change it. Just build another job to do the same except, without the link collector. This is just for debugging purposes.
I have had issues with link collectors and hashed files (connected together) before and therefore dont like them next to each other.
I have had issues with link collectors and hashed files (connected together) before and therefore dont like them next to each other.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Hope your design is many to one. I mean many Hashed file to to single Hashed file. I also assume the output file is different from the source files.
That case, if any one source has large data to be transfered, the job takes that long.
And by the way, what gets your solution.
And you can mark the topic are resolved.
That case, if any one source has large data to be transfered, the job takes that long.
And by the way, what gets your solution.
And you can mark the topic are resolved.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A hashed file is a way to implement a database table. You can have multiple streams inserting rows into it.
There is no need at all for a Link Collector stage.
There is no need at all for a Link Collector stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.