Job is running too long

[balu124]

Hi
job is like this , target is a dimention table ,we need to load the data from various sources to target table.In the job the target dimention table acts as a lookup table.
Right now the dimention table is empty.

after developing the,when executing ,it runs too long.

it haven't stoped even we stop the job manually or stop the datastage services.it stops only when restart the computer .can any one give some idea on how to resolve this ?

[ray.wurlod]

One way is to change your expectations.

[sanath1234]

Hi
job is like this , target is a dimention table ,we need to load the data from various sources to target table.In the job the target dimention table acts as a lookup table.
Right now the dimention table is empty.

after developing the,when executing ,it runs too long.

it haven't stoped even we stop the job manually or stop the datastage services.it stops only when restart the computer .can any one give some idea on how to resolve this ?

check if there are any dependencies/constraints/ect...
check whether all the job acting same way then its problem in project we have to check the buffer capabilities.
if its in parallel then check the node configaration....

its a trailand error as per your infomation..

[balu124]

One way is to change your expectations.

Hi ray,
I didn't get your words,could you please explain me in detail?

[ray.wurlod]

Define "too long".
Surely it takes as long as it takes (all else being equal).
If it takes two hours and you expected it to finish in one, change your ideas so that you expect it to finish in two.